Oracle Transactional Business Intelligence

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

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

1587
Views
13
Comments

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.....)

Tagged:
«1

Comments

  • Joel Acha11111
    Joel Acha11111 Rank 5 - Community Champion

    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
    Dharmendra Jha-160968 Rank 2 - Community Beginner

    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
    ravikiran goda-Oracle Rank 5 - Community Champion

    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
    Dharmendra Jha-160968 Rank 2 - Community Beginner

    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
    ravikiran goda-Oracle Rank 5 - Community Champion

    Hi Dharmendra,

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

    Invoice.Receipt Date

     

    Regards,

    Ravi

     

  • Dharmendra Jha-160968
    Dharmendra Jha-160968 Rank 2 - Community Beginner

    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
    Eric Geddes Rank 3 - Community Apprentice

    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
    Anna Patvakanova Rank 1 - Community Starter

    Hi Dharmendra,

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

    Thank you

    Anna

  • Daniel Clancy
    Daniel Clancy Rank 1 - Community Starter

    I have not found the solution.   

  • Tracy C
    Tracy C Rank 1 - Community Starter

    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