FTP Process on LEDGER_STAT Only Outputs 2,000 Records
(Doc ID 1290007.1)
Last updated on MARCH 27, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 5.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Funds Transfer Pricing (FTP), when you run an FTP process against more than a thousand records in the LEDGER_STAT table, FTP only outputs 2,000 records. For a Ledger Stat FTP process, FTP should output two records for every one input record: one for Financial Element 170 (Avg Transfer Rate) and one for Financial Element 450 (Transfer Charge/Credit). So, if you have an input data set of 5,000 records, you expect to get at least 10,000 output records. However, FTP stops outputting records at 2,000.
If you run an FTP process against 800 records in Ledger Stat, all records are processed successfully. The issue only occurs when FTP has to output more than 2,000 records.
Steps to Reproduce:
- Populate the LEDGER_STAT table with more than 2,000 records
- Go to Funds Transfer Pricing
- Go to FTP Processing > Standard Process
- Create and run an FTP Process against Ledger Stat
The FTP process inserts a maximum of 2,000 records into LEDGER_STAT.
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