What is Jeopardy: It is a alert which helps Business to take necessary action on order in case they see any potential delay in fulfilling the Order. It can also be considered as risk in fulfilling the order.

Order fulfillment comprises of different tasks i.e. Shipping, Billing, Invoicing etc. There could be potential delay in shipping an item from warehouse. Which will eventually delay the other activities. This is where Jeopardy comes into picture. It evaluate time taken at each level and if it is beyond permissible lead time, it raises a flag. Flag(Jeopardy) has different level of severity. Higher the Jeopardy is when Business has to chime in and investigate what is causing potential delay and what can be done to expedite steps of particular order.

Jeopardy has two Components/Setups

• Manage Jeopardy Priorities
• Manage Jeopardy Threshold

Manage Jeopardy Priorities

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Task “Manage Jeopardy Priorities”
• Minimum and Maximum scores determine what priority it will fall under(Low, Medium or High)
  and same is used at time of creating Jeopardy Threshold. Score is set based on business needs.

Manage Jeopardy Threshold

Jeopardy priority is used as a reference to determine

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Rules(Manage Jeopardy Threshold).
• Under Action Select Create if we wish to create new Thresholds, else select Edit to update existing thresholds.

• Code -> Enter Code for your Jeopardy Threshold Definition.
• Name -> Enter Name for your Jeopardy Threshold Definition.
• Process name -> Enter Process name given at time of Orchestration Process Definition.
• Task type -> where you want this threshold to be applicable. It can be set to All or if want this Jeopardy to be set for specific task i.e. Shipment.
• Task Name -> If we select any particular Task type, then respective Task Name will show in drop down. We can select All or any specific task name for which we want this threshold to be applicable
• Under Action Button, Select Add row.

• Based on Business provided values we can setup the threshold Ranges

When Jeopardy runs

1. When an orchestration process is assigned to an order line, the process is planned taking into account the lead time of steps in the orchestration process and certain key dates from the sales order, such as required completion date.
2. Each task of the process has a planned start and completion date.
3. The orchestration process is re-planned, when a task completes or when the scheduled process runs.
4. Jeopardy runs when planning runs, so a task can be at risk and still not appear as in jeopardy because an event hasn’t triggered planning to run.

How Jeopardy Threshold is evaluated

Order Management searches for a threshold that applies to the highest number of entities of the task. It
searches for a threshold in this order:

1. Process name, process version, task name, and task type
2. Process name, process version, and task name
3. Process name and task name
4. Process name, process version, and task type
5. Process name and task type
6. Task name
7. Process name and process version
8. Process name
9. Task type

Application of Jeopardy in Order Management

Jeopardy setup using Orchestration Process gets applied by default.

In case we want specific Jeopardy to be applied while Creating order then we need to go to Shipping Truck Icon. Under Shipping tab, Enter Orchestration process Name in Packing Instruction.

This is how Jeopardy thresholds gets picked up.

• Click on Actions -> Switch to Fulfillment Views -> Under Fulfillment Tab we will see Orchestration Process Name assigned to the corresponding Order Number

• Click on Orchestration Process to See Jeopardy Details

Please Note: Since my order will take some time to move, Below screenshot is of different orders.

Currently Jeopardy Score of this order is Low as it is in manageable range,

Statuses play key role in Order Management to determine the life cycle of Order. Any order goes through series of steps and Status helps in identifying the current status of order. Status defined in Orchestration Process will reflect in Order Management.

Statuses are determined at two level

• Orchestration Process
  • Designate the statuses that represent an Orchestration Process
  • Select a preset group of Orchestration process statuses
  • Create rules that govern how statuses are attained

• Fulfillment Line
  • A status catalog provides a means to differentiate status values by item characteristics.
  • A status rule set is:
    • A set of rules that govern the conditions under which status codes are assigned to fulfillment lines
    • used to apply a set of sequential statuses to the fulfillment line that is processed by the orchestration process

Statuses goes through a life cycle

• First we get status from fulfillment system which could be internal or External.
• External Interface layer translate/maps the fulfillment system status value into Order Orchestration status value.
• Task Layer Determine the status message to be send.
• Using Source and Target mapping, task status is set during Orchestration processing
  • Set Fulfillment line status based on task statuses associated with the fulfillment line.
  • Set Orchestration Order Line status based on the whether the associated fulfillment lines are opened or closed.
  • Set Orchestration Order status based on whether the associated orchestration order lines are opened or closed.
  • Set Orchestration Process status based on status of all tasks within the process.

Status setup involves two main activities

• Creating Status Values : Create Status Codes and designate where we want the status codes to be used. Example, we might want to allow Invoiced to be used for the fulfillment line status.

• Creating Status Conditions: Create If-Then conditions that designate when you want a status code to be used. Example: If the ship task status is Shipped, then use Shipped as the status of the Orchestration process.

Case 1: To create new status Values and assign it to Fulfillment Lines.

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter task “Manage Status Values“
• Under tab Status Codes-> Go to Actions -> click on Create and then add Status Code.

• Under tab Fulfillment Lines ->
  • Go to Actions ->
  • Click on Select and Add Status code ->
  • Search with either Status code or Display Name ->
  • Once Status code appears click on Apply ->
  • On top right corner click on Save and Close.

Case 2: To create new status Values and enabling it to pass through i.e. it can be used for Fulfillment lines and Task Types.

Step 1: Create Status Values

• Go to Others -> Setup and Maintenance -> Order Management -> Enter task “Manage Status Values” within this
  • Under tab Status Codes-> Go to Actions -> click on Create and then add Status Code
  • we need to enable Status values so it can be used under fulfillment lines.
  • Under tab Fulfillment Lines -> Go to Actions -> click on Select and Add Status code -> search with either status code or Display Name -> once status code appears click on Apply -> and on Top right corner click on Save and Close.
  • Under tab Task Types-> Select Task to which we want to associate Status Code. On Top section, scroll down to select Shipment. Under Bottom Section of Activity Go to Actions -> click on Add row-> Search status value created in previous Steps. Enter Split Priority and Click on Save and Close

Step 2: Use Status created in Step1 to map it to Task

• Go to Others -> Setup and Maintenance -> Order Management -> Enter task “Manage Task Status Conditions”
• Search for Shipment at top section by scrolling Down. Created in Step1.
• In lower section under Shipment Status Conditions -> Go to Actions -> click on Add row-> In Internal Status value search with either status code or Display Name -> In Display Status Value search with search with either status code or Display Name -> Once value is selected then select both the values and Mark as Complete -> And on top right corner click on Save and Close.

Step 3: Creating Orchestration Process Class

Orchestration Process Class holds all Status values which will be used in Orchestration. It gives the flexibility of grouping all custom defined status under one umbrella.

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Task “Manage Status Values” within this
• Under Orchestration Process Classes-> Click on Actions -> Click on Create -> Add Code with Name and Description
• Under Process Class Status Values -> Click on Actions -> add Status Code.
• Keep on adding Status Code in Process Class. After which on top right corner click on Save and Close

Step 4: Creating Custom Defined Statuses in Orchestration Process Definition.

• Navigation :Go to Others -> Setup and Maintenance -> Order Management -> Enter task “Manage Orchestration Process Definitions”
• Edit or Create New Orchestration Process Definition
• From drop down list, Select Process Class Created in steps “Creating Orchestration Process Class”

• Click on Status condition. Under Orchestration Process Status Values, Click on Actions -> Add

• Enter Sequence as 10, Status Values which was created in Step “Status Values”
• Click on Expression, Below screen appears. Since we are creating status for Shipping, select CustomDOO step which is meant for Shipping and then click on Insert into Expression link.

• Then click on necessary operators, next to Tasks Tab and choose “=”. We can manually type “=”
• Expand Custom DOO and then choose relevant Status. Click on Insert into Expression
• Finally we will have Expression “Ship” = “SHIPPED”.

• Repeat steps for all status which were created earlier.

Step 5: Setting Up Status for Fulfillment Lines

• Under Status Condition -> Fulfillment Line Status Values -> Click on Status Rule Set -> Copy Rule Set

• Click on Edit Rule Set, Below screen should appear

• Enter Value for Sequence. From drop down list Select custom defined Status Values.
• Click on Expression and follow same steps of adding Expression which was used in Orchestration Process Status Values.

Steps to Deploy Orchestration Process Definition

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Rules “Manage Orchestration Process Definition”
• Choose any Existing Orchestration Process to Edit
• After making changes to Orchestration process, go to Right Hand Corner. There is Action Button. Choose Action Button. Under Action Button, first click on Validate to verify error if any.

Under Action Button, then click on Release(release internally does Validation).

• We should get below message. No need to Download, simply click Cancel button.

• Under Action Button, Deploy button will get enabled. Click on Deploy.

• System will ask for user name and password along with Target Host and Port Number. Enter the details and click on “Deploy”.

• Orchestration process gets deployed successfully. In case if there is any error, we should see logs to verify the error.

• While Creating Order if we enter Packing Instruction if we enter Planning Orchestration id, it will be picked

Orchestration Process Assignment in Order Management, Oracle Fusion

After we submit an order, Orchestration process is assigned automatically to each fulfillment lines of the order.

• Below is the snapshot of Orchestration process getting assigned to each fulfillment lines. It could be possible that one Orchestration process gets assigned to multiple fulfillment lines.

Steps to Assign Orchestration Process

• Navigation: Setup and Maintenance -> Order Management -> Enter Rules(Manage Process Assignment Rules for Sales Order)
• Create a Rule to assign specific shipping Method for specific item
• Create a rule If Item(AssignLaunchRules.Order Fulfill Line) = “AS68004” then assign in Process section Process Name (AssignLaunchRules.Order Fulfill Line) “IS SET TO ” ShipOrderGenericProcess.
• Click Ok and Save and Close.

Orchestration Group

An orchestration group is a collection of fulfillment lines that Order Management, processes
together. Each orchestration group is a subset of a sales order. An assignment rule processes
each orchestration group at run time, so you must add a test that links each fulfillment line with
the group. The predefined assignment rules already include this test.

This gives flexibility to group fulfillment lines based on certain criteria which helps in saving cost of the organization.

If we take below example, due to unavailability of stock, Keyboard will not be delivered before Oct 15, but rest of items can be delivered by October 10th and 11th. If there would had been no grouping, all items would have got delivered on their respective scheduled dates, thereby incurring additional shipping cost.

But if Organization has set Grouping based on Shipment Set, despite order lines has different schedule date, they all get grouped and are shipped on October 15th, there by saving shipping cost for the organization.

What is Processing Constraint

Processing Constraints in Oracle Fusion regulate the changes that an order entry specialist makes on a sales order in Oracle Fusion Order Management Cloud. The controls can be of three types – Who, What and When:

1. Who:

Determines which users can make the said changes. This will depend upon the roles assigned to the user

Example: A person having custom role ATLANTA_ORDER_ENTRY_SPECIALIST cannot submit orders with Supply warehouse as SEATTLE Warehouse

2. What:

Determines on what field we have the constraint

Example: Constraint will apply if Warehouse Name is not “Atlanta”

3. When:

Determines the stage of order processing when the constraint should apply

Example: Constraints can apply when you Submit / Validate / Update etc an order

Components of Processing Constraint

1. Record Set:

2. Validation Rule Set:

3. Processing Constraint

4. Constraint Entity

How Processing Constraint Looks in Fusion

Steps to Setup Processing Constraint

Navigation for Processing Constraint.

• Go to Others -> Setup and Maintenance -> Order Management -> Enter Task “Manage Constraint Entities“

• In Entity Type search for View Entity and select Order Header Level. Take any field for which processing constraint needs to be enable and Check the box.

Step1: Processing Constraints Setup

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Task “Manage Processing Constraint”.

• Create a Record Sets -> Select Entity -> Order Fulfillment Line and Attribute Name(Order Line ID) and Click Save

• Create Validation Rule Sets
  • Select Validation Type as “Table”
  • Entity as “Order Fulfillment Line”
  • Go to Details section and in Attribute Name give “Status”.
  • Valid Operations = “Equal to”
  • Value String = “Awaiting Shipping”
  • Click on Save and Generate Packages

• We should see Confirmation Message after Generation of Packages.

• Create a Constraint
  • Constraint Name = ” SHIPPING CONSTRAINT”
  • Display Name =” SHP01″
  • Constraint Entity = “Order Fulfillment Line”
  • Constraint Operation = “Update”
  • Attribute Name = “Order quantity”
  • Ensure Enabled is Checked
  • Under Details section
    • Group Number = “10”
    • Validation Entity = “Order Fulfillment Line”
    • Validation Rule Set = “Shipping VRS 01” -> What we created at Validation Rule Set
    • Record Set = “Fulfillment Line” -> What we created at Record Sets
    • Message = “The Fulfillment Line wasn’t updated because it is Awaiting Shipping”.

• Under SHIP01 Details, Choose Applicable Roles is set to “All Roles”. Click on Save and close

Step2: Application/Testing of Processing Constraint on Order.

• Create Order and setup QTY to 1 and Submit the order

• Once Order gets submitted, wait till it status changes to “Awaiting Shipping”
• Create Revision of Order. Order changes to Draft Status.

• Try changing the Qty from 1 to 2

• Processing constraint will come into effect and will prevent order Qty to be changed. Error Message setup in Processing Constraint will display and QTY automatically changes from 2 to 1.

• In case we want to disable above applied Processing constraint, uncheck Enabled field at the Header level not the one at Detail level.
• Click on Save and then Generate Packages.

• If Header level has more than one constraint entries at detail level and we want to retain one detail level constraint but disable other then in such case we will uncheck Enabled field for that detail line which we do not want to keep and then click on Generate package. Do ensure Enabled field remains checked at Header level.

Pre-requisite : Refer link to create/understand BI Fusion Report from Scratch

https://wordpress.com/post/ravidubey.work/372

Below steps explain how to create parameterized BI report

Step 1: Create New DATA MODEL

1. Go to Menu Option New
2. Select Data Model
3. Click on + Icon
4. Select SQL Query
5. Create a Data model with SQL query

• Save as Sample Data  which needs to be used by Report when creating report from Instance

• Export the data and perform steps 2 and 3 of Report Generation from below link

https://wordpress.com/post/ravidubey.work/372

• Below Report appears.

Step2 : Save the Path of your BI report. It will be used to Setup job

https://adc2-zspy-fa-ext.oracledemos.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FRavi%20Test%20Folder%2FXXLT_Item_File4_ReportActual.xdo&path=%2Fshared%2FCustom%2FRavi%20Test%20Folder%2FXXLT_Item_File4_ReportActual.xdo

From Hyperlink of your BI report, copy path starting after Path=. So for my case, path to be copied is what is shown belo

%2FCustom%2FRavi%20Test%20Folder%2FXXLT_Item_File4_ReportActual.xdo&path=%2Fshared%2FCustom%2FRavi%20Test%20Folder%2FXXLT_Item_File4_ReportActual.xdo

Step3 : Setup the Job Definition

• Navigation : Go To Setup and Maintenance -> In Order Management Search for task “manage%Enterprise%Financial”

• Click on “+” button to create new Job Definition.

• Fill Details as shown below for setting up Job Definition
• BI Path copied in Step2 will be used in Report ID section.

• In case it is Parameterized Report, click on Tab “Manage List of Value Sources” and Enter Values

• Click on + symbol to create parameters for Job

• Enter Values as shown below and Click on Save and Close or Save and Create Another  Parameters in case we have multiple parameters.    

• Once Parameter created, Click on Save and Close of Job Definition

Step4 : Run the Job

• Navigation : Go to Tools-> Schedule New Processes and Enter your Job Definition Name

• Click on Okay, below screen appears

• On clicking Submit Button, Job Gets submitted and Output can be seen in Log of Job in PDF form.

Business can request for scrutiny of orders coming from specific system into Oracle Order Management. It can even request for extra pair of eyes for “High Value transactions” and request for Order Approval process to be in place.

Step1: Enable Order Approval Flow

• Navigation :
  • Go to Setup and Maintenance. Choose Order Management
  • Search for Task “Manager Order Management Parameter”

• Click on “Start approval process for Sales Order”. It Indicates whether approvals need to be initiated for orders from a given source order system.
• Select Source Order System. In Start Approval Process for Sales Orders value should be “YES”.
• In Source Order System we can have one set of system or multiple for which we want to start approval process i.e. we can only limit approval process for all orders coming from Legacy system.

Step2: Designing Order Approval Flow

• Navigation: Go to Others -> Setup and Maintenance -> Order Management -> Enter Task(Manage Order Approval Rules)

• Create Rule If Order Total Amount is Greater than $10,000 and Customer is “ABC Application Software”

• Based on above criteria, click on Then -> Action and assign a approval process. It can be assigned to Single Person or to a Group. See Step 4 if it is assigned to Approval Group.

Complete Order Approval Process Condition should look like below

Step3: Click on Activate to activate the rule with Effective Dates(Start and End) .

Step4: Create Approval group using Task (Manage Approval Groups)

In case we setup

• Extensible Flex Fields are set of Placeholder fields associated with Business Objects.
• It appear on Application Pages to contain additional data.
• It is used to
  • Modify Business Objects and Meet enterprise Data management requirements without changing the data model or performing database programming
  • Capture different data on the same database table
  • Modify features of the application
  • Integrate Order management with another application by capturing one or more attributes from other application.

• Navigation -> Go to Others -> Setup and Maintenance -> Order Management -> Enter task(Manage Order Extensible FlexField).

• In Module enter “Process order” and click on Search.

• Select flexfield, “Fulfillment Line Detail Information” and click on Actions -> Edit.

• Once edit screen appears, on right side, click on Manage Contexts.

• On Manage Contexts screen, click on Actions -> Create

• Context Page Navigation.
  • Enter Display Name, Select Behavior as Single Row or Multiple Rows. Multiple Rows should have one unique Key check box enabled.
  • Under Context Usages Click on create-> Select Additional Line Information from drop down.
  • Click on Save.
  • Under Context Sensitive Segments click on Create -> It will take us to Create Segment Page.
  • Create Segment page Navigation.
    • Enter Name. Do not enter Code and API name, it should get populated by default
    • Enter Data Type -> Table Column will get populated by Default Validation -> Value Set -> you can create Value set or select from existing list

• Under Context Sensitive Segments, Click on Actions -> Create.

• Segments represents attributes of Entities(Business Objects).
• Context are groups of attributes.
• Value sets are set of valid values which are assigned to a flexfield segment.
• On Segment Page, Enter Following details for Segment
  • Name = “Item Type”
  • Code and API Name will get populated by default
  • Choose Data Type = Character
  • Table Column = ATTRIBUTE_CHAR1
• Click on Save and then click on Create Value Set

• Click on Create Value Set -> Enter following
  • Value Set code
  • Enter Module = Process Order
  • Validation types = Choose between following
    • Format Only = “Free Text instead of selecting values from the dropdown list”.
    • Independent = These are free form of valid values.
    • Dependent = A valid values in a list of values derived from the independent value of another segment.
    • Subset = The list of values is a subset of the values in an existing independent value set.
    • Table = The values derive from a column in an application table, which can optionally be limited by a WHERE clause.
  • Value data type = Either Number or Character.
• Click on Save
• To enter default values click on Manage Values at Top Right corner and add values

• On Manage Values Page -> Click on Actions -> select “Create”.
• Enter Value sets values and Description.

• On Manage Values page, click on Save and Close. It will take us to Create Segment page. On Create Segment Page Click on Save and Close.

• New Context Line “Item Type” gets added. Click on Save and Close.

• After reaching to “Edit Extensible Flexfield” page
  • Click on Actions of Associated Contexts under Additional Line information and click on Select and Add
  • Search for your line context and click on Apply and OK
  • Click on Save

• Click on Pages tab under Additional Line information and click on Create under Actions
  • Create Page will get displayed
  • Enter Display Name , Usage enter Additional Line Information -> click on Save and close

• Under : Associated Contexts Details section, click on Select and Add -> Search for Name of Context and click on Apply and Add.

• On Manage Order Extensible Field main Page, select Line Information and click on Deploy FlexField. In case we have made many changes, its advisable to choose Deploy Offline.

• Deployment process

• We should see Deployment is successful Message.

• Run Job “Publish Extensible FlexField Attributes” to make this change available on Order management screen

• Go To Order Management. At Line level, Click on Additional Information. We should be able to see our new EFF created.