The Lease Super User HTML Contract Assets Configuration Billing Tab Errors Out

(Doc ID 2318646.1)

Last updated on OCTOBER 17, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Billing Modules

The Lease Super User HTML contract assets configuration Billing Tab errors out during viewing or upd



 

ERROR
-----------------------

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT chr.id
  ,bgh.bill_group_name
  ,bgh.bill_group_id
  ,bgl.bill_group_line_id
  ,asset.id kle_id
  ,chr.contract_number
  ,chr.currency_code
  ,pty.party_id cust_id
  ,pty.party_name customer
  ,plpty.party_id plbl_id
  ,plpty.party_name private_label
  ,hzc.cust_account_id
  ,hzc.account_number
  ,stst.ste_code ste_code
  ,chr.authoring_org_id org_id
  ,chr.scs_code scs_code
  ,to_number (rul.rule_information1) invoice_format_id
FROM okc_k_headers_v chr
  ,okc_statuses_v stst
  ,okc_k_party_roles_b cust
  ,hz_parties pty
  ,okc_k_party_roles_b plbl
  ,hz_parties plpty
  ,hz_cust_accounts hzc
  ,okc_k_lines_b asset
  ,okl_bill_group_headers bgh
  ,okl_bill_group_lines bgl
  ,okc_rule_groups_v rgp
  ,okc_rules_v rul
WHERE chr.sts_code = stst.code
AND chr.id = cust.chr_id (+)
AND cust.rle_code (+) = 'LESSEE'
AND cust.object1_id1 = pty.party_id (+)
AND chr.id = plbl.chr_id (+)
AND plbl.rle_code (+) = 'PRIVATE_LABEL'
AND plbl.object1_id1 = plpty.party_id (+)
AND hzc.cust_account_id (+) = chr.cust_acct_id
AND chr.id = bgl.khr_id (+)
AND bgl.bill_group_id = bgh.bill_group_id (+)
AND asset.dnz_chr_id = chr.id
AND asset.id = bgl.kle_id (+)
AND chr.id = rgp.dnz_chr_id (+)
AND rgp.id = rul.rgp_id (+)
AND rgp.cle_id IS NULL
AND rgp.rgd_code (+) = 'LABILL'
AND rul.rule_information_category (+) = 'LAINVD') QRSLT WHERE (KLE_ID = :1)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Lease Super User > Operations > Contract > Configuration Tab > Asset > Billing Tab





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