Search Results gl_automatic_posting_sets




Overview
Explore in AI Chat

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:

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.