My Oracle Support Banner

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

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
Symptoms
Cause
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.