Results for “iex_writeoffs_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IEX_WRITEOFFS_PVT is an internal, private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Advanced Collections (IEX) product family and provides the low-level data-manipulation layer that governs write-off records used during collections and receivables reconciliation. A write-off in this context represents the formal removal of an unrecoverable or immaterial receivable balance from a customer account. The package encapsulates the create, update, and delete operations against the underlying write-off entities, allowing higher-level public APIs and collection objects to persist, adjust, or reverse write-off activity without issuing direct DML against the base tables.

Because the package is classified as a PVT (private) API, it is not intended for direct invocation by external applications or customer extensions. Rather, it exposes reusable program units consumed internally by other Oracle Collections packages and objects. The ETRM 12.2.2 metadata confirms that the package is VALID and references FND_API (the standard Oracle Application Object Library API utility package) as well as the SYS.STANDARD package, indicating that it follows Oracle's established API design conventions and raises standard PL/SQL exceptions where appropriate.

Key Procedures and Functions

The documented package interface contains three procedures:

• CREATE_WRITEOFFS — Inserts a new write-off record, establishing the link between the customer account, transaction, and the write-off amount being removed from the collections ledger. It is the primary entry point for generating original write-off activity.
• UPDATE_WRITEOFFS — Modifies an existing write-off record. This supports adjustments to amounts, statuses, or other attributes when a previously recorded write-off must be corrected without being fully reversed.
• DELETE_WRITEOFFS — Removes a write-off record. Deletion is typically used for reversal or cleanup scenarios, such as when a write-off was created in error or subsequently reinstated.

As private API members, these units are designed to be called by the public wrapper packages rather than by end users. No parameter lists are published in the ETRM metadata, and callers should not assume a signature.

Tables Accessed

The package operates against two base tables through APPS synonyms:

• IEX_WRITEOFFS — The primary write-off entity table, holding the transactional write-off records created, updated, and deleted by the three procedures.
• IEX_WRITEOFFS_S — The sequence (or secondary) table used to generate primary keys for new write-off records during CREATE_WRITEOFFS.
• DUAL — The standard Oracle dummy table, commonly used for sequence queries and simple-value retrieval.

These tables are the persistent backing store for write-off data consumed by the higher-level Collections APIs.

Usage Notes

IEX_WRITEOFFS_PVT is referenced by two other packages: IEX_API_RECORDS_PVT and IEX_WRITEOFFOBJ_PUB, both of which are themselves PVT/PUB members of the Collections API stack. This dependency pattern confirms that the package is invoked indirectly — public collection objects and record APIs call IEX_WRITEOFFS_PVT to perform the actual persistence work. It is typically triggered from Oracle Advanced Collections forms, concurrent programs, or other Collections workflows that process write-off transactions, rather than from standalone custom code. Developers extending Collections should call the public APIs (for example, IEX_WRITEOFFOBJ_PUB) instead of this private package, because Oracle does not guarantee the signature or behavior of PVT APIs across patches or releases.