Explore Oracle Fusion

 Table Details:  Operations that are enabled for Automatic Work Definition can be found from the below table  WIS_STANDARD_OPERATIONS_B. Column - USED_IN_AUTO_WD_FLAG indicates whether operation is assigned to Automatic Work definition. Query1: All Standard Operations across the orgs that are used in Automatic Work Definition. select io.organization_code, standard_operation_code,used_in_auto_wd_flag, count_point_flag, auto_transact_flag from wis_standard_operations_b wsob, inv_org_parameters io where wsob.organization_id=io.organization_id and wsob.used_in_auto_wd_flag='Y'   Query2: All the automatic work definitions in the application across organizations. select io.organization_code, esi.item_number, wwd.system_generated_flag System_Generated, wwd.* from inv_org_parameters io, egp_system_items_b esi, wis_work_definitions wwd where esi.inventory_item_id=wwd.inventory_item_id and esi.organization_id=wwd.organization_id and io.organization_id=wwd.org

Automatic Work Definition:                     As the title suggests automatic work definition is a work definition that is automatically generated by Fusion Applications. Organizations deal with manufacturing assemblies of different complexity. Certain assemblies are manufactured in multiple operations and consume different components in different operations. Certain assemblies could have a generic operations like kitting etc. This feature addresses the later in which assemblies are manufactured with generic operations. How to Create Automatic Work Definitions: Below are the high-level steps to creating Automatic Work definitions.  Define a Standard Operation Define Item Structure.  Define a Standard Operation Navigation: Supply Chain Execution-->Work Definition-->Manage Standard Operations 2. Defining Item Structure For the test case, a test assembly FB_SA_ITEM1 is considered.  From Item Details, Switch to Structures tab and from Actions, Click on Create Automatic W