The Search Oracle Parts Inquiry searches directly against the Oracle back office database, while the Part Number search pulls its data from the Commerce Parts Catalog.  Search Oracle (Parts Inquiry) provides data for all products in a US inventory organization within Oracle and some may not be orderable via the on-line shopping process at this time.

• For performance reasons, Search Oracle (Parts Inquiry) searches only on the exact Part Number you enter, not on partial values.  It is also case sensitive, meaning you need to enter the exact value to find an item.  Note that, by convention, Part and Model Numbers are typically created in Oracle with all upper case values. The Part Number searches can be made on a partial value.
• Search Oracle (Parts Inquiry) will not be available when the Oracle database is down for any reason.
• Search Oracle (Parts Inquiry) is only available to employee and affiliate users, not customers. The Part Number search is available to customers.

Product Attributes

Part Number:  The Part Number you entered on the Parts Search Home Page appears here along with the associated data retrieved from Oracle.  Enter a different value here and click the “Next Inquiry” Button to search on another Part Number without returning to the Parts Search Home Page.

Description:  A short description of the part you have just searched for will be displayed in this field.

Unit of Measure:  A standard measurement of the item you have just searched for will be displayed in this field. Many of the items in the catalog will not have a standard unit of measure and will be designated by a generic unit such as “Each”.

Item Type: Indicates if the searched item is purchasable.

Status: The status indicates if the item is currently active or inactive. A part must be in active status to be purchased on-line.

Orderable: A “Y” here means that the Part Number is orderable on the Oracle Order Management System, but does not necessarily mean that it is orderable via the on-line shopping process.  The “Add to Cart” Button will appear for parts orderable via the on-line shopping process.  An “N” here means that the part is not orderable.

Product Line:  Indicates the product line the product is assigned to in Oracle and also determines the discount that will be provided by a MPA (Master Purchase Agreement).

Standard Cost:  Only displayed to users with access privileges and is not displayed when using the Print or E-mail Buttons to avoid exposing it to customers. To add view cost access privileges to your profile have your manager send an e-mail to IAC-Registrar(AZ15).

Replacement Information:  If the Part Number entered has been replaced by another item, the Parts Inquiry Page will automatically overlay the entered Part Number value with the replacement and display data for the new item on the page.  In those cases a message will appear here informing you that the replacement has taken place.

Service Information:   A message in this field gives information on whether the Item Number is a standard stockable part, and whether it qualifies for return credit or is a repairable item. Return credit programs are available to US customers only; return credit is obtained by returning the replaced product to the factory.

Price

Price List:  This List Box allows you to toggle between US List Price and US Transfer Price.

Effective Date/Price:  The three most recent prices are shown in descending order (left to right) by effective date.

Only the most recent US List Price is displayed when using the Print or Email Buttons as these are intended to send to customers.

Availability

Availability information is displayed for all US inventory organizations where the part is active.

If more that one inventory organization is displayed, the part would be fulfilled from the Service inventory organization (GLC) if the order quantity and extended cost meet a defined “service” criteria. 

Organization: The US inventory organization

Available:  This value is calculated as follows:  On Hand + Supply - Demand.

On Hand:  Quantity in stock in the inventory organization.

Supply:  Open purchase orders in the inventory organization scheduled within the displayed Lead Time or 30 Work Days if no Lead Time is displayed.

Demand:  Open Sales Orders in the default US shipping inventory organization scheduled within the displayed Lead Time or 30 Work Days if no Lead Time is displayed.

Lead Time (WD):  The standard order Lead Time in the inventory organization expressed in work days.

Note that none of the Availability fields are displayed when using the Print or Email Buttons as these are intended to send to customers.

Button/Link - Next Inquiry Button

When Visible - Always.

Action - Search Oracle for a new value in the Part Number field.  This button will also execute if the user hits the Enter Key.

Button/Link - Print Button

When Visible - Always.

Action - Initiate printing of Customer View of Page to user’s default printer.

Button/Link - E-Mail Button

When Visible - Always.

Action - Invoke window to e-mail Customer View of Page.

Button/Link - Add to Cart Button

When Visible - Never when Parts Inquiry is accessed from the Shopping Cart or Custom Attributes ATP Buttons.  Otherwise only for items orderable via IC.Home.

Action - Add Part Number displayed to existing Shopping Cart defaulting a quantity of one.  If a different quantity is needed increase it on the Shopping Cart.

Button/Link - Shopping Cart Button

When Visible - Always.

Action - Go to Shopping Cart Page.

Button/Link - Back Button

When Visible - Always.

Action - Return to page from which you accessed this page.

Button/Link - Service Bulletin Link(s)

When Visible - When Available in the ACS.Home Catalog.

Action - Clicking on a Service Bulletin icon will open the Service Request using Adobe Acrobat Reader.