Oracle COGS Workflow Customization to Get Account Value

Every Organization has different need based on business requirement; recently I need to give a demo to my customer about how to customized COGS workflow to derive the Cogs account.

Oracle is Provide a very flexible COGS workflow where customer can derive the values for their account flexfield from

1.    Order Line Type.
2.    Item on the Order Line
3.    Sales Rep revenue Account
4.    Model for an option

With all the above option we can derive the COGS account from any one of these options or with the combination of all these.

In my Demo I have selected Oracle Vision Accounting Structure where Accounting KFF has 5 segments.

In my case customer. requirement was derive the

• Company Code from Order Type
• Department   from   Item on Order line ID
• Rest 3 segments from revenue account associated with the Sales Rep.

 Below are step by Step info about how to customized the COGS workflow



Original workflow

 Modified Workflow

Below is how I have customized the COGS to fulfill my clients requirements.
1.    Create the copy of the exiting workflow ( for question on workflow refer my earlier posts).
2.    Drop the “Get CCID from the Order Type ID” between Start and “Get CCID for a line”
3.    Drop the “Copy Segment Value from Code Combination” after  “Get CCID for a line” and populated
       the Attribute Node with following values

• Code Combination ID = Generated CCID (Attribute)
• Segment Identifier     = Name
• Segment        = Company (Case Sensitive Value).
• Replace Existing value = False

4.    Join Start, Get CCID from the Order Type ID, Copy Segment Value from Code Combination and Get
       CCID for a line as shown in Pic( Modified flow).
5.    Drop the “Copy Segment Value from Code Combination” after  “Get CCID for a line” populated the
      Attribute Node with following values

• Code Combination ID = Generated CCID (Attribute)
• Segment Identifier     = Name
• Segment        = Department ( Case Sensitive Value).
• Replace Existing value = False
•  

6.    Drop the “Get CCID from Salesrep's revenue segment” .
7.    Drop Copy Values from Code Combination and populate it’s node just like above 2 cases, please note here we have only 2 attributes

• Code Combination ID = Generated CCID (Attribute)
• Replace Existing value = False

8.    Since I want to to retain the First 2 segments ( Segment1 and Segment2)  with the account values
       derived from Step 3 and 5 and Segment3/4/5 from the setp6, so I set Replace Existing value = False.
9.    Join all workflow notes as shown in modified flow pic.
10.  No changes required for
11.  Validate Code Combination.
12.  Verify the flow and save in database .
13.  Run cogs_11i.sql for both 11i/12i and verify the account generated by the workflow.

Hope that help.