Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Cloud Financials: payables link to projects account distribution

Received Response
73
Views
4
Comments
PLW
PLW Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

Need DB links between Financials and Projects tables

Content

In E-Business Suite, the payables distribution contains the project_id and task_id which link to the Projects tables for invoices matched to projects/tasks.  Does anyone have the links between the Cloud/fusion tables?

Answers

  • PLW
    PLW Rank 2 - Community Beginner

    Found it.  In AP distributions table project_id is null but pjc_project_id is not.

  • Xavier Cuinier
    Xavier Cuinier Rank 2 - Community Beginner

    Hi Pam

    What is the primary reason for asking this ?

    Xavier

  • PLW
    PLW Rank 2 - Community Beginner

    BI Publisher reporting

  • Matthew Bez
    Matthew Bez Rank 1 - Community Starter

    select s.vendor_name, i.invoice_num, i.invoice_date,  L.amount amt, 
    P.segment1 , E.Name ,T.EXPENDITURE_TYPE_NAME
    from AP_INVOICE_DISTRIBUTIONS_ALL L, AP_INVOICES_ALL I, POZ_SUPPLIERS_V S, PJF_EXP_TYPES_TL T, PJF_PROJECTS_ALL_B P, PJF_PROJ_ELEMENTS_TL E
    where i.invoice_id = l.Invoice_id
    and s.vendor_id = i.vendor_id
    and L.reversal_flag <> 'Y'
    and T.EXPENDITURE_TYPE_ID =  L.PJC_EXPENDITURE_TYPE_ID
    and P.Project_id = L.PJC_PROJECT_ID
    and T.EXPENDITURE_TYPE_NAME='COS Rent'
    and E.PROJ_ELEMENT_ID = L.PJC_TASK_ID