GLPPOS - GL Posting Program Completes With Error On Funds Failure - Should Be A Warning
(Doc ID 2733594.1)
Last updated on AUGUST 11, 2023
Applies to:
Oracle Public Sector Financials - Version 12.2 and laterOracle 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 |