Errors During Posting And Open Period Program When Working With Balancing Account

(Doc ID 1923802.1)

Last updated on SEPTEMBER 05, 2014

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.8.0.0 and later
Oracle 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