Scribd
Upload
439 views2 pages

Oracle Service Contracts API Details

The document outlines procedures for creating, updating, renewing, and terminating contracts, including necessary validations and Oracle Standard APIs for each activity. It details header and line level validations required for contract management, as well as specific API calls for contract operations. The document serves as a comprehensive guide for managing contracts within the specified system.

Uploaded by

Srikkanth Mani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
439 views2 pages

Oracle Service Contracts API Details

The document outlines procedures for creating, updating, renewing, and terminating contracts, including necessary validations and Oracle Standard APIs for each activity. It details header and line level validations required for contract management, as well as specific API calls for contract operations. The document serves as a comprehensive guide for managing contracts within the specified system.

Uploaded by

Srikkanth Mani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

1.

Create Contract & Add New Lines to Existing Contracts


1.1. Add Header
1.2. Add Lines
1.3. Billing Schedule
1.4. QA Check Contract

Header Level Validations:


1. Master Inv Org --> MTL_PARAMETERS --> IMO --> Fixed Value
2. Operating Unit --> HR_OPERATING_UNITS
3. Currency Code --> FND_CURRENCIES
4. Contract Start/End Date
5. HZ Party,Accounts,Bill To,Ship To -->
HZ_PARTIES,HZ_CUST_ACCOUNTS,HZ_CUST_ACCT_SITES_ALL,HZ_CUST_SITE_USES_ALL
6. Price List --> QP_LIST_HEADERS
7. Term Name --> RA_TERMS
8. Invoice Rule --> RA_RULES --> Advance Invoice --> Fixed Value
9. Accounting Rule --> RA_RULES
[Link] Check --> FND_PROFILE_OPTIONS_VL,FND_PROFILE_OPTION_VALUES -->
Profile name --> OKS_DEFAULT_QA_CHECKLIST --> Fixed Value
[Link] Name --> OKC_PROCESS_DEFS_TL --> Approval Process --> Fixed Value
[Link] Transaction Type --> RA_CUST_TRX_TYPES_ALL

Line Level Validations:


1. Inventory Item --> MTL_SYSTEM_ITEMS_B

Line Level Billing Schedule Validations:


[Link] Level(Amount) --> FND_LOOKUPS --> OKS_BILLSCH_LEVEL
[Link] UOM --> OKC_TIME_CODE_UNITS_B

Oracle Stanndard API'S:


1. OKS_IMPORT_HEADER_PUB.CREATE_CONTRACT_HEADER_WRAPPER
2. OKS_IMPORT_LINE_PUB.CREATE_CONTRACT_LINE
3. OKS_IMPORT_HEADER_PUB.INSERT_SALES_CREDIT
4. OKS_IMPORT_LINE_PUB.GENERATE_BILL_SCHEDULES
5. OKS_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT

2. Update Header & Lines

1. Update Header
2. Update Lines

Header & Lines Validations:


1. Contract & Lines Exists --> OKC_K_HEADERS_ALL_B,OKC_K_LINES_B

Oracle Stanndard API'S:


1. OKS_IMPORT_HEADER_PUB.UPDATE_CONTRACT_HEADER
2. OKS_IMPORT_LINE_PUB.UPDATE_CONTRACT_LINE

3. Renew Contracts

Renewal Validations:
1. Contract Exists --> OKC_K_HEADERS_ALL_B
2. Renewal Start/End Date
3. Renewal UOM Code --> OKC_TIME_CODE_UNITS_B
4. Renewal Duration

Oracle Stanndard API'S:


1. OKS_RENEW_CONTRACTAPI_PUB.RENEW_CONTRACT

4. Terminate Contracts

Termination Validations:
1. Contract Exists --> OKC_K_HEADERS_ALL_B
2. Termination Reason Code --> FND_LOOKUPS --> OKC_TERMINATION_REASON

Oracle Stanndard API'S:


1. OKS_TERMINATE_CONTRACT_PUB.TERMINATE_CONTRACT

--------------------
1. Create Contract & Add New Lines to Existing Contracts
Activity:
1. Add Header
2. Add Lines
3. Billing Schedule
4. QA Check
API'S:
1. OKS_IMPORT_HEADER_PUB.CREATE_CONTRACT_HEADER_WRAPPER
2. OKS_IMPORT_LINE_PUB.CREATE_CONTRACT_LINE
3. OKS_IMPORT_HEADER_PUB.INSERT_SALES_CREDIT
4. OKS_IMPORT_LINE_PUB.GENERATE_BILL_SCHEDULES
5. OKS_ACTIVATE_CONTRACT_PUB.ACTIVATE_CONTRACT

2. Update Existing Contract Header & Lines


Activity:
1. Update Header
2. Update Lines
API'S:
1. OKS_IMPORT_HEADER_PUB.UPDATE_CONTRACT_HEADER
2. OKS_IMPORT_LINE_PUB.UPDATE_CONTRACT_LINE

3. Renewing Existing Contracts


Activity:
1. Renew
API'S:
1. OKS_RENEW_CONTRACTAPI_PUB.RENEW_CONTRACT

4. Terminating Existing Contracts


Activity:
1. Terminate
API'S:
1. OKS_TERMINATE_CONTRACT_PUB.TERMINATE_CONTRACT

You might also like