Posts By Andy Haack

MSC Sourcing Rule Assignment Upload creates, updates and deletes assignment sets and their sourcing rule assignments on the Oracle Advanced Supply Chain Planning (ASCP) planning server for a selected planning instance, from Excel, following the same rules as the planning server's Sourcing Assignments window. [...]

MSC Plan Order Upload actions Oracle ASCP (Advanced Supply Chain Planning) plan recommendations from Excel. It downloads the planned orders and reschedule recommendations of a plan, lets you amend the implement date and implement quantity, and then selects them for release or releases them, [...]

MRP Sourcing Rule Assignment Upload creates, updates and deletes Oracle assignment sets and the sourcing rule assignments within them from Excel. Each row ties a sourcing rule or bill of distribution to a target at one of the six assignment levels (Global, Category, Item, [...]

MRP Sourcing Rule Upload creates, updates and deletes Oracle sourcing rules and bills of distribution from Excel, including their receiving organizations and shipping sources (Buy From, Transfer From, Make At) with allocation percentages and ranks. Each row of the Excel file is one shipping [...]

MRP Item Forecast Upload creates, updates and deletes item forecast entries in existing Oracle MRP/ASCP forecasts from Excel. Download the entries of one or more forecasts, change quantities, dates, bucket types or comments, add new entries for any item, and load them through Oracle's [...]

WIP Job Upload creates and updates Oracle Work in Process discrete jobs - Standard and Non-standard - including their operations, resources and material requirements (components), from Excel. One file can hold jobs for several inventory organizations; the upload loads the WIP Mass Load interface [...]

INV Unit Of Measure Conversion Upload creates and updates Oracle Inventory unit of measure conversions from Excel: standard conversions, item-specific intra-class and inter-class conversions, and lot-specific inter-class conversions. It downloads existing conversions in a readable form such as 1 Box = 24 x Each, [...]

INV Unit Of Measure Upload creates and updates Oracle Inventory unit of measure classes and their units of measure from Excel, including their descriptive flexfield attributes. It is available on Oracle EBS R12.2 and later. When to use it Create new unit of measure [...]

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 [...]

INV Physical Inventory Tag Count Upload enters counted quantities against the tags of an Oracle Inventory physical inventory from Excel. It downloads the tags of a physical inventory, lets you record the count on each tag, add new tags for stock that was found [...]