Search Results check_gl_setup

Overview

FUN_GLINT_WF is a PL/SQL package owned by the APPS schema that supports the integration between Oracle General Ledger and the Funds Capture / payment processing flows within Oracle E-Business Suite. Its role is to orchestrate the interaction with Oracle Workflow (WF) when transactions must be transferred to General Ledger, ensuring that the appropriate accounting events are signalled and that completion notifications are raised back to the initiating process. The package resides in the logical territory shared by the FUN (Funds Capture) and GL (General Ledger) application modules, and it is classified in the ETRM as an "OTHER" API, meaning it is an internal integration utility rather than a formally published public API.

In Oracle EBS 12.1.1 and 12.2.2, the package is documented as VALID in the APPS schema. It depends on the SYS schema and the STANDARD package, and its dependency footprint is deliberately narrow; it is referenced by no other packaged units and no other APPS packages depend on it. This confirms its status as a leaf-level integration component invoked by workflow-driven processes rather than by other PL/SQL APIs.

Key Procedures and Functions

The ETRM registry documents six procedures and functions within FUN_GLINT_WF. Their names and general purposes are as follows:

• GET_ATTR_GL — Retrieves General Ledger-related attribute values, typically used to obtain the ledger, account, or reference attributes required to build the GL transfer payload.
• CHECK_GL_SETUP — Validates that the General Ledger setup required for the transfer is present and correctly configured before processing proceeds.
• TRANSFER_TO_GL — Performs the actual transfer of funds capture transaction data into General Ledger, invoking the appropriate GL accounting interface.
• CHECK_SIGNAL_INITIATOR — Determines whether the calling workflow or process is the legitimate initiator of the GL signal, guarding against duplicate or erroneous invocations.
• RAISE_GL_COMPLETE — Raises the workflow completion event that notifies the broader Funds Capture workflow that the GL transfer step has finished.
• UPDATE_INI_COMPLETE — Updates the internal completion flag or status for the initiating transaction, marking the GL integration step as done.

Parameter lists are not enumerated in the ETRM metadata and should not be assumed; integrators should inspect the live source in the APPS schema.

Tables Accessed

Through APPS synonyms, the package reads and writes the following tables:

• FUN_TRX_BATCHES and FUN_TRX_HEADERS — the Funds Capture transaction batch and header tables that supply the payment data to be transferred.
• GL_LEDGERS — used to identify and validate the target ledger for the accounting transfer.
• HZ_PARTIES — provides party information associated with the transaction for the GL entry context.
• WF_PARAMETER_LIST_T — the Oracle Workflow parameter list type used to pass and receive event attributes.
• PLITBLM — a standard PL/SQL table type used internally for bulk collections.

Usage Notes

FUN_GLINT_WF is invoked as part of the Funds Capture-to-GL integration workflow. It is not exposed through a standard concurrent program or form button directly; rather, it is called by the Oracle Workflow engine when the relevant activity is executed, and it in turn raises workflow events such as GL completion. Custom code should avoid calling this package directly unless the calling process fully replicates the workflow state expected by CHECK_SIGNAL_INITIATOR and CHECK_GL_SETUP. Because the package is not referenced by other packaged APIs, it should be treated as an internal implementation detail of the Oracle Funds Capture GL integration rather than a supported extension point.