Get Error ORA-00904 "POSTED BY" Invalid Identifier When Reviewing Batch (Doc ID 563589.1)

Last updated on NOVEMBER 22, 2022

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
GLXJEENT, GLXJEPST This document replaces 339551.1, which as been deleted

Symptoms

In the journal entry form, when querying for a batch and clicking on Review Journal button, the following error appears:

ORA_00904 POSTED_BY invalid identifier
FRM-40505: unable to perform query

Posting may also fails with:

<< glucce() 17-JAN-2010 13:35:20
SHRD0030: glpubr() encountered an error returning from errexit:

> gluerr() 17-JAN-2010 13:35:20
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: -904 sqlerrml: 43
sqlerrmc:
ORA-00904: "POSTED_BY": invalid identifier

Changes

The issue occurs after applying <patch 4246728>

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.

Get Error ORA-00904 "POSTED BY" Invalid Identifier When Reviewing Batch (Doc ID 563589.1)

Applies to:

Symptoms

Changes

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!