My Oracle Support Banner

Same Task Not Working In UAT But Working In Dev And SIT (Doc ID 2937689.1)

Last updated on JUNE 27, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

On 8.1.2,

Task is failing with the error "ORA-00918: column ambiguously defined" 

Steps to reproduce:
1. Go to batch maintenance screen and create batch with t2t transform data task

2. Execute batch in the batch execution screen.

Expected Behavior:
Execution should complete successfully without any error

Actual Behavior:
We are seeing the below error in the task log:

09-03-23 06:11:53 GMT AM][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-00918: column ambiguously defined

[09-03-23 06:11:53 GMT AM][INFO][BACKEND][OFSAA][T2TCPP] ClsUBatchLoader::Bulk, Error Messaage : ORA-00918: column ambiguously defined.

Changes

 N/A

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.