Search Results update_cc_lineh
Overview
OKS_CCMIGRATE_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the migration of credit card data into the Oracle E-Business Suite payment instrument and credit card infrastructure. Its name follows the EBS convention for "Service Contracts" (OKS prefix) combined with the credit card migration role of the package (CCMIGRATE). The package is declared AUTHID CURRENT_USER, meaning that its unqualified references to database objects are resolved with the privileges of the calling user rather than the package owner, which is consistent with a utility or batch-oriented migration program executed under controlled privilege sets.
The package operates during data conversion and upgrade scenarios in Release 12.1.1 and 12.2.2, where legacy credit card records must be transformed and loaded into the IBY (payments) and HZ (trading community) schemas while remaining accessible through the service contracts and order capture flows. Header banner information indicates that the package has been stable since at least 2005 and is explicitly designated noship, confirming it is a non-shipped, migration-only utility rather than a supported runtime API.
Key Procedures and Functions
The ETRM metadata documents twelve procedures and functions. The migration entry point is MIGRATE_CC, which drives the overall credit card migration and accepts batch and sub-request control parameters. It delegates work to four stage-specific routines: MIGRATE_CC_HDR and MIGRATE_CC_LINE for current header and line records, and MIGRATE_CC_HDRH and MIGRATE_CC_LINEH for their historical counterparts. Each of these accepts low and high identifier bounds together with a batch size, enabling chunked processing of large data volumes.
Post-migration correction routines include UPDATE_CC_HEADER, UPDATE_CC_HEADERH, UPDATE_CC_HEADER_RULE, UPDATE_CC_LINE, and UPDATE_CC_LINEH. These refresh or reconcile header and line attributes, including associated rule data, after the initial load. PURGE_CC_NUMBER removes migrated credit card number artifacts in batch, and GENERATE_REPORT produces an output report, returning status through the standard ERRBUF and RETCODE concurrent program parameters. The user search term "update_cc_header" corresponds to the documented UPDATE_CC_HEADER and UPDATE_CC_HEADERH procedures.
Tables Accessed
The package reads and writes across the HZ trading community model, including HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, and HZ_PARTIES, to align migrated card records with the correct customer accounts, sites, and parties. The payment instrument tables IBY_CREDITCARD, IBY_INSTR_S, IBY_PMT_INSTR_USES_ALL, IBY_PMT_INSTR_USES_ALL_S, and IBY_SECURITY_SEGMENTS hold the actual instrument, usage, and security segment data created during migration.
Issuer and range validation relies on IBY_CC_ISSUER_RANGES, while external payer integration uses IBY_EXTERNAL_PAYERS_ALL, IBY_EXTERNAL_PAYERS_ALL_S, IBY_FNDCPT_TX_EXTENSIONS, and IBY_FNDCPT_TX_EXTENSIONS_S.
Usage Notes
Because OKS_CCMIGRATE_PVT is a PVT-classified package with no documented dependents, it is not intended for direct customer invocation. It is typically executed through concurrent programs or internal migration scripts during upgrade and conversion projects, or from controlled custom code that calls the procedures with explicit identifier ranges and batch sizes. Customers should not modify the package and should instead target supported public APIs for ongoing credit card maintenance. Always validate results in a test instance before running in production.