My Oracle Support Banner

The OKS_IMPORT_HEADER_PUB.UPDATE_CONTRACT_HEADER API Allows Updates to the End Date on a Billed Contract (Doc ID 2452994.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Service Contracts - Version 12.2.5 and later
Information in this document applies to any platform.


The OKS_IMPORT_HEADER_PUB.UPDATE_CONTRACT_HEADER API is updating contract End Dates on already billed Service Contracts. Trying to make the same update from the Service Contracts authoring form generates the following error: The contract has been already billed up to billed_date.

There is no validation in the API to check if the contract is billed or not. Also, it allows to change the End Date of an Active contract to a date less than teh line effectivity dates. This can lead to invalid data as the header End Date would be less than the line End Date.

1. Create a Service Contract and bill it fully. Start date is 23-AUG-17 and end date is 22-AUG-2018.
2. Try to change the End Date to an earlier date in the authoring form. Get the error: The contract has been already billed up to 22-AUG-2018.
3. Use the OKS_IMPORT_HEADER_PUB.UPDATE_CONTRACT_HEADER API to change the contract End Date to 01-AUG-2018. The contract End Date is updated without any errors.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.