Limitations In File Write & Append Functionalities In Groovy
(Doc ID 2664597.1)
Last updated on DECEMBER 08, 2023
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
While using the F1-PDBG batch for file write, facing the following issues:
Select Record algorithm runs an SQL query and returns the output. For every record, the Process Record algorithm invokes a Plug-in script which reads the record and writes it to a CSV file.
But, in this approach, since append functionality is not available, we have to read the existing file content and append the new record. This happens for every record.
So, for example, to write 1000 records, the script will have to read the file 1000 times and each time, append the new record.
Some limitations are: no append method available, have to read the entire file contents and override the file with new content, performance & memory issues for larger records may occur.
Also, this approach has to work in a multi-threaded scenario.
A functionality is required that the records can be appended to an existing file without the overhead of reading the file multiple times and enhancing the performance.
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