Search Results allow_foreign_curr_txn_flag

Overview

PA_IMPLEMENTATIONS_ALL is the principal setup table for the Oracle Projects (PA) application, residing in the PA schema. It stores information about the configuration of an Oracle Projects installation, with one implementation record per operating unit. Each row captures the business group, set of books, organization hierarchy, calendar, numbering, billing, costing, currency, and multi-organization options that govern how projects, expenditures, and invoices are processed for that unit.

The table is owned by the PA product and is classified as VALID in the ETRM metadata for Oracle EBS 12.1.1 and 12.2.2. It carries 98 documented columns and is described by the unique index PA_IMPLEMENTATIONS_U1 on the ORG_ID column, which is also the table's primary key (PA_IMPLEMENTATIONS_PK). Under the heuristic Data Vault classification mined from its foreign key structure, PA_IMPLEMENTATIONS_ALL is considered satellite-leaning; that is, it behaves as a configuration attribute repository keyed by operating unit rather than a transactional hub or a pure relationship link. This classification is a modeling suggestion, not a documented Oracle construct.

Key Information Stored

The surrogate primary key is ORG_ID, the operating unit identifier, and it is the sole documented business-key candidate through the unique index PA_IMPLEMENTATIONS_U1. The remaining columns hold the substantive setup data, and the most important among them include:

• SET_OF_BOOKS_ID — the general ledger set of books linked to the installation.
• BUSINESS_GROUP_ID — the HR business group owning the operating unit.
• ORGANIZATION_STRUCTURE_ID and ORG_STRUCTURE_VERSION_ID — the organization hierarchy and version used for project and expenditure organizations.
• EXP_ORG_STRUCTURE_ID / PROJ_ORG_STRUCTURE_ID and their corresponding version and start organization columns — separate hierarchies for expenditure and project organizations when they differ.
• PA_PERIOD_TYPE, ACCUMULATION_PERIOD_TYPE, PERIOD_SET_NAME, and SAME_PA_GL_PERIOD — the accounting calendar configuration, including alignment of the Projects period with the GL period.
• INVOICE_BATCH_SOURCE_ID and BILLING_CYCLE / BILLING_OFFSET — defaults for the billing and receivables invoice generation process.
• USER_DEFINED_PROJECT_NUM_CODE, MANUAL_PROJECT_NUM_TYPE, USER_DEFINED_INVOICE_NUM_CODE, and MANUAL_INVOICE_NUM_TYPE — project and invoice numbering rules.
• MULTI_CURRENCY_BILLING_FLAG, ALLOW_FOREIGN_CURR_TXN_FLAG, ACCT_RATE_TYPE, and ACCT_RATE_DATE_CODE — foreign currency handling and accounting rate defaults.
• INTERFACE_LABOR_TO_GL_FLAG, INTERFACE_USAGE_TO_GL_FLAG, and INTERFACE_REVENUE_TO_GL_FLAG — which cost and revenue streams are transferred to General Ledger.
• CC_PROCESS_IO_CODE, CC_ALLOW_IU_FLAG, and CC_IC_BILLING_PRVDR_FLAG — cross-charge processing behavior.
• ENABLE_MRC_FOR_FUND_FLAG, REVAL_MRC_FUNDING_FLAG, and related MRC options — multiple reporting currency behavior for funding and financial plans.
• BOOK_TYPE_CODE and SALES_CREDIT_TYPE_CODE — fixed asset book and sales credit type references.

Common Use Cases and Queries

The table is most frequently queried during Projects setup validation, period and calendar troubleshooting, and multi-organization reporting. A typical lookup retrieves the core configuration for a given operating unit:

• SELECT set_of_books_id, business_group_id, pa_period_type, period_set_name FROM pa_implementations_all WHERE org_id = :org_id;
• Detecting operating units where the Projects period differs from the GL period by filtering on SAME_PA_GL_PERIOD.
• Reviewing which operating units push labor, usage, or revenue to GL by inspecting the INTERFACE_*_TO_GL_FLAG columns.
• Identifying installations with multi-currency billing or cross-charge processing enabled for audit and impact analysis.
• Confirming the default invoice batch source and billing cycle before troubleshooting AR invoice generation.

Related Objects

PA_IMPLEMENTATIONS_ALL sits at the center of a set of reference and child objects. Its foreign keys reference HR_ALL_ORGANIZATION_UNITS through BUSINESS_GROUP_ID, GL_SETS_OF_BOOKS_11I through SET_OF_BOOKS_ID, FA_BOOK_CONTROLS through BOOK_TYPE_CODE, PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_VERSIONS through the organization hierarchy columns, RA_BATCH_SOURCES_ALL through INVOICE_BATCH_SOURCE_ID, GL_PERIOD_TYPES through PA_PERIOD_TYPE, and SO_SALES_CREDIT_TYPES_115 through SALES_CREDIT_TYPE_CODE.

Several dependent tables reference this table by ORG_ID, including PA_EVENT_TYPE_OUS_ALL, PA_EXPENDITURE_TYPE_OUS_ALL, PA_FP_OF_WEBADI_XFACE, PA_ORG_FCST_ELEMENTS (which also references it through OTHER_ORG_ID), and PA_ORG_LABOR_SCH_RULE. These objects inherit the operating unit's implementation configuration and depend on the presence of a valid PA_IMPLEMENTATIONS_ALL row for that organization.