My Oracle Support Banner

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

Last updated on JUNE 07, 2021

Applies to:

Oracle General Ledger - Version and later
Executable:GLPPOS - Posting
Executable:GLMMMP - Mass Maintenance Program


NOTE: In the images/examples above or below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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_NNNNN 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
glpubr:updated balances rows != gl_interim_posting rows. Posting stops.

sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
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


To view full details, 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 a vibrant support community of peers and Oracle experts.