Results for “future_posting_ccid”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGI_MPP_SETUP_ALL is a configuration table owned by the IGI schema, the Public Sector Financials International product family in Oracle E-Business Suite. Its documented purpose is to hold setup information for multi-period posting, a budgeting and accounting capability used primarily by public sector and government implementations to distribute a single transaction across multiple accounting periods. Each row in the table represents the multi-period posting configuration for a given ledger, which the schema identifies through the SET_OF_BOOKS_ID column. The table is marked VALID in the ETRM metadata for both 12.1.1 and 12.2.2, and the documented physical schema contains eleven columns.
From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is standalone. This suggests treating IGI_MPP_SETUP_ALL as an independent reference or configuration structure rather than as a hub, link, or satellite. Because it does not participate in a documented parent-child foreign key chain, it can be modeled as a standalone setup dimension keyed on the ledger, with no surrounding link table required.
Key Information Stored
The primary key is defined by the constraint IGI_MPP_SETUP_ALL_PK, which covers SET_OF_BOOKS_ID. This makes SET_OF_BOOKS_ID both the surrogate identifier for the constraint and the natural business key: a single multi-period posting configuration exists per ledger. Multi-organization installations additionally carry ORG_ID, which is present in the documented column list and typically operates in conjunction with the ledger to scope configuration by operating unit.
The functional configuration columns are:
- DEFAULT_ACCOUNTING_RULE_ID — the accounting rule applied by default when a multi-period transaction is generated, resolving to a rule definition that determines the period distribution pattern.
- FUTURE_POSTING_CCID — the code combination identifier for the account used in future-period postings, referenced against the chart of accounts combinations table.
- JE_CATEGORY_NAME — the journal category assigned to entries created by multi-period posting.
- JE_SOURCE_NAME — the journal source assigned to those entries, which drives validation and posting behavior in General Ledger.
- SET_OF_BOOKS_ID — the ledger identifier and primary key column.
- ORG_ID — the operating unit or organization identifier used for multi-org security and filtering.
The remaining documented columns are standard Oracle EBS audit attributes: LAST_UPDATED_BY, LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, and LAST_UPDATE_LOGIN. These support the WHO column convention and should always be retained for audit and diagnostic reporting.
Common Use Cases and Queries
The most frequent scenario is verifying that a ledger is correctly configured before running multi-period posting, or diagnosing why postings fail. A typical diagnostic query joins the setup row to the ledger:
SELECT s.set_of_books_id, s.default_accounting_rule_id, s.future_posting_ccid,
s.je_source_name, s.je_category_name
FROM igi.igi_mpp_setup_all s
WHERE s.set_of_books_id = :ledger_id;
Configuration comparison across ledgers is equally common, particularly during implementations with many sets of books. Analysts also extract the journal source and category values to cross-reference IGI_MPP_SETUP_ALL against GL_JE_SOURCES and GL_JE_CATEGORIES, and to confirm that FUTURE_POSTING_CCID resolves to a valid, enabled account combination. Because the table is small and largely static, it is often included wholesale in setup migration extracts and reconciliation reports between environments.
Related Objects
The table's relationships are primarily referential rather than enforced foreign keys. The columns resolve to the following significant objects:
- GL_LEDGERS / GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID, the primary key column.
- GL_JE_SOURCES — matched on JE_SOURCE_NAME for journal source validation.
- GL_JE_CATEGORIES — matched on JE_CATEGORY_NAME.
- GL_CODE_COMBINATIONS — joined on FUTURE_POSTING_CCID (CODE_COMBINATION_ID) to resolve the future posting account.
- IGI_MPP_ACCOUNTING_RULES (or the accounting rules definition) — referenced through DEFAULT_ACCOUNTING_RULE_ID.
- HR_OPERATING_UNITS / org definitions — referenced through ORG_ID for multi-org scoping.
Because the metadata documents no enforced foreign keys, joins to these objects must be written explicitly and validated at runtime; referential integrity is maintained by the application rather than by the database.
-
Contains setup information for multi -period posting
-
View: IGI_MPP_SETUP_V 12.1.1
View for the Multi Period Posting form based on IGI_MPP_SETUP view
APPS.IGI_MPP_SETUP_V·↳ GL_JE_CATEGORIES_TL·↳ GL_JE_SOURCES_TL·↳ IGI_MPP_SETUP·Explore IGI module →
-
Contains setup information for multi -period posting
-
View: IGI_MPP_SETUP_V 12.2.2
View for the Multi Period Posting form based on IGI_MPP_SETUP view
APPS.IGI_MPP_SETUP_V·↳ GL_JE_CATEGORIES_TL·↳ GL_JE_SOURCES_TL·↳ IGI_MPP_SETUP·Explore IGI module →
-
View: IGI_MPP_SETUP 12.2.2
Contains setup information for Multi Period Posting
-
View: IGI_MPP_SETUP 12.1.1
Contains setup information for Multi Period Posting
-
VIEW: IGI.IGI_MPP_SETUP_ALL# 12.2.2
-
VIEW: IGI.IGI_MPP_SETUP_ALL# 12.2.2
-
TABLE: IGI.IGI_MPP_SETUP_ALL 12.1.1
-
TABLE: IGI.IGI_MPP_SETUP_ALL 12.2.2
-
VIEW: APPS.IGI_MPP_SETUP 12.2.2
-
VIEW: APPS.IGI_MPP_SETUP 12.1.1
-
VIEW: APPS.IGI_MPP_SETUP 12.2.2
-
VIEW: APPS.IGI_MPP_SETUP 12.1.1
-
VIEW: APPS.IGI_MPP_SETUP_V 12.1.1
-
VIEW: APPS.IGI_MPP_SETUP_V 12.2.2
-
eTRM - IGI Tables and Views 12.1.1
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
-
eTRM - IGI Tables and Views 12.2.2
This is a temporary table used for GBV migration from 10.7/11.03 to 11i.