Oracle Apps Techno Functional................

How to customized Standard Cost of Goods Account (COGS) workflow to derive COGS from Order Type. Oracle has provided Standard COGS workflow to derive cost of goods sold (COGS) account from Inventory Item (defined in Shipping Organization). If there is requirement to derived the COGS account based on the Order type , we need to customized the Standard workflow. Follow the below steps to customized the workflow. 1.Open the standard workflow in workflow builder. 2.Copy the Standard Workflow "Generate Default Account (DEFAULT_ACCOUNT_GENERATION) " and name it XX_DEFAULT_ACCOUNT_GENERATION (custom_Generate Default Account ). 2.Remove the link between START and "Get CCID for a line". 3.Add New function "Get CCID from the Order Type ID(GET_ORDER_TYPE_DERIVED). 4.Make link between START and function GET_ORDER_TYPE_DERIVED. 5.Remove the function Get CCID for a line(GET_ITEM_DERIVED). 6.Connect the GET_ORDER_TYPE_DERIVED with Copy Values from Code Combination (FND_FL...

Oracle workflow engine provide wf_engine API to SKIP/Retry workflow activity Below is example how we do it in Oracle Order Management. wf_engine.handleerror('OEOL',TO_CHAR(LINE_ID),activity_label,RETRY,NULL) wf_engine.handleerror('OEOL',TO_CHAR(LINE_ID),activity_label,SKIP,NULL)

  Here is a demo on creating and testing a business event. This is a very simple example where a row is inserted into a table when the rule function (pl/sql package) attached to the subscription is executed. This rule function will be executed when the event queue is consumed by Workflow Agent Listener (one of the concurrent managers). Click here to see the demo. Code is here .

WorkFlow Overview : This article will illustrate how to create or define workflow attributes, notifications, messages, roles or users, functions, processes and last but not the least, how to launch a workflow from PL/SQL. The workflow concepts are better explained using an example. Business Requirement: When an item is created in inventory, workflow needs to be launched and it should collect the details of the item created and sends a notification to group of users along with the details and link to master item form. Process flow : When an item is created it will create/insert a record in MTL_SYSTEM_ITEMS_B so create a database trigger on the table and launch workflow from that trigger. All you need to do is create the workflow, create the trigger, pl/ sql package, roles and finally create an item in inventory. Open WFSTD and save as new workflow Create Attributes Create Functions Create Notification Create Messages Create Roles Create database trigger Create P...