Monday, August 28, 2017

Cascading Attribute Sales Order Header to Line

Attributes on sales order header are used as default for sales order line. However, if there is a change in sales order header, entered lines will not get updated automatically. This feature can replace those manual works to update entered lines so lines will always follow the value in sales order header.

How to setup :
1.      Responsibility : System Administrator > Profile > System
Find  profile option : OM: Sales Order Form: Cascade Header Changes to Line

Default value is NULL, change it to Automatic / Ask Me / Manual, in this case we’re using Automatic. Can be changed in Site / Responsibility / User level.

2.      Responsibility : Order Management Super User > Setup > QuickCodes > Order Management
Find lookup type : OM_HEADER_TO_LINE_CASCADE

Tick enable for each attributes that you want to cascade automatically.


Create Internal Suppliers From Employees

We know that to maintain our suppliers at Oracle E-Business Suite, we could utilize suppliers feature at Payables modules. To specifically differ the internal suppliers, such as employees, we could use another type supplier to automatically import the employee information to supplier: supplier used to process expense payment to internal employees. Furthermore, the feature could support the automatic expense report invoices utilization (we would explain this feature for the upcoming posting).

First of all, we usually only have one option to create supplier. When we click on Create button supplier, we immediately have to key in the supplier info, such as, Supplier Name, Alternate Supplier Name, Supplier Name, and do on. Yet to create internal suppliers from importing employee info, we need to grant an access at the menu POS_HT_SP_FULL_ACCESS_MENU.

Responsibility: System Administrator
Navigation: Application > Menu

Click Icon Find: POS_HT_SP_FULL_ACCESS_MENU
Tick all menu to grant the access.

POS_HT_SP_FULL_ACCESS_MENU
After we grant the access, we have another option to create supplier.
Internal Supplier Entry

Secondly, we could choose the the employee to import to internal supplier by pick the name from the list of value at Employee Name. When we choose the Employee Name, the Employee Number would automatically appear align with the employee master data.

Employee Master Data
Employee Import as Internal Supplier
The last, we complete the internal supplier information like we do for the external suppliers. When we finish the supplier creation, we could use the employee as the supplier for Expense Report, Invoice Workbench, or Purchase Orders.