PA — Projects
660 documented tables · 1391 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
PA_PROJECTS_ALL |
PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. | hub |
PA_TASKS |
User-defined subdivisions of project work | hub |
PA_SYSTEM_LINKAGES |
System-defined categories that classify expenditure types and determine how expenditure items of each type are | hub |
PA_EXPENDITURE_TYPES |
Implementation-defined classifications of expenditures charged to projects and tasks | hub |
PA_PROJECT_STATUSES |
Valid project status codes | hub |
PA_WORK_TYPES_B |
This table stores implementation-defined types of work being carried out in Projects in the base language. | hub-leaning |
PA_UTIL_CATEGORIES_B |
This table stores implementation-defined types of Utilization Categories being carried out in Projects Resour | hub-leaning |
PA_EXPENDITURE_CATEGORIES |
Implementation-defined groupings of expenditure types by type of cost | hub |
PA_IND_RATE_SCHEDULES_ALL_BG |
Implementation-defined burden schedules | hub |
PA_PROJ_ELEMENTS |
PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use | hub |
PA_CC_TP_SCHEDULES_BG |
Transfer price schedules which define how transfer price is calculated between the provider and receiver organ | hub |
PA_PROJ_ELEMENT_VERSIONS |
PA_PROJ_ELEMENT_VERSIONS stores the common versioned information related to tasks and structures. - For future | hub-leaning |
PA_INVOICE_GROUPS |
System-defined configurations of invoice line groupings | hub-leaning |
PA_BUDGET_VERSIONS |
Versions of project budgets | hub |
PA_ROLE_LISTS |
PA_ROLE_LISTS stores lists of roles defined with the system. | hub |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
PA_INTERFACE_UTILS_PUB |
PUB | 6 | 273 packages |
PA_CROSS_BUSINESS_GRP |
GRP | 11 | 132 packages |
PA_PROJ_TASK_STRUC_PUB |
PUB | 54 | 32 packages |
PA_TRANSACTIONS_PUB |
PUB | 7 | 26 packages |
PA_PROJECT_PUB |
PUB | 78 | 20 packages |
PA_ASSIGNMENTS_PUB |
PUB | 18 | 19 packages |
PA_EXCEPTION_REASONS_PUB |
PUB | 1 | 18 packages |
PA_FP_PLANNING_TRANSACTION_PUB |
PUB | 11 | 18 packages |
PA_RES_ASG_CURRENCY_PUB |
PUB | 1 | 18 packages |
PA_RLMI_RBS_MAP_PUB |
PUB | 7 | 17 packages |