My Oracle Support Banner

Posting Journal Completed With Error ORA-01403 and Journal Status is Processing (Doc ID 2150012.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLPPOS - Posting

Symptoms

When attempting to post a journal including cone combinations with a new segment value for Balancing Segment, the following error shows in the Log file:

ERROR

<< glpidff_de_concat_flexfield() 13-JUN-2016 13:41:25
RE BSV: eg.TST
Please choose an existing combination.
TST-000-000-000-0000
SHRD0030: glpire() encountered an error returning from errexit:


>> gluerr() 13-JUN-2016 13:41:25
Error in ROUTINE: glpire, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 0 0 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...



STEPS
The issue can be reproduced at will with the following steps:
1. Find Batch
2. Post
3. Check the Log file


Changes

 New Balancing Segment Value used in journals.

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
Changes
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.