Material Transaction Wizard
Material Transaction Wizard is an Excel based front-end for the Oracle Miscellanous Transaction Form. This program contains the validation and defaulting rules of the Oracle forms plus the capabilities made possible by our popular spreadsheet model. You can download historical transactions, transactions from the interface, quantity on hand and Bill of Materials from within Oracle as the basis for your new Material Transactions and employ the features of Excel to help prepare your data. Material Transaction Wizard is an ideal tool for quantity on hand data conversion and data migration.
Features
- Optional Data Entry forms, which include data validation and full List of Values capability
- Load one, a selected range or all Material Transactions from the worksheet
- Add a custom Account Generator to each of your transactions
- Supports Lot and Serial Transactions, including all WMS descriptive flexfield columns
- Supports Wip Job Component Issues and Receipts
- Supports Average Cost Updates
- Upload Material Transactions from the toolbar either online or as a background process, transacting via the material transaction processor
- Error messages are returned to the worksheet so there is no need to go into Oracle Applications to check the transaction status.
- Can use formulas in place of values
- Use multiple sheets and even operate on sheets in other workbooks
Requires MS-Excel and Internet Explorer on the PC, otherwise no additional software required. This program uses the standard Material Transaction Interface Table. Installation can be performed in a minute by your DBA. Runs on Excel 2000 or greater on any operating system. Connects to Oracle E-Business Suite releases 11.5.10 and R12 on any platform (Contact us for 11.5.9 version) on any platform.