When Authoring a Lease Contract with Usage Line, the Price List LOV Returns no Records (Doc ID 2902964.1)

Last updated on OCTOBER 14, 2022

Applies to:

Symptoms

On : 12.2.5 version, Customer Service

ACTUAL BEHAVIOR
---------------
Find that when authoring a lease contract with usage line, in the Usage line page, the Price List LOV returns no records. The price list LOV uses the following statement:

SELECT OKX_PRICE.ID1,
  OKX_PRICE.ID2,
  OKX_PRICE.NAME,
  OKX_PRICE.DESCRIPTION
from (SELECT B.LIST_HEADER_ID ID1,
  '#' ID2,
  B.LIST_TYPE_CODE LIST_TYPE_CODE,
  B.START_DATE_ACTIVE START_DATE_ACTIVE,
  B.END_DATE_ACTIVE END_DATE_ACTIVE,
  qdt.start_date_active qdt_start_date_active,
  qdt.end_date_active qdt_end_date_active ,
  B.LIST_SOURCE_CODE,
  B.SOURCE_SYSTEM_CODE,
  qdt.to_currency_code currency_code,
  T.NAME NAME,
  T.DESCRIPTION DESCRIPTION,
  B.ACTIVE_FLAG B_STATUS--,
  FROM QP_LIST_HEADERS_B B,
  QP_LIST_HEADERS_TL T,
  qp_currency_details qdt
  WHERE b.currency_header_id = qdt.currency_header_id AND
  b.LIST_TYPE_CODE = 'PRL' AND
  B.LIST_HEADER_ID = T.LIST_HEADER_ID AND
  T.LANGUAGE = USERENV('LANG') AND
  B.ACTIVE_FLAG = 'Y' AND
  TRUNC(SYSDATE) BETWEEN NVL(TRUNC(b.start_date_active), TRUNC(SYSDATE)) AND NVL(TRUNC(b.end_date_active), TRUNC(SYSDATE)) AND
  (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(qdt.start_date_active), TRUNC(SYSDATE)) AND NVL(TRUNC(qdt.end_date_active), TRUNC(SYSDATE))
  OR qdt.start_date_active = (sysdate-730000) OR qdt.end_date_active = (sysdate-730000) ) AND
  NVL(B.LIST_SOURCE_CODE,' ') <> 'BSO' AND
  B.SOURCE_SYSTEM_CODE IN (SELECT qpss.application_short_name
  FROM qp_pte_source_systems qpss
  WHERE qpss.pte_code = 'ORDFUL') AND
  T.NAME NOT LIKE B.SOURCE_SYSTEM_CODE|| ' LOCKED%' ) OKX_PRICE
  where currency_code = (select currency_code from okc_k_headers_all_b where id = 15279417)
ORDER BY OKX_PRICE.NAME;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, author a lease contract.
2. Navigate to additional charges tab and in the usage section, click the Create button to create a Usage line.
3. Use the LOV for the Price List and no values are returned.

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.