Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Displaying the Receipt Date for the Purchase Order in PO Details Report
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.....)
Comments
-
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
0 -
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:OI2DL65PState: 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 ONLYThanksDharmendra0 -
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,
Ravi0 -
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
0 -
Hi Dharmendra,
Please try this below column from Procurement - Procure To Pay Real Time
Invoice.Receipt Date
Regards,
Ravi
0 -
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
0 -
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.
0 -
Hi Dharmendra,
Have you found the solution? Having the same issue here.
Thank you
Anna
0 -
I have not found the solution.
0 -
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.
0
