My Oracle Support Banner

GLPPOS - GL Posting Program Completes With Error On Funds Failure - Should Be A Warning (Doc ID 2733594.1)

Last updated on DECEMBER 03, 2020

Applies to:

Oracle Public Sector Financials - Version 12.2 and later
Oracle General Ledger - Version 12.2 and later
Information in this document applies to any platform.
GLPPOS
PERF0005
glpubr
ORA-01403
Funds
Fail

Symptoms

In 12.2.9 UAT instance GL Posting (GLPPOS) completes in error with the following messages in the log file:


+---------------------------------------------------------------------------+
General Ledger: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

GLPPOSS: Posting: Single Ledger
+---------------------------------------------------------------------------+

Current system time is 29-OCT-2020 13:33:39

+---------------------------------------------------------------------------+

[29-OCT-2020 13:33:39]:
>> glpmai()
PPOS0003: *** Posting Process Started ***
PPOS0004: All phases to posting will be detailed in this log.
PPOS0219: glpmai() - Your Posting Run ID is 804542
[29-OCT-2020 13:33:39]:
.
.
.
.
.
.
>> glpubr.while()
SHRD0147: Finished processing rows
[29-OCT-2020 13:33:40]:
>> glpubr.update_gl_balances()
[29-OCT-2020 13:33:40]:
>> glpubr.update_gl_balances query is ready()
PERF0005: Oracle error detected in glpubr() - ORA-01403: no data found
[29-OCT-2020 13:33:40]:
[29-OCT-2020 13:33:40]:
>> gluerr()
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 24
sqlerrmc:
ORA-01403: no data found
sqlerrp: sqlerrd: 0 0 0 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...
[29-OCT-2020 13:33:40]:
>> glpuch()
[29-OCT-2020 13:33:40]:
<< glpuch()
[29-OCT-2020 13:33:40]:
>> glpueh()
[29-OCT-2020 13:33:40]:
<< glpueh()
[29-OCT-2020 13:33:40]:
>> glpsqx()
[29-OCT-2020 13:33:40]:
<< glpsqx()
[29-OCT-2020 13:33:40]:
>> glucmt()
[29-OCT-2020 13:33:40]:
<< glucmt()
[29-OCT-2020 13:33:40]:
>> glpdit()
[29-OCT-2020 13:33:40]:
>> gluddl()
[29-OCT-2020 13:33:40]:
<< gluddl()
[29-OCT-2020 13:33:40]:
<< glpdit()
PPOS0002: Posting terminated with fatal errors
[29-OCT-2020 13:33:40]:
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size:
9909
Concurrent program returned no reason for failure.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-OCT-2020 13:33:40

+---------------------------------------------------------------------------+

Changes

 

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


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