Search Results update_batch_status_err

Overview

FUN_NET_APPROVAL_WF is an Oracle Application Object Library package in the APPS schema that supports the Oracle Payables and Receivables netting functionality, specifically the workflow-driven approval of netting batches and agreements. Netting allows trading partners within a corporate group to offset reciprocal payables and receivables balances and settle the resulting net amount through a single payment or receipt. Because netting batches affect multiple trading partners and can carry significant financial exposure, they must pass through a defined approval process before settlement.

FUN_NET_APPROVAL_WF encapsulates the approval-related logic that the Oracle Workflow engine invokes during that process. It constructs and raises workflow events, determines the appropriate action when an approver does not respond within the allotted time, initializes approval context data, and writes the resulting status back to the netting batch record. The package is registered as an OTHER API in the ETRM repository with a VALID status and is certified for both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• RAISE_APPROVAL_EVENT — Raises the Oracle Workflow business event that launches or advances the netting approval workflow. This is the primary entry point through which the application signals that a netting batch or agreement requires approval action.
• INITIALIZE — Performs setup and initialization of the approval context before the workflow begins, populating the data structures that subsequent procedures and workflow activities rely upon.
• VALIDATE_SETTLE_BATCH — Validates whether a netting batch is eligible for settlement, typically after approval has been granted, ensuring the batch meets the conditions required to proceed.
• GET_NORESPONSE_ACTION — Determines the action to take when an approver fails to respond within the configured time limit, allowing the workflow to route the batch according to the defined timeout policy.
• UPDATE_BATCH_STATUS_REJ — Updates the netting batch status to reflect rejection, recording the outcome when an approver declines the batch.
• UPDATE_BATCH_STATUS_ERR — Updates the netting batch status to reflect an error condition encountered during approval processing.

Tables Accessed

• FUN_NET_BATCHES_ALL — The core netting batch table. The package updates batch status here through the UPDATE_BATCH_STATUS_REJ and UPDATE_BATCH_STATUS_ERR procedures and reads batch context during initialization and settlement validation.
• FUN_NET_AGREEMENTS_ALL — Stores netting agreement definitions. Accessed to resolve the agreement context associated with a batch under approval.
• FND_USER — Identifies approvers and the originator of the netting batch, supporting workflow routing and notification generation.
• WF_PARAMETER_LIST_T and PLITBLM — Workflow parameter and PL/SQL table structures used to pass event attributes and parameter lists between the package and the Workflow engine.

Usage Notes

FUN_NET_APPROVAL_WF is invoked indirectly rather than through direct end-user navigation. Its procedures are called by Oracle Workflow activities configured on the netting approval process, and by the netting forms and concurrent programs that submit batches for approval. The package is referenced by FUN_NET_ARAP_PKG, confirming its tight coupling to the netting payables/receivables processing module.

Customizations should avoid modifying this package directly. Extensions to approval behavior are more safely implemented through workflow process customization or by wrapping the documented procedures. Because it writes directly to FUN_NET_BATCHES_ALL status columns, any custom invocation must ensure the batch is in a state consistent with the intended status transition, and must be executed within the correct operating unit context.