Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real Time

Received Response
11
Views
1
Comments
Deepak Bhatt
Deepak Bhatt Rank 1 - Community Starter

Hi All,

Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing)

Subject Area : Procurement-Purchasing Real Time and Procurement-Requisitions Real Time

I am not able to find the above "Entered By" Field From the Procurement-Purchasing Real Time Subject Area . That's why I try to add the
another subject area Procurement-Requisitions Real Time to get the field "Entered By" and when I am trying to add the attribute "Display Name" (Entered By) inside folder Requisition Preparer in Procurement-Requisitions Real Time Subject area and join with it Procurement-Purchasing Real Time Subject area, it is giving me the below error in the results while running the OTBI report

So, if anyone have any idea how to resolve the below error in the OTBI Report, Please feel free to comment and help on it to provide the resolution


Thanks & Regards

Answers