Need Report that Shows Receipt #, Receipt Date, Received By, PO # and Requester — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

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

Need Report that Shows Receipt #, Receipt Date, Received By, PO # and Requester

313
Views
4
Comments

Description

As we approach our first year end on Oracle, our Financial Services Director is in need of a report that shows the following items: 

PO Number

Item Description (that was received)

Received By (user who entered the receipt)

Receipt Date (date entered on the self service receipt screen)

Receipt Number (system generated number)

I have searched OTBI subject areas and the P2P one does have the receipt number and date under invoice but it is blank on the invoice so of no value.  I haven't found any other Procurement subject area that contains receipt information from self service (we are not using inventory receiving).  

Has anyone found a subject area that contains the self servicing receiving information above or has a custom report on it they could share?  I know these fields exist in the system as you can run the Manage Receipts screen and find all of these columns but Manage Receipts does not allow me to search all POs and by a Receipt Date, it requires a specific PO # , etc.  

 

Use Case and Business Need

The need for this is that we are a municipality and do not close the period on the last day of our fiscal year.  Period 12/13 may remain open for 2-3 months after year end close, this is due to specific requirements of State and Local gov't.  

We need a report we can run that is going to show if users are entering the WRONG receipt date during this transition period (i.e. entering 9/30 for goods actually received in October just to get the receipt in).  

Original Idea Number: a56c50a006

2
2 votes

Submitted · Last Updated

Comments

  • Ashok Sriniva-Oracle
    Ashok Sriniva-Oracle Rank 3 - Community Apprentice

    Moving this to the OTBI space for guidance.

  • Sarah Munro 12024679
    Sarah Munro 12024679 Rank 3 - Community Apprentice

    Hi

    We had the same problem & had to create a custom data model for this.

    Our requirement isn't exactly the same as yours however, I believe the attached CATALOG file should have all the fields you need.

    There are 2 data sets, one (project POs) for just PO data & the other (potential new with receipts) to include receipt data too.

    I hope this helps

    regards

    Sarah

     

     

  • Rene George
    Rene George Rank 1 - Community Starter

    Thank you.  I'll see if our report developer can work with this.  

  • Dahlia Gaggan
    Dahlia Gaggan Rank 1 - Community Starter

    Hello! The user above (Sarah) you mentioned a catalog file, could you attach it here for me? I don't see any attachment. Thank you so much!