1. User Guide
  2. Data Loaders
  3. Ledger Data Loader
  4. Setup for the LEDGER_STAT load utility
  5. FSI_DATA_IDENTITY insert/update during Ledger_load

5.11.2.1 FSI_DATA_IDENTITY insert/update during Ledger_load

Insert happens into FSI_DATA_IDENTITY with new identity code if the new Data origin used in the STG_GL_DATA.

Update happens in case same set of Data source used STG_GL_DATA.

Updates set happens

start_time = SYSDATE,

end_time = SYSDATE,

number_of_entries = no.of entries for the current load

Here, STG_GL_DATA is considered as a source of input for LEDGER_LOAD. In case of other source table, the rule is same in populating data into FSI_DATA_IDENTITY.