Does anyone know what tables are needed to create OTBI report "Transactions awaiting my action"?

MarysueMcCracken

Summary:

Indirect Procurement stakeholder wants to create an OTBI report for "Transactions Awaiting My Action". This would be used to review POs that were not successful for some reason and need manual invervention.

Content (required):

Does anyone know what tables are needed to create OTBI report

Version (include the version you are using, if applicable):

22C

Code Snippet (add any code snippets that support your topic, if applicable):

Noelle Bartlam-Oracle

Have you reviewed the data lineage document?

https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

Gaurav Bharadwaj-Oracle

Hi,

The process of figuring out the correct subject area for your needs roughly goes like this :

1) Identify the tables and columns which store the data you want

2) Review the Data Lineage documentation to figure out the mapping of those tables and columns with the subject area's folders and attributes

3) Create an Analysis using the Subject Area you found in step 2

This process is explained here : How to verify if a certain attribute is available for reporting in OTBI ? (Doc ID 2447001.1)

Kiran Katti Mobily KSA

Hi MarysueMcCracken,

Just curious, how do you go to this screen, I am not able to find it in my UI. Can you share the details . Thanks. Seems like a Visual builder page..

Gaurav Bharadwaj-Oracle

If its a custom page built in Visual Builder, it may not be possible to report on all of this data via OTBI.

Dont quote me on that though !