My Oracle Support Banner

We Need To Give The Client Extract Of GL Tables (Doc ID 2646024.1)

Last updated on MARCH 09, 2020

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.19.10.0 version, Technology Management - Reports/Analytics

We need to give the client extract of GL tables

Client needs the extracts for GL tables from production for auditing purposes.
But, for gl_balance, gl_je_lines, and gl_code_combinations, the complete output is not getting generated.
They tried with CSV output and opening that in excel. They are only getting extract till 10,48.756 rows.

The parameters used are:
- period name
- ledger
- last_update_date between to_date and from_Date.

Is there another way they can get these extracts and share it with client?

The data count is more than 2 million.
Customer tried to do a POC of extracting the data from GL_JE_LINES (10 million plus) in their Instance.


Error Details from Notification:


Schedule Name: GJL BICC EXT POC 1
ESS Request Id: 340447
Start Time: 2020-01-27 10:44:27
End Time: 2020-01-27 20:49:33
Total Duration: 605 min 5 sec
Number of data stores: 1
________________________________________
Extract Summary
Data Store Duration (sec) Row Count Status Message
FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO 36006 41546000 FAILURE oracle.obiacm.dataExtract.DataExtractException: FscmTopModelAM.FinGlJrnlEntriesAM.JournalLinePVO - Error read results - Error while fetching rows from server: java.io.IOException: end of file at oracle.obiacm.utils.WriterUtils.readResults(WriterUtils.java:296) at oracle.obiacm.utils.WriterUtils.extractConcurrent(WriterUtils.java:197) at oracle.obiacm.dataExtract.BIVOExtractTask.extractConcurrent(BIVOExtractTask.java:698) at oracle.obiacm.dataExtract.BIVOExtractTask.extractData(BIVOExtractTask.java:576) at oracle.obiacm.dataExtract.BIVOExtractTask.doNormalExtract(BIVOExtractTask.java:232) at oracle.obiacm.dataExtract.B
 

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.