My Oracle Support Banner

Significance Of N_orig_payment_amt In Stg_od_Accounts Table (Doc ID 2857270.1)

Last updated on MARCH 27, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.


Client is currently using OFSAAI 8.0.2 version for AML & KYC applications, and wanted to check the significance of the column n_orig_payment_amt in stg_od_Accounts table.
This column is received as part of ETL from the source applications(Flexcube), in OFSAA AML client don't see this column is used in BDF or the Scenario jobs.
As part of extraction process, source application is facing performance issue while trying to fetch the details for this column.
The source application has asked the confirmation from OFSAA team whether they could remove this column in the extraction query to save the time taken to generate the data.
Kindly check and confirm whether is there any impact in the AML application if client stop sourcing the values in this column


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.