PA Tables (660)

PA - Projects — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
PAXINGEN_PA_PROJ_SUM_TEMP 26 The PAAPIMPR_RCV_SUB_SUM_TEMP temporary table is used by the report of Interface Supplier Costs process.
PA_ACCUM_COLUMNS 12 System-defined configurable columns used in project summarization
PA_ACCUM_COLUMN_VALUES 7 10SC Only
PA_ACCUM_TXN_TIME 23 Temporary table used in timing the Refresh Project Summary Amounts process
PA_ACTION_SETS 36 PA_ACTION_SETS stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc
PA_ACTION_SETS_AR 38 PA_ACTION_SETS stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc
PA_ACTION_SET_LINES 24 PA_ACTION_SET_LINES stores action set lines that belong to an action set or an action set template
PA_ACTION_SET_LINES_AR 26 PA_ACTION_SET_LINES stores action set lines that belong to an action set or an action set template
PA_ACTION_SET_LINE_AUD 23 PA_ACTION_SET LINE_AUD stores audit information for each action set line. Each audit line describes what action has been taken in order to
PA_ACTION_SET_LINE_COND 21 PA_ACTION_SET_LINE_COND stores conditions for an action set line. Each action set line must have at least one condition.
PA_ACTION_SET_TYPES 16 PA_ACTION_SET_TYPES stores attributes of action set types
PA_ACTN_SETLN_AUD_AR 26 PA_ACTION_SET LINE_AUD stores audit information for each action set line. Each audit line describes what action has been taken in order to
PA_ACTN_SET_LN_COND_AR 23 PA_ACTION_SET_LINE_COND stores conditions for an action set line. Each action set line must have at least one condition.
PA_ACT_PRL_PRECEDENCE 11 This table stores the precedence rules used for mapping planning resource assignments of source plan version with the target plan version an
PA_ACT_RBS_PRECEDENCE 7 This table stores the precedence rules used for mapping actual transactions to resource elements of resource breakdown structure
PA_ADW_DIMENSION_STATUS 9 Dimension status for Oracle Project Analysis Collection Pack
PA_AGREEMENTS_ALL 55 Customer contracts that serve as the basis for work authorization
PA_AGREEMENTS_EFC 5
PA_AGREEMENT_TYPES 27 Implementation-defined classifications of customer agreements
PA_ALLOC_EXCEPTIONS 12 Exceptions for an allocation run
PA_ALLOC_GL_LINES 10 Allocation source lines related to GL accounts
PA_ALLOC_MISSING_COSTS 10 Missing costs information for an allocation run
PA_ALLOC_MISSING_COSTS_EFC 7 PA_ALLOC_MISSING_COSTS_EFC archives missing costs information before EFC switch
PA_ALLOC_RESOURCES 12 Resources and percentages for each allocation rule
PA_ALLOC_RULES_ALL 65 Allocation rule definitions
PA_ALLOC_RULES_ALL_EFC 4 Table to archive rule information before EFC switch
PA_ALLOC_RUNS_ALL 68 Information for allocation runs
PA_ALLOC_RUNS_ALL_EFC 13
PA_ALLOC_RUN_BASIS_DET 14 Basis information for an allocation run
PA_ALLOC_RUN_BASIS_DET_EFC 11 PA_ALLOC_RUN_BASIS_DET_EFC archives information before efc switch
PA_ALLOC_RUN_GL_DET 13 Source lines related to GL accounts for each allocation run
PA_ALLOC_RUN_GL_DET_EFC 10
PA_ALLOC_RUN_RESOURCE_DET 10 Transaction table storing Resource List Member details.
PA_ALLOC_RUN_SOURCES 11 Source projects and tasks for each source line for an allocation run
PA_ALLOC_RUN_SOURCE_DET 14 Source project information for each allocation run
PA_ALLOC_RUN_SOURCE_DET_EFC 11 PA_ALLOC_RUN_SOURCE_DET_EFC archives source information before EFC switch
PA_ALLOC_RUN_TARGETS 13 Target projects and tasks for each target line for an allocation run
PA_ALLOC_SOURCE_LINES 16 Source lines for each allocation rule
PA_ALLOC_TARGET_LINES 18 Target lines for each allocation rule
PA_ALLOC_TXN_DETAILS 41 Transactions created by an allocation run
PA_ALLOC_TXN_DETAILS_EFC 8 PA_ALLOC_TXN_DETAILS archives transactions before EFC switch
PA_ALL_EXP_TYPES_IT 11 Information about the top level of the standard hierarchy on the expenditure type dimension
PA_ALL_FINANCIAL_YRS_IT 11 Information about the top level of the standard hierarchy on the time dimension
PA_ALL_ORGANIZATIONS 4 History information about organizations
PA_ALL_PRJ_TYPES_IT 11 Information about the top level of the standard hierarchy on the project dimension
PA_ALL_SRVC_TYPES_IT 11 Information about the top level of the standard hierarchy on the service type dimension
PA_AMOUNT_TYPES_B 11 PA_AMOUNT_TYPES_B stores the amount types used in summarization
PA_AMOUNT_TYPES_TL 10 PA_AMOUNT_TYPES_TL provides multi-lingual support for amount type names.
PA_ASGMTS_HSTRY_AR 95 pa_assignments_history stores details on all approved assignments for a project.
PA_ASGMT_CNFLT_HIST_AR 15 PA_ASSIGNMENT_CONFLICT_HIST stores a history of potential conflicts that would be formed by an assignment approval transaction. If an assig
PA_ASGMT_PLAN_CHANGE_T 3
PA_ASSET_INFO_GTEMP 12 A temporary table used to store summarized data. used during cost processing for capital projects
PA_ASSET_INFO_GTEMP1 12 A temporary table used to store summarized data used during cost processing for capital projects. This table should be an exact replica of
PA_ASSIGNMENTS_HISTORY 92 pa_assignments_history stores details on all approved assignments for a project.
PA_ASSIGNMENT_CONFLICT_HIST 12 PA_ASSIGNMENT_CONFLICT_HIST stores a history of potential conflicts that would be formed by an assignment approval transaction. If an assig
PA_AUD_COST_DIST_LINES 9 PA_AUD_COST_DIST_LINES stores audit information for summarized burden expenditure items.
PA_BATCH_SOURCES 9 System-defined sources of expense report expenditure batches
PA_BC_BALANCES 23 PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are c
PA_BC_COMMITMENTS_ALL 75 PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances progra
PA_BC_PACKETS 121 PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attrib
PA_BC_PACKET_ARRIVAL_ORDER 6 Keeps track of the processing order of budgetary control packets.
PA_BGT_TYPES_IT 22 Information about budget types for Oracle Project Analysis Collection Pack
PA_BILLING_ASSIGNMENTS_ALL 45 Assignments of billing extensions to a project type, project, or task
PA_BILLING_ASSIGNMENTS_EFC 5
PA_BILLING_CYCLES 33 System-defined and implementation-defined billing cycle definitions
PA_BILLING_EXTENSIONS 51 Implementation-defined billing extension definitions
PA_BILLING_MESSAGES 32 Messages issued by billing extensions to assist in debugging
PA_BILLING_MESSAGES_AR 35
PA_BILL_RATES_ALL 23 Information about bill rates and markups of standard bill rate schedules
PA_BILL_RATES_EFC 11
PA_BIS_PRJ_BY_PRD_DRILLS_ALL 14 Actuals and budget amounts by project and period for reporting.
PA_BIS_PRJ_TO_DATE_DRILLS_ALL 14 Period and year to date actuals and budget amounts for a project for reporting.
PA_BIS_TOTALS_BY_PRD_ALL 9 Total actuals and budget amounts for reporting.
PA_BIS_TOTALS_TO_DATE_ALL 8 Period and year to date actuals and budget amounts for reporting.
PA_BIS_TO_DATE_DRILLS_ALL 11 Period and year to date actuals and budget amounts for reporting.
PA_BUDGETARY_CONTROLS 13 PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions
PA_BUDGETARY_CONTROL_OPTIONS 25 pa_budgetary_control_options stores all the default budgetary control levels and time intervals
PA_BUDGETS 19 10SC Only
PA_BUDGET_ACCT_LINES 19 This entity stores consolidated accounting information for a budget version.
PA_BUDGET_ENTRY_METHODS 36 Implementation-defined methods for entering budgets
PA_BUDGET_ITEMS 17 10SC Only
PA_BUDGET_LINES 127 Detail lines of project and task budgets
PA_BUDGET_LINES_AR 40 Pa_Budget_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_BUDGET_LINES_EFC 19
PA_BUDGET_LINES_M_UPG_DTRANGE 90 INTERNAL
PA_BUDGET_TYPES 34 Implementation-defined classifications of types of budgets used for different business purposes
PA_BUDGET_VERSIONS 105 Versions of project budgets
PA_BUDGET_VERSIONS_AR 48 Pa_Budget_Versions_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_BUDGET_VERSIONS_EFC 29
PA_BUDGET_VERSIONS_OLAP_TMP1 4 This temporary table stores projects which have been newly created or refreshed in Stage 1 process
PA_BUDGET_VERSIONS_OLAP_TMP2 4 This temporary table stores budget versions and all the currency codes the project uses
PA_BURDEN_COST_CODES 12 R10SC Only - Implementation-defined classifications of the different types of overhead burden costs
PA_BURDEN_COST_MULTIPLIERS 12 R10SC Only - Multipliers for different types of overhead which are applied to raw cost to calculate burden cost
PA_CANDIDATES 30 The PA_CANDIDATES table contains candidates for a requirement.
PA_CANDIDATES_AR 33 The PA_CANDIDATES table contains candidates for a requirement.
PA_CANDIDATES_REV_AR 32 The PA_CANDIDATE_REVIEWS table contains the assignment review log of candidates.
PA_CANDIDATE_REVIEWS 29 The PA_CANDIDATE_REVIEWS table contains the assignment review log of candidates.
PA_CAPITAL_EVENTS 16 Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments.
PA_CC_DIST_LINES_ALL 61 Information about the accounting distributions related to transfer price for cross charged expenditure items.
PA_CC_DIST_LINES_AR 64
PA_CC_ORG_RELATIONSHIPS 30 Information about relationship between operating units and the attributes that specify cross charge control and processing.
PA_CC_TP_RULES_BG 32 Rules that define how transfer price is calculated, which include such attributes as calculation method, base amount, schedule or markup, an
PA_CC_TP_SCHEDULES_BG 27 Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged lab
PA_CC_TP_SCHEDULE_LINES 34 Transfer price schedule lines which make up a transfer price schedule.
PA_CC_TP_SCHEDULE_LINE_LKP 16 Denormalized data defined for faster processing in finding the transfer price rule between organizations within a transfer price schedule.
PA_CINT_EXP_TYPE_EXCL_ALL 8 Stores expenditure type exclusions by interest rate code for each operating unit. Cost associated with each expenditure type is excluded fr
PA_CINT_RATE_INFO_ALL 18 Stores information used to determine how capitalized interest is calculated for each operating unit
PA_CINT_RATE_MULTIPLIERS 14 Stores complied capitalized interest schedule revisions, denormalized by revision, organization and rate name. The multipliers in this tabl
PA_CINT_SOURCE_DETAILS 14 Stores the source detail expenditures used to create the associated Capitalized Interest transactions.
PA_CI_ACTIONS 17 This table stores the action log for each control item. Each entry stores the complete requesting information and response.
PA_CI_COMMENTS 11 This table stores all the comments in the action log. A comment can be a requestor, closure or progress comment on an action, or unsolicite
PA_CI_DIRECT_COST_DETAILS 24 This table stores details of the changes planned for project direct costs.
PA_CI_IMPACTS 15 This table stores impacts identified for the control item.
PA_CI_IMPACT_TYPE_USAGE 11 This table stores the setup data for all the possible impact types for an control item type or type class. Only one of the two column CI_TY
PA_CI_SUPPLIER_DETAILS 46 A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity cont
PA_CI_TYPES_B 44 The table stores the control item type definitions. The values are created by the customer.
PA_CI_TYPES_TL 12 The table consists of the name and description of a project control item type.
PA_CI_TYPE_USAGE 8 The table stores the allowable control item types for each project type.
PA_CLASS_CATEGORIES 35 Implementation-defined categories for classifying projects
PA_CLASS_CATGS_IT 22 Information about class categories for Oracle Project Analysis Collection Pack
PA_CLASS_CODES 28 Implementation-defined values within class categories that can be used to classify projects
PA_CLASS_CODES_IT 23 Information about class codes for Oracle Project Analysis Collection Pack
PA_COMMITMENT_TXNS 95 Commitment transactions for summarized project summary commitment amounts
PA_COMMITMENT_TXNS_EFC 29
PA_COMMITMENT_TXNS_TMP 75 This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a
PA_COMPENSATION_DETAILS_ALL 30 Information about hourly employee cost rates and assigned compensation rules
PA_COMPENSATION_DETAILS_EFC 7
PA_COMPENSATION_EXCL_EXP_TYPES 23 This table stores the expenditure types associated to time card lines that are excluded when summarizing the total hours
PA_COMPENSATION_RULE_SETS 32 Implementation-defined classifications of employee compensation (also referred to as pay types)
PA_COMPETENCE_CRITERIA_TEMP 4
PA_COMPETENCE_PROFILES 20 pa_competence_profiles is a temp table which stores the modified and new inserted competencients for a person until these changes are approv
PA_COMPILED_MULTIPLIERS 16 Buildup multipliers used for burdening
PA_COMP_OT_EXP_TYPES 8 PA_COMP_OT_EXP_TYPES assigns labor cost multipliers to overtime expenditure types for each labor costing rule. The multipliers are applied
PA_COMP_RULE_OT_DEFAULTS_ALL 9 This table stores the overtime default project and task details for a Labor costing rule.
PA_CONTROL_ITEMS 69 PA_CONTROL_ITEMS stores user-defined control items in a project. Each item is of an item type as specified by the CI_TYPE_ID column. The i
PA_COSTING_AUDIT 26 This is an internal audit table used by Oracle Projects
PA_COST_BASES 11 Implementation-defined groupings of expenditure types used for burdening
PA_COST_BASE_COST_CODES 11 Burden cost codes associated with cost bases
PA_COST_BASE_EXP_TYPES 9 Expenditure types associated with cost bases
PA_COST_DISTRIBUTION_LINES_ALL 90 Information about expenditure item cost distribution
PA_COST_DIST_LINES_AR 88 Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_COST_DIST_LINES_RECVR_EFC 10 Table containing CDL NCU records prior to EFC switch
PA_COST_DIST_OVERRIDES 13 Configurations used to override the expenditure organization used by AutoAccounting for projects
PA_COST_PLUS_STRUCTURES 12 Structures used for burdening
PA_CREDIT_RECEIVERS 17 Employees who receive credit for project revenue
PA_CUST_EVENT_RDL_ALL 73 Information about event revenue distribution
PA_CUST_EVENT_RDL_AR 71 Pa_Cust_Event_RDL_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_CUST_RDL_AR 86 Pa_Cust_Rev_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_CUST_REV_DIST_LINES_ALL 88 Information about expenditure item revenue distribution
PA_CUST_STATUS_TMP 7
PA_DEDUCTIONS_ALL 27 This table contains summary information about the deduction requests raised for suppliers.
PA_DEDUCTION_TRANSACTIONS_ALL 23 This table contains detailed information about the deduction requests raised for suppliers.
PA_DISTRIBUTION_LISTS 9 The table PA_DISTRIBUTION_ LISTS consists of the name and description of the lists.
PA_DISTRIBUTION_RULES 11 System-defined pairings of revenue accrual and invoicing methods that can be used for projects
PA_DISTRIBUTION_WARNINGS 16 Warning messages about exceptions encountered during draft revenue generation and draft invoice generation
PA_DIST_LIST_DENORM 11 The table PA_DIST_ LIST_DENORM holds the materialized list of people with their access details for a given distribution list. The records f
PA_DIST_LIST_ITEMS 13 The table PA_DIST_ LIST_ITEMS defines list of recipients who can access a particular object. The recipient can be a role or project team me
PA_DIST_WARNINGS_AR 19 Pa_Distribution_Warnings_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_DRAFT_INVOICES_ALL 94 Information about draft invoices generated for projects
PA_DRAFT_INVOICES_AR 96 Pa_Draft_Invoices_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_DRAFT_INVOICES_EFC 6
PA_DRAFT_INVOICE_DETAILS_ALL 60 Intercompany invoice details for cross charged transactions
PA_DRAFT_INVOICE_ITEMS 98 Draft invoice lines
PA_DRAFT_INV_DETAILS_EFC 8 Table containing invoice details NCU records prior to EFC switch
PA_DRAFT_INV_DETS_AR 63
PA_DRAFT_INV_ITEMS_AR 65 Pa_Draft_Invoice_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_DRAFT_INV_ITEMS_EFC 8 Table containing draft invoice items NCU records prior to EFC switch
PA_DRAFT_REVENUES_ALL 48 Information about draft revenue generated for projects
PA_DRAFT_REVENUES_AR 47 Pa_Draft_Revenues_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_DRAFT_REVENUE_ITEMS 25 Draft revenue lines
PA_DRAFT_REVENUE_ITEMS_EFC 6
PA_DRAFT_REV_ITEMS_AR 26 Pa_Draft_Revenue_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EARNED_VALUES 26 Earned value history for lowest-level tasks and resources as well as project-task rows
PA_EARNED_VALUES_EFC 23
PA_EI_CDL_CM_GTEMP2 62
PA_EI_DENORM 200 Denormalized expenditure item records for online time entry
PA_EI_DENORM_AR 203 Pa_Ei_Denorm_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EI_DENORM_EFC 24
PA_EMPLOYEE_ACCUM_ALL 30 Accumulated totals of revenue, costs, and hours by employee (used only when running in Dual Accumulation Mode).
PA_EMPLOYEE_ACCUM_EFC 18
PA_EMPLOYEE_ORG_ACCUM_ALL 29 Accumulated totals of revenue, costs, and hours by organization (used only when running in Dual Accumulation Mode).
PA_EMPLOYEE_ORG_ACCUM_EFC 17
PA_EMP_BILL_RATE_OVERRIDES 17 Non-standard employee bill rates negotiated for specific projects and tasks
PA_EMP_BILL_RATE_OVERRIDES_EFC 7
PA_EVENTS 113 Entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items
PA_EVENTS_AR 116 Pa_Events_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EVENTS_EFC 13
PA_EVENT_TYPES 28 Implementation-defined classifications of events
PA_EVENT_TYPE_OUS_ALL 9 Operating unit specific information for Event Types
PA_EXCEPTION_REASONS 10 Exception reasons and corresponding corrective actions
PA_EXPENDITURES_ALL 48 Groups of expenditure items incurred by employees or organizations for an expenditure period
PA_EXPENDITURES_AR 51 Pa_Expenditures_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EXPENDITURE_BATCHES_ALL 10 Groups of expense reports that are processed during the same run of the Distribute Expense Reports program
PA_EXPENDITURE_CATEGORIES 26 Implementation-defined groupings of expenditure types by type of cost
PA_EXPENDITURE_COMMENTS 12 Free text entered for expenditure items to explain or further describe work performed
PA_EXPENDITURE_COST_RATES_ALL 10 Cost rates for non-labor expenditure types
PA_EXPENDITURE_COST_RATES_EFC 7
PA_EXPENDITURE_GROUPS_ALL 19 Groups of pre-approved expenditures
PA_EXPENDITURE_HISTORY 34 Audit records for self service time
PA_EXPENDITURE_ITEMS_ALL 205 The smallest units of expenditure charged to projects and tasks
PA_EXPENDITURE_ITEMS_AR 201 Pa_Expenditure_items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EXPENDITURE_TYPES 32 Implementation-defined classifications of expenditures charged to projects and tasks
PA_EXPENDITURE_TYPE_OUS_ALL 9 Operating unit specific tax code information for expenditure types
PA_EXPEND_ALIASES 18 Personal aliases for project, task and/or expenditure types when entering self service timecards.
PA_EXPEND_COMMENT_ALIASES 8 Personal aliases for free text expenditure comments used when entering on-line timecards and expense reports
PA_EXPEND_ITEM_ADJ_ACTIVITIES 15 Information about cost and/or revenue adjustments made to expenditure items through the Oracle Projects forms
PA_EXPEND_TYP_SYS_LINKS 25 Intersection table for system_linkage_function and expenditure_types
PA_EXP_BUSINESS_GRPS_IT 11 Business groups for expenditure organizations for Oracle Project Analysis Collection Pack
PA_EXP_COMMENTS_AR 15 Pa_Expenditure_Comments_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EXP_HISTORY_AR 37 Pa_Expenditure_History_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EXP_ITEMS_RECVR_EFC 9 11i Only. Maintains a snapshot of the receiver columns not maintained in the Expenditure Items MRC table before conversion to the Euro.
PA_EXP_ITEM_ADJ_ACT_AR 17 Pa_Expend_Item_Adj_Act_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_EXP_ORGS_IT 23 Information about expenditure organizations for Oracle Project Analysis Collection Pack
PA_EXP_TYPES_IT 26 Information about expenditure types for Oracle Project Analysis Collection Pack
PA_FINANCIAL_QTRS_IT 15 Information about financial quarters for Oracle Project Analysis Collection Pack
PA_FINANCIAL_YRS_IT 15 Information about financial years for Oracle Project Analysis Collection Pack
PA_FIN_PLAN_ADJ_LINES 20 This table stores the adjustment lines for a Financial Plan
PA_FIN_PLAN_AMOUNT_SETS 23 This table stores the various amount sets available for financial plans.
PA_FIN_PLAN_TYPES_B 53 This table stores the various plan types for financial plans.
PA_FIN_PLAN_TYPES_TL 11 This table stores the various plan type names in the translated user language
PA_FI_AMOUNT_DETAILS 62 This table stores the amount details information for a forecast item.
PA_FI_AMOUNT_DETAILS_AR 62 This table stores the amount details information for a forecast item.
PA_FORECASTING_OPTIONS_ALL 32 This table stores the parameters and defaults that define the various options for forecasting options. If you have a multi-organization inst
PA_FORECAST_ITEMS 75 This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores s
PA_FORECAST_ITEM_DETAILS 52 This table stores the detailed amount information for each forecast item. An example of the amounts stored is labor hours
PA_FP_ADJ_ELEMENTS 12 This table stores denormalized header information for Plan Adjustments
PA_FP_CALC_AMT_TMP1_1 53
PA_FP_CALC_AMT_TMP2 26
PA_FP_ELEMENTS 22 This table stores plannable elements for a project.
PA_FP_EXCLUDED_ELEMENTS 12 Stores tasks which have been excluded for financial planning purposes.
PA_FP_FCST_GEN_TMP1_1 53
PA_FP_MERGED_CTRL_ITEMS 22 This table stores information about the change documents that have been merged into a financial plan version.
PA_FP_OF_WEBADI_XFACE 61
PA_FP_PLANNING_RES_TMP1_1 7
PA_FP_RES_ASSIGNMENTS_TMP 113 Stores the resource assignment level data for internal use of Oracle Projects
PA_FP_SPREAD_CALC_TMP 153 This is an internal table that is used to store temporary data required for calculate and spread api internal processing. This is a global t
PA_FP_TXN_CURRENCIES 20 This table stores the plannable transaction currencies for a project.
PA_FP_UPGRADE_AUDIT 17 This table stores information about upgraded budget types for a project.
PA_FP_WEBADI_UPLOAD_INF 126 This is table that is used to store temporary data from web ADI Layout to upload to Oracle Projects.
PA_FP_WEBADI_XFACE_TMP1 135
PA_FRCST_ITEMS_AR 78 This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores s
PA_FRCST_ITEM_DTLS_AR 55 This table stores the detailed amount information for each forecast item. An example of the amounts stored is labor hours
PA_FUNCTIONS 12 System-defined groupings of related AutoAccounting transactions
PA_FUNCTION_PARAMETERS 10 System-defined parameters available as input values for AutoAccounting functions
PA_FUNCTION_TRANSACTIONS_ALL 13 System-defined operations within AutoAccounting functions
PA_FUND_MRC_UPG_EXCEP 12 The PA_FUND_MRC_UPG_EXCEP table maintains all the exceptions got during funding up gradation in MRC.
PA_GANTT_BAR_STYLES_B 36 Stores Gantt view bar styles
PA_GANTT_BAR_STYLES_TL 10 Stores translated bar style names
PA_GANTT_BAR_TYPES 26 Stores bar style task types
PA_GANTT_COLUMNS 27 Stores Gantt view columns
PA_GANTT_CONFIG_B 33 Stores Gantt configurations
PA_GANTT_CONFIG_TL 11 Stores the translated configuration name
PA_GANTT_VIEWS_B 39 Stores Gantt views
PA_GANTT_VIEWS_TL 11 Stores the translated view name
PA_GL_INTERFACE 128 PA_GL_INTERFACE this table is used for interfacing Labor Cost records to GL Journal Import Process of GL and Tieback process of PA will ref
PA_GL_PA_PERIODS_TMP 7
PA_GL_PERIODS_IT 15 Information about GL periods for Oracle Project Analysis Collection Pack
PA_GL_REV_XFER_AUDIT_REP 22 Temporary table populated during Revenue Audit Report
PA_IMPLEMENTATIONS_ALL 98 Information about the configuration of an Oracle Projects installation
PA_IMPLEMENTATIONS_ALL_EFC 4
PA_IND_COMPILED_SETS 14 Groups of compiled multipliers
PA_IND_COST_CODES 27 Implementation-defined classifications of burden costs
PA_IND_COST_MULTIPLIERS 10 Burden multipliers for burden schedule revisions, organizations, and burden cost codes
PA_IND_RATE_SCHEDULES_ALL_BG 22 Implementation-defined burden schedules
PA_IND_RATE_SCH_REVISIONS 23 Revisions within burden schedules
PA_INTEGRATION_CONTROLS 8 PA_INTEGRATION_CONTROLS is used to stores controls for each Integration Option pertaining to its integration of designated Operating Units a
PA_INTEGRATION_OPTIONS 21 Projects Integration Options Table
PA_INTEGRATION_SETTINGS 22 PA_INTEGRATION_SETTINGS is used to store Integration Settings for each Project and Template
PA_INVOICE_FORMATS 14 Implementation-defined configurations of columns, text, and layout of invoice lines
PA_INVOICE_FORMAT_DETAILS 12 Implementation-defined details of the invoice format configurations
PA_INVOICE_GROUPS 12 System-defined configurations of invoice line groupings
PA_INVOICE_GROUP_COLUMNS 15 System-defined columns associated with invoice groups
PA_INVOICE_GROUP_TABLES 9 System-defined tables used to derive invoice group columns
PA_INV_GRP_COL_WHR_CLAUSES 8 System-defined invoice group WHERE clauses assigned to invoice group columns
PA_INV_GRP_WHR_CLAUSES 8 System-defined WHERE clauses used to derive invoice group column values
PA_JOB_ASSIGNMENT_OVERRIDES 14 Non-standard employee job assignments and/or billing titles negotiated for specific projects and tasks
PA_JOB_BILL_RATE_OVERRIDES 17 Non-standard job bill rates negotiated for specific projects and tasks
PA_JOB_BILL_RATE_OVERRIDES_EFC 7
PA_JOB_BILL_TITLE_OVERRIDES 13 Non-standard job billing titles negotiated for specific projects and tasks
PA_JOB_RELATIONSHIPS 10 This table holds job relationships.
PA_LABOR_COST_MULTIPLIERS 9 Multipliers used to determine premium hourly cost rates for labor overtime expenditure items
PA_LABOR_MULTIPLIERS 12 Multipliers, assigned to projects or tasks, that are applied to raw cost to determine the revenue and/or bill amounts
PA_LEGAL_ENTITY_IT 12 Information about legal entities for Oracle Project Analysis Collection Pack
PA_LIFECYCLE_USAGES 9 PA_LIFECYCLE_USAGES stores information about the usuage types of the existing lifecycle.
PA_LOCATIONS 9 This table is used to store the locations that are used in Projects. A new location is created when a new location is assigned to a project
PA_LOWEST_RLMEM_IT 24 Information about the lowest level of resources for Oracle Project Analysis Collection Pack
PA_LOWEST_TASKS_IT 27 Lowest level task information for reporting.
PA_MAP_VALUE_SETS 17 PA_MAP_VALUE_SETS stores the source or destination information for the mapping. Each record could be a source or a destination. The data in
PA_MAP_WP_TO_FIN_TASKS_TMP 12
PA_MASS_UPDATE_BATCHES_ALL 35 Batches created for mass update of project/task attributes
PA_MASS_UPDATE_DETAILS 14 Detail information about batches created for mass update of project/task attributes
PA_MC_BUDGET_LINES 22 This table stores budget lines for all the reporting set of books associated with primary set of books. The raw cost, burdened cost and reve
PA_MC_BUDGET_LINES_OLD115 17
PA_MC_CC_DIST_LINES_ALL 20 Information about cross charge distributions of expenditure items for each reporting set of books.
PA_MC_CC_DIST_LINES_AR 22
PA_MC_CDL_AR 23 Pa_MC_Cost_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_COST_DIST_LINES_ALL 21 Information about the cost distribution of expenditure items for each reporting set of books
PA_MC_CUST_EVENT_RDL_ALL 20 Information about the revenue distribution of revenue events in each reporting set of books
PA_MC_CUST_EVENT_RDL_AR 23 Pa_MC_Cust_Event_Rdl_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_CUST_RDL_ALL 24 Information about the revenue distribution of expenditure items in each reporting set of books
PA_MC_CUST_RDL_AR 27 Pa_MC_Cust_Rdl_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_DRAFT_INV_DETAILS_ALL 13 Information about invoice details for cross charged transactions in each reporting set of books
PA_MC_DRAFT_INV_DETS_AR 16 Archive/Purge Draft Invoice Detail
PA_MC_DRAFT_INV_ITEMS 12 Draft invoice line information in each reporting currency
PA_MC_DRAFT_INV_ITMS_AR 15 Pa_MC_Draft_Inv_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_DRAFT_REVS_ALL 22 The draft revenues generated for a project in each reporting currency
PA_MC_DRAFT_REVS_AR 24 Pa_MC_Draft_Revs_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_EVENTS 15 Event information in each reporting currency
PA_MC_EVENTS_AR 18 Pa_Mc_Events_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_EXP_ITEMS_ALL 34 Information for the smallest expenditure units charged to projects and tasks in each reporting currency.
PA_MC_EXP_ITEMS_AR 37 Pa_MC_Exp_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_PRJ_AST_LINES_ALL 5 Summarized project CIP cost lines in each reporting currency
PA_MC_PRJ_AST_LINE_DTLS 7 Detail information for each asset line created in each reporting currency
PA_MC_PRJ_AST_LN_DET_AR 10 Pa_MC_Prj_Ast_Line_Dtls_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_MC_PROJECT_FUNDINGS 18 The PA_MC_PROJECT_FUNDINGS table stores project funding lines for all the reporting set of books associated with functional set of books. Th
PA_MC_RETN_INV_DETAILS 19 PA_MC_RETN_INV_DETAILS stores total retained amount as of the invoice generated date.
PA_MC_RETN_INV_DETLS_AR 22
PA_MC_SUM_PROJ_FUNDINGS 15 The PA_MC_SUM_PROJ_FUNDINGS table maintains the total baselined, total unbaselined, total accrued and total billed amount for each agreement
PA_MC_TXN_INTERFACE_ALL 10 Information about transactions imported from external sources in each reporting set of books
PA_MC_UPGRADE_RATES 9 Rate information cached for all Transaction currencies.
PA_MRC_UPG_HISTORY 14 Upgrade statuses for upgrading to MRC enabled environments.
PA_MSP_PRC_STATUS 5 This table stores the data from the asynchronous upload from Microsoft Project.
PA_NEXT_ALLOW_STATUSES 24 This table stores the next allowable statuses for statuses in PA_PROJECT_STATUSES.
PA_NL_BILL_RATE_OVERRIDES 18 Non-standard non-labor bill rates negotiated for specific projects and tasks
PA_NL_BILL_RATE_OVERRIDES_EFC 8
PA_NON_LABOR_RESOURCES 28 Non-labor assets utilized during project work
PA_NON_LABOR_RESOURCE_ORGS 25 Assignments of non-labor resources to organizations
PA_OBJECTS 25 PA_OBJECTS stores the reporting objects for which summarized balances are created.
PA_OBJECT_DIST_LISTS 9 The table PA_OBJECT_DIST_ LISTS stores the distribution lists used by each object.
PA_OBJECT_PAGE_LAYOUTS 26 PA_OBJECT_PAGE_LAYOUTS stores associations between page layouts and objects such as Project or Task.
PA_OBJECT_REGIONS 10 This table identifies replacement regions for placeholder regions. Replacement regions are associated with an object and object type.
PA_OBJECT_RELATIONSHIPS 28 This table is used to store all relationships relating to projects, structures and tasks.
PA_OBJ_STATUS_CHANGES 14 This table records the changes of the status of the objects.
PA_OBJ_STATUS_LISTS 10 This table stores the assignments of status lists to project objects.
PA_OLAP_WBS_HEADER 16 This table tracks associations between projects and Work Breakdown Structures.
PA_OLAP_XBS_DENORM_TMP 20 This table stores the last summarized PA_XBS_DENORM structure for PRG and WBS
PA_OLD_RES_ACCUM_DTLS 17 The PA_RESOURCE_ACCUM_DETAILS table records that are deleted when accumulation is refreshed
PA_ONLINE_EXP_SETTINGS 19 User defined preferences for self service time entry.
PA_OPER_UNITS_IT 24 Information about operating units for Oracle Project Analysis Collection Pack
PA_OPTIONS 18 System-defined navigation options for a project or task
PA_ORGS_IT 23 Information about organizations for Oracle Project Analysis Collection Pack
PA_ORG_FCST_ELEMENTS 18 This table stores denormalized header information for Organization Forecasts.
PA_ORG_FORECAST_LINES 25 This table stores the detailed forecast lines data for the PA_ORG_FCST_ELEMENTS table
PA_ORG_HIERARCHY_DENORM 12 Denormalized table holding the relationship between parent and child organizations
PA_ORG_LABOR_SCH_RULE 20 PA_ORG_LABOR_SCH_RULE stores labor costing rule and rate schedule assignments for organizations
PA_ORG_REPORTING_SESSIONS 2 Start organization used for reporting by organizations below the start organization
PA_PAGE_CONTENTS 14 PA_PAGE_CONTENTS stores the captured html page to be emailed
PA_PAGE_LAYOUTS 15 PA_PAGE_LAYOUTS contains the page layouts created for each page type. The seeded page types are Project Home and Project Status Report.
PA_PAGE_LAYOUT_REGIONS 14 This table contains all the regions included in a page layout.
PA_PAGE_TYPE_REGIONS 21 This table stores the regions for page types.
PA_PARALLEL_AUTOINSTALL 5 Oracle Corporation does not support access to Oracle Applications data using this table, except from standard Oracle Applications forms, rep
PA_PARAMETERS 9 System-defined variables for use with AutoAccounting functions or rules
PA_PAY_AUDIT_ALL 19 PA_PAY_AUDIT_ALL stores the details of all payroll batches that are interfaced to Oracle Projects .
PA_PAY_DIST_LINES_ALL 33 PA_PAY_DIST_LINES_ALL stores the details of distribution of pay amounts in Oracle Projects.
PA_PAY_ELEMENT_MAPPING_ALL 38 This table stores the distribution method to distribute payroll costs in Oracle Projects
PA_PAY_EXCLUDE_EXP_TYPES 23 This table stores expenditure types to exclude from distribution basis for each rule
PA_PAY_EXP_TEMP 19 PA_PAY_EXP_TEMP holds timecard data during payroll integration process temporarily.
PA_PAY_EXTERNAL_INTERFACE 23 PA_PAY_EXTERNAL_INTERFACE stores third party payroll information to be interfaced to Oracle Projects
PA_PAY_EXTERNAL_PAYROLL 14 PA_PAY_EXTERNAL_PAYROLL stores the details of all third party payrolls
PA_PAY_EXTERNAL_TIME_PERIODS 9 PA_PAY_EXTERNAL_TIME_PERIODS stores the details of all third party payroll periods
PA_PAY_EXT_INTERFACE_DETAILS 20 PA_PAY_EXT_INTERFACE_DETAILS stores third party payroll information to be interfaced to Oracle Projects
PA_PAY_EXT_INTERFACE_HEADER 15 PA_PAY_EXT_INTERFACE_HEADER stores third party payroll header information to be interfaced to Oracle Projects
PA_PAY_INTERFACE_TEMP 75 PA_PAY_INTERFACE_TEMP holds payroll data during payroll integration process temporarily.
PA_PAY_PROJ_STATUS_ALL 12 PA_PAY_PROJ_STATUS_ALL stores the details of the payroll batch that is interfaced Oracle Projects .
PA_PAY_REJECTIONS_ALL 15 PA_PAY_REJECTIONS_ALL stores the details of rejections while interfacing the payroll amounts .
PA_PAY_REJECTION_PRIORITY 8 PA_PAY_REJECTION_PRIORITY stores the details of all payroll related rejection codes and priorities.
PA_PAY_SOURCE_AMOUNTS_ALL 32 PA_PAY_SOURCE_AMOUNTS_ALL stores the source pool of all pay amounts that are interfaced to Oracle Projects in each batch.
PA_PERCENT_COMPLETES 45 Estimated percent completion for all levels of the work breakdown structure.
PA_PERF_BZ_MEASURES 8 This table stores the association between business event and measure.
PA_PERF_BZ_OBJECT 9 Interface table to pass the objects which are affected by the business event.
PA_PERF_COMMENTS 10 This table Records performance comments.
PA_PERF_KPA_SUMMARY 36 This table records the exception summary for a given object across all KPAs.
PA_PERF_KPA_SUMMARY_DET 24 This table Records exception summary details for an object.
PA_PERF_KPA_TRANS 7 Records transactions associated with a project key performance indicator scoring summary.
PA_PERF_OBJECT_RULES 10 This table stores the association between Exception Rule and the actual object.
PA_PERF_RULES 19 This table stores the information regarding the available performance rules.
PA_PERF_THRESHOLDS 15 This table stores the thresholds of exception notification rule.
PA_PERF_TRANSACTIONS 31 This table records performance transaction data.
PA_PERIODS_ALL 12 Implementation-defined periods against which project performance is measured
PA_PERIODS_IT 29 Information about PA periods for Oracle Project Analysis Collection Pack
PA_PERIOD_MASKS_B 12 This table stores the various period mask definitions to be used for displaying periodic data
PA_PERIOD_MASKS_TL 11 This table stores the various translated period mask definitions to be used for displaying periodic data
PA_PERIOD_MASK_DETAILS 12 This table stores the various period mask details to be used for displaying periodic data
PA_PJI_PROJ_EVENTS_LOG 32 PA_PJI_PROJ_EVENTS_LOG stores event logs on changes on PA tables which affects Project Intelligence data. This table allows Project Intelli
PA_PJM_PO_COMMITMENTS_TMP 49 This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a
PA_PJM_REQ_COMMITMENTS_TMP 33 This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a
PA_PJT_FACT_PERIOD 44
PA_PLAN_RES_DEFAULTS 18 Stores the default settings of planning resource classes, either at the resource class level, project level, or organization level.
PA_PLAN_RL_FORMATS 9 Intermediate table used to store the mappings between resource lists and resource formats.
PA_PM_CONTROL_ACTIONS 10 Controlled actions on data imported from other systems
PA_PM_PRODUCT_CONTROL_RULES 10 Actions to be controlled for records imported from a specific external product
PA_PPR_OBJ_TMP 5
PA_PPR_OBJ_TMP2 2
PA_PPR_OBJ_TMP_VIEW 5
PA_PRC_ASSIGNMENTS 42 PA_PRC_ASSIGNMENTS is the table store PRC conversion rules by project
PA_PRC_CONVERSION_RULES 34 PA_PRC_CONVERSION_RULES is the table for PRC feature
PA_PRIM_REP_LEGER_TMP 4 The PA_XLA_LINES_TMP temporary table used by revenue xla upgrade.
PA_PRJ_ACCUM_ACTUALS_AR 50 Pa_Project_Accum_Actuals_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_PRJ_ACCUM_BUDGETS_AR 66 Pa_Project_Accum_Budgets_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_PRJ_ACCUM_COMMIT_AR 26 Pa_Project_Accum_Commit_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_PRJ_ACCUM_HEADERS_AR 22 Pa_Project_Accum_Headers_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_PRJ_ACT_CMT_IT_ALL 42 Information about project level actuals and commitments for Oracle Project Analysis Collection Pack
PA_PRJ_ASSET_LN_DETS_AR 18 Pa_Project_Asset_Line_Dets_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_PRJ_BGT_LINES_IT_ALL 35 Information about budgets at the project level for Oracle Project Analysis Collection Pack
PA_PRJ_BUSINESS_GRPS_IT 11 Information about business groups for project/task organizations for Oracle Project Analysis Collection Pack
PA_PRJ_CLASSES_IT 23 Information about project classes for Oracle Project Analysis Collection Pack
PA_PRJ_ORGS_IT 23 Information about project/task organizations for Oracle Project Analysis Collection Pack
PA_PRJ_TYPES_IT_ALL 24 Information about project types for Oracle Project Analysis Collection Pack
PA_PRL_RBS_PRECEDENCE 7 This table stores the precedence rules used for mapping planning resource assignments with the resource elements of a resource breakdown str
PA_PROBABILITY_LISTS 26 This table stores the probability lists that are used in Oracle Projects.
PA_PROBABILITY_MEMBERS 27 This table stores information about the members that make up the probability list.
PA_PRODUCT_FUNCTIONS 10 PA_PRODUCT_FUNCTIONS stores the functions defined for each product in the Oracle Projects suite.
PA_PROGRESS_REPORT_VALS 51 This table contains the actual values for different versions of a page.
PA_PROGRESS_REPORT_VERS 23 This table holds header information for each version of the status report associated with an object.
PA_PROGRESS_ROLLUP 125 PA_PROGRESS_ROLLUP stores rolled up progress information for tasks and structures.
PA_PROG_ACT_BY_PERIOD_TEMP 27
PA_PROJECTS_ALL 201 PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects.
PA_PROJECTS_EFC 5
PA_PROJECTS_ERP_EXT_B 99 PA_PROJECTS_ERP_EXT_B stores user-defined attribute data for the project and task level.
PA_PROJECTS_ERP_EXT_TL 51 PA_PROJECTS_ERP_EXT_TL stores translated user-defined attribute data for the project and task level.
PA_PROJECTS_FOR_ACCUM 5 Temporary table updated during the Update Project Summary Process
PA_PROJECTS_IT_ALL 27 Information about projects for Oracle Project Analysis Collection Pack
PA_PROJECT_ACCUM_ACTUALS 47 Project summary amounts for cost and revenue
PA_PROJECT_ACCUM_ACTUALS_EFC 23
PA_PROJECT_ACCUM_BUDGETS 64 Project summary amounts for budgets
PA_PROJECT_ACCUM_BUDGETS_EFC 34
PA_PROJECT_ACCUM_COMMITMENTS 23 Project summary amounts for commitments
PA_PROJECT_ACCUM_COMMITS_EFC 11
PA_PROJECT_ACCUM_HEADERS 19 Project summary records for each combination of project_id, task_id, and resource_list_member_id
PA_PROJECT_ASGMTS_AR 93 PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project.
PA_PROJECT_ASSETS_ALL 65 Assets defined for capital projects
PA_PROJECT_ASSETS_EFC 5
PA_PROJECT_ASSET_ASSIGNMENTS 24 Relationship between projects or tasks and assets used to summarize CIP costs
PA_PROJECT_ASSET_LINES_ALL 46 Summarized project CIP costs
PA_PROJECT_ASSET_LINE_DETAILS 15 Information necessary to drill down from an asset line to the cost distribution line
PA_PROJECT_ASSIGNMENTS 92 PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project.
PA_PROJECT_CLASSES 29 Class codes of class categories that are used to classify projects
PA_PROJECT_CONTACTS 11 Customer representatives who are involved in projects
PA_PROJECT_COPY_OVERRIDES 12 Quick Entry fields for project templates
PA_PROJECT_CTX_SEARCH 11 PA_PROJECT_CTX_SEARCH stores the concatenated attributes for the columns of PA_PROJECTS_ALL that we perform keyword search on, including Nam
PA_PROJECT_CUSTOMERS 24 Customers involved in projects
PA_PROJECT_CUSTOMERS_EFC 7 Table containing project customers NCU records prior to EFC switch
PA_PROJECT_EVENT_ACCUM 19 Accumulated totals of event revenue for projects and tasks (used only when running in Dual Accumulation Mode).
PA_PROJECT_EVENT_ACCUM_EFC 9
PA_PROJECT_EXPEND_CATEGORIES 10 10sc Only
PA_PROJECT_EXP_ITEM_ACCUM 32 Accumulated revenue, costs, and quantities from expenditure items (used only when running in Dual Accumulation Mode).
PA_PROJECT_EXP_ITEM_ACCUM_EFC 18
PA_PROJECT_FUNDINGS 77 Incremental amounts of allocated funds from agreements to projects and tasks
PA_PROJECT_FUNDINGS_EFC 5
PA_PROJECT_OPP_ATTRS 14 PA_PROJECT_OPP_ATTRS stores the opportunity value related attributes for each project in PA_PROJECTS_ALL.
PA_PROJECT_OPTIONS 8 Navigation options for each project template
PA_PROJECT_PARTIES 18 Resources involved in a Specified Project
PA_PROJECT_PARTIES_AR 21 Resources involved in a Specified Project
PA_PROJECT_REPORTS_B 10 This stores the report view data used to view projects in Project List Page
PA_PROJECT_REPORTS_TL 8 This stores the translated report view data used to view projects in Project List Page
PA_PROJECT_REQUESTS 43 The PA_PROJECT_REQUESTS table stores the project creation requests.
PA_PROJECT_RETENTIONS 22 PA_PROJECT_RETENTIONS stores retention summary balances.
PA_PROJECT_ROLE_TYPES_B 38 Implementation-defined responsibilities or positions assigned to employees on projects
PA_PROJECT_ROLE_TYPES_TL 11 This table provides multi-lingual support (MLS) for project role types that you define in Oracle Projects. MLS enables you to store and prin
PA_PROJECT_SETS_B 27 This table stores the Project Set information
PA_PROJECT_SETS_TL 10 This table provides multi-lingual support (MLS) for project sets that you define in Oracle Projects. MLS enables you to store and print data
PA_PROJECT_SET_LINES 7 This is an intersection table between PA_PROJECTS_ALL and PA_PROJECT_SETS_B. It stores the elements (which will be projects) of the project
PA_PROJECT_STATUSES 40 Valid project status codes
PA_PROJECT_STATUS_CONTROLS 16 Allowed actions for project status codes
PA_PROJECT_SUBTEAMS 28 This table stores the details of subteams associated with project or team template.
PA_PROJECT_SUBTEAM_PARTIES 11 Table to store information about the association of project parties and assignments to project subteams.
PA_PROJECT_TYPES_ALL 90 Implementation-defined project classifications that supply default information and drive some project processing
PA_PROJ_ASGN_TIME_CHART 21 No Longer Used.
PA_PROJ_ELEMENTS 67 PA_PROJ_ELEMENTS stores the common non-versioned information related to tasks and structures. - For future use
PA_PROJ_ELEMENTS_TMP 15
PA_PROJ_ELEMENT_VERSIONS 40 PA_PROJ_ELEMENT_VERSIONS stores the common versioned information related to tasks and structures. - For future use
PA_PROJ_ELEM_RELATIONSHIP_T 9 This is a temporary table used for performance improvement.
PA_PROJ_ELEM_VER_SCHEDULE 64 PA_PROJ_ELEM_VER_SCHEDULE stores workplan attributes, which are versioned. - For future use
PA_PROJ_ELEM_VER_STRUCTURE 41 PA_PROJ_ELEM_VER_STRUCTURE stores the structure attributes which are versioned. - For future use
PA_PROJ_ELEM_VER_TMP 9
PA_PROJ_FP_OPTIONS 123 This table stores the default financial planning options for a project, plan type or plan version.
PA_PROJ_LEVELS_TMP 11
PA_PROJ_PERIODS_DENORM 73 This table stores denormalized amounts for various amount types for the set of periods defined in the PA_PROJ_PERIOD_PROFILES entity.
PA_PROJ_PERIOD_PROFILES 170 This table stores the period profile information that is used for reporting purposes.
PA_PROJ_PROGRESS_ATTR 19 PA_PROJ_PROGRESS_ATTR stores progress setup related information for structures.
PA_PROJ_PROGRESS_REPORTS 27 This table was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
PA_PROJ_REFRESH_TMP 1 This is a temporary table used TO store data required for refreh project summary amounts internal processing.
PA_PROJ_RETN_BILL_RULES 16 PA_PROJ_RETN_BILL_RULES stores retention billing rules for a
PA_PROJ_RETN_RULES 27 PA_PROJ_RETN_RULES stores retention setup rules. These rules are entered at the project or top task level.
PA_PROJ_ROLLUP_BULK_TEMP 172 This table is used to generate schedules for sets of dates in a project. Records are deleted from the table at the end of the user session.
PA_PROJ_ROLLUP_OBJ_TEMP 87 PA_PROJ_ROLLUP_OBJ_TEMP temporarily holds the data to be processed by the scheduling API
PA_PROJ_ROLLUP_TEMP 36 This table is used to generate schedules for sets of dates in a project. Records are deleted from the table at the end of the user session.
PA_PROJ_STRUCTURE_TYPES 25 PA_PROJ_STRUCTURE_TYPES stores the structure types for a particular structure. - For future use
PA_PROJ_SUMM_TMP 1 This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a
PA_PROJ_TYPE_DISTRIBUTIONS_ALL 9 Implementation-defined available distribution rules for each project type
PA_PROJ_TYPE_VERIFICATIONS_ALL 10 10SC Only
PA_PROJ_WORKPLAN_ATTR 26 This table stores the workplan attributes for projects.
PA_PT_CO_IMPL_STATUSES 12 This table stores the integration between change document types and financial plan types that is done as part of setup.
PA_PURGE_BATCHES_ALL 29 Purge batch information
PA_PURGE_PRJ_DETAILS 14 Purged details for projects in a purge batch
PA_PURGE_PROJECTS 25 Information on projects to be purged in a purge batch
PA_PURGE_PROJECT_ERRORS 9 Validation errors for projects in a purge batch
PA_PWP_AP_INV_DTL 36 This temporary table stores processed supplier invoice data at invoice distribution level.
PA_PWP_AP_INV_HDR 29 This temporary table stores processed supplier invoice data at invoice level.
PA_PWP_CUSTOMER_SUMM_ALL 58 This stores customer invoice information to be used in subcontractor workbench
PA_PWP_LINKED_INVOICES_ALL 8 This table stores manual links between a Draft Invoice and Supplier Invoices. This is used for concurrent programs related to the Pay When P
PA_PWP_RELEASE_REPORT_ALL 15 PA_PWP_RELEASE_REPORT is a table for Pay When Paid Invoice Release Report
PA_RBS_DENORM 12 This table stores normalized resource breakdown structure information
PA_RBS_ELEMENTS 45 This table stores the RBS element information and the parent-child relationship.
PA_RBS_ELEMENT_MAP 8 This table stores the numeric identifiers for all rbs resource type instances that do not have a numeric identifier in the transaction syste
PA_RBS_ELEMENT_NAMES_B 8 This table stores the resource names for elements in the RBS that are not resource types.
PA_RBS_ELEMENT_NAMES_TL 9 Stores all translated resource names for elements in the RBS that are not resource types.
PA_RBS_HEADERS_B 13 This table stores the RBS Header information that is not version specific.
PA_RBS_HEADERS_TL 10 Stores all translated RBS header information that is not version specific.
PA_RBS_MAPPING_RULES 29 This table stores the rules created for each RBS version. The rule determines how transactions are mapped to the RBS.
PA_RBS_MAP_T1 3 This is a temporary table used for performance improvement.
PA_RBS_MAP_TMP2 28
PA_RBS_PRJ_ASSIGNMENTS 16 This table stores the RBS to Project association information.
PA_RBS_TXN_ACCUM_MAP 8 This table stores the mapping information between resource breakdown structure elements and transaction accum headers
PA_RBS_VERSIONS_B 18 This table stores the RBS information that is version specific.
PA_RBS_VERSIONS_TL 10 Stores all translated RBS information that is version specific.
PA_REPORTING_EXCEPTIONS 34 General purpose table used for reporting Success and Exceptions
PA_REPORT_TYPES 15 This table stores report types that enable users to create multiple reports for a project.
PA_REP_SEQ_NUMBER 1 This table stores sequence number from -100 to 20000 numbers.
PA_RESOURCES 37 Resources used in budgeting and project summary amounts
PA_RESOURCES_DENORM 30 PA_RESOURCES_DENORM is a denormalized table containing attributes for resources.
PA_RESOURCE_ACCUM_DETAILS 17 Information on how a PA_TXN_ACCUM record was mapped to a resource list member
PA_RESOURCE_ASGN_CURR 41 This table stores the rate overrides, the average rate, and the rollup amounts by currency for the planning transaction level.
PA_RESOURCE_ASGN_CURR_TMP 36
PA_RESOURCE_ASSIGNMENTS 124 Resource assignments for a budget version at a branch of project's work breakdown
PA_RESOURCE_ASSIGNMENTS_AR 15 Pa_Resource_Assignments_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_RESOURCE_CLASSES_B 9 This table stores resource class information.
PA_RESOURCE_CLASSES_TL 11 This table stores translated resource class information.
PA_RESOURCE_FORMATS 21 System-defined valid resource transaction attribute combinations
PA_RESOURCE_FORMAT_RANKS 8 System-defined ranking of resource formats used when mapping transaction attributes to resources in a resource list
PA_RESOURCE_LISTS_ALL_BG 28 Implementation-defined lists of resources for budgeting and project summary amounts
PA_RESOURCE_LISTS_TL 11 This table stores translated resource list information..
PA_RESOURCE_LIST_ASSIGNMENTS 12 Resource list assignments to projects
PA_RESOURCE_LIST_MEMBERS 92 Resources within a resource list
PA_RESOURCE_LIST_USES 8 Uses of resource lists assigned to projects
PA_RESOURCE_MAPS 25 Mapping of a resource list member to a combination of resource transaction attributes
PA_RESOURCE_TXN_ATTRIBUTES 26 Combination of transaction attributes for a resource that define which transactions to map to the resource
PA_RESOURCE_TYPES 17 Types of resources
PA_RESTYPE_MAP_TO_RESFORMAT 11 This table stores all mapping information between Pre FP-M and FP-M resource types.
PA_RES_ACCUM_DETAILS_AR 20 Pa_Resource_Accum_Details_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_RES_ASGN_TIME_CHART 21 No Longer Used.
PA_RES_ASSIGNMENTS_AR 25 Pa_Resource_Assignments_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_RES_AVAILABILITY 11 PA_RES_AVAILABILITY is a table storing available/overcommitted percent and hours of a resource for a given period.
PA_RES_FORMATS_B 23 Stores all valid resource formats for planning resources.
PA_RES_FORMATS_TL 11 Stores all translated valid resource formats for planning resources.
PA_RES_LISTS_IT_ALL_BG 24 Information about resource lists for Oracle Project Analysis Collection Pack
PA_RES_LIST_MAP_TMP1_1 71
PA_RES_LIST_MAP_TMP4_1 74
PA_RES_SCH_TIME_CHART 17 No Longer Used.r
PA_RES_TYPES_B 9 This table stores the resource type information.
PA_RES_TYPES_TL 11 This table stores the translated resource type information.
PA_RETN_INVOICE_DETAILS 22 PA_RETN_INVOICE_DETAILS stores total retained amount as of the invoice generation
PA_RETN_INV_DETAILS_AR 25
PA_ROLE_CONTROLS 9 PA_ROLE_CONTROLS stores the information about the controls defined on roles
PA_ROLE_JOB_BGS 12 This table holds the job defaults for a project role, either by business group or for across business groups.
PA_ROLE_LISTS 27 PA_ROLE_LISTS stores lists of roles defined with the system.
PA_ROLE_LIST_MEMBERS 8 PA_ROLE_LIST_MEMBERS stores the information about the roles which make up the role list
PA_ROLE_PROFILES 17 PA_ROLE_PROFILES stores business level attributes and resource id for each project role profile. The entries are categorized into two types:
PA_ROLE_PROFILE_LINES 8 PA_ROLE_PROFILE_LINES stores project roles and corresponding weightings defined for each project role profile. The sum of role weightings fo
PA_ROLE_STATUS_MENU_MAP 11 This table provides support for security on project role types based on the status of the project.The primary key for this table is ROLE_ID,
PA_ROUTINGS 12 Steps in the approval cycle for online timecards and expense reports
PA_ROUTINGS_AR 15 Pa_Routings_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_RP_CONC_PARAMS 9 This table stores the details about the concurrent parameters.
PA_RP_DEFINITIONS_B 13 This table stores the definitions about the Reporting Pack.
PA_RP_DEFINITIONS_TL 12 This table stores the definitions about the Reporting Pack.
PA_RP_JOB_ASSIGNMENTS 13 This table stores the information regarding job assignments.
PA_RP_JOB_ASSIGNMENTS_HISTORY 13 This table stores the information regarding history of job assignments.
PA_RP_LOBS 8 This table stores the information regarding Reporting Pack LOBS.
PA_RP_TEMPLATE_LISTS 11 This table stores the information regarding Reporting Pack Template Lists.
PA_RP_TYPES_B 13 This table stores the information regarding Reporting Pack Types.
PA_RP_TYPES_TL 9 This table stores the information regarding Reporting Pack Types.
PA_RULES 17 Implementation-defined formulas for deriving Accounting Flexfield segment values using AutoAccounting
PA_RULE_PARAMETERS 8 Parameters used by AutoAccounting rules that use SQL statements
PA_SCHEDULES 26 PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules
PA_SCHEDULES_AR 29 PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules
PA_SCHEDULES_HISTORY 26 This table stores copies of changed schedule records.
PA_SCHEDULES_HSTRY_AR 29 This table stores copies of changed schedule records.
PA_SCHEDULE_ELEMENTS 21 PA_SCHEDULE_ELEMENTS table contains the denormalized information of the various schedules, such as status, work type, and activity. This ta
PA_SCHEDULE_EXCEPTIONS 29 PA_SCHEDULE_EXCEPTIONS table contains the schedule day exceptions for assignments and requirements. This table has a row for each exception
PA_SCHEDULE_EXCEPT_HISTORY 30 PA_SCHEDULE_EXCEPT_HISTORY table contains the history of schedule exceptions requirements and assignments. Depending on the type of schedul
PA_SCH_EXCPT_HSTRY_AR 33 PA_SCHEDULE_EXCEPT_HISTORY table contains the history of schedule exceptions requirements and assignments. Depending on the type of schedul
PA_SEARCH_RESULTS_TEMP 30
PA_SEGMENT_RULE_PAIRINGS_ALL 14 Implementation-defined assignments of AutoAccounting rules to Accounting Flexfield segments
PA_SEGMENT_VALUE_LOOKUPS 8 Implementation-defined mappings of AutoAccounting rule intermediate values to Accounting Flexfield segment values
PA_SEGMENT_VALUE_LOOKUP_SETS 8 Implementation-defined lists of segment value lookups
PA_SET_OF_BOOKS_IT 11 Information about sets of books for Oracle Project Analysis Collection Pack
PA_SPAWNED_PROGRAM_STATUSES 9 Statuses of spawned programs
PA_SPREAD_CURVES_B 22 This table stores the spread curve information
PA_SPREAD_CURVES_TL 11 This table stores the translated spread curve information
PA_SRVC_TYPES_IT 23 Information about service types for Oracle Project Analysis Collection Pack
PA_STAGE1_BATCH_OLAP 1
PA_STANDARD_UNIT_COSTS 8 Stores the standard cost per unit for Project Assets by Asset Category and Asset Book. When the Asset Cost Allocation Method is "Standard U
PA_STATUS_COLUMN_SETUP 13 Project Status Inquiry display column definitions
PA_STATUS_LISTS 14 This table stores the attributes of a project status list.
PA_STATUS_LIST_ITEMS 10 This table stores the statuses in a status list.
PA_STD_BILL_RATE_SCHEDULES_ALL 25 Sets of standard bill rates that can be assigned as groups to projects and tasks
PA_STREAMLINE_REQUESTS 11 Information about submitted streamline process requests
PA_STRUCTURES_TASKS_TMP 233
PA_STRUCTURE_TYPES 26 PA_STRUCTURE_TYPES stores user-defined Structure Types. - For future use
PA_SUBBUDGETS 28 10SC Only
PA_SUMMARY_PROJECT_FUNDINGS 69 Summary funding amounts allocated from agreements to projects and tasks
PA_SUMMARY_PROJECT_RETN 29 PA_SUMMARY_PROJECT_RETN stores summary retention amounts calculated based on retention and retention billing setup at the project or top tas
PA_SUMMARY_PROJ_FUNDINGS_EFC 10
PA_SUMM_BALANCES 23 PA_SUMM_BALANCES stores summarized balance informations for reporting objects.
PA_SYSTEM_LINKAGES 16 System-defined categories that classify expenditure types and determine how expenditure items of each type are processed
PA_SYSTEM_NUMBERS 11 PA_SYSTEM_NUMBERS stores the next available control item type number for the project item type intersection.
PA_TASKS 99 User-defined subdivisions of project work
PA_TASKS_TMP 1
PA_TASK_HISTORY 17 Service type and task organization history
PA_TASK_TYPES 47 PA_TASK_TYPES stores implementation-defined classifications of task.
PA_TEAM_TEMPLATES 32 PA_TEAM_TEMPLATES stored details of the team templates. The templates are system-wide and accessible to all with appropriate privileges wit
PA_TEMP_IMPORT_TASKS 4 This table is for future use.
PA_TIMELINE_COLORS 12 The PA_TIMELINE_COLORS table stores the names of the GIF files used to define the colors for the timeline. This table is used as lookup tabl
PA_TIMELINE_ROW_LABEL 25 This table is no longer used.
PA_TIME_CAL_NAME 9 This table stores calendar names used in Oracle Projects
PA_TOP_RLMEM_IT 24 Information about the group level of resources for Oracle Project Analysis Collection Pack
PA_TOP_TASKS_IT 27 Information about the top task level for Oracle Project Analysis Collection Pack
PA_TRANSACTION_CONTROLS 18 Transaction controls of chargeable and billable status for projects and tasks
PA_TRANSACTION_INTERFACE_ALL 119 Interface table to import transactions from external sources into Oracle Projects
PA_TRANSACTION_SOURCES 48 Implementation-defined sources of imported transactions originating in an external system
PA_TRANSACTION_XFACE_CTRL_ALL 16 Control table used internally by the Transaction Import program to control processing of pending transactions
PA_TSK_ACT_CMT_IT_ALL 42 Task level actuals and commitments for Oracle Project Analysis Collection Pack
PA_TSK_BGT_LINES_IT_ALL 35 Task level budgets for Oracle Project Analysis Collection Pack
PA_TSK_BILL_SCH_OVRD_TMP 20
PA_TXN_ACCUM 58 Lowest level of summarized transaction record used in project summary amounts
PA_TXN_ACCUM_AR 61 Pa_Txn_Accum_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_TXN_ACCUM_DETAILS 17 Drilldown information from PA_TXN_ACCUM to cost, revenue, and event revenue distribution lines, and to commitments
PA_TXN_ACCUM_DETAILS_AR 21 Pa_Txn_Accum_Details_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_TXN_ACCUM_EFC 15
PA_TXN_INTERFACE_AUDIT_ALL 118 Auditing information about updates on PA_TRANSACTION_INTERFACE_ALL
PA_TXN_INTERFACE_AUDIT_AR 121 Pa_Txn_Interface_Audit_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
PA_TXN_UPGRADE_TEMP 6
PA_UBR_UER_SUMM_ACCT 22 The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue.
PA_UNBILLED_REC_REPORTING 13 Temporary table used when reporting project unbilled receivables aging
PA_UNIQUE_IDENTIFIER_CONTROL 7 The next project number (for automatic project numbering)
PA_USAGE_COST_RATE_OVR_ALL 12 Cost rates, assigned to non-labor resources and organizations, that override the expenditure type cost rates
PA_USAGE_COST_RATE_OVR_EFC 9
PA_UTILIZATION_OPTIONS_ALL 13 This table stores the parameters and defaults that define the various utilization options.If you have a multi-organization installation, you
PA_UTIL_CATEGORIES_B 25 This table stores implementation-defined types of Utilization Categories being carried out in Projects Resource Management in the base lang
PA_UTIL_CATEGORIES_TL 10 This table provides multi-lingual support (MLS) for Utilization Categories that you define in Oracle Projects. MLS enables you to store and
PA_VALID_CATEGORIES 24 Table for storing valid categories for an object type.
PA_VALUE_MAPS 19 PA_VALUE_MAPS stores the mapping data for mapping definition defined in PA_VALUE_MAP_DEFS.
PA_VALUE_MAP_DEFS 12 PA_VALUE_MAP_DEFS stores the mapping definition between value sets in PA_MAP_VALUE_SETS. The data in this table should be seeded by develope
PA_VERIFICATION_RULES 11 10SC Only
PA_WBS_SEQ_TMP 4
PA_WF_NTF_PERFORMERS 17 This table stores information about the approvers for a specific workflow process .
PA_WF_NTF_PERFORMERS_AR 25 PA_WF_NTF_PERFORMERS_AR is a table for Archive/Purge.
PA_WF_PROCESSES 11 Versions of project and budget workflows. There can be many workflows for a project or budget.
PA_WF_PROCESSES_AR 14 Versions of project and budget workflows. There can be many workflows for a project or budget.
PA_WF_PROCESS_DETAILS 21 PA_WF_PROCESS_DETAILS stores details of workflow processes.
PA_WF_PROCESS_DETAILS_AR 24 PA_WF_PROCESS_DETAILS_AR is a table for Archive/Purge.
PA_WORK_TYPES_B 33 This table stores implementation-defined types of work being carried out in Projects in the base language.
PA_WORK_TYPES_TL 10 This table provides multi-lingual support (MLS) for work types that you define in Oracle Projects. MLS enables you to store and print data t
PA_WORK_TYPE_SCHEDULES 14 PA_WORK_TYPE_SCHEDULES table contains the work type schedules for requirements and assignments
PA_XBS_DENORM 20 This table stores normalized work breakdown structure and program hierarchy information
PA_XBS_DENORM_TEMP 18 Global temporary table to store the interim xbs_denorm data.
PA_XLA_DRAFT_REV_TMP 10 The PA_XLA_DRAFT_REV_TMP temporary table used by revenue xla upgrade.
PA_XLA_LINES_TMP 19 The PA_XLA_LINES_TMP temporary table used by revenue xla upgrade.
PA_XLA_UPG_CTRL 6 This table used for driving R12 Projects SLA upgrade
PA_XLA_UPG_LINES_GT 27