Search Results migrate_primary_cc

Overview

IBE_PAYMENT_INT_PVT is an internal (private) PL/SQL package owned by APPS and shipped as part of the Oracle iStore (IBE) payment integration layer in Oracle E-Business Suite 12.1.1 and 12.2.2. The package is declared with AUTHID CURRENT_USER and, as indicated by the "_PVT" suffix and its header comment block, is intended strictly for internal use by other iStore components rather than as a public, supported API. Its core business function is to manage the storage and migration of payment instrument data — most notably credit card information used during checkout — and to bridge legacy iStore checkout/payment setup structures with the Oracle Payments (IBY) instrument model during upgrades and data conversions. The presence of the migration procedures reflects its role as an upgrade and one-time data-conversion utility that realigns stored iStore credit card data into the IBY payment instrument tables following the consolidation of payment processing into the Oracle Payments framework.

Key Procedures and Functions

• SAVE_CREDIT_CARD — Persists a credit card for a party and customer, taking card number, holder name, expiration date, card type, currency, assignment, and optional statement address information, and returning generated credit card and assignment identifiers together with the standard API return status and message outputs.
• CHECK_PAYMENT_CHANNEL_SETUPS — Verifies configuration prerequisites for payment channels, returning flags that indicate whether CVV2 setup and statement-address setup are enabled, along with standard return status and message outputs.
• PRINT_DEBUG_LOG — Writes a diagnostic string to the debug output, used for troubleshooting migration and checkout execution.
• MIG_EXP_CHECKOUT_PAY_SETUP — A concurrent-program style procedure (errbuf/retcode signature) that migrates express checkout payment setup data, accepting a debug flag and a commit size to control batching.
• MIGRATE_PRIMARY_CC — The procedure matching the user search term "migrate_primary_cc." It migrates primary credit card data, again using the standard concurrent-program errbuf/retcode parameters plus debug and commit-size controls.
• MIGRATE_IBE_CC_DATA — Migrates iStore credit card data, driven by a cutoff date parameter and returning errbuf/retcode, allowing incremental conversion of records up to a specified point in time.

Tables Accessed

The package references the following objects through APPS synonyms. HZ_PARTY_SITES and the party-related references support statement and billing address resolution. IBY_EXTERNAL_PAYERS_ALL, IBY_EXTERNAL_PAYERS_ALL_S, IBY_PMT_INSTR_USES_ALL, and IBY_UPG_INSTRUMENTS form the Oracle Payments instrument and payer model into which credit card data is written or migrated. IBE_ORD_ONECLICK and IBE_ORD_ONECLICK_ALL store iStore one-click/express checkout setup, read during the express setup migration. FND_USER and FND_USER_PREFERENCES identify the operating user and their stored preferences. DUAL is used for singleton computations and setup probes.

Usage Notes

Because the package is classified as PVT, it should not be called directly from custom code unless fully understood, as its signature and behavior are subject to change without notice. In practice it is invoked indirectly: SAVE_CREDIT_CARD and CHECK_PAYMENT_CHANNEL_SETUPS are called by iStore checkout and payment flows, while MIG_EXP_CHECKOUT_PAY_SETUP, MIGRATE_PRIMARY_CC, and MIGRATE_IBE_CC_DATA follow the concurrent-program errbuf/retcode convention and are driven by registered concurrent programs or one-time upgrade scripts during the migration to Oracle Payments. PRINT_DEBUG_LOG supports diagnostic runs. The documented package is referenced by two other packages, confirming its role as a private dependency within the iStore payment stack.