R12.2:Publish and Presentation: Failed to Get The Expanded Values, java.lang.NullPointerException for Large FSG (Doc ID 1967140.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 12.2.3 and later
Oracle Report Manager - Version 12.2.3 and later
Information in this document applies to any platform.
Executable:RGRARG - Financial Statement Generator
Executable:RGFSGXML - Program - Publish FSG Report

Symptoms

For a very large FSG report (greater than 10,000 reports), the Publish and Presentation program is failing with :

" Failed to get the expanded values: oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException;
Published doc Id: -1Publishing did not complete successfully, unable to insert data into database"


Steps:
--------
1. Financial Report Submission
2. Select the report and components
3. Submit
4. Check the logs

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms