My Oracle Support Banner

Limitations In File Write & Append Functionalities In Groovy (Doc ID 2664597.1)

Last updated on MAY 01, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Goal

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.
 

Solution

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
Goal
Solution
References


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