Subject Area "Procurement - Requisition Real Time" Issue — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

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

Subject Area "Procurement - Requisition Real Time" Issue

76
Views
3
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

PERFORM CONTENT SERVICES LIMITED


Description (Required):

Hi Team,


We would like the actions from the section “Request Information” to be reflected in the Oracle Procurement Requisition report, but it appears that the "Comment" is not stored in the expected Subject Area “Procurement - Requisitions Real.


We have found out that the "Comment" has been stored in fa_fusion_soainfra.wfcomments but the WFCOMMENT has not been exposed in Subject Area.


We would like to add the WFCOMMENT column to our Procurement Requisition report. 

Currently, all columns shown in the below screenshot are being made by using OTBI Analysis.

All columns are from Subject Area “Procurement - Requisitions Real", and we would like to add the WFCOMMENT in our report.

Please see the screenshot below:


Regards,

Wilson


Use Case and Business Need (Required):

We would like the actions from the section “Request Information” to be reflected in the Oracle Procurement Requisition report.


Enhancement Request / Service Request:

4
4 votes

Submitted · Last Updated

Comments

  • Ivan Pena-Oracle
    Ivan Pena-Oracle Rank 2 - Community Beginner

    Moved from Purchasing.

    Ivan

  • Priya_B
    Priya_B Rank 1 - Community Starter
    edited Mar 28, 2024 2:17PM

    Hi All,

    I have been trying to pull a report with basic requisiton information - Requisition number, status, creation date, preparer.

    However, the OTBI is not pulling all the requisitions that are showing up in the Manage Requisitions page.

    I further tried to just pull the requisition number , yet the same issue.


    Could you please help with the same.


    @Ivan Pena-Oracle @Ashok Sriniva-Oracle

  • Ed Redding
    Ed Redding Rank 1 - Community Starter

    Has there been a response to this question? (We would like to add the WFCOMMENT column to our Procurement Requisition report. )

    We have found out that the "Comment" has been stored in fa_fusion_soainfra.wfcomments but the WFCOMMENT has not been exposed in Subject Area.

    We would like to add the WFCOMMENT column to our Procurement Requisition report. 

    Currently, all columns shown in the below screenshot are being made by using OTBI Analysis.

    All columns are from Subject Area “Procurement - Requisitions Real", and we would like to add the WFCOMMENT in our report.