OKS — Service Contracts
80 documented tables · 134 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
OKS_ITEM_SPLIT |
Used to Store the details of the Item before and after split | satellite-leaning |
OKS_BILL_CONT_LINES |
Records which are sent to AR. | hub-leaning |
OKS_BILL_SUB_LINES |
Related to a lower level contract line eg. coverage level or product. | hub-leaning |
OKS_BILL_TRANSACTIONS |
The transaction (invoice, credit etc.) which is eventually received from AR. | hub-leaning |
OKS_SUBSCR_HEADER_B |
Used for Subcription Header Information | satellite-leaning |
OKS_BTN_PR |
The transaction (invoice, credit etc.) which is eventually received from AR. | hub-leaning |
OKS_BCL_PR |
Records which are sent to AR. | satellite-leaning |
OKS_BSL_PR |
Related to a lower level contract line eg. coverage level or product. | hub-leaning |
OKS_K_ORDER_DETAILS |
This table captures service contract details when a service is ordered in Order Management. | satellite-leaning |
OKS_TEMPLATE_SET |
Stores the template set information. | hub-leaning |
OKS_BILL_SUB_LINE_DTLS |
The detail of quantities and monetary amounts either regular or adjustment. | satellite-leaning |
OKS_BSD_PR |
The detail of quantities and monetary amounts either regular or adjustment. | satellite-leaning |
OKS_SERV_AVAILS |
Stores availability information for a service. | satellite-leaning |
OKS_INSTANCE_HISTORY |
standalone | |
OKS_MSCHG_OPERATIONS_DTLS |
This table stores masschage related information. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
OKS_ENTITLEMENTS_PUB |
PUB | 22 | 28 packages |
OKS_RENEW_UTIL_PUB |
PUB | 9 | 19 packages |
OKS_TIME_MEASURES_PUB |
PUB | 11 | 17 packages |
OKS_IBINT_PUB |
PUB | 10 | 16 packages |
OKS_BILL_UTIL_PUB |
PUB | 29 | 15 packages |
OKS_CONTRACT_LINE_PUB |
PUB | 18 | 14 packages |
OKS_CONTRACT_HDR_PUB |
PUB | 23 | 13 packages |
OKS_OMINT_PUB |
PUB | 11 | 12 packages |
OKS_COVERAGES_PUB |
PUB | 13 | 11 packages |
OKS_SALES_CREDIT_PUB |
PUB | 10 | 10 packages |