Results for “receipt_register”
23 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ARRX_C_RC is an Oracle Receivables report driver package that belongs to the Receivables Reports (ARRX) family of PL/SQL modules in Oracle E-Business Suite. It is owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling user rather than the package owner. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the programmatic entry point for several standard Receivables registers and receipt-related reports. It is classified as OTHER in the ETRM metadata, reflecting its role as a report interface rather than a public business API.
The "ext RCT Arch" search term most closely maps to the external Receipt Archive and receipt register functionality driven by this package. The package header confirms its primary purpose is the generation of the Receipt Register, with additional documented procedures for related receipt and transaction registers.
Key Procedures and Functions
Four documented procedures are exposed by ARRX_C_RC:
- RECEIPT_REGISTER — The most fully documented procedure. Its parameter list consists almost entirely of standard concurrent program arguments that define the reporting level, reporting entity, set of books, chart of accounts identifier, and low/high ranges for company segment, GL date, currency, batch name, customer name, deposit date, receipt status, receipt number, receipt date, bank account name, payment method, confirmed flag, and document sequence name and numbers. Two trailing parameters provide a debug flag and an SQL trace flag. This procedure produces the Receipt Register output.
- ACTUAL_RECEIPT — Supports receipt-level reporting, generating detail on actual receipt records as captured in Receivables.
- AR_APPL_REC_REGISTER — Drives the Applied Receipts Register, which lists receipt application activity against transactions.
- AR_MISC_TRX_REGISTER — Drives the Miscellaneous Transactions Register, reporting miscellaneous receipt and transaction activity.
All procedures follow the standard concurrent program signature pattern, returning errbuf and retcode to the concurrent manager.
Tables Accessed
The documented table reference for this package is AR_SYSTEM_PARAMETERS_ALL, accessed via its APPS synonym. This table stores Receivables system-level setup options, including accounting and reporting defaults, and is read by ARRX_C_RC to resolve the operating context for report execution. The procedures themselves draw on the broader Receivables reporting schema, but only AR_SYSTEM_PARAMETERS_ALL is formally documented in the ETRM metadata.
Usage Notes
ARRX_C_RC is typically invoked as the underlying program unit for seeded Receivables concurrent programs rather than called directly. The RECEIPT_REGISTER procedure corresponds to the standard Receipt Register report submitted from the Submit Requests window or the Receipts workbench. Because the package is defined with AUTHID CURRENT_USER, any custom wrapper or concurrent program definition must ensure the invoking user has the necessary Receivables and general ledger privileges. The package is not referenced by any other documented package, confirming it sits at the top of the call stack for its reports. Customizations should follow Oracle's documented concurrent program parameter conventions and avoid modifying the seeded package, using a custom copy where changes are required.
-
PACKAGE: APPS.ARRX_C_RC 12.1.1
-
PACKAGE BODY: APPS.ARRX_C_RC 12.1.1
-
PACKAGE: APPS.ARRX_C_RC 12.2.2
-
PACKAGE BODY: APPS.ARRX_C_RC 12.2.2
-
View: JAI_PO_OSPM_AEL_V 12.2.2
Base view of OSP manually entered
APPS.JAI_PO_OSPM_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
View: JAI_PO_OSP_DISP_AEL_V 12.2.2
Base view of OSP
APPS.JAI_PO_OSP_DISP_AEL_V·↳ AP_SUPPLIER_SITES_ALL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_IMPORT_REFERENCES·Explore JA module →
-
VIEW: APPS.JAI_PO_OSPM_AEL_V 12.2.2
-
VIEW: APPS.JAI_PO_OSPM_AEL_V 12.2.2
-
APPS.JAI_PO_OSP_DISP_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
APPS.JAI_PO_OSP_DISP_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSP_DISP_AEL_V·Explore JA module →
-
View: JAI_PO_OSPM_AEL_GL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
View: JAI_PO_OSPM_AEL_SL_V 12.2.2
APPS.JAI_PO_OSPM_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_PO_OSPM_AEL_V·Explore JA module →
-
PACKAGE BODY: APPS.ARRX_C_RC 12.1.1
-
PACKAGE BODY: APPS.ARRX_C_RC 12.2.2
-
PACKAGE: APPS.ARRX_C_RC 12.1.1
-
PACKAGE: APPS.ARRX_C_RC 12.2.2
-
eTRM - JA Tables and Views 12.2.2
The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines.