Ambigously Defined Sql
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.