[go: up one dir, main page]
Scribd
Upload
2K views4 pages

Inventory - Transaction - Document 2608989.1

The document provides instructions for creating inventory transactions using File-Based Data Import (FBDI) in Oracle Fusion Inventory Management. It includes templates and steps for creating subinventory transfers and intransit shipments using FBDI. It also describes how to enter inventory transaction costs and import the loaded CSV file.

Uploaded by

Sai Ram
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views4 pages

Inventory - Transaction - Document 2608989.1

The document provides instructions for creating inventory transactions using File-Based Data Import (FBDI) in Oracle Fusion Inventory Management. It includes templates and steps for creating subinventory transfers and intransit shipments using FBDI. It also describes how to enter inventory transaction costs and import the loaded CSV file.

Uploaded by

Sai Ram
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Copyright (c) 2020, Oracle. All rights reserved. Oracle Confidential.

Create Inventory Transaction Using FBDI (File-Based Data Import) (Doc ID 2608989.1)

In this Document

Goal
Solution
References

APPLIES TO:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

GOAL

Environment Version: 11.13.19.07.0 | 19C


Environment: TEST
Product: INV MGMT > INV TRX > FBDI

Problem Description | Question:


---------------------------------------------------
User cannot create Inventory transaction using File-Based Data Import. The template is as below:
https://docs.oracle.com/en/cloud/saas/supply-chain-management/19b/oefsc/inventory-and-cost-
management.html#inventorytransactionimport-3012

How do you successfully create a transaction using the above for Subinventory Transfer and Intransit Shipment?

Describe the Issue in Detail:


---------------------------------------------------
Steps to Reproduce:
1) Download FBDI Template
2) Complete template and create CSV File
3) Load Interface File for Import
4) Create Inventory Transactions
5) Manage Inventory Transactions

SOLUTION

Environment Version: 11.13.19.07.0 | 19C


Environment: TEST
Product: INV MGMT > INV TRX > FBDI

Solution | Answer:
---------------------------------------------------
Using the following link: https://docs.oracle.com/en/cloud/saas/supply-chain-management/19c/oefsc/index.html download
Inventory Transaction Import Template.

Direct link template: https://docs.oracle.com/en/cloud/saas/supply-chain-management/19c/oefsc/inventory-and-cost-


management.html#inventorytransactionimport-3012

Steps to Implement the Solution


---------------------------------------------------
FBDI for Subinventory Transfer
----------------------------------------------
Complete the following columns:

A: Organization_Name
F: Process_Flag (Must be: 1)
H: Item_Number
I: Revision
K: Subinventory_Code
AG: Transaction_Quantity
AH: Transaction_UOM
AK: Transaction_Date (Format: YYYY/MM/DD HH:MM:SS - Example: 2019/10/16 03:00:00)
AL: Transaction_Source_Type_Name (Example: Inventory)
AM: Transaction_Type_Name (Must be: Subinventory Transfer)
AP: Transfer_Subinventory
BK: Primary_Quantity
BO: Source_Code
BP: Source_Header_ID
BQ: Source_Line_ID
CX_Transaction_Mode (Must be: 3)
CY: Lock_Flag (Must be: 2)
ET: Shipment_Number
EX: Expected_Arrival_Date (Format: YYYY/MM/DD)
IP: Use_Current_Cost (Either Y or N, If N, complete Tab: CST_I_INCOMING_TXN_COSTS)

FBDI for Intransit Shipment


----------------------------------------------
Complete the following columns:

A: Organization_Name
F: Process_Flag (Must be: 1)
H: Item_Number
I: Revision
J: Inv_LotSerial_Interface_Num
K: Subinventory_Code
AG: Transaction_Quantity (Quantity must be a negative integer. Example: -9)
AI: Transaction_Unit_Of_Measure
AK: Transaction_Date (Format: YYYY/MM/DD HH:MM:SS - Example: 2019/10/16 03:00:00)
AL: Transaction_Source_Type_Name (Example: Inventory)
AM: Transaction_Type_Name (Must be: Subinventory Transfer)
AO: Transfer_Organization_Name
AP: Transfer_Subinventory
BK: Primary_Quantity
BO: Source_Code
BP: Source_Header_ID
BQ: Source_Line_ID
BR: Transaction_Source_Name
CX_Transaction_Mode (Must be: 3)
CY: Lock_Flag (Must be: 2)
CZ: Transaction_Reference
DA: Reason_Name
ET: Shipment_Number
EX: Expected_Arrival_Date (Format: YYYY/MM/DD)
IP: Use_Current_Cost (Either Y or N, If N, complete Tab: CST_I_INCOMING_TXN_COSTS)

**NOTE** - Columns on the template that has * in front of the Column Name (For Example: *ORGANIZATION_NAME) are
mandatory fields.
Entering Inventory Transaction Costs
-------------------------------------------------------
"When entering inventory transactions, users must determine how item costs are associated with an inventory transaciton line.
The mandatory column USE_CURRENT_COST allows users to indicate whether they want to use the current item cost or enter
item cost by component. If you intend to use the current item cost, the value 'Y' must be selected for the column
USE_CURRENT_COST. If you intend to enter the item cost by component, the value 'N' must be selected for the column
USE_CURRENT_COST. The value 'NULL' is not an accepatble value and the tansaction will not be processed.

The following steps are required to enter a cost for an inventory transacation:

1) The first step is to detrmine whether you want to use the current item cost or enter item cost by component for the
transation line. This selection is required.
2) The madatory column USE_CURRENT_COST is used to indicate if you intend to use the current item cost or enter item cost
by compoonent. The value 'Y' indicates your intent to use the current item cost in the system. The value 'N' indicates your
intent to enter the item cost by component in the CST_I_INCOMING_TXN_COSTS worksheet. This column is mandatory and a
'Y' or 'N' value must be selected. NULL is not a valid selection.
3) Enter a value in the column TRANSACTION_COST_IDENTIFIER in the INV_TRANSACTIONS_INTERFACE worksheet. The
value entered in this column will be used to link the associated cost entered in the CST_I_INCOMING_TXN_COSTS worksheet.
For example, if you enter value 100 for the TRANSACTION_COST_IDENTIFIER the same value must be entered in the
CST_I_INCOMING_TXN_COSTS worksheet.
4) Enter the same value from Step 3 in the TRANSACTION_COST_IDENTIFIER column in the CST_I_INCOMING_TXN_COSTS
worksheet. The value entered in this column will be used to link the associated transaction in the
INV_TRANSACTIONS_INTERFACE worksheet.
5) To enter multiple cost components for a single inventory transaction, repeat the TRANSACTION_COST_IDENTIFIER for
each unique COST_COMPONENT_CODE.
6) Ensure a valid value is entered for the column COST_COMPONENT_CODE. The valid values for COST_COMPONENT_CODE
include the following:
- ITEM_PRICE
- NONRECOVERABLE_TAX "

After all of the information has been entered, go back to the Instructions and CSV Generation Tab. Select 'Generate CSV File'
and save the file. Next please conduct the following instructions:

Importing the Loaded Data


--------------------------------------------
1. Navigate to the Scheduled Processes UI (under Tools).
2. Click on Schedule New Process, then Search and Select 'Load Interface File for Import', Click OK
3. Process Details appears
4. Import Process: Search and Select ' Create Inventory Transactions'
5. Data File: Click on Drop-down Menu and Select 'Upload a new file'
6. Click on 'Choose File', then Select the CSV File you generated and Click 'OK' and Select 'Submit'
7. If the submitted process ends in error or warning, review the log file for details about the rows that caused the failure.

After you successfully load your data, you must submit the Manage Inventory Transactions process to import the data into the
application tables.
----------------------------------------------

To submit the Manage Inventory Transactions process:


1. Navigate to the Scheduled Processes UI (under Tools).
2. Click on Schedule New Process and select 'Manage Inventory Transactions'.
3. Monitor the process in the Scheduled Process UI.
4. If the submitted process ends in error or warning, review the log file for details about the rows that caused the failure.

To correct import errors:


1. Click on Manage Pending Transactions task in the Inventory work area.
2. Click on View Pending Transactions.
3. Query the records by specifying appropriate Search criteria.
4. Review and correct the errors.
5. Once all the errored rows are corrected, click 'Add All to Process Schedule'.
6. Repeat the submit and error correction steps in this section until all rows are imported successfully.
REFERENCES

NOTE:2222018.1 - Fusion INV: "The quantity entered for the transaction is invalid" While Importing Miscellaneous Issue
Transaction Through FBDI
Didn't find what you are looking for?

You might also like