Description:
One of the most common requirement for every technical consultant working in oracle and Related technologies is to find out specific database tables which hold a particular piece of information. This input is required to create reports, understand links between various charts, and even for troubleshooting purpose.
| 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
——————————————- |
Summary:
This Post described the EBS to FUSION PA (Project Accounting) Table Changes in oracle EBS.
Queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
