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
36
Views
5
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

  • Elena-Cristina Staniloiu-Oracle
    Elena-Cristina Staniloiu-Oracle Rank 1 - Community Starter

    Hello @Anick B Augustin_SAMC,

    You can create a custom OTBI analysis using seeded OTBI 'Procurement - Purchasing Real Time' subject area.

    Please see like example:

    image.png

    And you can create a filter based on action date: ascending for your case.

    Action date is the column that you need for create your custom OTBI analysis.

    Thank you,

    Elena

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 1 - Community Starter

    Hi @Elena-Cristina Staniloiu,

    User is asking that is there any direct column available that 'First PO Approved Date ' will come in the OTBI Subject Area. If the direct column is not possible to show in the OTBI Subject Area, please give us the confirmation that the direct column is not feasible so that we will inform the user.

    Thanks,

    Prathyusha

  • Elena-Cristina Staniloiu-Oracle
    Elena-Cristina Staniloiu-Oracle Rank 1 - Community Starter

    Hello @Anick B Augustin_SAMC,

    We don't have 'First PO Approved Date ' column in seeded OTBI 'Procurement - Purchasing Real Time' subject area

    As I mentioned above you can create a custom OTBI analysis using seeded OTBI 'Procurement - Purchasing Real Time' subject area using "action date" column from Action history and you can order asc based on data.

    This will achieve your requirement.

    Thank you,

    Elena