Oracle Application Blog

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…

Read More

QA Collection Elements creation

API used for EAM preventive collection plan creation and its Elements insertion. Basically this QA tables are used for capturing daily meter reading of asset in EAM and then This…

Read More

EAM Preventive maintenance Last service reading API

API used for while generating Preventive Maintenance work orders for an asset. This API used to insert last service meter reading for an asset while generating work orders.     …

Read More

EAM Construction Estimation Creation

API used to create EAM Construction Estimation headers and lines creation. This used in for creation any construction like building etc  to estimate how much labour and how much cost…

Read More

EAM Asset Number activity association creation API

API used for to maintain asset in proper manner during work order generation. After generating work order for an asset . Users will follow the asset activities for an asset…

Read More

GL Revaluation Accounts Query – FUSION

SELECT   DISTINCT o101368.book_currency AS c_1,          (o101368.converted_journal_total_dr           * o101368.currency_conversion_rate          ) AS c_2,            o101368.converted_journal_total_cr…

Read More

EAM Asset Failure code,Cause,Resolution creation

API used for EAM asset maintenance during work order failure. This API used to create failure code and its cause and its resolution for an asset in an asset group.…

Read More

Project Unbilled Balances Query – FUSION

WITHFUNCTION get_rev_todate_amt (      p_contract_id      IN NUMBER,            p_contract_line_id IN NUMBER,      P_AS_OF_DATE       IN DATE   )RETURN NUMBERIS  ln_amount NUMBER;BEGIN      SELECT SUM(PRD.cont_curr_revenue_amt) cont_curr_revenue_amt     INTO ln_amount     FROM pjb_rev_distributions PRD    WHERE PRD.gl_date <= P_AS_OF_DATE     …

Read More

Project Details – Auditor Query – FUSION

SELECT DISTINCT PPA.project_status_code       ,HOU.name organization_name       ,PPA.description            ,OCT.name contract_type       ,PPT.project_type       ,PPA.segment1 project_number    …

Read More

Period and Daily Exchange Rates Query – FUSION

SELECT gper.set_of_books_id       ,gl_set_of_books.name        || gper.period_name        || gper.to_currency_code set_of_books_name       ,gper.period_name       ,gper.to_currency_code to_currency       ,lk.meaning…

Read More