GLPPOS Posting Error- PERF0005: Oracle Error Detected In Glpidr() - ORA-01036: Illegal Variable Name/num (Doc ID 2820132.1)

Last updated on DECEMBER 04, 2023

Applies to:

Symptoms

When attempting to post some journal entries, the following error is seen in the log file:

ERROR
-----------------------
PERF0005: Oracle error detected in glpidr() - ORA-01036: illegal variable name/number
  
SHRD0030: glpire() encountered an error returning from errexit:
>> gluerr()
Error in ROUTINE: glpire, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: -1036 sqlerrml: 40
sqlerrmc:
ORA-01036: illegal variable name/number

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

PPOS0002: Posting terminated with fatal errors


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use General Ledger Super User Responsibility.
2. Navigate to Journals > Post.
3. Check the concurrent and notice the error mentioned above.

This issue is being seen on specific journals and not all.

Changes

 Occurring after upgrade from 12.1.3 to 12.2.9.

Cause

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