Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Need Join Condition for BIAPPS Warehouse Tables

Received Response
1
Views
1
Comments
User_IFBH0
User_IFBH0 Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum
W_PURCH_COST_F
W_PURCH_RCPT_F
W_AP_HOLDS_F
W_AP_XACT_F
W_PROJ_EXP_LINE_F
W_PURCH_RQSTN_LINE_F
W_PROJ_INVOICE_DIST_F
W_PROJ_INVOICE_LINE_F

Hello,

I am new to BIAPPS and need to create a query using BIAPPS Warehouse facts:

W_PURCH_COST_F,W_PURCH_RCPT_F,W_AP_HOLDS_F,W_AP_XACT_F,W_PROJ_EXP_LINE_F,W_PURCH_RQSTN_LINE_F,W_PROJ_INVOICE_DIST_F,W_PROJ_INVOICE_LINE_F.

can somebody please provide me a query for the same?

Thanks in advance

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    How are these joined in the RPD?  you are better off following Oracle's example (from the RPD) and since you purchased apps you have that RPD and all you need to answer the question.