My Oracle Support Banner

Error When Add Secondary Price List Using HTML Page (Doc ID 2594927.1)

Last updated on OCTOBER 23, 2019

Applies to:

Oracle Advanced Pricing - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

Following error occurs while adding secondary price list to already created price list using HTML page.
It happens for all price lists.

ERROR

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT name, description,list_header_id,active_flag, orig_org_id,
global_flag
FROM qp_secu_list_headers_v
WHERE list_header_id != :1
AND currency_code = :2
AND nvl(global_flag, 'N') = :3
AND nvl(pte_code,'ORDFUL') 'LOGSTX'
AND view_flag = 'Y') QRSLT WHERE (list_header_id not IN ( xxx,yyy,zzz
) AND ( UPPER(NAME) like UPPER(:5) AND (NAME like :6 OR NAME like :7 OR NAME
like :8 OR NAME like :9)))



STEPS TO REPRODUCE THE ISSUE:
1. Navigate to Pricing HTML page (using responsibility Oracle pricing user)
2. Create price list
3. Add secondary price list
4. Complete price list creation process
5. Add price list line
6. Click on "price list maintenance"
7. Try to add secondary price list
8. Exception error message displayed.
9. System allows to add the secondary price list only during creation of price list in HTML page but not after price list creation in HTML page. But this is not the case in Java forms.

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
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.