Search Results start_fracct_wf_process

Overview

FTE_FPA_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as a UTIL (utility) API. It forms part of the Financials Transaction Engine (FTE) subsystem, which processes freight, payment, and accounting distribution logic for procurement and payables transactions. The package exposes a reusable set of helper routines that encapsulate common lookups and calculations required by higher-level FTE flows, notably the FTE_TENDER_WF workflow and the FTE_FPA_UTIL package body itself. It depends on FND_API and the SYS.STANDARD package, and it is referenced by one other package in addition to its own body. In Oracle EBS 12.1.1 and 12.2.2 the package retains a VALID status and is treated as an internal utility rather than a public application programming interface.

Key Procedures and Functions

The ETRM metadata documents seven distinct routines within FTE_FPA_UTIL. Their names indicate the following responsibilities:

• GET_PAYMENT_METHOD — Retrieves the payment method associated with a payment or invoice context, supporting downstream tender and settlement processing.
• CALCULATE_PO_FREIGHT — Computes freight charges relating to purchase order or receipt transactions, typically feeding accounts payable freight distribution.
• GET_LEGAL_ENTITY — Resolves the legal entity (organization) that owns or is responsible for a given document or transaction.
• UPDATE_STATUS — Updates the processing status of an FTE transaction or workflow record, enabling progress tracking.
• GET_FRACCT_CCID — Derives the Flexfield Accounting (FRACCT) code combination identifier, returning the CCID used for accounting distribution.
• LOG_FAILURE_REASON — Records a failure reason against a transaction or workflow event, writing to the FTE failure reason tables.
• START_FRACCT_WF_PROCESS — Initiates the accounting distribution (Flexfield Accounting) workflow process for a transaction.

Parameter signatures are not published in the ETRM excerpt; only the routine names and their implied purpose are documented.

Tables Accessed

The package reads and writes a broad set of APPS synonyms. Payables and invoice data come from AP_CHECKS_ALL, AP_INVOICES_ALL, and AP_INVOICE_PAYMENTS_ALL, supporting payment method and settlement logic. Freight and receipt information is drawn from PO_RCV_CHARGES. Failure tracking uses FTE_FAILURE_REASONS and FTE_FAILURE_REASONS_S. Transaction processing leverages FTE_INVOICE_HEADERS and FTE_INVOICE_LINES. Organization context is resolved through HR_ORGANIZATION_INFORMATION and carrier data via WSH_CARRIERS and WSH_DELIVERY_ASSIGNMENTS. Item categorization uses MTL_CATEGORIES_KFV, MTL_CATEGORY_SETS, and MTL_ITEM_CATEGORIES. Workflow parameters are passed through WF_PARAMETER_LIST_T.

Usage Notes

FTE_FPA_UTIL is not intended for direct invocation by end users. It is called programmatically by the FTE_TENDER_WF workflow and by the package body itself, meaning it executes implicitly during freight tender, payment, and accounting distribution processing. Customizations or extensions that need payment method lookup, legal entity resolution, freight calculation, failure logging, or FRACCT workflow initiation for FTE transactions can call these routines provided the calling code complies with FND_API error-handling conventions. Because the package is classified as a utility internal to the FTE subsystem, Oracle does not guarantee its interface across releases; developers should validate behavior when applying 12.1.1 or 12.2.2 patches.