Search Results gl_set_of_bks_id

Overview

Payables Transfer to General Ledger (APGLTRANS) is the Oracle Payables concurrent program responsible for moving accounting entries from the Payables subledger into Oracle General Ledger. The program is owned by the AP - Payables product and executes the Payables Accounting Process output, transferring the accounted distributions generated from invoices, payments, adjustments, and related transactions so that they become available for GL posting and reporting. Its documented user-facing name is "Payables Transfer to General Ledger," and the ETRM metadata records it as Enabled: No, meaning it is not intended for direct, unrestricted submission in the standard navigation flow.

Execution Details

The documented execution attributes for APGLTRANS are:

• Product: AP - Payables
• Execution Method: Oracle Reports
• Argument Method: Standard
• Executable: APXGLTRN
• Execution File Name: APXGLTRN
• User Name (Executable): APXGLTRN
• Enabled: No

Because the execution method is Oracle Reports, the program is driven by the APXGLTRN report executable and receives its selection criteria through standard SRS arguments. The disabled status reflects that the transfer is normally initiated indirectly through the Payables accounting and transfer flow rather than as a standalone user-run request.

How to Run

Users typically submit APGLTRANS through the Submit Request (SRS) window or via the concurrent manager. The standard argument method governs parameter entry, and the request set argument metadata exposes the following parameters and defaults:

• ATTRIBUTE4 — a shared, display/insert/update-enabled argument whose default is populated by the query select name from ap_sob_info_v where (sob_type = 'Primary' AND set_of_books_id = (SELECT fnd_profile.value('GL_SET_OF_BKS_ID') FROM dual)) OR ((SELECT mrc_sob_type_code FROM gl_sets_of_books WHERE set_of_books_id = (SELECT fnd_profile.value('GL_SET_OF_BKS_ID') FROM dual)) = 'N' AND sob_type = 'Reporting'). This resolves the ledger name from the GL_SET_OF_BKS_ID profile option.
• ATTRIBUTE6 — the batch_name argument, display and insert enabled, with no default.
• ATTRIBUTE7 — the transaction_from_date argument, display/insert/update enabled.
• ATTRIBUTE8 — the transaction_to_date argument, display/insert/update enabled.

The presence of GL_SET_OF_BKS_ID in the default query is significant for users searching on that term: the program's ledger context is derived from this profile option rather than being freely entered.

Related Objects

APGLTRANS interacts with the Payables accounting and GL interface architecture. Commonly associated objects include:

• GL_INTERFACE — the General Ledger interface table into which transferred accounting entries are staged.
• GL_JE_BATCHES / GL_JE_HEADERS / GL_JE_LINES — journal structures populated upon import and posting.
• AP_SOB_INFO_V and GL_SETS_OF_BOOKS — ledger and set-of-books sources referenced by the ATTRIBUTE4 default query.
• FND_PROFILE — source of the GL_SET_OF_BKS_ID profile value used to resolve the ledger.
• APXGLTRN — the Oracle Reports executable that implements the transfer.
• Related Payables programs such as the Payables Accounting Process, Create Accounting, and GL Journal Import, which precede and follow the transfer in the accounting lifecycle.

Because the program is documented as disabled, administrators should confirm the intended accounting workflow before attempting direct submissions, and rely on supported Payables and GL transfer processes for routine operations.