Need 'PO First Approved Date' in the OTBI Subject Area

Anick B Augustin_SAMC

Please guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved date” but showing in header report "Approved date" without mentioning it is the ‘PO last approved date’.Since it is not clear hence confusing everyone and giving wrong impression or incorrect reading from “PR approved date” to “PO approved date”, while here the PO approved date = PO last approval date.

Waleed Fetoh

You can try implementing the following logic:

select min(action_date)
from po_action_history poh
where 1=1
and action_code = 'APPROVE'
and object_type_code = 'PO'
--and role_code = 'APPROVER'

Anick B Augustin_SAMC

Hi Waleed Fetoh,

Thanks for the reply,

But I want this in the OTBI 'Procurement - Purchasing Real Time' subject area where I am not getting direct column. Can you please help me on this. If this is not possible in the OTBI Subject Area, please give me the confirmation that the direct column is not feasible.

Thanks,

Prathyusha