My Oracle Support Banner

Service Contracts Main Billing Performance Issue for some Operating Units (Doc ID 2613511.1)

Last updated on JULY 14, 2020

Applies to:

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

Symptoms

On :  12.2.6 version, Contracts Billing/Termination

ACTUAL BEHAVIOR  
---------------
Running the Service Contracts Main Billing program with a large number of usage lines takes about 3 hours for some operating units.

EXPECTED BEHAVIOR
-----------------------
Expect that the Service Contracts Main Billing program would complete in less than 2 hours for these operating units.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using the Service Contracts Manager responsibility.
2. Run the Service Contracts Main Billing program for specific operating units.
3. It is taking a few hours to complete.


Changes

Query causing the delay taken from the trace/tkprof:

SELECT /*+  PARALLEL(a) */ A.ID , A.BTN_ID , A.DATE_BILLED_FROM,
  A.DATE_BILLED_TO, A.CLE_ID, A.AMOUNT, A.BILL_ACTION, B.DNZ_CHR_ID,
  A.DATE_NEXT_INVOICE, B.START_DATE, B.LSE_ID, A.CURRENCY_CODE,
  B.DATE_TERMINATED, C.NAME LSE_NAME, B.CUST_ACCT_ID, KLN.TRXN_EXTENSION_ID,
  B.LINE_NUMBER TOP_LINE_NUMBER
FROM
OKC_LINE_STYLES_V C, OKS_BILL_CONT_LINES A, OKC_K_LINES_B B, OKS_K_LINES_B
  KLN WHERE A.BTN_ID IS NULL AND A.AMOUNT IS NOT NULL AND B.ID = A.CLE_ID AND
  B.ID = KLN.CLE_ID AND C.ID = B.LSE_ID AND A.BILL_ACTION IN ('AV','TR','STR',  'SRI','RI') AND :B1 IS NULL

call     count       cpu    elapsed       disk      query    current rows
------- ------  -------- ---------- ---------- ---------- ---------- ----------
Parse        1      0.00       0.00          0          0          0  0
Execute     1      3.67    15724.90      83360     507053         71  0
Fetch        0      0.00       0.00          0          0          0  0
------- ------  -------- ---------- ---------- ---------- ---------- ----------
total        2      3.67   15724.90      83360     507053         71  0

 
This is explained in the following bug:
Bug 29707124 - SERVICE CONTRACTS MAIN BILLING PERFORMANCE ISSUE FOR SOME OUS
 

Cause

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
Symptoms
Changes
Cause
Solution
References


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