Financial Management - PSFT (MOSC)

MOSC Banner

Ambigously Defined Sql

edited Jan 20, 2015 10:03AM in Financial Management - PSFT (MOSC) 1 commentAnswered

I am running the General Ledger -> Review Financial Information -> Ledger Inquiry in F92.  The auto constructed sql fails on an ambiguous definition of the dept for row security.

918 - ORA-00918: column ambiguously defined   is the trace message.

FROM PS_LEDGER A ,

  PS_SEC_DEPT_USER SCF1

.

.

.

.

OR DEPTID     IN

  (SELECT A1.DEPTID FROM PS_DEPTSEC02_VW A1 WHERE A1.OPRID='xxxxxx'

  ))

AND A.DEPTID       = SCF1.DEPTID

no qualifier is attached to the DEPTID.  Has anyone else seen this ?

thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center