Search Results cf_data_not_foundformula

Overview

APPS.AR_ARXSOC2_XMLP_PKG is a report-support PL/SQL package associated with an Oracle Receivables XML Publisher (XMLP) concurrent program in Oracle E-Business Suite. Its header comment identifies the source file as ARXSOC2S.pls, and the package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema (typically APPS). The naming convention and parameter signatures indicate that the package drives a Receivables cash receipt / bank account summary report, providing the PL/SQL side of the report logic — global variables, summary accumulators, formatting formulas, and report-level trigger logic — that the XML Publisher template consumes at runtime. Its 37 documented routines place it in the class of report definition packages (commonly referred to as "OTHER" API classification), not in the class of public, callable business APIs.

Key Procedures and Functions

The package exposes report structure triggers, formula functions, and helper procedures:

• BEFOREREPORT and AFTERREPORT — report-level triggers that initialize and finalize report execution state, including concurrent request context.
• REPORT_NAMEFORMULA — derives the report name from the company name for display in the report header.
• C_DIFFERENCE_AMOUNTFORMULA and CA_DIFFERENCE_AMOUNTFORMULA — the routines most relevant to the search term "ca_difference_amountformula". Both compute a difference between a receipt control amount and an actual amount; the "CA" variant operates on the second currency grouping columns of the report, while the "C" variant handles the first.
• C_SUMMARY_LABELFORMULA and CA_SUMMARY_LABELFORMULA — build the summary label text for each currency grouping.
• CF_DATA_NOT_FOUNDFORMULA, CR_DATA_FOUNDFORMULA, CM_DATA_NOT_FOUNDFORMULA — conditional formatting logic that determines whether the report should display "no data found" style output for the cash, cash receipts, and miscellaneous sections respectively.
• C_UNAPPLIED_AMOUNTFORMULA and CA_UNAPPLIED_AMOUNTFORMULA — compute unapplied receipt amounts per currency grouping.
• F_AMOUNTSFORMULA and F_ALL_AMOUNTSFORMULA — aggregate or format the receipt amounts displayed in the report body.
• ORDER_BY_MEANINGFORMULA — translates the ORDER_BY parameter into a human-readable sort description (the RP_ORDER_BY column).
• AFTERPFORM — post-formula processing trigger.
• P_ACTUAL_AMOUNT_P, P_UNIDENTIFIED_AMOUNT_P, P_MISC_AMOUNT_P, P_NSF_AMOUNT_P — helper procedures that populate the summary accumulators (actual, unidentified, miscellaneous, and non-sufficient-funds amounts) that back the report totals.

Tables Accessed

The package reads data through APPS synonyms:

• AR_CASH_RECEIPTS — the primary source of receipt control amounts used in the difference and summary calculations.
• AR_RECEIVABLE_APPLICATIONS — supplies applied and unapplied amounts that determine the applied/unapplied counts and the unapplied amount formulas.
• CE_BANK_ACCOUNTS — provides bank account name and identifier values used for the bank account range parameters and reporting.
• FND_CONCURRENT_REQUESTS — links the report output to the concurrent request record, supporting request ID handling and report metadata.
• DUAL — used for scalar computations and simple formula evaluation.

Usage Notes

AR_ARXSOC2_XMLP_PKG is invoked indirectly. It is called by the Oracle Receivables XML Publisher concurrent program associated with the ARXSOC2 report when the report is submitted from the Receivables responsibility or through the standard concurrent manager. The package is not intended for direct invocation from forms or custom code; the ETRM metadata records zero other packages referencing it. Customization should be limited to the XML Publisher template or to parameter values passed through the concurrent program definition, since modifying the package body would invalidate Oracle's support for the seeded report. The documented parameter variables (P_DATE_LOW, P_DATE_HIGH, P_BANK_ACCOUNT_NAME_LOW, P_BANK_ACCOUNT_NAME_HIGH, P_SET_OF_BOOKS_ID, P_ORDER_BY, and P_CONC_REQUEST_ID) reflect the report's standard concurrent program parameter set.