Adding Group Asset IDs with Background Processing

Group asset IDs, like group member assets, can be loaded using a background process. In the Transaction Loader, you use the Default_Profile_SW = "N" option. Consequently, you must load one record for each book of each asset into INTFC_FIN.

Load these required fields into the PS_INTFC_FIN table when adding group asset IDs:

• INTFC_ID

• INTFC_LINE_NUM

• BUSINESS_UNIT

• ASSET_ID

  This is the group asset ID.

• BOOK

• DTTM_STAMP

• APPROVAL_SW

• LOAD_STATUS

• DEFAULT_PROFILE_SW = 'N'

• CATEGORY

• METHOD

  Set the method to FL (flat rate).

• DEPR_PERCENT

• CONVENTION

• DEPR_AVG_OPTION

• IN_SERVICE_DT

• TRANS_DT

• CURRENCY_CD

Load these fields into the PS_INTFC_PHY_A record when loading group asset IDs:

• INTFC_ID

• INTFC_LINE_NUMBER

• BUSINESS_UNIT

• ASSET_ID

  This is the group asset ID.

• DTTM_STAMP

• INTFC_TYPE

• SYSTEM_SOURCE

• APPROVAL_SW

• LOAD_STATUS

• DEFAULT_PROFILE_SW

• ASSET_STATUS

• FINANCIAL_ASSET_SW

• PROFILE_ID

• GROUP_ASSET_FLAG

• CURRENCY_CD

• CUSTODIAN_EFFDT

• LOCATION_EFFDT

Note:

You can include physical attribute data (asset location and asset custodian) for the group asset; however, the custodian and location effective-dated fields are required. The physical attribute data must be loaded into the PS_INTFC_PHY_A table.

Note:

If a profile is already created for a group asset ID and you load the group asset ID in a background process, the system detects the profile ID in the PROFILE_DET_TBL table and returns an error.