Posts By Andy Haack

PER Person Assignment Upload creates and updates employee assignments from Excel with the fields of the Assignment window of the People form: organization, job, position, grade, payroll, location, assignment status, categories, supervisor, probation and notice periods, standard conditions, statutory information, salary basis, people group and [...]

PER Person Upload creates and updates people in Oracle HR from Excel, as in the People window: employees, contingent workers and applicants, their personal details and the Further Person Information and Additional Personal Details flexfields. It also terminates employees, ends contingent worker placements and rehires [...]

AP Invoice Payment Upload records Manual and Quick payments of open Payables invoices and voids existing payments from Excel, the equivalent of entering a payment and selecting its invoices in the Payments window. Each payment is created through the same Payables and Oracle Payments processing [...]

INV Lot Upload creates and updates Oracle Inventory lots from Excel, with the fields of the Lot Numbers form: status, grade, the Disabled flag, the parent lot of a new lot, the origination, expiration, expiration action, retest, maturity and hold dates, and the Lot [...]

AP Distribution Set Upload creates and updates Oracle Payables distribution sets and their lines in bulk from Excel - the equivalent of the Distribution Sets window (Setup > Invoice > Distribution Sets). Oracle provides no interface or API for distribution sets, so this upload [...]

WIP Material Transaction Upload issues components to, and returns components from, WIP work orders in bulk from Excel. The download gives you one row per component requirement of the work orders you select, with the operation, department, supply subinventory and locator already filled in [...]

INV Item Cross Reference Upload creates, updates and deletes Oracle Inventory item cross references from Excel - the alternative part numbers held against an item, such as supplier, customer or GTIN numbers - as maintained in the Cross References window (Item form, Tools > [...]