Service Contracts Import Scope and Limitations

Service Contracts Import Scope and Limitations

Scope:

Bulk import all types of Service contracts. Import all type of covered levels. Import contracts in different status types (Entered, Canceled, Signed, Active, Expired) Import of Sales person, Contract Administrator at the header level. Import of customer Billing contact for the lines is possible. Ability to associate a contract with only one contract group Import of sales credits for the contract header. Import of only Fully billed of Fully Unbilled contracts. Import of Standard coverage alone is possible. Instantiation of counters for imported contracts Import only Intangible Subscription contracts. Import of header Notes is possible Limitations:

Import of contracts in the status (Terminated, QA Hold) are not supported Contract versions will not be imported Contract Auto-numbering will not be supported Importing sales credits at the line level is not possible. Import of Attachments is not possible Importing Mutiple contract groups is not possible Imported contracts can have a maximum of 3 billing streams. Partially billed contracts cannot be imported The fully billed imported contracts will not have any billing details (no invoice information) Import of customized coverage is not possible. Import of Fulfillment schedules for tangible subscription is not possible. Import of manual price adjustments is not possible Tax calls will not be made. Tax information should be specified in the interface table Defaulting the attributes from the contract template is not possible Importing lines /sublines to existing service contracts is not possible. Defaulting the Contract group, QA checklist, Approval Work flow from the GCD while importing is not possible. Import of contracts with Sales Order details is not possible. Importing Service contracts with Credit cards is not possible. No flex fields will be imported Billing of new lines/Sublines added to the fully billed contract is not possible. Credit upon termination of fully billed contracts is not possible, because of the lack of billing information.

Process1. Populate interface tables. Apart from the relevant columns that contain contract information, populate a unique batch id in the batch_id column2. Run Service Contracts Import program with batch id, mode,number of workers,commit size as input.3. Run the program in Validate only mode .4. Review the output/log file which summarize the successful and failed records.5. Re-run the Program in Import Mode to get the data into the base tables6. Review the imported contract in the Authoring Form7. Run the Service Contracts import Purge Program to purge the Successful records.

Concurrent Programs:Service Contracts import Program: This program does the validation and import of the interface table data to our base tables. Parameters:Sr. No.ParameterDescriptioon

1ModeValidate only, Import

2Batch NumberBatch_id

3Number of WorkersNumber of workers required

4Commit sizeRepresents number of successfully processed contracts commited to database

Service Contracts Import Purge: This program can be run to purge the successfully processed records.

Parameters:Sr. No.ParameterDescriptioon

1Batch NumberBatch_id

2Number of WorkersNumber of workers required

3Commit sizeNumber of successfully processed contracts records

Architecture

List of Interface Tables:

OKS_HEADERS_INTERFACEThis table must be populated with all Header details,along with the batch number.Header_interface_id is the primary key to all the other interface tables.OKS_LINES_INTERFACE This table must be populated with the line details,with proper header_interface_id .Line_interface_id is the primary key.Populate the Header_interface_id from oks_headers_interface.OKS_COVERED_LEVELS_INTERFACE This table should be populated with all covered level details.covered_level_interface_id is the primary key.Populate line_interface_id from the oks_lines_interface.OKS_USAGE_COUNTERS_INTERFACE This table must be populated with the counter details. Usage_counter_interface_id is the primary key for this table.Line_interface_id must be populated from oks_lines_interface.OKS_SALES_CREDITS_INTERFACE This should be populated with the sales credit details.sales_credits_interface_id being the primary key.Header_interface_id should correspond to the oks_headers_interfaceOKS_NOTES_INTERFACE Populate this table with required notes information. Notes_interface_id is the primary key.The header_interface_id and line_interface_id should be populated corresponding to the header_interface_id of the oks_headers_interface table and line_interface_id from the oks_lines_interface.

OKS_SALE_CREITS INTERFACE

Headers_interface_id OKS_HEADERS_INTERFACE

Headers_interface_id Headers_interface_id

OKS USAGECOUNTERSINTERFACE

Line_ Line_interface_idOKS_LINES_INTERFACEOKS_NOTESINTERFACE

Interface_id

Line_interface_id

OKS_COVERED EVELS_INTERFACE

OKS_HEADERS_INTERFACEPrimary Key: OKS_HEADERS_INTERFACE_PK HEADER_INTERFACE_ID Unique Index: OKS_HEADERS_INTERFACE_U1 HEADER_INTERFACE_ID Not Unique Index: OKS_HEADER_INTERFACE_N1 BATCH_ID ColumnsNameDatatypeLengthOptionalityComment

HEADER_INTERFACE_ID NUMBER NOT NULLPrimary Key

CONTRACT_NUMBER VARCHAR2 120NOT NULLContract Number

CONTRACT_NUMBER_MODIFIER VARCHAR2 120NULLContract Number modifier

CATEGORY VARCHAR2 30NOT NULLContract Category. Possible values are SUBSCRIPTION, SERVICE or WARRANTY

START_DATE DATE NOT NULLContract start date

END_DATE DATE NOT NULLContract end date

STATUS_CODE VARCHAR2 240NOT NULLContract status code.

KNOWN_AS VARCHAR2 300NULLKnown as

DESCRIPTION VARCHAR2 1995NOT NULLContract description

OPERATING_UNIT_ID NUMBER NOT NULLOperating Unit

CUSTOMER_PARTY_NAME VARCHAR2 360NULLCustomer Party Name

CUSTOMER_PARTY_NUMBER VARCHAR2 30NULLCustomer Party

CUSTOMER_PARTY_ID NUMBER NULLCustomer Id

THIRD_PARTY_NAME VARCHAR2 360NULLThird Party Name

THIRD_PARTY_NUMBER VARCHAR2 30NULLThird Party Number

THIRD_PARTY_ID NUMBER NULLThird Party

BILL_TO_SITE_USAGE_CODE VARCHAR2 40NULLNot supported

BILL_TO_SITE_USAGE_ID NUMBER NULLBill to site usage id

SHIP_TO_SITE_USAGE_CODE VARCHAR2 40NULLNot supported

SHIP_TO_SITE_USAGE_ID NUMBER NULLShip to usage id

SALESPERSON_NAME VARCHAR2 360NULLSales Person

SALESPERSON_ID NUMBER NULLSales Person ID

SALESGROUP_ID NUMBER NULLSales Group ID

CUSTOMER_CONTRACT_ADMIN_NAME VARCHAR2 360NULLCustomer Contract administrator

CUSTOMER_CONTRACT_ADMIN_ID NUMBER NULLCustomer Contract Administrator

CONTRACT_CURRENCY_CODE VARCHAR2 15NOT NULLContract Currency code

CURRENCY_CONVERSION_TYPE VARCHAR2 30NULLCurrency Conversion Type

CURRENCY_CONVERSION_RATE NUMBER NULLCurrency Conversion Rate

CURRENCY_CONVERSION_DATE DATE NULLCurrency Conversion Date

AGREEMENT_NAME VARCHAR2 240NULLAgreement Name

AGREEMENT_ID NUMBER NULLAgreement Id

PRICE_LIST_NAME VARCHAR2 240NULLPrice List Name

PRICE_LIST_ID NUMBER NULLPrice List Id

PAYMENT_TERMS_NAME VARCHAR2 15NULLPayment Terms

PAYMENT_TERMS_ID NUMBER NULLPayment Terms Id

PAYMENT_INSTRUCTION VARCHAR2 3NULLPayment Instruction

PO_REQUIRED VARCHAR2 3NULLPo Required

PAYMENT_INSTRUCTION_DETAILS VARCHAR2 150NULLPayment Instruction Details

PAYMENT_METHOD_CODE VARCHAR2 30NULLPayment Method Code

COMMITMENT_ID NUMBER NULLCommitment ID

TAX_EXEMPTION_CONTROL VARCHAR2 30NULLTax Status

TAX_EXEMPTION_NUMBER VARCHAR2 80NULLTax Exemption Number

BILL_SERVICES VARCHAR2 1NULLAR Interface flag

BILLING_TRANSACTION_TYPE_ID NUMBER NULLInventory Transaction type.

ACCOUNTING_RULE_NAME VARCHAR2 30NULLAccounting Rule

ACCOUNTING_RULE_ID NUMBER NULLAccounting Rule ID

INVOICING_RULE_NAME VARCHAR2 30NULLInvoicing Rule

INVOICING_RULE_ID NUMBER NULLInvoicing Rule ID

HOLD_CREDITS VARCHAR2 1NULLHold credits

SUMMARY_PRINT VARCHAR2 1NULLInventory Print Profile

SUMMARY_TRANSACTIONS VARCHAR2 1NULLSummary Transaction.

SERVICE_CHRG_PREPAY_REQ VARCHAR2 1NULLService Charges Prepay Required flag

SERVICE_CHARGES_PO_REQUIRED VARCHAR2 1NULLService PO required flag

SERVICE_CHARGES_PO_NUMBER VARCHAR2 240NULLService PO Number

RENEWAL_PROCESS VARCHAR2 30NULLRenewal Type Code

APPROVAL_REQUIRED VARCHAR2 30NULLApproval Type

RENEW_UP_TO DATE NULLRenew up to date

PRICING_METHOD VARCHAR2 30NULLRenewal Pricing Method

RENEWAL_PRICE_LIST_NAME VARCHAR2 240NULLRenewal Price List Name

RENEWAL_PRICE_LIST_ID NUMBER NULLRenewal Price List ID

RENEWAL_MARKUP NUMBER NULLMarkup %

RENEWAL_BILLING_PROFILE_ID NUMBER NULLBilling Profile ID

RENEWAL_PO_NUMBER VARCHAR2 240NULLRenewal PO Number

RENEWAL_PO_REQUIRED VARCHAR2 1NULLRenewal PO Required flag

RENEWAL_GRACE_DURATION NUMBER NULLRenewal grace duration

RENEWAL_GRACE_PERIOD VARCHAR2 30NULLRenewal Grace Period

RENEWAL_ESTIMATED_PERCENT NUMBER NULLRenewal Estimated Percent

RENEWAL_ESTIMATED_DURATION NUMBER NULLRenewal Estimated Duration

RENEWAL_ESTIMATED_PERIOD VARCHAR2 30NULLRenewal Estimated Period

QUOTE_TO_PARTY_SITE NUMBER NULLQuote to party site id

QUOTE_TO_CONTACT NUMBER NULLQuote To Contact

QUOTE_TO_PHONE NUMBER NULLQuote To Phone Number

QUOTE_TO_FAX NUMBER NULLQuote To Fax number

QUOTE_TO_EMAIL NUMBER NULLQuote To Email

DATE_APPROVED DATE NULLApproval Date

DATE_SIGNED DATE NULLSigned Date

DATE_CANCELED DATE NULLCanceled date

CANCELLATION_REASON VARCHAR2 30NULLCancellation Reason Code

GRACE_DURATION NUMBER NULLGrace Duration

GRACE_PERIOD VARCHAR2 30NULLGrace Period

ESTIMATION_PERCENT NUMBER NULLEstimated Percent

ESTIMATION_DATE DATE NULLEstimation Date

FOLLOW_UP_DUE_DATE DATE NULLFollow up due date

FOLLOW_UP_ACTION VARCHAR2 30NULLFollow up action

QA_CHECKLIST NUMBER NULLQA Checklist

CONTRACT_GROUP_NAME VARCHAR2 150NULLContract group name

CONTRACT_GROUP_ID NUMBER NULLContract Group

APPROVAL_PROCESS_ID NUMBER NULLApproval process used

FULLY_BILLED VARCHAR2 1NOT NULLFully Billed

SOURCE VARCHAR2 80NULLSource

DOCUMENT VARCHAR2 240NULLDocument

INTERFACE_STATUS VARCHAR2 1NULLE=Error, S=Success, R=Reprocess

INV_ORGANIZATION_ID NUMBER NULLInventory Organization Id

EXEMPT_REASON_CODE VARCHAR2 30NULLExempt Reason Code

BATCH_ID NUMBER NOT NULLBatch Number

PARENT_REQUEST_ID NUMBER NULLRequest Id to be stamped by the import process

OKS_LINES_INTERFACE:Primary Key: OKS_LINES_INTERFACE_PK LINE_INTERFACE_ID Unique Index: OKS_LINES_INTERFACE_U1 LINE_INTERFACE_ID Not Unique Index: OKS_LINES_INTERFACE_N1 HEADER_INTERFACE_ID ColumnsNameDatatypeLengthOptionalityComment

LINE_INTERFACE_ID NUMBER NOT NULLPrimary Key

HEADER_INTERFACE_ID NUMBER NOT NULLHeader Interface ID

LINE_NUMBER NUMBER NULLLine Number

LINE_TYPE VARCHAR2 25NOT NULLLine Type

ITEM_ORGANIZATION_ID NUMBER NULLItem Organization

ITEM_NAME VARCHAR2 800NULLItem Name

ITEM_ID NUMBER NULLItem Id

REFERENCE_TEMPLATE_ID NUMBER NULLCoverage ID

LINE_REFERENCE VARCHAR2 300NULLLine Reference

STATUS_CODE VARCHAR2 30NULLStatus

START_DATE DATE NULLLine start date

END_DATE DATE NULLLine end date

BILL_TO_SITE_USAGE_CODE VARCHAR2 40NULLBill to site usage code

BILL_TO_SITE_USAGE_ID NUMBER NULLBill to site usage id

SHIP_TO_SITE_USAGE_CODE VARCHAR2 40NULLShip to site usage code

SHIP_TO_SITE_USAGE_ID NUMBER NULLShip to site usage id

BILLING_CONTACT_NAME VARCHAR2 360NULLBilling contact name

BILLING_CONTACT_ID NUMBER NULLBilling contact id

SHIPPING_CONTACT_NAME VARCHAR2 360NULLShipping Contact Name

SHIPPING_CONTACT_ID NUMBER NULLShipping Contact Id

RENEWAL_TYPE_CODE VARCHAR2 30NULLRenewal Type Code

CANCELLATION_DATE DATE NULLCancellation Date

CANCELLATION_REASON VARCHAR2 30NULLCancellation Reason

PRICE_LIST_NAME VARCHAR2 240NULLPrice List Name

PRICE_LIST_ID NUMBER NULLPrice List Id

INVOICE_TEXT VARCHAR2 2000NULLInvoice Text

PRINT_INVOICE VARCHAR2 1NULLPrint Invoice

SUBTOTAL NUMBER NULLSubtotal to be populated for Subsciption lines

TAX_AMOUNT NUMBER NULLTax Amount to be populated for Subsciption lines

TAX_EXEMPTION_CONTROL VARCHAR2 30NULLTax Exemption Control

TAX_EXEMPTION_NUMBER VARCHAR2 80NULLTax Exemption Number

TAX_CLASSIFICATION_CODE VARCHAR2 30NULLTax Classification Code

PAYMENT_INSTRUCTION VARCHAR2 3NULLPayment Instruction

PO_REQUIRED VARCHAR2 3NULLPo Required

PAYMENT_INSTRUCTION_DETAILS VARCHAR2 150NULLPayment Instruction Details

PAYMENT_METHOD_CODE VARCHAR2 30NULLPayment Method Code

COMMITMENT_ID NUMBER NULLCommitment Id

ACCOUNTING_RULE_NAME VARCHAR2 30NULLAccounting Rule

ACCOUNTING_RULE_ID NUMBER NULLAccounting Rule Id

INVOICING_RULE_NAME VARCHAR2 30NULLInvoicing Rule Name

INVOICING_RULE_ID NUMBER NULLInvoicing Rule Id

BILLING_INTERVAL_DURATION NUMBER NULLBilling Interval Duration

BILLING_INTERVAL_PERIOD VARCHAR2 30NULLBilling Interval Period

FIRST_BILL_UPTO_DATE DATE NULLFirst Bill Upto Date

EXEMPT_REASON_CODE VARCHAR2 30NULLExempt Reason Code

RECUR_BILL_OCCURANCES NUMBER NULLFrequency

SUBSCRIPTION_QUANTITY NUMBER NULLSubscription Quantity to be populated for Subsciption lines

QUANTITY_UOM VARCHAR2 3NULLSubscription quantity unit of measure code to be populated for Subsciption lines

PRICE_UOM VARCHAR2 3NULLSubscription price unit of measure code to be populated for Subsciption lines

UNIT_PRICE NUMBER NULLSubscription unit price to be populated for Subsciption lines

FIRST_BILLED_AMOUNT NUMBER NULLSubscription first bill amount to be populated for Subsciption lines

LAST_BILLED_AMOUNT NUMBER NULLSubscription last bill amount to be populated for Subsciption lines

USAGE_TYPE VARCHAR2 10NULLUsage Type

USAGE_PERIOD VARCHAR2 3NULLUsage Period

AVERAGING_INTERVAL NUMBER NULLAveraging Interval

SETTLEMENT_INTERVAL VARCHAR2 30NULLSettlement Interval

USAGE_TERMINATION_METHOD VARCHAR2 30NULLUsage Termination Method

OKS_COVERED_LEVELS_INTERFACE:Primary Key: OKS_COVERED_LEVEL_INTERFACE_PK COVERED_LEVEL_INTERFACE_ID Unique Index: OKS_COVERED_LEVEL_INTERFACE_U1 COVERED_LEVEL_INTERFACE_ID Not Unique Index: OKS_COVERED_LEVEL_INTERFACE_N1 LINE_INTERFACE_ID ColumnsNameDatatypeLengthOptionalityComment

COVERED_LEVEL_INTERFACE_ID NUMBER NOT NULLPrimary Key

LINE_INTERFACE_ID NUMBER NOT NULLLine Interface ID

LINE_NUMBER NUMBER NULLLine Number

COVERED_SERIAL_NUMBER VARCHAR2 30NULLSerial Number

COVERED_INSTANCE_NUMBER VARCHAR2 30NULLInstance Number

COVERED_INSTANCE_ID NUMBER NULLInstance Id

COVERED_ITEM_NAME VARCHAR2 800NULLItem Name

COVERED_ITEM_ID NUMBER NULLItem Id

COVERED_ITEM_ORG_ID NUMBER NULLItem Organization

COVERED_SYSTEM_ID NUMBER NULLSystem Id

COVERED_ACCOUNT_NUMBER VARCHAR2 30NULLAccount Number

COVERED_ACCOUNT_ID NUMBER NULLAccount Id

COVERED_SITE_NUMBER VARCHAR2 30NULLSite Number

COVERED_SITE_ID NUMBER NULLSite Id

COVERED_PARTY_NAME VARCHAR2 360NULLParty Name

COVERED_PARTY_NUMBER VARCHAR2 30NULLParty Number

COVERED_PARTY_ID NUMBER NULLParty Id

LINE_REFERENCE VARCHAR2 300NULLLine Reference

STATUS_CODE VARCHAR2 30NOT NULLStatus

START_DATE DATE NULLLine Start Date

END_DATE DATE NULLLine End Date

RENEWAL_TYPE_CODE VARCHAR2 30NULLRenewal Type

CANCELLATION_DATE DATE NULLCancellation Date

CANCELLATION_REASON VARCHAR2 30NULLCancellation reason

INVOICE_TEXT VARCHAR2 2000NULLInvoice text

PRINT_INVOICE VARCHAR2 1NULLInvoice Print flag

QUANTITY_COVERED NUMBER NULLCovered quantity

QUANTITY_UOM VARCHAR2 3NULLCovered quantity unit of measure code

PRICE_UOM VARCHAR2 3NULLPrice unit of measure code

SUBTOTAL NUMBER NULLSubtotal

TAX_AMOUNT NUMBER NULLTax amount

FIRST_BILL_AMOUNT NUMBER NULLFirst bill amount

LAST_BILL_AMOUNT NUMBER NULLLast bill amount

OKS_USAGE_COUNTERS_INTERFACE:Primary Key: OKS_USAGE_COUNTERS_INTERFACE USAGE_COUNTER_INTERFACE_ID Unique Index: OKS_USAGE_COUNTER_INTERFACE_U1 USAGE_COUNTER_INTERFACE_ID Not Unique Index: OKS_USAGE_COUNTER_INTERFACE_N1 LINE_INTERFACE_ID ColumnsNameDatatypeLengthOptionalityComment

USAGE_COUNTER_INTERFACE_ID NUMBER NOT NULLPrimary Key

LINE_INTERFACE_ID NUMBER NOT NULLLine Interface Id

LINE_NUMBER NUMBER NULLLine Number

COUNTER_ID NUMBER NULLCounter Id

LINE_REFERENCE VARCHAR2 300NULLLine Reference

STATUS_CODE VARCHAR2 30NULLStatus Code

START_DATE DATE NULLStart Date

END_DATE DATE NULLEnd Date

RENEWAL_TYPE_CODE VARCHAR2 30NULLRenewal Type

CANCELLATION_DATE DATE NULLCancellation date

CANCELLATION_REASON VARCHAR2 30NULLCancellation Reason Code

INVOICE_TEXT VARCHAR2 2000NULLInvoice Text

PRINT_INVOICE VARCHAR2 1NULLInvoice Print Flag (Y or N)

SUBTOTAL NUMBER NULLSubtotal

TAX_AMOUNT NUMBER NULLTax Amount

FIXED_USG_CNT NUMBER NULLFixed

MINIMUM_USG_CNT NUMBER NULLMinimum

DEFAULT_USG_CNT NUMBER NULLDefault

FILL_YN VARCHAR2 1NULLFill 'Y'/ 'N'

ESTIMATION_METHOD VARCHAR2 30NULLEstimation method

ESTIMATION_START_DATE DATE NULLEstimation start date

LEVEL_YN VARCHAR2 1NULLLevel

OKS_SALES_CREDITS_INTERFACE:

Primary Key: OKS_SALES_CREDITS_INTERFACE_PK SALES_CREDIT_INTERFACE_ID Unique Index: OKS_SALES_CREDITS_INTERFACE_U1 SALES_CREDIT_INTERFACE_ID Not Unique Index: OKS_SALES_CREDITS_INTERFACE_N1 HEADER_INTERFACE_ID ColumnsNameDatatypeLengthOptionalityComment

SALES_CREDIT_INTERFACE_ID NUMBER NOT NULLPrimary Key

HEADER_INTERFACE_ID NUMBER NOT NULLHeader interface id

SALESPERSON_NAME VARCHAR2 150NULLSales person name

SALESPERSON_ID NUMBER NULLSales person id

SALESGROUP_ID NUMBER NULLSales group id

SALES_CREDIT_TYPE VARCHAR2 40NULLSales credit type

PERCENT NUMBER NULLPercent

OKS_NOTES_INTERFACE:Primary Key: OKS_NOTES_INTERFACE_PK NOTES_INTERFACE_ID Unique Index: OKS_NOTES_INTERFACE_U1 NOTES_INTERFACE_ID Not Unique Index: OKS_NOTES_INTERFACE_N1 HEADER_INTERFACE_ID Not Unique Index: OKS_NOTES_INTERFACE_N2 LINE_INTERFACE_ID ColumnsNameDatatypeLengthOptionalityComment

NOTES_INTERFACE_ID NUMBER NOT NULLPrimary key

HEADER_INTERFACE_ID NUMBER NULLForeign Key reference to OKS_HEADERS_INTERFACE. HEADER_INTERFACE_ID

LINE_INTERFACE_ID NUMBER NULLForeign Key reference to OKS_LINES_INTERFACE. LINE_INTERFACE_ID

NOTES VARCHAR2 2000NOT NULLNotes

NOTES_DETAIL CLOB NULLAdditional details for notes.

NOTE_STATUS VARCHAR2 1NULLIndicates whether the note is Public, Private or Publish. Foreign Key reference to JTF_NOTE_STATUS

NOTE_TYPE VARCHAR2 30NULLType of Note. Foreign Key reference to JTF_NOTE_TYPE

ENTERED_BY NUMBER 15NOT NULLFND User who created the note

ENTERED_DATE DATE NOT NULLDate on which the FND User created the note

Load interface tables

Bulk validation against interface table for each attributes, entity, cross entity (possibility of merging related attributes)

Processing

Log errors to error table

Fisrt validation will insert into staging table with proper error flag

AD Parallel framework

Submission Approval workflow, QA Check etc

Rollup Errors to Contract Header Level and update interface table.

Load / Insert

Subsequent validation will update the error flag of the corresponding record in staging table

Purge / Update interface table, Clear temp tables

Validation

Post Processing

1

Flag Error Records on Interface Tables

1

Error Logging

Identify Con-current Work Units

Spawn Multiple Workers

Assign Work Unit to each Worker

Attribute Level validation (bulk)

Entity validation (bulk)

Cross entity validation (bulk)

Validation

Amount & Tax rollup

Processing

Bulk Create Contract Header, Party Roles, Contacts, Sales Credit, K Group etc

ID generation for Contracts entities and FK assignments

Create billing & PM Schedule, subscription fulfillment etc

Bulk Create Lines for Service, Warranty, Ext-warranty, Subscription, Usage etc

Bulk Create Covered Levels, usage counters

Load / Insert

2

2

4

3

3

4

End Import

Header

Subscription

Usage

Service, Warranty, Ext-Warranty

Cov Levsls

Usage Counters

Flat structure for interface tables

Generate billing & PM Schedule, subscription fulfillment etc (PL/SQL)