OKS_BILLING_MAIN In 12.2.14 For CM Populates Contract_line_id With LINE Id Instead Of SUBLINE Id (Doc ID 3068811.1)

Last updated on JANUARY 23, 2025

Applies to:

Symptoms

Find that in 12.2.14 for Credit Memo, Service Contracts Main Billing (OKS_BILLING_MAIN) populates contract_line_id with line id instead of subline id and populates sales_order_line with line number instead of subline number in ra_interface_lines_all table.

sales_order_line:
in 12.2.4 (for OKS INV and OKS CM) and in 12.2.14 (for OKS INV) --- has the SUBLINE line number.
in 12.2.14 (for the OKS CM) - has the LINE line number

contract_line_id:
in 12.2.4 (for OKS INV and OKS CM) and in 12.2.14 (for OKS INV) --- has the ID of the SUBLINE
in 12.2.14 (for OKS CM) -- has the ID of the LINE

STEPS
-----------------------
1. Using service contract manager responsibility, query a contract in Active status that has been billed.
2. In the search screen, right click and terminate with full credit.
3. Run main billing to generate credit memo.
4. Query ra_interface_lines_all table and observe the two fields: sales_order_line and contract_line_id. They are being populated incorrectly.

Changes

Cause

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