For Oracle EBS, AR, there is no data in AR_DISPUTE_HISTORY (0 rows). Hence when running the transformation, it is giving the following error. How to resolve the same ?
Error while executing transformation Create View: AR_DISPUTE_HISTORY
ERROR: Relation "ar_dispute_history" does not exist
Hello Sanket,
Usually the error about "Relation xxx does not exist" occurs when the table doesn't exist.
Often it's cause by misspell in the table check, could you check it?
Also - could you provide us with the sql code sample? Without it it's impossible to provide more detailed solution.
I've created an view based on empty table without any problems:
Best Regards,
Mateusz Dudek
The table has zero rows in the siurce system. I created the table (If NOT Exists) as a transformation and that solved this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
