My Oracle Support Banner

Errors During Posting And Open Period Program When Working With Balancing Account (Doc ID 1923802.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Oracle Fusion General Ledger - Version and later
Information in this document applies to any platform.


On : 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
ORA-01403: no data found


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.