GLPPOS Posting Or GLMMMP Mass Maintenance Errors in GLPUBR: PPOS0225, PPOS0226, SHRD0042, SHRD0043, ORA-01403 (Doc ID 1032339.6)

Last updated on AUGUST 12, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
HP Tru64 UNIX
Executable:GLPPOS - Posting
Executable:GLMMMP - Mass Maintenance Program

Symptoms

Your General Ledger Posting (GLPPOS) failed with the following in the log:
The same error can happen when running GLMMMP Mass Maintenance Program when doing Move Merge.

<< glpubr.concurrency() 29-DEC-1999 08:49:56
PPOS0225: glpubr(): Number of updated GL_BALANCES rows does not equal the number of rows in GL_POSTING_INTERIM_24697 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.

<x glpubr() 29-DEC-1999 08:53:24
SHRD0042: Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
glpubr:updated balances rows != gl_interim_posting rows. Posting stops.
CALL YOUR CUSTOMER SUPPORT REPRESENTATIVE!

***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-1403: no data found
sqlerrp: sqlerrd: 0 0 15164 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...
PPOS0064: Posting exited with error status
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-DEC-1999 08:53:24
+---------------------------------------------------------------------------+

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms