Oracle Fusion - Transfer Order End To End Process.

Transfer orders can be used to move orders from one organization to another. This process is similar to an inter-organization transfer but includes the handling of in-transit goods. It involves documentation, including the pick and ship process. In contrast, an inter-organization transfer does not include the pick and ship process in its workflow.

Create Transfer Order: 

1. Access Supply Chain Execution.
2. Select Inventory Management.
3. Under Inventory Tasks, select Manage Item Quantities.
4. Select the target organization.
5. Select the item number for which you want to raise a Transfer Order (TO) and search.
6. Under Actions, select Request Transfer Order.
7. The Create Supply Request page will open with the selected item.
8. Provide the quantity, delivery date, and select the supply details action.
9. Provide the source organization.
10. Submit the request.
11. This will create the Transfer Order.
12. Go back to Inventory Tasks and select Manage TO Task.
13. Sort by date and note the transfer order number.
14. Line status will be in Open and Fulfillment Status will be in Awaiting Fulfillment. 

Create Pick Wave :

We can release the pick wave only under the source organization.

1. Change the organization to the source organization.
2. Go to Picks Task and select Create Pick Wave Task.
3. Select Order Type as Transfer Order and provide the order number.
4. Remove all the dates.
5. Click the Submit Release Now button.

Confirm Pick Slip : 

1. Go to Picks Task and select Confirm Pick Slip Task.
2. Provide the transfer order in the search field and click the Search button.
3. Select the displayed pick slip number.
4. Select the checkbox, provide the pick quantity, and click the Submit Confirm button.

Ship Confirmation: 

1. Go to Shipments Tasks and select Manage Shipment Task.
2. Provide the transfer order number and click Search.
3. The shipment details page will be displayed.
4. Provide the shipped quantity and click the Submit Ship Confirm button.

Receipt Items at Destination. 

1. Go to Receipts Tasks and select Receive Expected Shipments Task.
2. Change the organization to the destination organization.
3. Provide the transfer order number in the search field and click Submit.
4. Select the line and click the Receive button at the top of the line.
5. The Receive page will open. Provide the received quantity and sub-inventory.
6. Click the Submit Create Receipt button.

Oracle Fusion Queries

Query to get Value Set Values - GL Segments. 

SELECT segvalsets.value_set_code             ,
value                                       ,
segvals.description                      ,
enabled_flag                                ,
start_date_active                           ,
end_date_active                             ,
summary_flag                                ,
flex_value_attribute1 AS POSTING_ALLOWED    ,
flex_value_attribute2 AS BUDGETING_ALLOWED  ,
flex_value_attribute3 AS ACCOUNT_TYPE       ,
flex_value_attribute4 AS CONTROL_ACCOUNT    ,
flex_value_attribute5 AS RECONCILIATION_FLAG,
flex_value_attribute6 AS FINANCIAL_CATEGORY
FROM fusion.fnd_vs_values_vl segvals,
fusion.fnd_vs_value_sets segvalsets
WHERE segvals.value_set_id = segvalsets.value_Set_id
AND segvalsets.value_Set_id IN
(SELECT value_set_id
  FROM FUSION.fnd_kf_segment_instances
 WHERE structure_instance_id IN
 (SELECT fusion.fnd_kf_str_instances_b.structure_instance_id
    FROM FUSION.fnd_kf_str_instances_b
   WHERE application_id =101
 AND key_flexfield_code = 'GL#'
 )
)

flex_value_attribute3 AS ACCOUNT_TYPE  - Mapping

A	Asset
C	Budgetary credit
D	Budgetary debit
E	Expense
L	Liability
O	Owners' equity
R	Revenue

Oracle Fusion - Errors and Solutions

Sales Order Creation Error1 - SourceTransactionLineNumber 1, SourceScheduleNumber 1: The request couldn't be completed because either it doesn't include a value for the TaxClassificationCode attribute, or the value of XXXXXX that it does provide isn't valid.

Solution:  Go to Setup and Maintenance -> Search for "Manage Tax Lookup Codes" --> Search for the following Lookup Code "ZX_OUTPUT_CLASSIFICATIONS"  -->  Add the missing XXXX value , select Common set as a reference data set.  

Use the following Lookup codes for the respective entities. 
ZX_INPUT_CLASSIFICATIONS = Payables
ZX_OUTPUT_CLASSIFICATIONS = Receivables / Sales Orders
ZX_WEB_EXP_TAX_CLASSIFICATIONS = Expenses

Sales Order Creation Error2 - SourceTransactionLineNumber 4, SourceScheduleNumber 4: The request to add an order line failed because fulfillment isn't set up to supply item 1234567777 from warehouse 1234456778. Select another warehouse.

Solution:  Check the item configurations in PIM and make sure the item is associated with the proper inventory organization.