Concurrent Programs

In-Memory Cost Management Concurrent Programs

In-Memory Cost Management uses the following concurrent request programs:

• Create Product Category Hierarchy (In-Memory Cost Management

• Create Territory Hierarchy (In-Memory Cost Management)

• Create Time Dimension (In-Memory Cost Management)

• Incremental Margin Load

• Purge Margin Data

• Purge Simulations

• Simulation Margin Load

• Write Back Simulation to EBS

Create Product Category Hierarchy

This concurrent program creates the setup data used for Gross Profit Analysis dashboard. It considers the item category flexfields defined in the system and creates the hierarchy for the categories.

Note: Only categories defined under the category set attached to the functional area Cost Management are used in Gross Profit Analysis. The category information for an item is taken from the item master organization.

Run this program after product installation, after new categories are created, categories are changed, or the category assignment of items is changed.

Create Territory Hierarchy

This concurrent program creates the setup data to be used for Gross Profit Analysis. It considers the territory flexfield defined and creates the hierarchy for the territory.

Run this program after product installation and after territories are created or changed.

Create Time Dimension

This concurrent program creates the setup data for the Gross Profit Analysis dashboard. It uses general ledger periods and creates the time dimension required for reporting in Profit Analysis.

Run this program after product installation, each time new periods are opened, and when the calendar is changed.

Loading Incremental Margins

Incremental Margin Load Programs

There are two concurrent programs for incremental margin load, one for Discrete and one for Process manufacturing:

• Incremental Margin Load (In-Memory Cost Management)

• Incremental Margin Load (In-Memory Cost Management) for Process Manufacturing

These programs collect the data for actual costs; and incrementally load data from Accounts Receivables, Accounts Payables, Inventory, Order Management, and Cost Management - to gather the actual COGS and invoiced information for shipped and invoiced sales orders. They also gather data for sales orders that are open and booked - but not yet shipped or invoiced, data for newly created items and customers. These programs must be run to use the following functions:

• Simulation Margin Load concurrent program.

• Calculate Gross Profits in the Cost Impact Simulation page.

At completion, the programs launch a child concurrent request - Incremental Margin Load for Planned Orders ll imports all the data from the Planned Order Interface, see: Incremental Margin Load for Planned Orders Interface

Schedule the programs to run on a periodic basis to have the information needed for accurate simulations. Set the profile option CMI: Incremental Margin Load Start Date to set the date used for the concurrent program's first run. See: Profile Options.

Chronological Considerations for Profit Analysis Display

• Invoice Quantity and Invoice Amount values are populated after the Invoice Import and Revenue Recognition programs in Accounts Receivables are run. Launch these programs prior to launching the Incremental Margin Load program. Otherwise, COGS and Shipped Quantity values display as Null on the Profit Analysis dashboards.

• After running the Interface Trip Stop-SRS process in Shipping Execution, ensure that the Workflow Background Process is successfully completed prior to launching the Incremental Margin Load concurrent program.

To launch incremental margin load

1. Navigate to the Incremental Margin Load request program.

2. When the Request window appears, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.

Purging Margin Data

Purge Margin Data Concurrent Request

The Purge Margin Data program is used to purge collected COGS and revenue data in the fact tables and dimensions. Fact tables contain various measures, attributes of measures, and foreign keys that connect the fact table and the dimension tables. Dimensions contain attributes for items such as time, organization, and customer. This data is collected by the Gross Profit Analyzer to calculate the margins that are displayed in the multiple dashboards.

To launch the Purge Margin Data program

1. Navigate to the Purge Margin Data request program.

   The Request and Parameters windows appear.

   

2. In the Parameters window, select a Purge Mode. Choices are:

   • Purge Facts and Dimensions

   • Purge Facts Only

3. If you select Purge Facts Only, select values for the following parameters. Choices are:

   • Organization Type: Discrete, Process, or Both

   • Fact Type: Actuals, Simulation, Actuals and Simulations

4. If the Purge Mode value selected is Purge Facts Only, and the Fact Type value is Simulation, select a Simulation Code.

   Simulation Codes appearing are codes where the Simulation Margin Load or Calculate GPA programs have been executed.

5. Choose OK.

6. On the Request window, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.

Purging Simulation Records

Older cost simulation records can be purged and deleted from your system. You can only delete one record at a time.

Purge Simulation Concurrent Request

To purge cost simulation records

1. Navigate to the Purge Simulation request window.

   

2. When the Parameters window appears, enter the Simulation Code value you want to delete from the system.

3. Choose OK.

4. When the Request window appears, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.

Simulation Margin Load Programs

There are two simulation margin load programs: Simulation Margin Load and Simulation Margin Load for CIS Impacted Items.

Simulation Margin Load

The Simulation Margin Load concurrent program uses the actual cost information to create the simulated comparison data. The calculation is used in the Gross Profit Analysis and Impact on Gross Profit dashboards. After entering the Cost Type:

• The program calculates the simulated COGS and simulated margins based on the costs defined in that cost type.

• If the costs do not exist in the cost type specified, then the program attempts to get the cost from the default cost type specified.

• If the default value does not exist, then the simulated COGS is defaulted as actual COGS.

Set the profile option CMI: Number of Months for Simulated Margin Load to the number of months to be used in the concurrent program, see: Profile Options.

To launch simulation margin load

1. Navigate to the Simulation Margin Load request program.

   The Request window and Parameters window appear.

   

2. In the Parameters window, select a Cost Type value.

3. Choose OK.

4. On the Request window, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.

Simulation Margin Load for CIS Impacted Items

This concurrent program is an option for the background calculation process required for viewing the Gross Profit Analysis and Impact on Gross Profit dashboards. It can be used in instances when the program fails after selecting Calculate GPA in the Cost Impact Simulator. The program uses the actual cost information to create the simulated comparison data for impacted items.

To launch Simulation Margin Load for CIS Impacted Items

1. Navigate to the Simulation Margin Load for CIS Impacted Items request program.

   The Request and Parameters windows appear.

   

2. In the Parameters window, select a Simulation Code value.

3. Choose OK.

4. On the Request window, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.

Write Back Simulation to EBS

In-Memory Cost Management supports multiple Oracle E-Business databases by pulling data from, and importing the calculations back into each instance. The Write Back Simulation to EBS concurrent request is used to bring back selective simulation data from Memory Cost Management to E-Business products

After completing real-time data synchronization for your data, this concurrent process is run for a given simulation code to bring specific simulation data and cost information from In-Memory Cost Management. The program parameter accepts only one simulation code value as input. After performing all relevant validations, it writes back the simulation data from In-Memory Cost Management to E-Business.

For more information, see: Oracle In-Memory Cost Management Installation and Configuration Guide, Note Number 1632072.1 on My Oracle Support (support.oracle.com)

Write Back Simulation from to EBS Concurrent Request

To launch the Write Back Simulation to EBS program

1. Navigate to the Write Back Simulation to EBS request program.

2. The Request and Parameters windows appear.

3. In the Parameters window, select a Simulation Code value.

4. Choose OK.

5. On the Request window, choose Submit.

   The Request ID appears in the Decision window. You have the option to submit another request.