DATA ACT Performance Issue : File C Is Not Completing or OPP ERROR: Not Enough Rendering Area

(Doc ID 2234704.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, INSTALL/PATCH

ACTUAL BEHAVIOR
---------------
FV DACT: Performance Issue identified after <Patch 24422526>

Performance: File C is not completing for 2 of our biggest agencies. Looks like the outer loop returns 500k rows and the inner loop is querying dact_PBV that many times.

Sometimes when running the Federal File Creation Process, to generate DACT File C, the spawned program 'Data Act File C Balances Report' is failing with the following error:

-- PUBLISH:
oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.fnd.cp.opp.PostProcessorException: oracle.apps.xdo.XDOException: Not enough rendering area. Please look into the incomplete output file for cause.

Concurrent output and log from this program, as well as OPP manager log, are attached.

EXPECTED BEHAVIOR
-----------------------
File C is should complete in a reasonable time without any errors.

Changes

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