Approval Rule Is Not Valid For The Offer Approval

(Doc ID 1471751.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Trade Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Marketing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Dec-2013***


When submitting the offer for approval, it is always picking up the "Default Approval Rule" and not using the correct approval rule.
Observed that the organization_id in the ams_approval_details table or orig_org_id in the qp_list_headers_b is the main cause of the problem. Click on the "Request Approval" button, it is clearing off the orig_org_id column to blank in the qp_list_headers_b table. When selecting the approval rule, it is checking for organization_id column in ams_approval_details table and couldn't match it because of the blank values in qp_list_headers_b table.

Goto Trade Planning --> Offers --> Create offer.
Enter a LUMPSUM offer and Click on "Request For Approval" button.


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