Oracle Transactional Business Intelligence

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
102
Views
20
Comments
2»

Answers

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Hello @Anick B Augustin_SAMC,

    Sorry for delay in my response.

    I checked and I noticed that we also have in "Procurement-Purchasing Real Time' subject area section related:

    Time-Approved Date.

    This section is providing us information on different hierarchical time components like Year, quarter, Month and Day anchored on Purchase Order Approved Date.

    You can use all fields under this column.

    For respond to your question, yes you can use this field: Reported Date for achieve your requirement.

    Thank you,

    Elena

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Hello @Anick B Augustin_SAMC,

    Kindly check my last update from above, from 23 SEP 2025?

    Please let me know if any questions for me.

    Thank you,

    Elena

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Anick B Augustin_SAMC
    Anick B Augustin_SAMC Rank 3 - Community Apprentice

    Hi @Elena-Cristina Staniloiu,

    We are getting that PO first approved date from other column 'report date' in the Procurement-Purchasing Real Time' subject area. Can you please tell us that 'report date' column field and its functionality.

    Thanks,

    Prathyusha

  • Hello @Anick B Augustin_SAMC,

    Please check my above response, I will also mention here:

    I checked and I noticed that we also have in "Procurement-Purchasing Real Time' subject area section related:

    Time-Approved Date.

    This section is providing us information on different hierarchical time components like Year, quarter, Month and Day anchored on Purchase Order Approved Date.

    You can use all fields under this column.

    For respond to your question, yes you can use this field: Reported Date for achieve your requirement.

    Thank you,

    Elena