Search Results get_failure_summary

Overview

IBY_DBCCARD_PVT is a private PL/SQL package in the Oracle Payments (IBY) application, created with AUTHID CURRENT_USER and owned by the APPS schema. Its header identifies it as the "ibyvdbcs.pls" module (version 120.2). The package provides the server-side logic supporting debit, credit, and procurement card instrument registration and processing within Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the data structures and utility routines required to summarize payment card transaction activity and convert monetary amounts for reporting and inquiry purposes.

The package defines several constants that characterize its domain: instrument types CREDITCARD and PURCHASECARD, summary periods DAILY, WEEKLY, and MONTHLY, and status codes SUCCESS, FAILED, PENDING, and UNKNOWN. It also declares record types such as Summary_rec_type, TrxnSum_rec_type, and TrxnFail_rec_type, together with the corresponding table types, to carry transaction summary rows between the package APIs and calling code.

Key Procedures and Functions

The documented public interface comprises six procedures and functions, several of which are directly relevant to the "get_processor_summary" search term:

• GET_PROCESSOR_SUMMARY — Returns summarized transaction activity grouped by payment processor. It allows the caller to retrieve aggregate counts and amounts for a given processor within a selected period, supporting reconciliation and monitoring of card processing performance.
• GET_TRXN_SUMMARY — Produces an overall transaction summary for the specified criteria, using the Summary_rec_type structure to report total transaction counts and amounts.
• GET_FAILURE_SUMMARY — Aggregates failed transactions, returning status, cause, count, and amount per the TrxnFail_rec_type definition, so that rejection reasons can be analyzed.
• GET_CARDTYPE_SUMMARY — Summarizes activity by card instrument type, distinguishing CREDITCARD and PURCHASECARD volumes.
• GET_RISK_SUMMARY — Returns summary information relevant to risk evaluation of card transactions.
• CONVERT_AMOUNT — Converts a monetary amount between currencies. A header comment (Bug 3714173) records that the target currency constant C_TO_CURRENCY is now obtained from a profile option rather than a hard-coded value, reflecting the fix for that bug.

Tables Accessed

The package operates against several application tables, accessed through APPS synonyms:

• IBY_BEPINFO — Holds payment system and processor configuration; it provides the processor context for GET_PROCESSOR_SUMMARY.
• IBY_PAYEE — Stores payee information used to scope summaries and payee-level reporting.
• IBY_TRXN_SUMMARIES_ALL — The principal transaction summary table, supplying the aggregated counts and amounts returned by the summary APIs.
• PLITBLM — A standard EBS PL/SQL table used as a temporary workspace for tabular data during processing.

Usage Notes

IBY_DBCCARD_PVT is a private (PVT) package and is not intended for direct customer invocation; it is called internally by Oracle Payments forms, concurrent programs, and by other IBY packages. The metadata records that three other packages reference it. Custom code should prefer the public IBY APIs, but where direct calls are necessary, they must supply the package's record and table types. Typical invocation points include card transaction inquiry forms, summary reporting concurrent programs, and reconciliation processes that require processor-, card-type-, or failure-level aggregation over daily, weekly, or monthly periods.