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.