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

Ashok Sriniva-Oracle

Moving this to the OTBI space for guidance.

Sarah Munro 12024679

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

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

Dahlia Gaggan

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!