Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

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

Received Response
17
Views
2
Comments
Anick B Augustin_SAMC
Anick B Augustin_SAMC Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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.

Tagged:

Answers

  • Waleed Fetoh
    Waleed Fetoh Rank 3 - Community Apprentice

    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
    Anick B Augustin_SAMC Rank 1 - Community Starter

    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