My Oracle Support Banner

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

Last updated on NOVEMBER 09, 2021

Applies to:

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

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

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.