Wednesday, October 13, 2010

Sales Order Error

When the user navigates to Order Management responsibility on setting up BG, OU, Inv Org and responsibilities MO- default Operating Unit, MO-Operating Unit, HR: Cross Business Group = yes, Security Profile = Business Group ID and tries to access the Order Management Form then two consecutive note pops up:
  1. Validation failed for the field- Sales person

  2. User defined exception in Package OE_Default_Header procedure attributes.
Note 1 : Validation failed for the field- Salesperson

salesorder_error_1.jpg

Note2: OE_Default_Header procedure attributes

salesorder_error_2.jpg

Solution:

Set the Profile option MO: Operating Unit to the desired operating unit under all the responsibilities.

Login to the application with ‘System Administrator’ Responsibility.

The Navigation Path is Profile >System


Set the Profile option OM : Default Sales Rep at the Site Level.

Login to the application with ‘System Administrator’ Responsibility.

The Navigation Path is Profile >System


Map the Responsibility with the desired Organization

Login to the application with ‘Oracle Order Management Super User’ Responsibility.

1. The Navigation Path is Inventory > Setup >Organizations.

salesorder_error_3.jpg


Define the System option under Oracle Receivables.

  1. Login to the application with ‘Receivables Manager’ responsibility.

  2. The Navigation Path is Setup > System>System Option.

salesorder_error_4.jpg

Define the Transaction Type under Oracle Receivables.


  1. Login to the application with ‘Receivables Manager’ responsibility.

  2. The Navigation Path is Setup > System>System Option.

  3. salesorder_error_5.jpg


  4. Save the information.

Define Defaulting Rule under Order Management Super User Responsibility.

  1. Login to the application with ‘Order Management Super User’ responsibility

  2. The Navigation Path is Setup>Rules>Defaulting

  3. Query entity = Order Header and attribute = Salesperson.

  4. Modify the defaulting rule so that validation is correct.

salesorder_error_3.jpg

Modify the defaulting rule according to the Business Requirement

salesorder_error_7.jpg

Define the Transaction type under Order Management Super user Responsibility.

Two types of Transactions are defined : Order Type and Line Type.

  1. Login to the application with ‘Order Management Super User’ responsibility.

  2. The Navigation Path is Setup>Transaction Type> Define

  3. Define the Transaction type for Sales Order.

  4. Navigate to the Shipping Tab and Assign the Warehouse Organization in the Warehouse Field.

  5. Navigate to the Finance Tab and Enter the Invoicing Rule and the Accounting Rule

  6. Save the Information

  7. Define the Line Type Transaction

  8. Navigate to the Shipping Tab and Assign the Warehouse Organization in the Warehouse Field.

  9. Navigate to the Finance Tab and Enter the Invoicing Rule and the Accounting Rule

  10. Query the ‘Order Type’ Transaction Typeand click on Assign Line flows to assign the Line type to the Order Type Transaction.

salesorder_error_8.jpg

Shipping Tab

salesorder_error_12.jpg

Finance Tab

salesorder_error_13.jpg

Line type : Transaction Type

Similar to Order Type define the Warehouse Organization under shipping Tab and Invoicing Rules under

salesorder_error_14.jpg

Assign the Line Type Transaction to Order Type.

Query on Order type Transaction and click on Assign Line Flows

salesorder_error_15.jpg

salesorder_error_16.jpg

No comments:

Post a Comment