Termination Date and Reason Code not Populated On Expired Lines When Line is Terminated for Full Credit (Doc ID 1063474.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Service Contracts - Version 11.5.10.2 to 12.1. [Release 11.5 to 12]
Information in this document applies to any platform.
Form:OKSAUDET.FMB - Service Contracts Authoring

Checked for relevancy 14-Oct-2013

Symptoms

Find that terminating a line in a contract with a termination date that is earlier than the end date of a subline
for that line,  when a full credit is issued, the subline status does not change to Terminated and the trn_code is not populated.

Expected Behavior:

This is the expected behavior for expired contract sublines after applying this patch:
- The subline status code will remain in Expired status.
- The trn_code will show the termination reason.
- The date_terminated will NOT show the termination date for the transaction

This change will allow users to run reports based on the termination reason, but also reflect the fact that the subline was indeed Expired before the transaction occurred.


Steps to Reproduce:

The issue can be reproduced at will with the following steps:
1. Create a contract with these attributes:
- Contract and line have a start date of 01-JAN-2009 and an end date of 31-DEC-2009.
- At least one subline has an end date that is earlier than the current date, e.g., 30-JUN-2009.
2. Terminate the contract or contract line with a termination date that is later than 30-JUN-2009.
- Enable the full credit button to issue a full credit (or an override amount that is greater than the calculated  amount).
- Complete the transaction.
- Run this query:
select UBT_AMOUNT, CREDIT_AMOUNT, SUPPRESSED_CREDIT, tax_amount
from oks_k_lines_b
where cle_id = &subline_id
Note that the credit_amount is populated, thus demonstrating that the subline has in fact been terminated.
- Run this query:
select PRICE_NEGOTIATED, last_update_date, end_date, date_terminated, trn_code, sts_code
from okc_k_lines_b
where id = &subline_id;;
The price_negotiated has been decremented by the amount of the credit for the subline, again demonstrating that the subline has in fact been terminated.

The date_terminated and trn_code are not updated to reflect that the subline was terminated.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms