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

Rene George

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