Enable DFF's/KFF's In OTBI Need to enable these attributes in OTBI. These are example DFF's. But this is generic to all DFF's and KFF's that need to be enabled in BI.

 Need to enable these attributes in OTBI. These are example DFF's. But this is generic to all DFF's and KFF's that need to be enabled in BI.

1) Go to  Navigate To Manage Key FlexFields Task, search for GL#

2) Go to Manage Structure Instances task and search for your Chart of Account

3) Edit the segments, CHECK BI Enable check-box

4) Save the changes and deploy the flexfield.

5) Run 'Import Oracle Fusion Data Extensions For Transactional Business

Intelligence' Ess Job.

6) Once Job completes, navigate to Subject area, you should be able to see

missing segments."

Note: All DFF's and KFF's which are edited should be deployed successfully before running the Import process.

usion OTBI How To Avoid Grouping Of Rows Together

Following steps need to be performed in the analysis (before exporting to Excel) to avoid this issue:

1. Move the mouse to the right end of the person number column

2. There would be a pop-up menu displayed, from this menu select Column Properties

3. Click on Column Format tab

4. Under Value Suppression section, click on Repeat radio button

5. Save the analysis and view the results

6. Export to Excel and confirm whether the issue is resolved or not.

EBS to FUSION PA (Project Accounting) Table Changes

 

EBS to FUSION PA (Project Accounting) Table Changes

EBS Tables -----------------------------------------	FUSION Tables -------------------------------------------
PA_PROJECTS_ALL -----------------------------------------	PJF_PROJECTS_ALL_B PJF_PROJECTS_ALL_TL -------------------------------------------
PA_PROJECT_TYPES_ALL -----------------------------------------	PJF_PROJECT_TYPES_B PJF_PROJECT_TYPES_TL -------------------------------------------
PA_PROJECT_STATUSES -----------------------------------------	PJF_PROJECT_STATUSES_B PJF_PROJECT_STATUSES_TL -------------------------------------------
PA_PROJECT_STATUS_CONTROLS -----------------------------------------	PJF_PROJ_STATUS_CONTROLS -------------------------------------------
PA_PROJECT_ACCUM_ACTUALS -----------------------------------------	PJO_PROJECT_PLAN_ACTUALS -------------------------------------------
PA_TASKS -----------------------------------------	PJF_PROJ_ELEMENTS_B PJF_PROJ_ELEMENTS_TL PJF_TASKS_V -------------------------------------------
PA_BUDGET_TYPES -----------------------------------------	PJO_PLAN_TYPES_B -------------------------------------------
PA_EXPENDITURE_TYPES -----------------------------------------	PJF_EXP_TYPES_B PJF_EXP_TYPES_B_ST PJF_EXP_TYPES_TL PJF_EXP_CATEGORIES_B  -------------------------------------------
PA_EXPENDITURE_ITEMS_ALL -----------------------------------------	PJC_EXP_ITEMS_ALL -------------------------------------------
PA_COST_DISTRIBUTION_LINES_ALL  -----------------------------------------	PJC_COST_DIST_LINES_ALL -------------------------------------------
PA_TRANSACTION_SOURCES -----------------------------------------	PJF_TXN_SOURCES_B PJF_TXN_SOURCES_TL -------------------------------------------
PA_IMPLEMENTATIONS_ALL -----------------------------------------	PJF_BU_IMPL_ALL -------------------------------------------
PA_EXPENDITURE_COMMENTS -----------------------------------------	PJC_EXP_COMMENTS -------------------------------------------
PA_CUST_REV_DIST_LINES_ALL -----------------------------------------	PJB_REV_DISTRIBUTIONS -------------------------------------------
PA_TASKS -----------------------------------------	PJF_TASKS_V -------------------------------------------
PA_EXPENDITURE_ITEMS_ALL, PA_EXPENDITURES_ALL -----------------------------------------	PJC_EXP_ITEMS_ALL -------------------------------------------
PA_EXPENDITURE_TYPES -----------------------------------------	PJF_EXP_TYPES_B PJF_EXP_TYPES_B_ST PJF_EXP_TYPES_TL -------------------------------------------
PA_EVENTS -----------------------------------------	PJB_BILLING_EVENTS -------------------------------------------
PA_PROJECT_PARTIES -----------------------------------------	PJF_PROJECT_PARTIES -------------------------------------------
PA_PROJECT_ROLE_TYPES_B -----------------------------------------	PJF_PROJ_ROLE_TYPES_B -------------------------------------------

AP Supplier Invoices query - FUSION

AP Supplier Invoices query - FUSION

SELECT gp.period_name,
       (SELECT    'Q'
               || quarter_num
               || '-WK'
               || LPAD (TO_CHAR (DECODE (period_num,
                                         53, 14,
                                         DECODE (MOD (period_num, 13),
                                                 0, 13,
                                                 MOD (period_num, 13)
                                                )
                                        )
                                ),
                        2,
                        '0'
                       ) planning_week
          FROM gl_periods gp
         WHERE 1 = 1
           AND dist.accounting_date BETWEEN start_date AND end_date
           AND adjustment_period_flag = 'N'
           AND gp.period_set_name = gl.period_set_name) planning_week,
       (SELECT fv.description
          FROM fnd_flex_values_vl fv,
               fnd_flex_value_sets fvs
         WHERE fv.flex_value_set_id = fvs.flex_value_set_id
           AND fvs.flex_value_set_name = 'Department'
           AND fv.flex_value = gcc.segment3) expenditure_organization,
       inv.project_id project_id,
       NVL ((SELECT p.segment1
               FROM pjf_projects_all_b p
              WHERE p.project_id = inv.project_id), 'N/A') project_number,
       NVL ((SELECT p.NAME
               FROM pjf_projects_all_tl p
              WHERE project_id(+) = inv.project_id), 'N/A') project_name,
       NULL project_type_class_code, hp.party_name employee_vendor,
       DECODE (TO_CHAR (dist.accounting_date, 'DAY'),
               5, dist.accounting_date,
               NEXT_DAY (dist.accounting_date, 6)
              ) week_ending,
       dist.accounting_date expenditure_date,
       inv.invoice_currency_code entered_currency_code,
       dist.amount entered_amount,
       DECODE (inv.invoice_currency_code,
               gl.currency_code, NVL (dist.amount, 0),
               NVL (dist.amount, 0) * NVL (dist.exchange_rate, 0)
              ) accounted_amount,
       dist.exchange_rate accounted_exchange_rate,
       dist.exchange_rate_type accounted_exchange_type,
       (  DECODE (inv.invoice_currency_code,
                  gl.currency_code, NVL (dist.amount, 0),
                  NVL (dist.amount, 0) * NVL (dist.exchange_rate, 1)
                 )
        * NVL ((SELECT gdr.conversion_rate
                  FROM gl_daily_rates gdr
                 WHERE gdr.conversion_type = 'Corporate'
                   AND gdr.to_currency = 'USD'
                   AND gdr.from_currency = gl.currency_code
                   AND gdr.conversion_date = dist.accounting_date),
               1
              )
       ) usd_amount,
       NVL ((SELECT gdr.conversion_rate
               FROM gl_daily_rates gdr
              WHERE gdr.conversion_type = 'Corporate'
                AND gdr.to_currency = 'USD'
                AND gdr.from_currency = gl.currency_code
                AND gdr.conversion_date = dist.accounting_date),
            1
           ) usd_conversion_rate,
       dist.accounting_date conversion_date, gl.NAME set_of_books_name,
       gl.currency_code book_currency_code, gcc.segment1 company,
       gcc.segment2 ACCOUNT, gcc.segment3 department, gcc.segment4 region,
       gcc.segment5 FUNCTION, gcc.segment6 intercompany,
       dist.description comments, inv.invoice_num ap_invoice_number,
       gcc.segment1,
       (SELECT class_code
          FROM pjf_project_classes prc,
               pjf_class_codes_tl pct
         WHERE prc.class_code_id = pct.class_code_id
           AND prc.project_id = inv.project_id) project_region_code
  FROM ap_invoice_distributions_all dist,
       ap_invoice_lines_all line,
       ap_invoices_all inv,
       gl_code_combinations gcc,
       poz_suppliers ps,
       hz_parties hp,
       gl_ledgers gl,
       gl_periods gp
 WHERE dist.invoice_id = line.invoice_id
   AND dist.invoice_line_number = line.line_number
   AND line.invoice_id = inv.invoice_id
   AND dist.dist_code_combination_id = gcc.code_combination_id
   AND inv.vendor_id = ps.vendor_id
   AND hp.party_id = ps.party_id
   AND inv.set_of_books_id = gl.ledger_id
   AND gp.period_set_name = gl.period_set_name
   AND dist.accounting_date BETWEEN gp.start_date AND gp.end_date
   AND gp.adjustment_period_flag = 'N'