EGL 9.1 Brazil: Performance Issue On Sped ECD GLSPED_D_BRL, Stuck On Step GLSPED_D_BRL.IRGI1550.Rgl155

(Doc ID 2250364.1)

Last updated on JANUARY 11, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version Brazil localization, Performance

Issues Generating SPED Contabil (GLSPED_D_BRL)

Users are having issues to generate the SPED Contabil. The process ran on the same step during all night and did not finalize.

There are a large number of entries on the PS_JRNL_LN tables (Great than 2 million).
 

ERROR
-----------------------

Stops on step GLSPED_D_BRL.IRGI1550.Rgl155



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Report: GLSPED_D_BRL
2. Report run long and gets stuck on step GLSPED_D_BRL.IRGI1550.Rgl155

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