Comparison of using the Inventory Balance Message Import and Inventory Transaction Import Template for on hand Migration

 
Pros and Cons of the Using the Template for on hand migration 

Errors and Resolutions for oracle fusion cloud SCM Workarea

 Calendar Code is not Valid. 

error : while you run collection and sub process is completed in warning and found schedule is invalid  for org assigned 

Reason:

Check Schedule and make sure  workday pattern ensuring that the - length in days - field = 7

common mistake is no of days working is 5 and length of days given as 5 and oracle will not stop from processing. 

Solution : Always the  length in days - field = 7 

make sure the Schedule is changed in Inventory org as well as Mfg parameters.

GOP: How to Create a Calendar used by Order Management and Global Order Promising (GOP) (Doc ID 2204151.1)

************************************************************************

How to Process Transactions That Are In "Ready to be processed" Status in pending transactions

 

If you are using Inventory Balance Message import

 

The transaction was not added because it was not ready for processing, was already in the process schedule, was locked, was not in confirmed status, or was updated by another user",

proceed to run the transaction manager to process the transactions using the steps provided below:

 

Run the "Manage Inventory Transactions" ESS job to process the inventory interface rows.

 

1) Go to "Scheduled Processes"

2) Click on the "Schedule New Process" button

3) The popup will appear and in the name field search for "Manage Inventory Transactions".

Select that job and submit the process.

4) This will then process all of the interface rows that are ready to process.

 

 

This should have processed the transactions selected above.

If there are transactions that are still not processed, manually run the "Create Inventory Transactions" ESS job to process the inventory interface row.

 

1) Go to "Scheduled Processes"

2) Click on the "Schedule New Process" button

3) The popup will appear and in the name field search for "Create Inventory Transactions".

Select that job and provide the 'Transaction Header ID' from 'View Pending Transactions' UI and submit the process.

4) This will then process all of the interface rows that are ready to process.

 ********************************************************************************

 

 

 

Inter company transfer pricing and Supply chain financials orchestration

In this post we will have overview on the transfer pricing is applicable on the inter company transactions

A single physical movement of goods may involve multiple transfers of ownership

example : to achieve post tax revenues, lower cost and customer responsiveness
if we have sales order is created in US Business unit and  Singapore as Sales office and manufacturing unit as China BU.

goods physical movement from china BU to  customer in USA

Sales invoice by US BU,  Inter company invoice by China BU to Singapore BU, Singapore BU to USA BU

4 ways of doing business

1. Global Procurement

Supplier  send goods to ORG B
Sold BU as ORG A
Receiving BU as ORG B
internal invoice between ORG A and ORG B

2. Internal Material Transfer

Material Movement from ORG A to ORG C
Inter company invoice from ORG A to ORG B
Inter company invoice from ORG B to ORG C

3. Internal Drop Shipment 

Shipping BU Org A
Selling BU Org B
Ship goods from ORG A to Customer
Invoice to Customer from org B
Inter company invoice between Org A and Org B

4. Drop shipment  with shipment and procurement


Supplier ship goods to Customer
Sold BU Org A ( makes supplier payment )
Receiving and shipping BU as Org B
Selling BU Org C Invoice to Customer
Inter company invoice between Org A and Org B , Org B and Org C

Transfer pricing configuration 

1.  Static  mark up percentage based on transaction cost  or source document price 

--- Use the task : manage Transfer Pricing

Markup percentage : numeric value

--Accounting transfer price - Transaction cost basis, Source document price

Select the rule in the the supply chain financial orchestration Flow

Functional orchestration Qualifier 

usage is based on the parameter we can  set the markup percent

parameters
Item
Ship from org
Ship to Org
User item type
item class
destination type etc.

based on the qualifier we can have the Transfer pricing rule

2. Pricing Strategy  -- using Price list , using tier based discount, transaction Attribute of item, Source document price  markup or discount 


Create Pricing strategy  with any user defined name
using the pricing strategy assignment
select as below

Assignment level : Line
Context  - Material Transfer
Pricing Strategy - for a set of condition

Select Pricing Strategy option in the transfer pricing rule, Aggrement type : internal Material  for the financial orchestration flow.

While defining the price of the item in the price list we can select the calculation method

Source document Cost :  and we can add the markup or the discount to be applied

Cost -- then we need to upload the cost price in the pricing strategy  for all the items
Note : we can not copy cost  of the item to the price list  may be used for Standard item and not supported for actual cost  / average cost

Price -- then taken as the cost for the transfer price  in the price list

using the manage pricing algorithm

name : Price material transfer  -- we can achieve the   below quantity based / attribute based etc.

we can use qty based tierd based discount
or item based attribute for the transnational attributes enabled  ex: color of the shirt




3. Third party Pricing Service -  Derive transfer price using the external service  by using custom web service using client security policy

Task: Register Financial Orchestration Third Party Transfer Pricing Service  using URL and the Security Policy



Transfer Pricing Currency
Create Document and accounting rule

Currency Option : Selling node, Buying node, Source Document