My Oracle Support Banner

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.


On : 12.2.5 version, Billing Modules

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



oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
  , kle_id
  ,pty.party_id cust_id
  ,pty.party_name customer
  ,plpty.party_id plbl_id
  ,plpty.party_name private_label
  ,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 = cust.chr_id (+)
AND cust.rle_code (+) = 'LESSEE'
AND cust.object1_id1 = pty.party_id (+)
AND = 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 = bgl.khr_id (+)
AND bgl.bill_group_id = bgh.bill_group_id (+)
AND asset.dnz_chr_id =
AND = bgl.kle_id (+)
AND = rgp.dnz_chr_id (+)
AND = 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)

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


To view full details, 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 a vibrant support community of peers and Oracle experts.