Hi Experts,
I’m using Oracle EBS OOTB connector. I see test connection is working fine. but aggregation is failing with below error. I see no duplicate attributes added in the account schema. However it still throwing Ambiguous error message.
The issue here isn’t with the schema but rather how tables are being joined in Oracle. From the link in the screenshot:
Cause: A column name used in a join was defined in more than one table and was referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name or table alias when referenced.
Action: To avoid ambiguity, prefix references to column names that exist in multiple tables with either the table name or a table alias and a period. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or DEPT.DEPTNO.
You may need help from a DBA on this one
Hi @chandramohan27 ,
We are also seeing same issue with Oracle EBS aggregation.
Have you found root cause for this ?
Thanks.
If you have PASSWORD_LIFESPAN_DAYS and/or PASSWORD_LIFESPAN_ACCESSES in the account schema, try to remove them. We saw this issue after the following update:
The release notes incorrectly spells the attribute name, but the PASSWORD_EXPR and PASSWORD_NO_OF_DAYS attributes now contain this information on account aggregation.
1 Like
@nsorlien Could you please share the link for the EBS connector release notes.
Thanks.
I got the the link.
Thanks.
Can i have a link @chandra? and did Aggregation got success after removing it in Schema ?
yes, Aggregation, working after removing those 2 attributes from schema.
1 Like
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.