INV Transaction Upload

INV Transaction Upload Help

INV Transaction Upload creates Oracle Inventory material transactions from Excel: miscellaneous, account and account alias issues and receipts, subinventory transfers, direct inter-organization transfers and intransit shipments, including revision, lot, serial, locator and project controlled items. Each row becomes one transaction, processed by the standard inventory transaction manager. The upload only creates transactions; it does not change or reverse existing ones.

When to use it

Bulk-load miscellaneous issues and receipts instead of keying them one at a time in the Miscellaneous Transaction window.
Move stock between many subinventories, or to other organizations, in one go.
Post account and account alias adjustments, for example after a physical count.
Transact lot, serial, revision or locator controlled items in volume.
Record project related inventory transactions with their project, task and expenditure details.

Before you start

You use a responsibility with access to the inventory organization.
The inventory accounting period covering your transaction date is open, in both organizations for an inter-organization transfer.
If the organization does not allow negative balances, there is enough on-hand quantity in the source subinventory for issues and transfers.
For project related transaction types, project cost collection is enabled in the organization.

Choose a template

Template	Use it for
Default (default)	All transaction types. Shows every column, including the account segments, transfer and intransit shipment columns.
Project related transactions	Project related issues and receipts. Shows the Source Project, Source Task, Expenditure Type and Expenditure Org columns with the lot, serial and locator columns, without the transfer and shipment columns.
Serial controlled template	Transactions of serial controlled items, including subinventory transfers. Presets the download to active items with predefined serial numbers and shows the From Serial Number, To Serial Number, To Subinv and To Locator columns.

Step 1 – Set the parameters

Open INV Transaction Upload in Blitz Report, choose the template and set the parameters:

Parameter	Meaning
Upload Mode	Create (default) opens an empty sheet to enter transactions. Create, Update downloads the selected items with their current on-hand quantity by subinventory, locator and revision, ready to transact against.
Organization Code	The inventory organization to download items from. Defaults to your current organization.
Category Set, Category	Downloads items assigned to this category. Choose the Category Set first.
Item, Item Like, Item Description	Downloads a specific item, items whose number matches a pattern (for example AS5%), or items by description.
Item Type, Item Status, BOM Item Type, Contract Item Type, Make or Buy	Restricts the download to items with these attributes.
Buyer, Planner, Inventory Planning Method	Restricts the download to items with this buyer, planner or planning method.
Cross Reference Type, Cross Reference	Downloads items with this item cross reference.
Locator Control, Serial Number Control, Lot Control, Revision Control	Restricts the download to items with this control setting.

In Create, Update mode, enter at least one item restriction (any parameter from Category onwards), otherwise the run stops with “Please enter one or more item restriction criteria for download”. Only items enabled for transactions are downloaded.

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens, either empty or with one row per item and stock location showing the Onhand Quantity. The Transaction Date of downloaded rows is set to the current date and time.

Step 3 – Enter the transactions

Fill in the rows you want to transact, or add new rows. Only rows you change or add are uploaded; untouched downloaded rows are ignored. On each row enter:

Organization, Item, Subinventory and, for locator controlled stock, Locator; Revision for revision controlled items.
Transaction Type, Quantity, UOM and a Transaction Date in an open period. Enter the quantity as a positive number: issues and intransit shipments are made negative automatically.
For a miscellaneous or account issue or receipt, the Distribution Account to charge. Picking an Account Alias (a shorthand for an account) fills the Distribution Account for you, and the account segment columns follow the Distribution Account.
For an account alias issue or receipt, the alias in Transaction Source; it also defaults the Distribution Account.
For a subinventory transfer, To Subinv and, if the destination is locator controlled, To Locator. For an inter-organization transfer also To Org; an intransit shipment additionally takes the Shipment Number and optionally Expected Receipt Date, Freight Code, Containers, Waybill Airbill, Transportation Cost, Transportation Account and Transfer Cost.
For lot controlled items, Lot Number (Lot Quantity defaults to the Quantity), and Lot Expiration Date for a new lot. For serial controlled items, From Serial Number and To Serial Number.
For project related transaction types, Source Project, Source Task, Expenditure Type and Expenditure Org.

Optionally add a Transaction Reference, Reason or Transaction Cost. The example below receives 10 units into FldSvc as a miscellaneous receipt and transfers 5 units from Staging1 to FldSvc.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs the upload’s validation of each row (item and organization, revision, lot, serial and locator control, open period, on-hand quantity, transfer destination and account), then saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which passes all rows to the inventory transaction manager.

Step 6 – Review the result report

When the request completes, a result report opens listing every uploaded row with its status and message. Successful rows show the created material transactions with the on-hand quantity after the transaction; a transfer is listed with both its issue and its receipt line.

What’s produced

Inventory material transactions, with on-hand quantities updated by the transaction manager.
A result report listing every row with a status (success or error) and a message.

Common questions

Can I update or reverse an existing transaction?
No. The upload only creates new transactions. To reverse one, upload an offsetting transaction, for example a miscellaneous issue for a wrong receipt.

Why do I get an empty sheet in Create mode?
By design, Create always opens an empty sheet. Use Create, Update to download items with their on-hand quantities.

Should I use Account Alias or Transaction Source?
For an Account issue or Account receipt, enter the Distribution Account, or pick an Account Alias to fill it. For an Account alias issue or Account alias receipt, pick the alias in Transaction Source and leave Account Alias empty.

Do I enter issue quantities as negative numbers?
No. Enter positive quantities; issues and intransit shipments are converted to negative quantities automatically.

Which transaction types can I use?
Issues and receipts with an account, account alias, inventory (miscellaneous) or user defined source, subinventory transfers, direct inter-organization transfers and intransit shipments. Project related types are available only in organizations with project cost collection enabled.

Why does my transfer show two lines in the result report?
A transfer creates an issue from the source and a receipt into the destination. The result report lists both, each with the on-hand quantity after the transfer.

Troubleshooting

Message	Cause	What to do
Please enter one or more item restriction criteria for download	Create, Update mode without an item restriction.	Enter an item, category or other item parameter, or use Create mode.
Invalid Organization Code	The Organization is not an inventory organization code.	Pick the organization from the list.
Invalid Item or Item is not assigned to the given organization.	The item does not exist, is not enabled or is not an inventory item in the organization.	Check the item and its organization assignment.
No open period found for the entered Transaction Date.	No open inventory period covers the Transaction Date.	Use a date in an open period, or open the period.
No open period found in transfer organization for the entered Transaction Date.	The period is not open in the To Org.	Use a date that is open in both organizations.
Transaction quantity should be more than zero.	Quantity is zero or negative.	Enter a positive quantity.
Transaction quantity cannot be more than quantity onhand, Negative balance not allowed.	The organization does not allow negative balances and the issue or transfer exceeds the on-hand quantity in the subinventory.	Reduce the quantity or receive stock first.
Revision is required for revision-controlled items.	Revision controlled item without a Revision.	Enter the Revision.
Locator is required for locator-controlled subinventories.	The subinventory or item requires a locator.	Enter the Locator.
Lot Number is required for lot-controlled items.	Lot controlled item without a Lot Number.	Enter the Lot Number.
The Lot Quantity does not match the Transaction Quantity.	Lot Quantity differs from Quantity.	Enter the same value in both columns.
Lot Number … does not exist for this item in the organization. New lots can only be created on receipt transactions.	A new lot on an issue or transfer.	Use an existing lot, or create the lot with a receipt.
From and To Serial Number are required for serial-controlled items.	Serial controlled item without serial numbers.	Enter From Serial Number and To Serial Number.
Project related transaction types required Source Project, Task, Expediture Type and Org.	A project related transaction type without its project details.	Enter Source Project, Source Task, Expenditure Type and Expenditure Org.
Transaction Source is required for account alias related transaction types.	Account alias issue or receipt without a Transaction Source.	Pick the account alias in Transaction Source.
Distribution Account is required for Account issue/Account receipt transaction type.	Account issue or receipt without a Distribution Account.	Enter the Distribution Account or an Account Alias.
To-Subinventory is required for transfer related transaction type.	Transfer without To Subinv.	Enter the destination subinventory.
To-Locator is required for locator-controlled subinventories.	The destination subinventory requires a locator.	Enter the To Locator.
Invalid Transfer Organization Code.	Inter-organization transfer with a missing or wrong To Org.	Pick the destination organization from the list.
Item is not valid in the transfer organization.	The item is not enabled in the To Org.	Assign the item to the destination organization first.
Transaction quantity has an incorrect sign for the given transaction action	The quantity sign does not fit the transaction type.	Change the sign of the Quantity.
The transportation account is not valid for the given freight code	The Transportation Account is not the account set up for the Freight Code.	Use the Transportation Account defaulted from the Freight Code.
Record was not processed but no error was returned	The transaction manager did not process the row and returned no error.	Check the row values and upload the row again.