Search Results bill_upgradation_all_om
Overview
The APPS.OKS_BILL_MIGRATION package is a technical utility within the Oracle E-Business Suite Service Contracts (OKS) module. Its principal role is to migrate, upgrade, and regenerate billing detail records for service contracts when contract structures change or when legacy billing data must be reconciled with the current Service Contracts data model. It is fundamentally a data-transformation package: it reconstructs bill lines, billing schedules, and level elements associated with covered lines so that downstream billing and invoicing processes operate on consistent data.
In the 12.1.1 and 12.2.2 releases, this package is classified as an OTHER API — that is, it is not a public, customer-facing API, but an internal migration utility invoked by Oracle-supplied upgrade, patch, or backfill logic. It sits alongside contract entities such as billing sub-lines, contract lines, rules, and rule groups, and it manipulates these structures to align historical billing records with the current contract hierarchy.
Key Procedures and Functions
The documented interface exposes thirteen procedures and functions. Their purposes are as follows:
- BILL_UPGRADATION, BILL_UPGRADATION_OM, BILL_UPGRADATION_ALL, BILL_UPGRADATION_ALL_OM — Core upgrade drivers that migrate billing data across contract versions. The _ALL variants process the full contract population, while the _OM variants extend the logic to order-management-originated contracts.
- CREATE_BILL_DTLS, CREATE_BILL_DTLS_FOR_ORDER — Construct billing detail rows, either generically or specifically from order data, populating the billing sub-line structures used for invoice generation.
- CREATE_BILLING_SCHD — Generates the billing schedule associated with a contract or covered line.
- CREATE_TIMEVALUE — Derives and inserts time-based values required by billing and level-elements logic.
- UPDATE_LVL_ELEMENTS, UPDATE_OKS_LEVEL_ELEMENTS — Synchronise and refresh level-element records that drive pricing, discounting, and entitlement structures on contract lines.
- UPDATE_LINE_NUMBERS, MIGRATE_LINE_NUMBERS — Renumber and resequence contract billing line identifiers during migration.
- MIGRATE_CURRENCY — Converts billing tuples to a target currency as part of contract currency migration.
Parameter lists are intentionally omitted; invoke only through Oracle-supplied wrappers.
Tables Accessed
The package reads and writes a defined set of Service Contracts tables via APPS synonyms:
- OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES — The contract billing line and sub-line tables that store billable detail generated by the migration routines.
- OKS_LEVEL_ELEMENTS, OKS_STREAM_LEVELS_B — Level-element and stream definitions supporting entitlement and pricing structures that the UPDATE procedures reconcile.
- OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_REL_OBJS — Core contract header, line, and relationship objects that anchor the contract hierarchy.
- OKC_RULES_B, OKC_RULE_GROUPS_B, OKC_STATUSES_B — Contract rules, rule groups, and statuses used to derive correct billing behaviour.
- PLITBLM, DBMS_JOB, DBMS_LOCK, DBMS_TRANSACTION, USER_JOBS — Utility and concurrency infrastructure for batch processing and job scheduling.
The package also references OKC_API for contract creation and update operations.
Usage Notes
OKS_BILL_MIGRATION is not documented for direct customer invocation and is not referenced by any other application package. It is typically executed as part of Oracle-supplied patch drivers, upgrade scripts, or backfill concurrent programs when billing data must be regenerated after structural changes. Custom code should avoid calling these routines directly; reliance on an unversioned internal API risks incompatibility during upgrades. Where migration behaviour is required, the recommended approach is to invoke the standard Service Contracts public APIs and allow Oracle to manage the internal migration path.