My Oracle Support Banner

Error Message After Offer Activation (Doc ID 2483859.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Oracle Trade Management - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Trade Management Offers

Offer with an alternate beneficiary are returned with an error message when it is activated. 

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT QP_QP_Form_Pricing_Attr.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER', :1, :2 , :3) benf_party_name From dual

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Creation of offer & copy
2. Activate offer
3. F5 / Refresh button
4. Beneficiary filed null, just customer field remains
5. Approve offer

Changes

 

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.