ENG Engineering Change Order Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Creates and updates engineering change orders (ECOs) with their revised items and revised components - the Engineering Change Orders form (Engineering > ECOs > ECOs).

Each row holds one ECO, optionally one of its revised items and one revised component of that revised item. The ECO and revised item columns repeat on every row, and a change in any of these rows is applied. A new ECO is created with status Open.

A revised item is identified by item and alternate. An Effective Date in the past is moved to the current date, as in the form. Changing the Effective Date of an existing revised item reschedules it with its revised components, and changing New Item Revision renames the new revision. Revised items are not deleted; set their status to Cancelled instead.

Component Action Add adds a component to the bill. Change and Disable refer to the implemented component of the revised item’s bill at Old Operation Seq (or Operation Seq when Old Operation Seq is blank) effective at the revised item’s effective date; for Change enter only the values that change. Delete Component removes a pending revised component from the ECO.

Approval, implementation, substitute components, reference designators and revised operations are maintained in the form.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Organization Code, ECO, ECO Type, Revised Item, Pending only

Oracle EBS Tables Used

eng_engineering_changes, eng_revised_items, mtl_system_items_vl, mtl_parameters, eng_change_order_types_vl, eng_change_statuses_vl, hr_all_organization_units_vl, mtl_item_revisions_vl, bom_components_b, org_access_view

Report Categories

Enginatics, R12 only, Upload

INV Item Upload, ENG Engineering Change Orders, BOM Bill of Material Structure, INV Items, INV Item Upload 11i, BOM Item Where Used GUI, BOM Routing Upload, INV Item Attribute Master/Child Conflicts

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import ENG_Engineering_Change_Order_Upload.xml
SQL Source ENG Engineering Change Order Upload.sql
Full Report on Enginatics www.enginatics.com/reports/eng-engineering-change-order-upload/

© Enginatics GmbH