Oracle Fusion: How to Create Inventory Sub-Inventory Transfer Transaction

Subject: Business required to move on-hand stock from one sub inventory to another sub-inventory for that we need to create a sub-inventory transfer.

--Item Details--

Item Code: 04081006.1

Organization: DHY

Sub-Inventory1: C1-R2-150-A-G05

Sub-Inventory2: C2-R2-170-A-G09

Let me check the Item stock before creating the transaction against both sub-inventory.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on the right-side panel Task Button > Show Task "Inventory" > Manage Item Quantities.

Sub-Inventory1: G05
Locator: C1-R2-150-A-G05

QTY: 11

Sub-Inventory2: G09

Locator: C2-R2-170-A-G09 

QTY: 8

Let's create the sub-inventory transfer from G05 to G09

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management > Select Task > Show Task "Inventory" > Create Subinventory Transfer.

Enter all the required details.

Date: It must be within the open inventory accounting period.

Type: Subinventory Transfer

Item: 04081006.1

--Source--

Sub-Inventory: G05
Locator: C1-R2-150-A-G05

--Destination--

Sub-Inventory: G09

Locator: C2-R2-170-A-G09 

Qty: 1

Reason: Stock Pick

After entering all the details click on Submit button. 

Now let's check on hand in both sub-inventory locators.

Click on the right-side panel Task Button > Show Task "Inventory" > Manage Item Quantities.

Sub-Inventory1: G05
Locator: C1-R2-150-A-G05

QTY: 10

Sub-Inventory2: G09

Locator: C2-R2-170-A-G09 

QTY: 9

Sun-inventory transfer transaction completed successfully. 

Oracle Fusion: How to create Miscellaneous Transaction to add item on-hand stock

Subject: We need to create onhand for items using Oracle Fusion Miscellaneous Transaction Screen.

Let me check the Item stock before creating the transaction.

--Item Details--

Item Code: 341-01-0018

Organization: JV2

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on the right-side panel Task Button > Show Task "Inventory" > ManageItem Quantities.

Search with Item Code and Organization.

We can see that Item having Onhand Quantity 100.

Let's Increase the onhand Quantity using Miscellaneous Transaction.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management > Select Task > Show Task "Inventory" > Create Miscellaneous Transaction

Entered highlighted all Details. Must take care date within Open Inventory Accounting Period

Type: Miscellaneous Receipts

Account: Inventory Material Account

Use Current Item Cost: Yes

After entering all these details, click on edit details.

We must be required to enter the serial numbers for serialized Items. 

After entering the serial number click on Ok.

Now Click on Submit.

Miscellaneous Transaction Created successfully.

Let's Check the Onhnad for the same Item again.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on Task Button > Show Task "Inventory" > ManageItem Quantities.

Search with Item Code and Organization.

We can see that Item having an Onhand Quantity of 250.

Onhand created successfully.

Oracle EBS - How to upload bulk Material Transaction Reason

Subject: How to upload bulk Material Transaction Reason in Oracle EBS.

Pre-requisite: We need to store Reason Name and Description fields Values in a temporary table for bulk data.

EBS Navigation: Iventory > Setup > Transactions > Reasons

--Base Table:-- MTL_TRANSACTION_REASONS

--PLSQL Scripts--

DECLARE

    v_rowid   NUMBER;

    v_rowid1  VARCHAR2(1000);

BEGIN

    fnd_global.apps_initialize(user_id => 25665, resp_id => 52895, resp_appl_id => 0);

    fnd_msg_pub.initialize;

    FOR i IN (

        SELECT

            *

        FROM

            temp_lookup_tbl

        WHERE

            lookup_type = 'MTL_TRANSACTION_REASON' 

--                and MEANING in ('PS-Metallicplate of switch-127','PS-Metallicplate of switch-159')

--                and rownum=1

    ) LOOP

        INSERT INTO mtl_transaction_reasons (

            reason_id,

            last_update_date,

            last_updated_by,

            creation_date,

            created_by,

            last_update_login,

            reason_name,

            description,

            attribute2,

            reason_type,

            reason_type_display

        ) VALUES (

            mtl_transaction_reasons_s.NEXTVAL,

            sysdate,

            - 1,

            sysdate,

            - 1,

            - 1,

            i.meaning,

            i.description,

            i.org,

            8,

            'QA Update Status'

        );

    END LOOP;

    COMMIT;

END;