My Oracle Support Banner

Trading Partners Report (ECRDTPD) Fails With ORA-942 table or view not found for RA_ADDRESSES (Doc ID 785928.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Oracle EDI Gateway - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
REPORT:ECRDTPD.RDF - Trading Partners


Symptoms

Running report Trading Partners from eCommer Gateway responsibility fails with 


ORA-0942: table or view not found error.

Log file shows:


ECRDTPD module: Trading Partners Log File:

Enter Password:
ORA-00942: table or view does not exist
select etg . tp_group_code , etg . tp_group_description , eth . tp_header_id , eth . tp_code , eth . tp_description , eth . tp_reference_ext1 , eth . tp_reference_ext2 , eth . tp_contact_name , eth . tp_contact_job_title , eth . address1 , eth . add
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: table or view does not exist
select etg . tp_group_code , etg . tp_group_description , eth . tp_header_id , eth . tp_code , eth . tp_description , eth . tp_reference_ext1 , eth . tp_reference_ext2 , eth . tp_contact_name , eth . tp_contact_job_title , eth . address1 , eth . add


Changes

None

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
 Still Have Questions?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.