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

Question

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

Full PO Report - Purchasing 12 2018 (2).catalog

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

John Hung-Oracle · Answer

Hi Deepak,  To better serve you, please post this in the Reporting and Analytics for SCM forum since its specific to Procurement subject areas/use cases. Thank you.