Blog / Category
Fusion PA Tables
6 articles in this category
Function To Get Bill Rate Of Employee in Specific Project in Oracle Fusion
FUNCTION get_bill_rate ( p_project_id IN NUMBER, p_person_id IN NUMBE…
Query to Find AP Reimbursable Expenses in Oracle Fusion
WITH GET_PERIOD_AVG_RATE AS ( SELECT gper.avg_rate, &…
Query to Find NonBillable Expense in Oracle Fusion
SELECT pcdl.prvdr_gl_period_name gl_period, trx_org.NAME expenditure_organization, prb.p…
Query to Find Project Estimation To Complete in Oracle Fusion
SELECT A.PROJECT_STATUS, A.OPERATING_UNIT_NAME, A.AGREEMENT_TYPE,  …
Query to Find Projects Not Accruing Revenue in Oracle Fusion
–**** Project Not Accruing Revenue Due to Expenditure Exception ****– SELECT PE.accounting_period AS GL_PERIOD ,OKH.contract_numbe…
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_TYPE…