General OBIEE

Get Involved. Join the Conversation.

Topic

    Dharmendra Jha
    Displaying the Receipt Date for the Purchase Order in PO...
    Topic posted July 7, 2019 by Dharmendra Jha, tagged OTBI 
    77 Views, 6 Comments
    Title:
    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.....)

    Comment

     

    • Joel

      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

      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

        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

      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

        Hi Dharmendra,

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

        Invoice.Receipt Date

         

        Regards,

        Ravi

         

    • Dharmendra Jha

      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