Search Results iby_instr_s

Overview

OKS_CCMIGRATE_PVT is a private PL/SQL package in the APPS schema that supports the migration and maintenance of credit card data within Oracle E-Business Suite Service Contracts (OKS) and the Oracle Payments (IBY) instrument model. Its central purpose is to move credit card information from legacy Service Contracts tables into the standardized payment instrument structures introduced by Oracle Payments, and to maintain the linkage between contract headers, contract lines, and the corresponding payment instruments and credit card records. The package is classified as a PVT (private) API, meaning it is not intended as a public integration interface; it is invoked internally by migration programs, correction utilities, and report generation within the Service Contracts credit card feature set.

Because credit card instruments in Release 12 are governed by the IBY payment instrument framework, this package depends heavily on IBY_INSTR_S, IBY_CREDITCARD, IBY_PMT_INSTR_USES_ALL, and IBY_CC_SECURITY_PUB, alongside Service Contracts contract structures such as OKS_K_HEADERS_B and OKS_K_LINES_B. The user search term "iby_instr_s" corresponds directly to IBY_INSTR_S, the base payment instrument table that this package references during migration.

Key Procedures and Functions

The package documents twelve procedures and functions:

• GENERATE_REPORT – Produces the migration output report, writing to the concurrent manager file handles via FND_FILE.
• MIGRATE_CC – The primary driver procedure that orchestrates the overall credit card migration process.
• MIGRATE_CC_HDR – Migrates credit card header-level information for contract headers.
• MIGRATE_CC_HDRH – Handles the history (audit) counterpart of header migration.
• MIGRATE_CC_LINE – Migrates credit card data associated with contract lines.
• MIGRATE_CC_LINEH – Manages history records for migrated line-level credit card data.
• PURGE_CC_NUMBER – Removes or masks stored credit card numbers in line with security requirements.
• UPDATE_CC_HEADER – Updates credit card information at the contract header level.
• UPDATE_CC_HEADERH – Updates the historical header credit card records.
• UPDATE_CC_HEADER_RULE – Maintains the rule group association for header credit card data via OKC_RULES_B.
• UPDATE_CC_LINE – Updates line-level credit card information.
• UPDATE_CC_LINEH – Updates the historical line-level credit card records.

Tables Accessed

The package reads and writes the IBY payment instrument tables—IBY_INSTR_S (instrument master), IBY_CREDITCARD (card specifics), IBY_PMT_INSTR_USES_ALL and its _S history table, IBY_FNDCPT_TX_EXTENSIONS and its _S table, IBY_EXTERNAL_PAYERS_ALL and _S, IBY_SECURITY_SEGMENTS, and IBY_CC_ISSUER_RANGES—all of which form the credit card instrument and security model. Customer data is drawn from HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL. Contract structures come from OKC_K_HEADERS_ALL_B/BH, OKC_K_LINES_B/BH, OKC_K_ITEMS, OKC_RULES_B/BH, OKC_RULE_GROUPS_B, OKC_STATUSES_V, OKC_DATATYPES, and the OKS equivalents OKS_K_HEADERS_B/BH and OKS_K_LINES_B/BH. Error logging uses OKS_RULE_ERROR.

Usage Notes

OKS_CCMIGRATE_PVT is invoked from concurrent programs and internal Service Contracts processes rather than from public APIs—the metadata confirms it is referenced by zero external database objects. It relies on FND_REQUEST, FND_CONC_GLOBAL, FND_PROFILE, FND_GLOBAL, FND_MESSAGE, and FND_RELEASE for concurrent processing, session context, and concurrent manager file output. Typical invocation contexts are the upgrade/migration of credit card data into Oracle Payments, security maintenance routines such as card-number purging, and report generation for migration verification. Because it is a private package, customizations should call the supported public interfaces instead of calling OKS_CCMIGRATE_PVT directly, and any direct reference risks incompatibility across 12.1.1 and 12.2.2.