Errors During Posting And Open Period Program When Working With Balancing Account
Last updated on SEPTEMBER 05, 2014
Applies to:
Oracle Fusion General Ledger Cloud Service - Version 11.1.8.0.0 and laterOracle Fusion General Ledger - Version 11.1.8.0.0 and later
Information in this document applies to any platform.
Symptoms
On : 11.1.8.0.0 version, Capture Transactions-Post Journal Entries and Update Ledger Balances
When attempting to post mixed currency journals, the posting program ends in error.
Th error in the Posting log shows:
The Posting log file shows:
GL_R_PPOS0111: Invalid entered currency balancing account.
SHRD0173: Account: 999999-000-0000-000-000000-00000-00000-00000-00000-000000-000000.
Another symptom of the same problem is with the Open Period program, failing with ORA-01403: no data found although all the necessary retained earnings account already exist.
The error in the Open Period program log shows:
<x gl_multi_bal_seg_api.get_balancing_accounts() 21-JUL-2014 19:02:59 SHRD0086: Error code from executing previous SQL statement: 1403.
<x gloprr: errexit() 21-JUL-2014 19:02:59
GL_SHRD0180: gloroc() - Performing action: Error returned by gloprr.
SHRD0026: Current system time is: .21-JUL-2014 19:02:59
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found
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