Showing posts with label Oracle Trade Management. Show all posts
Showing posts with label Oracle Trade Management. Show all posts

Monday, October 8, 2012

How to rectify error "More than one user has been assigned the Marketing Default Approver role"

 This error is the standard system functionality, only one resource should be assigned to Marketing Default Approver Role

 Use the following SQL query to check the setup
 
 SELECT a.role_resource_id ,
   a.role_name,
   b.resource_name ,
   a.ROLE_TYPE_CODE,
   a.role_id
 FROM jtf_rs_defresroles_vl a,
   ams_jtf_rs_emp_v b
 WHERE a.role_type_code  IN ('MKTGAPPR','AMSAPPR')
 AND a.role_resource_type = 'RS_INDIVIDUAL'
 AND a.delete_flag        = 'N'
 AND TRUNC(SYSDATE) BETWEEN TRUNC(a.res_rl_start_date) AND
 TRUNC(NVL(a.res_rl_end_date,SYSDATE))
 AND a.role_resource_id = b.resource_id;

 Remove the duplicate and assign only one user to the Role Marketing Default Approver and try the flow again.

Request only offer created in Trade Management is not getting applied in Order Management


Please note that when you choose "Request only " in offer you have to choose it manually in sales order. Please follow the following step

  1) Enter Order line
  2) Click on Action Button
  3) Choose "Promotion and Payments"
  4)  Query for the offer created manually., choose the same
  5) Click on Apply
  6) Go ahead once again to View Adjustment and find that the offer is applied.

Wednesday, October 3, 2012

How to set Default Marketing Approver role



1.Go to Responsibility, CRM Resource Manager, Vision Enterprises, Maintain Resources -> Resources Forms UI.
2.Find the resource by name. Click on Resource Details.
3.In Roles tab, add a new row by selecting  Role Type -> "Default Marketing Approver", Role -> "Default Marketing Approver Role", start date and end date.