Displaying the Receipt Date for the Purchase Order in PO Details Report

Dharmendra Jha-160968

Summary

Displaying the Receipt Date for the Purchase Order in PO Details Report

Content

Hi ,

I have PO Details Report with the following fields. 

PO Number,

PO Date,

PO Status

PO Line Number

PO Line Description

Order Quantity

Unit Price

PO Line Value

PO Line Received Quantity

Total Receipt Amount

Total Match Amount

I am trying to display Last Receipt Date for PO Number. I have created report based on the logical sql on the combination of "Procurement - Purchasing Real Time" and "Procurement - Procure to Pay Real Time" subject area.

I am looking to display receipt date column & unable to find in these two subject area. Is there a specific field with some different name as Receipt Date in these two subject area OR do I need to join some other subject area.

Basically its a Receipt Date which appears under Receipts section when you click on View Details button on the PO details screen in the Application screen.

Version

19B(11.13.....)

Joel Acha11111

Does this data lineage documentation help you trace back from the subject areas to the database columns?

 

Oracle Support Document 1499772.1 (Is there a Dashboard/Reports Content Guide For Fusion BI Applications which list the standard dashboards - https://support.oracle.com/knowledge/Oracle%20Fusion%20Applications/1499772_1.html

 

Dharmendra Jha-160968

Apologies.. I should have mentioned that its a customised OTBI Report in SAAS environment. Is there a documentation for the Procurement subject area post 19B patch.

Although I can see that there is a receipt date field in the "Procurement - Procure to Pay Real time" subject area but when trying to create a sample analysis with the PO Number the report output displays error.

 

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: ADFException-3007: The View Object "FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO" is used as the destination of more than one View Link. (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Procurement - Procure To Pay Real Time"."Delivery Obsolete"."Receipt Date" s_1, "Procurement - Procure To Pay Real Time"."Purchase Order Obsolete"."Order" s_2 FROM "Procurement - Procure To Pay Real Time" WHERE (("Purchase Order Obsolete"."Order" = 'HME314122') AND ("Purchase Order Additional Attributes"."Closed for Receiving Date" IS NULL)) FETCH FIRST 400001 ROWS ONLY

 

Thanks

Dharmendra

 

ravikiran goda-Oracle

HI Dharmendra,

Please review the below document

Procurement - Procure To Pay Real Time Subject Area "Delivery Obsolete" Errors Out [nQSError: 77031] (Doc ID 2494931.1)

"Procurement - Procure To Pay Real Time"."Delivery Obsolete"."Receipt Date" is a hidden column and as it's named, it's an obsolete column.
Please remove it from your logical sql. It should never be used.

Regards,
Ravi

 

Dharmendra Jha-160968

Thanks for responding Ravi. I am aware of this that this is the obsolete Column but can you suggest which is the equivalent column to be used in either of  the subject area.

Procurement - Purchasing Real Time

Procurement - Procure to Pay Real Time

.or in which subject area will I find the PO receipt date column for respective PO & PO HEADER ID

ravikiran goda-Oracle

Hi Dharmendra,

Please try this below column from Procurement - Procure To Pay Real Time

Invoice.Receipt Date

 

Regards,

Ravi

 

Dharmendra Jha-160968

Hi Ravi,

I did try to use the Invoice.Receipt Date but the issue was this is coming as blank. there is no data for that field. so had to go with the Obsolete one. Do I need to ask the oracle to populate this field as I guess Oracle are responsible for loading the SAAS environment.

Thanks

Dharmendra

Eric Geddes

Was this ever resolved? We're having the same problem. In fact, none of the Procurement Subject Areas appear to contain the Receipt Date—other than the empty Invoice.Receipt Date and the erroring Delivery Obsolete.Receipt Date fields mentioned above. (According to the 19C data lineage workbook.)

So, which Subject Area do we use to report on the date that goods were received? What field?

Help? Please? Thank you.

Anna Patvakanova

Hi Dharmendra,

Have you found the solution? Having the same issue here.

Thank you

Anna

Daniel Clancy

I have not found the solution.   

Tracy C

We have a similar issue with two other Purchasing fields (PO Variance and PO Accrual Accounts). I'm curious if anyone knows the subject area where these can be found or if there is an alternative solution for pulling in this information as it appears that only the PO Charge Account is available in the Purchasing subject areas.

https://community.oracle.com/customerconnect/discussion/666915/subject-area-for-po-variance-and-po-accrual

IIGC

several years later…. has anyone find a solution?

John Hung-Oracle

Hi, If you are still looking for a solution, please post this question in the Reporting and Analytics for ERP forum since its specific to Procurement subject areas/use cases. Thank you.