Copy Asset Categories Between Books

Tags:

fa2 create new tag

Introduction

The following SQL code will copy all of the categories from a source book to a target book. It has been used successfully in version 11.5.10.2. Note you must edit the script to tell it the source and target books.

SQL Code

Insert into fa_category_books
    (      CATEGORY_ID
    ,      BOOK_TYPE_CODE
    ,      LAST_UPDATE_DATE
    ,      LAST_UPDATED_BY
    ,      CREATED_BY
    ,      CREATION_DATE
    ,      LAST_UPDATE_LOGIN
    ,      ASSET_CLEARING_ACCT
    ,      ASSET_COST_ACCT
    ,      CIP_CLEARING_ACCT
    ,      CIP_COST_ACCT
    ,      DEPRN_EXPENSE_ACCT
    ,      DEPRN_RESERVE_ACCT
    ,      REVAL_AMORTIZATION_ACCT
    ,      REVAL_RESERVE_ACCT
    ,      ASSET_COST_ACCOUNT_CCID
    ,      ASSET_CLEARING_ACCOUNT_CCID
    ,      WIP_COST_ACCOUNT_CCID
    ,      WIP_CLEARING_ACCOUNT_CCID
    ,      RESERVE_ACCOUNT_CCID
    ,      REVAL_AMORT_ACCOUNT_CCID
    ,      REVAL_RESERVE_ACCOUNT_CCID
    ,      LIFE_EXTENSION_CEILING
    ,      LIFE_EXTENSION_FACTOR
    ,      PERCENT_SALVAGE_VALUE
    ,      DEFAULT_GROUP_ASSET_ID
    ,      BONUS_DEPRN_EXPENSE_ACCT
    ,      BONUS_DEPRN_RESERVE_ACCT
    ,      BONUS_RESERVE_ACCT_CCID
    ,      IMPAIR_EXPENSE_ACCOUNT_CCID
    ,      IMPAIR_EXPENSE_ACCT
    ,      IMPAIR_RESERVE_ACCOUNT_CCID
    ,      IMPAIR_RESERVE_ACCT
    )
SELECT CATEGORY_ID
    ,      'XXXXXXX'   --Enter the name of the book that is the target
    ,      SYSDATE
    ,      LAST_UPDATED_BY
    ,      CREATED_BY
    ,      SYSDATE
    ,      LAST_UPDATE_LOGIN
    ,      ASSET_CLEARING_ACCT
    ,      ASSET_COST_ACCT
    ,      CIP_CLEARING_ACCT
    ,      CIP_COST_ACCT
    ,      DEPRN_EXPENSE_ACCT
    ,      DEPRN_RESERVE_ACCT
    ,      REVAL_AMORTIZATION_ACCT
    ,      REVAL_RESERVE_ACCT
    ,      ASSET_COST_ACCOUNT_CCID
    ,      ASSET_CLEARING_ACCOUNT_CCID
    ,      WIP_COST_ACCOUNT_CCID
    ,      WIP_CLEARING_ACCOUNT_CCID
    ,      RESERVE_ACCOUNT_CCID
    ,      REVAL_AMORT_ACCOUNT_CCID
    ,      REVAL_RESERVE_ACCOUNT_CCID
    ,      LIFE_EXTENSION_CEILING
    ,      LIFE_EXTENSION_FACTOR
    ,      PERCENT_SALVAGE_VALUE
    ,      DEFAULT_GROUP_ASSET_ID
    ,      BONUS_DEPRN_EXPENSE_ACCT
    ,      BONUS_DEPRN_RESERVE_ACCT
    ,      BONUS_RESERVE_ACCT_CCID
    ,      IMPAIR_EXPENSE_ACCOUNT_CCID
    ,      IMPAIR_EXPENSE_ACCT
    ,      IMPAIR_RESERVE_ACCOUNT_CCID
    ,      IMPAIR_RESERVE_ACCT
FROM FA.FA_CATEGORY_BOOKS
where book_type_code = 'ZZZZZZ'     --Enter the name of the source book

INSERT into fa_category_book_defaults
(
       CATEGORY_ID
,      BOOK_TYPE_CODE
,      START_DPIS
,      END_DPIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      CEILING_NAME
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      DEPRECIATE_FLAG
,      RETIREMENT_PRORATE_CONVENTION
,      PRICE_INDEX_NAME
,      USE_STL_RETIREMENTS_FLAG
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SUBCOMPONENT_LIFE_RULE
,      MINIMUM_LIFE_IN_MONTHS
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      CAPITAL_GAIN_THRESHOLD
,      USE_DEPRN_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      CUA_LIFE_END_DATE
,      CUA_RULE_SET_ID
,      GROUP_ASSET_ID
,      MASS_PROPERTY_FLAG
)
SELECT CATEGORY_ID
,      'XXXXXXXX'   --Enter the name of the book that is the target
,      START_DPIS
,      END_DPIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      CEILING_NAME
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      DEPRECIATE_FLAG
,      RETIREMENT_PRORATE_CONVENTION
,      PRICE_INDEX_NAME
,      USE_STL_RETIREMENTS_FLAG
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      SYSDATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      SYSDATE
,      LAST_UPDATE_LOGIN
,      SUBCOMPONENT_LIFE_RULE
,      MINIMUM_LIFE_IN_MONTHS
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      CAPITAL_GAIN_THRESHOLD
,      USE_DEPRN_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      CUA_LIFE_END_DATE
,      CUA_RULE_SET_ID
,      GROUP_ASSET_ID
,      MASS_PROPERTY_FLAG
FROM FA.FA_CATEGORY_BOOK_DEFAULTS
where book_type_code = 'ZZZZZZZ'     --Enter the name of the source book

Comments

Links

• Related: FA12SetupAssetSystemAssetCategories, OracleAssets

This Topic Is Referenced By These Topics:
Related Links: FA12SetupAssetSystemAssetCategories, WebStatistics

---

---

Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Very Useful (1)

Disclaimer

Use at Your Own Risk: We provide the material available through this website for informational purposes only. Before you act on any information you've found on this site, you should confirm any facts that are important to your decision. IF YOU RELY ON ANY INFORMATION OR SERVICE AVAILABLE THROUGH THIS WEBSITE, YOU DO SO AT YOUR OWN RISK. YOU UNDERSTAND THAT YOU ARE SOLELY RESPONSIBLE FOR ANY DAMAGE OR LOSS YOU MAY INCUR THAT RESULTS FROM YOUR USE OF ANY SERVICE OR ANY MATERIAL AND/OR DATA DOWNLOADED FROM OR OTHERWISE PROVIDED THROUGH THIS WEBSITE.

Collaborating Authors and Reviewers: -- JimCrum