ECM: Update Accounting Generates SQL Errors When An Intra-Interunit Setup Is In Place (Doc ID 2220368.1)

Last updated on JANUARY 05, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When creating Inter Unit entries on Cash Management Accounting Entry page, if number of lines are above 100, an SQL error occurs.

Steps:

1. Perform configurations for Inter Unit and Ledger Groups.
2. Manually create over 100 lines.
3. Click on Update Accounting Button at the bottom of the page. Following errors are generated:

"A SQL error occurred. Please consult your system log for details."

"Process 103740 ABENDED at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805 (108,524)"

"CallAppEngine: Application TRA_IU_PROC: AppEngine error. (2,653)

TRA_ACCTG_WRK.TR_HYPERLINK.FieldChange PCPC:1447 Statement:24

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information."

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