My Oracle Support Banner

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

Last updated on AUGUST 19, 2019

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
***Checked for relevance on 26-Apr-2011***
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
Symptoms
Changes
Cause
Solution
References

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