Search Results ar_interface_lines_all




Overview
Explore in AI Chat

Overview

APPS.FUN_INITIATOR_WF_PKG is a workflow-enabled PL/SQL package used by Oracle E-Business Suite Receivables and the Oracle Financials (FUN) transaction-initiator framework to orchestrate the outbound creation of AutoInvoice transactions. It coordinates Oracle Workflow events and attributes for records originating in the FUN transaction tables, then drives the transfer, validation, and posting of those transactions into the Receivables interface and base tables. In effect, the package acts as the bridge between the internal FUN transaction staging model and the standard Oracle Receivables AutoInvoice pipeline, invoking the same interface structures (RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL) that customer-facing interfaces populate.

Key Procedures and Functions

  • SET_ATTRIBUTES — Initializes and populates the Oracle Workflow process item attributes from the underlying FUN and Receivables data. It reads the BATCH_ID and TRX_ID set by the receiving event and derives values such as batch number, GL date, batch date, recipient organization name, transaction number, transaction amount, and currency for use downstream in the workflow.
  • UPDATE_STATUS — Updates a workflow status attribute, allowing the process to reflect the current state of the transaction as it progresses through the initiator flow.
  • TRANSFER_AR — Transfers transaction data into the Receivables interface tables so that AutoInvoice can process it.
  • CHECK_AR_SETUP — Validates that the required Receivables configuration (batches, transaction types, sources, and related setup) exists before transfer.
  • GET_INVOICE — Retrieves the invoice/transaction record being processed, typically from the FUN transaction headers, for use by later steps.
  • GENERATE_KEY — Generates workflow item keys or transaction identifiers needed to uniquely track each initiator process instance.
  • UPDATE_TRX_HEADERS — Updates the FUN transaction header records, reflecting transfer or processed status back into the FUN model.
  • POST_AR_INVOICE — Invokes posting of the Receivables invoice once AutoInvoice has created the transaction.

Tables Accessed

The package reads and writes across the FUN transaction model and the Receivables interface and base tables. It uses the FUN tables (FUN_TRX_BATCHES, FUN_TRX_HEADERS, FUN_TRX_LINES, FUN_DIST_LINES) as the source transaction data. It references Receivables interface tables RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL — the same table family as AR_INTERFACE_LINES_ALL that the user searched — to stage lines and distributions for AutoInvoice. It reads Receivables setup tables (RA_BATCH_SOURCES_ALL, RA_CUST_TRX_TYPES_ALL), party/customer tables (HZ_PARTIES, HZ_CUST_SITE_USES_ALL, HZ_CUSTOMER_PROFILES), base transaction tables (RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL), and workflow tables (WF_EVENT_T, FND_USER) to resolve attributes, ownership, and event state.

Usage Notes

FUN_INITIATOR_WF_PKG is invoked primarily through the Oracle Workflow engine as part of the FUN transaction initiator process, with its procedures registered as workflow function activities. It is not intended as a general-purpose API for external callers; the documented reference by five other packages indicates it is consumed internally by the FUN/Receivables integration layer. It is not exposed through standard Oracle Forms or a standalone concurrent program. Customizations or diagnostics involving FUN transactions, AutoInvoice transfers, or the RA_INTERFACE_LINES_ALL interface typically trace into this package indirectly through workflow event processing rather than by direct invocation.