Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SOA Infra Tables

3440487Aug 30 2017 — edited Aug 30 2017

I am working on Fusion Applications for which I want to write a Report (BI) that gives me Approvals for PO/Requisitions.

I have been given access to the following tables from SOA Infra such as:

SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFTASKHISTORY TO FUSION_RUNTIME;

SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFASSIGNEE TO FUSION_RUNTIME;

SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFTASK TO FUSION_RUNTIME;

SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFAPPROVALGROUPS TO FUSION_RUNTIME;

SQL> GRANT SELECT ON PRC_FUSION_SOAINFRA.WFAPPROVALGROUPMEMBERS TO FUSION_RUNTIME;

IS there a way to find how these tables are related or a repository of the SOA Infra tables and their relations

Any guidance to this would be appreciated.

This post has been answered by Krishna Hanumantharao on Aug 30 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2017
Added on Aug 30 2017
3 comments
2,812 views