Blitz Report™ Library
135 reports
| Description | Download | ||
|---|---|---|---|
| FND Menu Entry Upload | Upload to create, update and delete menu entries in FND Menus.
Useful for adding entries to existing menus, e.g. during Supply Chain Hub installation.
Upload Modes
============
Create
------
Opens an empty spreadsheet where the user can enter new menu entries.
Create, Update
--------------
Downloads existing menu entries matching the Menu Name filter for review and update.
New rows can be added to create additional entries in the same upload.
Fields
======
- User Menu Name: Display-only. Shows the translatable menu name.
- Menu Name: Required. The internal menu name (e.g. INV_NAVIGATE).
-… full description | Enginatics, Upload |  |
| FND Responsibility Upload | Create and update Oracle E-Business Suite responsibilities, and maintain their menu/function exclusions, replicating the System Administrator Responsibilities form (FNDSCRSP).
Each row is one of two entity types, chosen in the Row Type column:
- Responsibility: creates or updates the responsibility definition (Name, Application, Key, Description, Effective Dates, Available From, Data Group, Menu, Request Group, Web Host/Agent Name). Responsibilities are identified by Application + Responsibility Key. A responsibility is created when that combination does not yet exist, otherwise it is… full description | Enginatics, Upload | |
| FND User Upload | Listing and updating all EBS users and their responsiblities | Enginatics, Upload | |
| GL Account Upload | This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations. | Enginatics, Upload | |
| GL Account Upload 11i | This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations. | Enginatics, Upload | |
| GL Budget Amounts Upload | GL Budget Amounts Upload
===================
This can be used to upload GL Budget Amounts | Enginatics, Upload | |
| GL Daily Rates Upload | GL Daily Rates Upload
==================
Use this upload to upload new or update existing GL Daily Exchange Rate Conversions.
If exchange rates do not already exist for the entered data, they will be created.
If exchange rates do already exist for the entered data, they will be updated. | Enginatics, Upload | |
| GL Setup Upload | Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options.
Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is… full description | Enginatics, R12 only, Upload | |
| GL Summary Account Upload | This upload can be used to import Summary Account Templates. | Enginatics, R12 only, Upload | |
| IEX Collection Note Upload | Creates and updates Collection Notes in Oracle Collections (IEX) - the same notes shown in the Collections work area.
Each note is attached at a single Note Level: Customer (party), Account, Bill To, or Collections Transaction.
The Note column is limited to 2,000 characters. The upload will reject the row if the note exceeds this.
The Note Detail column is limited to 4,000 characters. Note details exceeding this will be truncated.
Party Level Notes:
Pary Name is required
Party Number is required only when the Party Name is not unique.
Account Level Notes:
Party Name and Account Number… full description | Enginatics, R12 only, Upload | |
| IGI Dossier Maintenance Upload | Upload to create and maintain dossier transactions (budget transfers) for Oracle Public Sector Financials International (IGI). Supports header creation with source and destination budget lines using the seeded IGI Dossier Maintenance APIs. | Enginatics, R12 only, Upload | |
| INV Item Cross Reference Upload | Creates, updates and deletes item cross references - the Cross Reference Types form (Inventory > Setup > Items > Cross-Reference Types), also reached from the Item form via Tools > Cross References.
A cross reference is either organization independent (Applicable To All Organizations is set and Org is blank) or specific to one organization (Org is entered). The organization must be one the item is assigned to.
Revision and Unit of Measure only apply to the GTIN cross reference type named by the profile option INV: GTIN Cross Reference Type, and Revision additionally requires an… full description | Enginatics, R12 only, Upload | |
| INV Item Subinventory Upload | Create, update and delete item-to-subinventory assignments (plus their optional item-subinventory-locator ties) across accessible inventory organizations.
Each row is one (Organization, Item, Subinventory, Locator?) combination. When the Locator column is blank, only the item-subinventory header is processed. When the Locator column is populated, the item-subinventory header (if not already processed in this run) AND the locator tie are processed. When multiple rows share the same Organization/Item/Subinventory triple, the header is processed only on the first row of the triple (siblings… full description | Enginatics, R12 only, Upload | |
| INV Item Transaction Defaults Upload | This upload can be used to create and update Item transaction default subinventories and locators | Enginatics, Upload | |
| INV Item Upload | INV Inventory Item Upload
======================
This upload can be used to create and update Inventory Items.
It supports creation of Inventory Items:
- by manually entering the Item details.
- from a master row, with optional semicolon-separated child organization assignments
- from an item template (Copy from Template)
- from an existing item in the same Organization (Copy from Item)
It supports update of existing Inventory Items either by:
- update the details of an existing inventory items by downloading the items to be updated. Use the report parameters to select and download the… full description | Enginatics, Upload | |
| INV Item Upload 11i | INV Inventory Item Upload
======================
This upload can be used to create and update Inventory Items.
It supports creation of Inventory Items:
- by manually entering the Item details.
- from a master row, with optional semicolon-separated child organization assignments
- from an item template (Copy from Template)
- from an existing item in the same Organization (Copy from Item)
It supports update of existing Inventory Items either by:
- update the details of an existing inventory items by downloading the items to be updated. Use the report parameters to select and download the… full description | Enginatics, Upload | |
| INV Item User Defined Attribute Upload | Item user-defined attribute (UDA) values upload for Oracle Product Information Management (PIM / Advanced Product Catalog).
Creates, updates and deletes item user-defined attribute values (attribute groups defined in the item catalog) at the item, item organization and item revision data levels through the Oracle EGO user attributes API. Each upload row carries one attribute value; the rows of one attribute group row instance (same item, data level, attribute group and row number) are processed together.
For multi-row attribute groups, enter a Row Number to group the attribute values… full description | Enginatics, Upload | |
| INV Lot Upload | Creates and updates lots as in the Lot Numbers form (Inventory > On-hand, Availability > Lots).
A row updates the lot when Organization Code, Item and Lot Number exist, and creates it otherwise. A new lot takes the item defaults for status, grade, origination type and the dates left blank, and copies the parent lot attributes where the item or organization is set up to copy them. A blank Origination Date on a new lot defaults to the current date. Parent Lot can only be entered for a new lot.
Expiration Date, Expiration Action Date and Retest Date can be changed only for items under shelf… full description | Enginatics, R12 only, Upload | |
| INV Manufacturer Upload | INV Manufacturer Upload
======================
This upload can be used to create, update and delete Manufacturers. | Enginatics, Upload | |
| INV Physical Inventory Purge Upload | This upload supports the purging of existing Physical Inventories.
For each Physical Inventory to be purged the user can select to purge the tags only, or to purge the full Physical Inventory.
On upload, the upload process will submit the standard 'Purge physical inventory information' concurrent program for each Physical Inventory to be purged.
To improve performance of the upload process, the upload does not wait for completion of the purge concurrent requests before completing.
The ‘Create, Update’ upload mode can be used to first download the Physical Inventories to be purged for… full description | Enginatics, R12 only, Upload | |
| INV Physical Inventory Tag Count Upload | INV Physical Inventory Tag Count Upload
=================================
This upload enables the user to upload counts against the Physical Inventory Tags defined against the specified Physical Inventory.
The upload supports
- the update of counts against existing Tags
- the generation of new tags.
For clients on R12.2.14 or later, creation of manually entered tag numbers is supported
For clients on earlier releases, to generate a new tag leave the tag number blank. The tag number will be automatically generated when the tag is created
For clients on R12.2.3 or later
- the upload also… full description | Enginatics, Upload | |
| INV Physical Inventory Upload | This upload supports the creation of new Physical Inventories and the update of existing Physical Inventories that have not yet been frozen.
The upload supports the specification of the subinventories to be included in the Physical Inventory.
When updating an existing Physical Inventory, the Delete Subinventory upload column allows for individual subinventories to be removed from the Physical Inventory subinventory list.
Replace Existing Subinventories
==========================
When the Replace Existing Subinventories report parameter is set to Yes, the existing physical inventory… full description | Enginatics, Upload | |
| INV Safety Stock Upload | INV Safety Stock Upload
================================
- Upload New Safety Stock Entries.
- Update Existing Safety Stock Entries.
- Delete Existing Saffety Stock Entries (Delete by setting the 'Delete This Entry' = Yes).
Upload Modes
============
Create
------
Opens an empty spreadsheet where the user can enter new Safety Stock Quantities
Create or Update
-----------------
Create new Safety Stock entries and/or modify existing Safety Stock entries.
Allows the user to
- download existing Safety Stock entiries based on the selection criteria specified in the report parameters.
- modify… full description | Enginatics, Upload | |
| INV Stock Locator Upload | Create, update and delete Stock Locators.
Note on entering a locator as a concatenated segment value: if a segment value contains the KFF delimiter character or a backslash (\), each such character must be preceded with a backslash. For example, with delimiter '.', the segment value '1\4\4.' must be written as '1\\4\\4\.' | Enginatics, Upload | |
| INV Subinventory Upload | Create and update Subinventories across accessible inventory organizations.
Accounts and Default Cost Group are tightly linked; the behavior depends on the organization's configuration:
- WMS=No + Standard cost method (with no on-hand or transaction history): the accounts drive the Cost Group. Enter any valid GL detail accounts and the upload auto-resolves the Cost Group — switching to an existing Cost Group whose 7 accounts match, or creating a new one when none matches. The Cost Group action taken is reported in the success message.
- WMS=Yes (any cost method): the Cost Group drives the… full description | Enginatics, R12 only, Upload | |
| INV Transaction Upload | INV Transaction Upload
======================
This upload can be used to create Inventory Material Transactions.
The following upload modes are supported:
Create – Generates an empty upload file. Transaction details must be entered manually. The Create mode always opens a blank Excel template, regardless of any parameter settings.
Create, Update – Based on the selected parameters, this mode can generate a pre-populated file with details such as item, primary unit of measure, and transaction date (defaulted to today’s date). It also displays the current on-hand quantity for each item,… full description | Enginatics, Upload | |
| INV Unit Of Measure Conversion Upload | INV Unit Of Measure Conversion Upload
=============================
In R12.2 and later:
This upload enables the user to
- upload new unit of measure conversions
- update existing unit of measure conversions.
The upload supports the following unit of measure conversion types:
- Standard, Intra-Class and Inter-Class, Lot Specific Inter-class
In R12.1:
The functionality is restricted to creating new Item specific Intra-Class and Inter-Class conversions only.
Update of existing unit of measure conversions is not supported in R12.1
Creation of Standard and Lot specific unit of measure… full description | Enginatics, Upload | |
| INV Unit Of Measure Upload | INV Unit Of Measure Upload
======================
Note: This upload can only be used in R12.2 or later.
This upload can be used to create and update Unit of Measure Classes and Units of Measures | Enginatics, R12 only, Upload | |
| JA India Third Party Registration Upload | JA India Third Party Registration Upload
=========================================
Use this upload to create or update India Localization Third Party Registrations for customers and suppliers, including tax/registration identifiers such as PAN, TAN, TIN, GST, Service Tax, and other India-specific registration numbers.
This upload also supports Reporting Codes linked to Third Party Registrations.
NOTE: If you are creating new records for a third party, enter and upload all Registration records first, and then enter and upload the Reporting Code records.
Available columns:
1.Record Type:… full description | Enginatics, R12 only, Upload | |
| MRP Master Schedule Upload | MRP Master Schedule Upload
==========================
- Create new MDS/MPS schedule entries.
- Create and Update existing schedule entries.
Each row stages one schedule entry into the MRP schedule interface (mrp_schedule_interface, process_status=2) for an existing schedule designator (MDS or MPS). The staged entries are loaded into the master schedule (mrp_schedule_dates) asynchronously by the customer's MRP Planning Manager.
Upload Modes
============
Create - opens an empty spreadsheet to enter new schedule entries against any accessible schedule designator.
Create and Update - downloads… full description | Enginatics, Upload | |
| MRP Sourcing Rule Assignment Upload | MRP Sourcing Rule Assignment Upload
=============================
- Upload new Assignment Sets and Sourcing Rule Assignments
- Update Existing Assignment Sets and Sourcing Rule Assignments
Notes:
If an Assignment Organization is specified, then this determines the selecatable items.
If an Assignment Organization is not specified, then the Master Organization determines the selectable Items.
The selectable Assignment Organizations is not restricted by the Master Organization.
This is the same logic as used in the Sourcing Assignments form | Enginatics, Upload | |
| MRP Sourcing Rule Upload | MRP Sourcing Rule Upload
====================
- Upload new Sourcing Rules
- Update Existing Sourcing Rules | Enginatics, Upload | |
| MSC Plan Order Upload | Report: MSC Plan Orders Upload
Description: Upload to action Plan Order recommendations.
This upload can be used to either select for release or release Plan Order Recommendations from ASCP planning instances.
Currently supported recommendations that can be actioned by this upload are:
- Planned Order Releases
- Reschedule In/Out recommendations
Additionally, it allows the user to amend the recommended Implement Date and/or Quantity.
In the generated Excel the user can amend the following columns:
- Implement Date
- Implement Quantity
- Update Release Status
Update Release Status can be… full description | Enginatics, Upload | |
| MSC Sourcing Rule Assignment Upload | MSC Sourcing Rule Assignment Upload
=============================
- Upload new Assignment Sets and Sourcing Rule Assignments
- Update Existing Assignment Sets and Sourcing Rule Assignments
Notes:
If an Assignment Organization is specified, then this determines the selecatable items.
If an Assignment Organization is not specified, then the Master Organization determines the selectable Items.
The selectable Assignment Organizations is not restricted by the Master Organization.
This is the same logic as used in the Sourcing Assignments form | Enginatics, Upload | |
| OKL Lease Contract Update Upload | Changes the bill to customer account and bill to site of Lease Management contracts through the Oracle public API okl_contract_pub.update_contract_header - the Bill To of the Lease Contract header.
One row per contract. Enter the Bill To Customer Account, the Bill To Site, or both; everything else on the row is context and is read only. A site that does not belong to the Bill To Customer Account on the row is rejected, so change both together when the account changes too.
A bill to change does not require a rebook: it was verified against Booked, Evergreen, Passed and Incomplete contracts.… full description | Enginatics, R12 only, Upload | |
| OKS Contract Termination Upload | Terminates service contracts (full termination), terminates individual contract lines and sublines (partial termination), and deletes lines from Entered contracts - the Terminate action of the Service Contracts Authoring form (okc_terminate_pub / okc_contract_pub).
Set Terminate Contract to Yes on any row of the contract for a full termination, Terminate Line to Yes to terminate that row's line or subline, or Delete Line to Yes to delete the line (Entered contracts only). Termination Date and Termination Reason are required for terminations.
A termination cannot be undone by this upload -… full description | Enginatics, R12 only, Upload | |
| OKS Service Contract Line Upload | This upload maintains the lines of existing Oracle Service Contracts through the standard Service Contracts public APIs: it updates header and line level values, adds new service and usage lines, and adds covered product or counter sublines.
Each row is one contract line or subline. Rows identified by the Line Number column update that line; sublines use the parent.child format, for example 1.2 for the second covered product of service line 1. Rows without a Line Number create a new line: leave Parent Line Number empty and enter Line Type, Item and the line dates for a top line, or enter a… full description | Enginatics, R12 only, Upload | |
| ONT Order Upload | Upload to Create, Update, Book and Cancel Sales Orders in Oracle Order Management.
Supports creating new orders, updating existing orders, adding new lines to existing orders, splitting lines, booking orders and cancelling orders.
To split a line, add a row for the order with the line to split in Split From Line and the new shipment's quantity in Ordered Quantity. The original line is reduced by that quantity unless its own row sets its new quantity. As in the Split Line window, the new shipment copies all other values from the original line, only Request Date, Warehouse and Ship To can… full description | Enginatics, Upload | |
| ONT Sales Quote Close Upload | Bulk closes open Oracle Order Management sales quotes (documents in the Negotiation transaction phase) - useful for cleaning up large volumes of old draft quotes.
Download the open quotes, keep the rows you want to close, set a Close Reason, and upload. Each quote is driven to the Lost terminal (status Lost, no longer open) through the standard negotiation workflow, and the reason is recorded against the quote.
Quotes are identified by Quote Number and Operating Unit, so you can also paste those two values from an external list instead of downloading. Only open quotes are closed - an order… full description | Enginatics, Upload | |
| OPM Formula Upload | OPM Formula Upload
==================
Create or update Oracle Process Manufacturing (OPM / GMD) Formulas via the public API GMD_FORMULA_PUB / GMD_FORMULA_DETAIL_PUB.
Row model
=========
One spreadsheet row per formula LINE. The header columns (Organization Code, Formula, Formula Version, Description, Class, Owner, Header Scale Type, Status, header attributes) repeat on every line of the same formula. Each line carries its Line Type (Ingredient / Product / By-Product) plus its item, quantity, UOM, scale, and line attributes. Rows of the same formula (Organization Code + Formula + Formula… full description | Enginatics, R12 only, Upload | |
| OPM Recipe Upload | Enginatics, R12 only, Upload | | |
| OPM Routing Upload | OPM Routing Upload
==================
Create or update Oracle Process Manufacturing (OPM / GMD) Routings via the public API GMD_ROUTINGS_PUB / GMD_ROUTING_STEPS_PUB.
Row model
=========
One spreadsheet row per routing STEP. The header columns (Organization Code, Routing, Routing Version, Description, Class, UOM, dates, owner, header attributes) repeat on every step of the same routing. Each step carries its Step No, Operation (No + Version), Step Quantity, Release Type, and step attributes. Rows of the same routing (Organization Code + Routing + Routing Version) must be contiguous. Every… full description | Enginatics, R12 only, Upload | |
| OTL Timecard Upload | OTL Timecard Upload
===================
Create, update and delete Oracle Time and Labor (OTL / HXC) timecards via the public TimeStore deposit API hxc_timestore_deposit, as an Excel-based alternative to self-service time entry.
Row model
=========
One spreadsheet row per timecard line and day: Employee, Date, classification and Hours. Rows are grouped into timecards by employee and the OTL timecard period (e.g. the weekly period from the employee's OTL preferences) containing the Date. Rows of the same employee and period must be contiguous and are deposited together as one timecard. The… full description | Enginatics, Upload | |
| OTL Timecard Upload 11i | OTL Timecard Upload
===================
Create, update and delete Oracle Time and Labor (OTL / HXC) timecards via the public TimeStore deposit API hxc_timestore_deposit, as an Excel-based alternative to self-service time entry.
Row model
=========
One spreadsheet row per timecard line and day: Employee, Date, classification and Hours. Rows are grouped into timecards by employee and the OTL timecard period (e.g. the weekly period from the employee's OTL preferences) containing the Date. Rows of the same employee and period must be contiguous and are deposited together as one timecard. The… full description | Enginatics, Upload | |
| PA Budget Upload | The PA Budget Upload supports the creation/update of standard project budgets.
At this stage it does not support the creation/update of Financial Plan Budgets.
The PA Budget Upload allows users to:
- Create new working budgets.
When creating a new working budget, any existing working budget for the specified Project and Budget Type will be overwritten.
The upload allows the user to create a working budget either by entering the data directly into an empty upload excel file, or by copying a prior version of the budget and modifying this in the upload excel file.
- Update existing… full description | Enginatics, Upload | |
| PA Event Upload | PA Event Upload
===================
This upload can be used to create new Project Billing and Revenue Events against the Projects belonging to the Operating Units accessible to the current responsibility.
If the Operating Unit parameter is specified, then the upload will be restricted to Projects within the specified Operating Unit only. | Enginatics, Upload | |
| PA Project Asset Upload | PA Project Asset Upload
======================
Create, update, or delete project assets and their task assignments for Oracle Projects capital projects, using the public API pa_project_assets_pub.
Supported Actions:
- Create / Update project asset (ESTIMATED or AS-BUILT types only — RETIREMENT_ADJUSTMENT is excluded)
- Add / Delete asset-to-task assignment (top-task rollup or leaf-task)
Row Structure (bundled parent-child):
- One row per (asset, assignment) pair
- Leave Assignment Task Number blank on a row to create/update just the asset header with no assignment
- For multiple assignments… full description | Enginatics, Upload | |
| PA Project Upload | PA Project Upload
===================
Create and update Projects in Oracle Projects using the pa_project_pub API.
Create Mode:
- Select a Template to populate default values (project type, organization, billing setup, etc.)
- Template-specific required fields (customer, organization, completion date, etc.) are validated in Excel before upload
- Project Manager can differ from the template PM — the template PM is replaced post-creation
- PM Product Code determines which external PM system owns the project (default: Primavera). Do NOT use Microsoft Project — it blocks date updates due to… full description | Enginatics, Upload | |
| PA Task Upload | PA Task Upload
======================
Create new tasks or update existing task attributes within Oracle Projects using APIs pa_project_pub.add_task and pa_project_pub.update_task.
This upload does not create projects — it operates on tasks within existing projects.
Supported Actions:
- Create: Add new top-level tasks, child tasks under existing parents, or entire parent-child hierarchies
- Update: Modify attributes of existing tasks (organization, manager, work type, flags, schedules, etc.)
Report Parameters:
- Upload Mode: 'Create' for new tasks only, or 'Create, Update' for both
-… full description | Enginatics, Upload | |
| PA Transaction Upload | PA Transaction Upload
===================
This upload can be used to upload transactions from external cost collection systems into Oracle Projects.
Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems.
If the 'Operating Unit' and/or 'Transaction Source' parameters are specified, then the upload excel will be restricted to the specified Operating Unit and/or Transaction Source.
If the 'Batch Name' parameter is specified, this will default as the Batch Name in the upload Excel.
If the 'All Negative Expend Unmatched'… full description | Enginatics, Upload | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…