Oracle Transactional Business Intelligence

Purchase requistion Status analysis
Summary
Analysis for Purchase Requistions status
Content
Hi,
I need to developed OTBI analysis for Purchase Requisition with below information:
PR number
PR Amount
Created by
Creation date
Status
Pending with
Can someone please help me to develop this analysis in OTBI.
Thannk
Tagged:
Answers
-
Try creating OTBI through "Procurement-Requisitions Real Time" subject area
-
Hi,
You must be aware of the following for creating the analysis
1.You should be aware of which SA to be used for creating the analysis?
2. what are the reportable objects for the below fields.
Regards,
Ramesh
-
Hi,
You will find the R12_ERP_SCM_OTBI_Database_Mapping Excel in the Oracle site , it will be very useful to find the Subject Area , Presentation column , Database column and even Table name
Regards,
Vijay S