3 Integration via Staging Tables

This topic describes the information about Integration via Staging Tables.

This integration imports data from Product Processor into Oracle Banking Collections using a staging-table-based interface. Product Processor first loads data into OBC staging tables, where it is validated. A scheduled batch job then processes valid staging records and loads them into the various entities in Oracle Banking Collections.

New Delinquent Accounts:

When an account is classified as delinquent in Product Processor, it sends the account and related entity data to the OBC staging area for onboarding. Inbound entities are categorized as mandatory or non-mandatory for onboarding.

Mandatory Entities (mandatory to onboard new account):

• Account Details (For field level details please refer to Account Details)
• Account Party Details (For field level details please refer to Account Party Relationship)
• Party Details (For field level details please refer to Party Details )
• Party Name Details (For field level details please refer to Party Name Details

Non-Mandatory Entities:

• Account Arrears
• Bill Details
• Repayment Address
• Party Address
• Party Contact
• Party Employment Details
• Party Identity Details
• Collateral Details
• Collateral Charge Details
• Collateral Linkage Details

This topic contains the following sub-topics:

• Inbound Mandatory Entity Creation
  This topic describes the information about to Inbound Mandatory Entity Creation.
• Inbound Non-mandatory Entity Creation
  This topic describes the information about to Inbound Non-mandatory Entity Creation.