Reporting and Analytics for Financials

Get Involved. Join the Conversation.

Comments

  • Julien Dubouis

    Hi, 
    I think this note could be helpful : How to Create BI Publisher Report on Workflow Notifications ? (Doc ID 2135790.1)

    In particular, I checked the table FA_FUSION_SOAINFRA.WFTASK_VIEW and it seems to contain the information you are looking for.
    If you work with the following views, you should get a nice report: 

    FA_FUSION_SOAINFRA.WFTASK
    FA_FUSION_SOAINFRA.WFTASK_VIEW  -- filter on WFTASK where STATE IS NULL OR STATE IN ('ERRORED', 'STALE', 'WITHDRAWN', 'EXPIRED')
    FA_FUSION_SOAINFRA.WFTASKHISTORY_VIEW - history (join on TASKNUMBER)
    FA_FUSION_SOAINFRA.WFTASKTL_VIEW - title (join on TASKID)
    FA_FUSION_SOAINFRA.WFCOMMENTS_VIEW - comments (join on TASKID)
    FA_FUSION_SOAINFRA.WFATTACHMENT_VIEW - attachments (join on TASKID)
    FA_FUSION_SOAINFRA.WFASSIGNEE_VIEW - assignee (join on TASKID)

    Best regards,
    Julien

  • Gail Langendorf

    Typically there is a white paper collection, for example,
    White Papers HCM Document 1504483.1
    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=170419429851509&id=1504483.1&_afrWindowMode=0&_adf.ctrl-state=782jbtixt_43

    White Papers and Articles for Oracle Enterprise Resource Planning Cloud Service (Doc ID 1970326.1)
    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=525646146890246&id=1970326.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=d7scjvm08_78

  • Glen Ryen

    Hi Nathanael,

    You didn't have the full path (subject area and folder) to the two invoice ID columns within the a and b (inner) SELECT statements.  And for the outer SELECT statement and the join condition, then you need to refer to the same columns with just the a or b table alias.  Hopefully that makes sense.  Give this a try:

    SELECT a."Invoice ID", b."Invoice ID"
      FROM (SELECT "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID"
              FROM "Payables Invoices - Transactions Real Time") a
           INNER JOIN
           (SELECT "Procurement - Procure To Pay Real Time"."Invoice"."Invoice ID"
              FROM "Procurement - Procure To Pay Real Time") b
              ON (a."Invoice ID" = b."Invoice ID")

    Hope that helps,

    Glen

  • Marybeth Snodgrass

    The syntax for drilling to supplier profile is not included in the document attached to this post (the document provided on initial post that includes syntax for all transaction detail drills to fusion has been updated to include the new receivables actions now available with 19c). 

    After much searching and going around in circles, i finally found a white paper that details how to navigate to Supplier Profile. 

    I'll save you some steps and provide the download URL: https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2556026.1%3ANAVTOSUPPLPROF_19C&docType=WHITE%20PAPER&action=download

     

    As an aside, it would be great if white paper documentation was located in one central location that is kept up to date as documents are added and edited..

     

  • Marybeth Snodgrass

    The syntax for drilling to supplier profile is not included in the document attached to this post (the document provided on initial post that includes syntax for all transaction detail drills to fusion has been updated to include the new receivables actions now available with 19c). 

    After much searching and going around in circles, i finally found a white paper that details how to navigate to Supplier Profile. 

    I'll save you some steps and provide the download URL: https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2556026.1%3ANAVTOSUPPLPROF_19C&docType=WHITE%20PAPER&action=download

     

    As an aside, it would be great if white paper documentation was located in one central location that is kept up to date as documents are added and edited..

     

  • Marybeth Snodgrass

    The syntax for drilling to supplier profile is not included in the document attached to this post (the document provided on initial post that includes syntax for all transaction detail drills to fusion has been updated to include the new receivables actions now available with 19c).

    After much searching and going around in circles, i finally found a white paper that details how to navigate to Supplier Profile.

    I'll save you some steps and provide the download URL: https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=2556026.1%3ANAVTOSUPPLPROF_19C&docType=WHITE%20PAPER&action=download

     

    As an aside, it would be great if white paper documentation was located in one central location that is kept up to date as documents are added and edited..

     

  • Amar

    Hi,

    How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter?

    Financial Year: Jun-19 to May- 20 and one Adjacent period.

    Ex: When user selects period name as May-19, Then the total Amount from Jun-18 to May-19 should show from that column. Can we achieve this by passing Period Name as a Prameter? because we cannot iterate Period name from and To using OTBI? t

    Even though we pass Period Name as Parameter do we need to calculate based on Accounting Date..?

    Kindly advice.!!

  • Veronica Dumitriu

    Hi Julie,

    We do not currently have collections in OTBI. There are already a few ERs raised to address this but if something of interest, please let us know what is the enhancement that you'd like to have addressed, what is the business impact if not adressed and what are the exact functional requirements that customer has.

     

    thank you,

    Veronica

  • Julie Bullock

    Veronica - just to clarify.  There is no collection data available in OTBI?

    Thanks!

  • Ruchir Nema

    Hi Elliot,

    Each approval even with a delegation would be raising an event and the information will be stored in the workflow tables or its history table. Below are the details.

    Table are different for different entities. If they are setup using BPM then it would be stored in the below tables

    fa_fusion_soainfra.wftaskhistory ,
    fa_fusion_soainfra.wfcomments

    The above table holds data for your approval delegation for GL and PO.

    for AP Approval Delegations - ap_inv_aprvl_hist_all would be the table that will provide you the information. .

    I am attaching sample queries for you that can help you build these BIP reports. Please have a look at them.

    Regards,

    RN

  • Karthikeyan Sukumar

    Hari- You need to join the payment subject area to get the Paid amount for that invoice/supplier.

    Thanks!

    Karthik 

  • Hari Thyagaraj

    Hello Karthik - Is there a field in OTBI subject area to show the Voucher Amount (amount that was actually paid to the Supplier) and not the Invoice Amount? I see a Delivered Amount in Procure to Pay Subject area? Would that be the field?

  • Sudhakara Rao Kovuru

    Hey Amar,

    Please share the query then I will review and will be able to help.

    Thanks,

    -Sudha

  • Manikantan Surendran

    Hi Experts,

     

    need the ITD actual cost and PTD actual cost table list  from the PPM in the Review project performance

     

    Regards

    Sampath

  • Amar

    Did you check "Receivables to Ledger Reconciliation Report" from receivables?