Search Results gl_automatic_posting_sets_pk

Overview

GL_AUTOMATIC_POSTING_SETS is a General Ledger configuration table that stores named sets of automatic posting criteria used by the Oracle EBS Automatic Posting program. Each row defines a reusable posting set that determines which journal entries are eligible for automatic posting, the priority ordering to apply, and the date window within which entries may be posted. The table is owned by the GL schema and is classified as VALID in the ETRM repository for both 12.1.1 and 12.2.2. Its primary key is GL_AUTOMATIC_POSTING_SETS_PK, defined on the AUTOPOST_SET_ID column.

From a Data Vault modeling perspective the table is heuristically classified as satellite-leaning. It behaves as a descriptive satellite attached to a ledger (GL_SETS_OF_BOOKS) and a chart of accounts context, and it is the parent of the child options stored in GL_AUTOMATIC_POSTING_OPTIONS. This classification is a modeling suggestion rather than a physical constraint enforced by the product.

Key Information Stored

The table contains 34 documented columns. The most significant ones are:

• AUTOPOST_SET_ID — surrogate primary key defined by GL_AUTOMATIC_POSTING_SETS_PK and reinforced by the U1 unique index.
• AUTOPOST_SET_NAME — user-visible name of the posting set. Together with CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, and ACCOUNTED_PERIOD_TYPE it forms the business-key candidate enforced by unique index U2.
• SET_OF_BOOKS_ID and SET_OF_BOOKS_ID_11I — ledger foreign keys supporting the 12.1.x and 11i upgrade paths respectively, referencing GL_SETS_OF_BOOKS and GL_SETS_OF_BOOKS_11I.
• CHART_OF_ACCOUNTS_ID — chart of accounts context for the set, referenced against GL_MGT_SEG_UPGRADE_H.
• PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE — accounting calendar and period type determining the calendar context in which the posting set is valid.
• SUBMIT_ALL_PRIORITIES_FLAG — controls whether all priority groups are submitted together during a run.
• ENABLED_FLAG — indicates whether the posting set is active and selectable by the posting program.
• NUM_OF_PRIORITY_OPTIONS — number of priority options configured for the set.
• EFFECTIVE_DAYS_BEFORE and EFFECTIVE_DAYS_AFTER — the date window (expressed in days) relative to the run that limits eligibility of journal entries.
• SECURITY_FLAG — governs whether the set is restricted by data access security.
• DESCRIPTION, CONTEXT, and ATTRIBUTE1 through ATTRIBUTE15 — descriptive and descriptive-flexfield columns, with standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The table is primarily queried for configuration review, security auditing, and troubleshooting of the Automatic Posting program. A representative query listing enabled sets for a ledger is:

• SELECT autopost_set_id, autopost_set_name, enabled_flag, submission_priority
  FROM gl_automatic_posting_sets
  WHERE set_of_books_id = :ledger_id AND enabled_flag = 'Y';
• Finding sets by calendar context: filter on PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE.
• Reviewing the date window: inspect EFFECTIVE_DAYS_BEFORE and EFFECTIVE_DAYS_AFTER.
• Security reporting: query SECURITY_FLAG to identify sets subject to access restrictions.
• Child option analysis: join to GL_AUTOMATIC_POSTING_OPTIONS on AUTOPOST_SET_ID to list priority options per set.

Related Objects

The most significant related objects and their join columns are:

• GL_AUTOMATIC_POSTING_OPTIONS — child table referencing AUTOPOST_SET_ID; holds the individual priority options for each set.
• GL_SETS_OF_BOOKS — referenced through SET_OF_BOOKS_ID.
• GL_SETS_OF_BOOKS_11I — referenced through SET_OF_BOOKS_ID_11I.
• GL_MGT_SEG_UPGRADE_H — referenced through CHART_OF_ACCOUNTS_ID.
• GL_AUTOMATIC_POSTING_SETS_PK — primary key constraint.
• GL_AUTOMATIC_POSTING_SETS_U1 — unique index on AUTOPOST_SET_ID.
• GL_AUTOMATIC_POSTING_SETS_U2 — unique business-key index on AUTOPOST_SET_NAME, CHART_OF_ACCOUNTS_ID, PERIOD_SET_NAME, and ACCOUNTED_PERIOD_TYPE.