GLPPOS When Post Journals Get PPOS0225 Number of updated GL_BALANCES rows does not equal the number or rows in GL_POSTING_INTERIM_260738 (Doc ID 1327833.1)

Last updated on OCTOBER 25, 2023

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:GLPPOS - Posting

Symptoms

This note is archived, please refer to <note:1032339.6> GLPPOS: GL Posting Routine Errors in GLPUBR: PPOS0225, PPOS0226, SHRD0042, SHRD0043, ORA-01403

When run GLPPOS and post journal batches the following error occurs :-

Error
------
PPOS0225: glpubr(): Number of updated GL_BALANCES rows does not equal the number or rows in GL_POSTING_INTERIM_260738 table.
PPOS0226: Balances update will be ROLLED BACK. Posting is stopping here.
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-01403: no data found

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

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

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

GLPPOS When Post Journals Get PPOS0225 Number of updated GL_BALANCES rows does not equal the number or rows in GL_POSTING_INTERIM_260738 (Doc ID 1327833.1)

Applies to:

Symptoms

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!