EAR 9.1+:SQL Error In Pending Item Group When Accounting Entries Generated Manually (Doc ID 2193957.1)

Last updated on JANUARY 20, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.1 and 9.2 versions,  when creating a new Pending Item Group in the Receivables module, if the User tries to manually generate the Accounting Entries for a third Item, while using ChartField Inheritance, and IntraUnit Balancing Entries by Fund Code ChartField, the system throws an Error Message.


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

Process ABENDED at Step AR_PGG_SERV.IU_ONLIN.PENDST (SQL) -- RC = 805 (108,524)

CallAppEngine: Application AR_PGG_SERV: AppEngine error. (2,653) PGG_SERVICE_WRK.REQUEST_NBR.FieldDefault Name:AE_CALL PCPC:823 Statement:12
Called from:PENDING_ITEM.DOC_TYPE.SavePostChange Statement:14

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

REPLICATION STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into the FSCM Online Application as User ID VP1
  2. Navigate to: Set Up Financials/Supply Chain > Install > Installation Options > Payables
  3. Place the Posting Method to Detail Offset Method
  4. Navigate to: Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > ChartField Inheritance > ChartField Inheritance
  5. For all ChartField inheritance Groups under Set ID SHARE, place all ChartFields to 'Always Inherit'
  6. Navigate to: General Ledger > Ledgers> Ledger Groups
  7. Open existing Ledger Group RECORDING under Set ID SHARE
  8. In the Balancing tab, select the values: IntraUnit Balancing Entries = Y ; Fund Code = Y
  9. Navigate to: Set Up Financials/Supply Chain > Business Unit Related > General Ledger > General Ledger Definition
  10. Open existing configuration for GL Business Unit US005
  11. Go to the Inter/IntraUnit tab, and ensure the values: IntraUnit Template = US001; Fund = F100
  12. Navigate to: Accounts Receivables > Pending Items > Online Items > Group Entry
  13. Select Group Unit US005, and click on the ADD button
  14. In the Group Control tab, enter a Control of 200 USD, and Count of 5
  15. In the Pending Item 1 tab, enter new Item ID GCS1
  16. Go to the Accounting Entries tab, and click on the lightning bolt, to automatically generate the accounting lines on Item ID GCS1
  17. Manually enter a value in the Fund Code ChartField, and save the changes
  18. Back in the Pending Item 1 tab, enter second Item ID GCS2
  19. Go to the Accounting Entries tab, and click on the lightning bolt, to automatically generate the accounting lines on Item ID GCS2
  20. Manually enter a value in the Fund Code ChartField, and save the changes
  21. Once again in the Pending Item 1 tab, enter third Item ID GCS3
  22. Go to the Accounting Entries tab, and click on the lightning bolt, to automatically generate the accounting lines on Item ID GCS3
  23. The system throws several Error Messages

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