4 Staging Tables Data Population

This topic provides the information about the Staging Tables Data Population.

Oracle Banking Retail Lending will send the data of accounts getting delinquent to Oracle Banking Collections in the various staging tables as specified by Oracle Banking Collections.

Oracle Banking Retail Lending will send the data for new delinquent accounts as well as for updates on the existing delinquent accounts and their related entities (such as, re-payment schedule, bill details etc).

This data will be processed into Oracle Banking Collections through various batch processes. For more details on the batch processes, see Oracle Banking Collections Batch Execution Guide.

Oracle Banking Retail Lending will populate the following staging tables of Oracle Banking Collections:

Table 4-1 Field Description : Staging Tables Data Population

Table Name Description
DM_ACCOUNT_STG When an account becomes delinquent in OBRL, account details are sent to Oracle Banking Collections with the record type I. Similarly, any updates to an already delinquent account are sent by OBRL with the record type U.
DM_ACCOUNT_PARTY_STG When an account becomes delinquent in OBRL, the account customer relationship details are sent to OB Collections in this table, with the record type marked as I. If there are any updates to the account customer relationship for an already delinquent account, OBRL sends these updates with the record type U. Additionally, if there are any deletions to the account customer relationship for a delinquent account, OBRL sends these changes with the record type D.
DM_PAYMENT_STG Payment transactions made on delinquent accounts are sent to OB Collections with the record type I.
DM_ACCOUNT_REPAY_SCH_STG OBRL sends the repayment schedule for delinquent accounts with the record type I.
DM_ACCOUNT_BILL_DTLS_STG OBRL sends Bill Details of delinquent accounts with the record type I. For any updates or deletions, OBRL sends the Bill Details with record types U and D, respectively.