Search Results unhold_br

Overview

AR_BILLS_MAINTAIN_PUB is a public PL/SQL API package in the APPS schema that serves as the central maintenance interface for Oracle Receivables bills receivable (BR). Bills receivable are customer drafts and promissory notes that a receivable organization manages through a formal lifecycle—from creation and acceptance, through remittance and endorsement, to maturation, protest, or cancellation. This package encapsulates the business logic that governs that lifecycle so that internal concurrent programs, forms, and external integrations do not need to manipulate the underlying transaction tables directly.

The package is classified as a public (PUB) API, indicating it is intended for supported external invocation. Its dependency footprint confirms this role: it reads and writes core Receivables transaction tables while relying on FND_API for the standard EBS API error-handling and message conventions. It is referenced by six other packages, including ARP_PROCESS_BR_REMIT, ARP_PROGRAM_BR_REMIT, ARP_PROGRAM_GENERATE_BR, and AR_BR_REMIT_IMPORT_API_PUB, which demonstrates that the bill lifecycle operations are reused across concurrent processing, remittance import, and cancellation logic.

Key Procedures and Functions

The package exposes nineteen documented procedures that map to distinct bill lifecycle events:

• COMPLETE_BR and UNCOMPLETE_BR — transition a bill into or out of the completed state, marking the bill as finalized and available for subsequent processing.
• ACCEPT_BR — records acceptance of the bill, typically by the drawee or paying party, advancing the instrument toward maturity.
• HOLD_BR and UNHOLD_BR — place or release a processing hold that suspends further lifecycle actions on the bill.
• SELECT_BR_REMIT and DESELECT_BR_REMIT — add or remove a bill from a remittance batch before the remittance is executed.
• CANCEL_BR_REMIT — reverses a remittance selection or unexecuted remittance involving the bill.
• APPROVE_BR_REMIT — approves a pending remittance, authorizing submission to the remittance bank.
• CANCEL_BR — cancels the bill entirely, reversing its associated accounting and application effects.
• UNPAID_BR — records a maturity event in which the bill was not honored, updating the bill's status accordingly.
• ENDORSE_BR — endorses the bill to a third party, transferring rights and recording the endorsement.
• PROTEST_BR — records a formal protest after non-payment, a legal step in the bill collection process.
• RESTATE_BR — restates the bill, adjusting its recorded amounts or terms.
• RECALL_BR — recalls a previously remitted or endorsed bill back into the organization's control.
• ELIMINATE_RISK_BR and UNELIMINATE_RISK_BR — mark or unmark the bill as having eliminated risk, which affects reserves and factoring accounting.
• EXCHANGE_BR — replaces the bill with a new instrument, carrying forward relevant terms.
• REVISION — applies a revision to the bill, generating the appropriate reversal and rebooking entries.

All procedures follow the standard EBS API contract, returning status and message information through FND_API conventions rather than exceptions, and they are safe to invoke from concurrent programs and PL/SQL integrations.

Tables Accessed

The package reads and writes through APPS synonyms for the core Receivables tables that support bills receivable:

• AR_BATCHES — stores batch header information for remittance and bill batches; used during select, remit, and cancel operations.
• AR_PAYMENT_SCHEDULES — holds the bill's payment schedule, status, and accounting distribution rows; central to acceptance, maturity, and protest processing.
• AR_ADJUSTMENTS — records adjustments such as risk elimination and restatement entries.
• AR_CASH_RECEIPTS — captures receipt activity generated when a bill is remitted, honored, or applied to a customer account.
• AR_RECEIVABLE_APPLICATIONS — links the bill to the transactions or receipts it settles, particularly during remittance, cancellation, and exchange.
• AR_TRANSACTION_HISTORY — maintains the audit trail of transactions and status changes affecting the bill.
• RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — store the invoice or credit memo header and line information when the bill is created, revised, or exchanged as a transaction.

Usage Notes

AR_BILLS_MAINTAIN_PUB is invoked primarily from the Bills Receivable remittance and generation concurrent programs, most notably ARP_PROGRAM_BR_REMIT, ARP_PROCESS_BR_REMIT, and ARP_PROGRAM_GENERATE_BR, and from the remittance import API AR_BR_REMIT_IMPORT_API_PUB. It is also called by AR_BR_CANCEL_UNPAID_API_PUB, meaning bill cancellation and unpaid processing reuse the same lifecycle procedures.

Custom integrations and extensions should always call these procedures rather than updating the underlying tables directly, because the package enforces validation rules, derives status transitions, and writes the required Receivables accounting and history records. When invoking the API from custom code or workflow, callers should check the returned API status and message before committing, and should treat each procedure as a unit of work scoped to a single bill. The same interface is valid on both Oracle EBS 12.1.1 and 12.2.2, since the package resides in the APPS schema and is shared across the online patching editions of the application.