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

Note2: OE_Default_Header procedure attributes

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.

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.

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

Modify the defaulting rule according to the Business Requirement

 

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 Type and click on Assign Line flows to assign the Line type to the Order Type Transaction.

Shipping Tab

Finance Tab

Line type : Transaction Type

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

Assign the Line Type Transaction to Order Type.

Query on Order type Transaction and click on Assign Line Flows

Save the Information.