Search Results ppv_automatic_processing

Overview

AX_SETUP_SUBLEDGERS_V is a reporting and inquiry view in the Oracle E-Business Suite Global Accounting Engine (AX) module. It consolidates setup and configuration attributes for the subledger integration between Oracle subledger applications and the Global Accounting Engine, joining each setup row to its owning application and its associated set of books. The view exposes descriptive values — most notably the application name and the set of books name — in place of the numeric identifiers stored on the base setup table. This "denormalized" presentation makes it suitable for direct use in reports, custom concurrent programs, and integration queries where a user-readable context is required.

The view was commonly referenced when administrators or developers searched for the term main_set_of_books_name, since the underlying AX_SETUP_SUBLEDGERS table stores only MAIN_SET_OF_BOOKS_ID; the view supplies the corresponding set of books name by joining GL_SETS_OF_BOOKS.

Underlying Base Objects

The view is defined over three base objects:

• AX_SETUP_SUBLEDGERS — the primary setup table holding subledger configuration rows (aliased SL).
• GL_SETS_OF_BOOKS — the General Ledger set of books definition (aliased SOB), joined on SOB.SET_OF_BOOKS_ID = SL.MAIN_SET_OF_BOOKS_ID.
• FND_APPLICATION_VL — the application definitions view (aliased A), joined on A.APPLICATION_ID = SL.APPLICATION_ID, supplying the translated application name.

The view text selects from these three objects using an inner-join structure, so a row is returned only when both a matching application and a matching set of books exist for the setup record. The ETRM metadata for 12.2.2 documents no additional base objects beyond these three.

Key Columns

• ROW_ID — the ROWID of the underlying AX_SETUP_SUBLEDGERS row, useful for precise row identification.
• APPLICATION_ID / APPLICATION_NAME — the subledger application owning the setup row and its translated display name (for example, Payables or Purchasing).
• MAIN_SET_OF_BOOKS_ID / MAIN_SET_OF_BOOKS_NAME — the identifier and descriptive name of the set of books to which the subledger accounting setup is linked. This is the column most frequently sought by users searching for main_set_of_books_name.
• TRANSLATE_EVENTS, SECURE_POSTING — setup flags controlling event translation and posting security behavior.
• PERIOD_FROM, PERIOD_TO — the effective period range for the subledger setup.
• IPV_AUTOMATIC_PROCESSING, PPV_AUTOMATIC_PROCESSING — flags governing automatic processing of invoice price variance and purchase price variance.
• Standard audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical scenarios include auditing which subledgers are configured for Global Accounting Engine, verifying the set of books assigned to each application, and embedding setup lookups in custom reports. A basic query listing all configured subledgers is:

SELECT application_name,
       main_set_of_books_name,
       translate_events,
       secure_posting,
       period_from,
       period_to
FROM   ax_setup_sublergers;  -- correct name: ax_setup_subledgers_v

To retrieve the setup for a specific application and set of books, filter on the descriptive columns:

SELECT application_name,
       main_set_of_books_name
FROM   ax_setup_subledgers_v
WHERE  application_name = 'Payables'
AND    main_set_of_books_name = 'Vision Operations';

Because the view resolves both the application and set of books names through joins, it should be used in read-only reporting contexts; DML against the view is not supported, and changes must be applied to the base AX_SETUP_SUBLEDGERS table.