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;

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

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

Let me check the Item stock before creating the transaction.

Let's create Miscellaneous Transaction to add on hand for this item.

Navigate to Inventory Responsibility > Transactions > Miscellaneous Transactions

Enter the details.

Enter the all details.

Let's check on hand.

Onhand created successfully.