Order Inquiry

Overview of Order Organizer

The Order Organizer window enables you to manage existing orders and returns. Using this window you can find recent orders, orders past their requested shipment date, orders on a particular hold, or orders for an important customer.

When you open the Order Organizer window, the Find Orders/Quotes window is displayed. It enables you to enter search criteria to locate an order or a group of orders. The Find Orders/Quotes window has the following tabs: Quote/Order Information, Line Information, Advanced, Holds Information, andScheduling. The fields in these tabs enable you to enter or select values which are used as the criteria for finding and displaying orders.

Each of the tabs of the Order Organizer window contain the folder enabled Operating Unit field. You can specify criteria to search for orders and include the Operating Unit field as one of the search criteria or you can leave the field blank to search across all operating units that you have access to. If the Operating Unit field has a value then the LOVs for fields that are operating unit-specific display data only from that operating unit. If the Operating Unit field is blank then those LOVs display data from all operating unit accessible to you. If you change or clear the Operating Unit field, then the operating unit-specific fields are cleared too.

Note: The Related PO Number field in the Find Orders/Quotes window (Quote/Order Information tab) displays drop-ship orders only and not back-to-back orders. If the Related PO Number is a blanket PO, then you can use the PO Release Number to search by a specific blanket release. The PO Release Number field is a folder enabled field and not displayed by default on the Find Orders/Quotes window. If you enter the Related PO Number but do not select a PO Release Number, then the application displays all blanket releases in the selected operating unit.

The Related PO Number field in the Find Orders/Quotes window (Line Information tab) displays only drop-ship orders. The Related PO Number field is a folder enabled field and not displayed by default in the Line Information tab. If you select the Related PO Number on the Line Information tab, and click Find, then the application displays all the sales order lines associated to the Related PO Number in the Orders - Lines tab.

The Order Organizer window consists of the Navigator Tree and the Search Results (Order Summary) window. Double-click an entry in the Navigator Tree to refresh the results window to show corresponding orders or lines.

The Operating Unit field is a folder enabled field and can be made visible in the Order Summary tab of the Search Results. The summary window displays order information sorted by operating unit. If you have specified sorting parameters using the folder functionality, then the operating unit is the last sorting parameter.

Note: The right mouse button is enabled in the Order Organizer search results panel. Additionally, Booked Date is available as a read-only folder-enabled field on the Order Summary window.

Order Organizer Window

Navigator Tree View

The Navigator Tree contains two predefined queries and two predefined folders to enable administrators and end users to have quick access to their customers' orders.

Today's Orders

Double-click Today's Orders to display information about all orders you entered today in the results window.

Search Results

Double-click Search Results to display information about orders matching the most recent query criteria you entered in the Find Orders/Quotes window. Right-click to save a search and its results to avoid entering it again.

Personal Folders

Click Personal Folders to expand the tree and display a list of saved queries. To access orders matching any of your saved queries, select the appropriate entry. You can organize and access orders you deal with on a regular basis.

Public Folders

If you are an administrator, then you may want to predefine searches and make them available to all of your users. This way, these queries are defined once and everyone does not have to define them individually.

Find Orders/Quotes Window

The Find Orders/Quotes window of the Order Organizer consists of the following tabs: Quote/Order Information, Line Information, Advanced, Holds Information, Scheduling.

The Operating Unit is a folder enabled field and available in all the tabs. It defaults to your default operating unit. You can choose another operating unit that you have access to from the LOV to restrict your search to that operating unit. To expand your search to all operating unit that you have access to, you can leave the field blank. The fields in the various tabs that are operating unit-specific behave as follows:

When the Operating Unit field is blank, the LOVs for those fields display values from all operating units accessible to you. After you choose a specific value, the Operating Unit field is populated accordingly and the LOVs for all the operating unit specific fields display data from only that operating unit.

The Order Organizer window displays the fields that are available to you as a result of the converged inventory models into a single Oracle Inventory model: Secondary Cancelled Quantity, Secondary Fulfilled Quantity, Secondary Shipping Quantity, Secondary Shipped Quantity, Secondary Shipping UOM, and Secondary Reserved Quantity. These fields are view only. You can use the Lot Number in the Line Information tab to query for sales order lines (lot-indivisible items) as a criterion.

Quote/Order Information Tab

The operating unit sensitive fields in this tab are:

• Order Type

• Ship To

• Invoice To (Bill To)

• Sales Agreement Name

• Sales Agreement Number

• Customer Location

• Customer PO Number

• Sales Person

• Related PO Number

• Requisition Number

• Order Source Reference

• Invoice Number

• Deliver To

When the Operating Unit field has no value specified, then the Price List LOV displays only those price lists (global or operating unit specific) that belong to the operating unit to which you have access. If there is a default operating unit or the one that you have specified, then the Price List LOV displays price lists that are global and those that are defined for the specified operating unit.

To search for orders, you can folder enable Book Date From andBook Date To fields.

When you select the Order Source as Copy, the Order Source Reference field displays all the orders irrespective of the order source. You can select the parent order and the Search Result shows all the orders which are copied from the parent order.

Line Information Tab

The following fields are operating unit-specific:

• Ship To

• Sales Agreement Number

• Deliver To

• Invoice To (Bill To)

• Line Type

• Project

• Task Number

• Ship Set

• Fulfillment Set

• Customer PO Number

• Related PO Number

• Price List

• Internal Item

Note: LOVs for Related PO Number and Requisition Number display the operating unit. For Related PO Number LOV displays Sales Order OU and the Purchase Order OU. For Requisition Number the LOV displays the Sales Order OU and the Requisition OU.

If there is an operating unitt specified in the Find Quotes/Orders window, then the Item LOV displays values based on the Item Validation Organization for that operating unit. If the Operating Unit field is blank, then the Item LOV displays values based on the Item Validation Organization for your default operating unit. If you do not specify an operating unit or do not have a default operating unit set, then you cannot use item as a search criteria.

Searching by Customer or Customer Site: The Customer Relationship system parameter setting determines the data displayed in the Ship To/Bill To/Deliver To LOVs when a Sold To Customer Name is specified. If the Operating Unit field has a value and the Sold To is specified, then the Ship To/Bill To/Deliver To LOVs display data based on the Customer Relationship System Parameter setting for that Operating Unit.

Holds Information Tab

You can use this tab to search for hold sources, or for orders, and for lines on hold.

The operating unit field is folder enabled and displays a default value.

When searching for hold sources based on Ship To or Bill To fields:

If there is a value in the Operating Unit field in the Quote/Order Information tab, then the LOVs display values for Ship To and Bill To from that operating unit.

If there is no value specified, then the LOVs display data across all operating units accessible to you. When you select a value, the Operating Unit field is populated based on the value selected.

When you change or clear the operating unit, then the application clears the Ship To or Bill To values.

Hold Source

An operating unit is not required to search for a order, blanket sales agreement, customer, or warehouse based hold source.

You can specify any criteria to search for a hold source. If you specify an operating unit in the Quote/Order Information tab and the hold source was created in that operating unit, then the hold source search results are displayed in the Hold Sources window for that operating unit (click the Hold Sources button in the Holds Information tab to open the Hold Sources window). If you do not specify an operating unit in the Quote/Order Information tab, then the search results display the hold source details for all operating units it was created in.

You can use the following criteria to search for hold sources:

• Bill To Site

• Creation Date

• Customer

• Customer Number

• Deliver To Site

• End Customer

• End Customer Location

• End Customer Number

• Item

• Item Category

• Order

• Order Type

• Payment Type

• Price List

• Project Number

• Sales Agreement Number

• Sales Channel Code

• Ship To Site

• Shipping Method Code

• Top Model

• Warehouse

Use the Hold Until Date field in the Release Sources window to view, enter, or update a date. To change the date, click in the field to open the calendar, select a date, and save.

You can update the Hold Until Date for all hold sources except for the hold sources corresponding to the system applied holds like Credit Check Failure, GSA Violation, Pending Process Payment Hold.

Scheduling Tab

The Operating Unit is a folder enabled field on this tab. It displays the default operating unit. You can choose a different operating unit that you have access to from the LOV. Clear the field to search for order lines across operating units.

When there is no operating unit defaulted or specified, the LOVs for the following operating unit specific attributes display values from all the operating units that you have access to:

• Order Type

• Line Type

• Ship To

• Project Number

• Task Number

When you select a value for one of these fields, the windows default the operating unit and then the LOVs for the other fields only display values from that operating unit. When you clear the Operating Unit field or change its value, the window clears all these fields.

Search by Reservation Set: The LOV for this field only display the reservation sets that you have created.

See Lines Information tab for on details on searching based on an item.

For additional details on using the Scheduling tab, see Overview of Scheduling Across Orders.

Querying Orders

Use the Find Orders/Quotes window to query for existing orders, order lines, quotes, returns, and returns lines based on a specific criteria.

Note: The right click is enabled in the Find Orders/Quotes window.

To Query an Order

1. Navigate to the Order Organizer window.

   Find Orders/Quotes window

   

   The Find Orders/Quotes window displays.

2. In the Quote/Order Information tab, enter a criteria. Enter a full or partial value in the Customer PO field to search for an order.

   You can include additional fields to query orders with the Oracle Folder functionality (Folder > Show Fields). Additional fields available for display on the Quote/Order Information tab include:

   • Operating Unit

   • Agreement

   • Check Number

   • Deliver To

   • Delivery Name

   • Delivery Name To

   • Demand Class

   • Expiration Date

   • Expiration Date To

   • Freight Carrier

   • Freight Terms

   • Invoice To Customer

   • Invoice To Customer Number

   • On Hold

   • Order Hold

   • Original System Document Type

   • Price List

   • Sales Agreement Name

   • Ship To Customer

   • Ship To Customer Number

   • Shipping Method

   • Warehouse

3. Select the Line Information tab and enter line level criteria on which to base your query.

   You can include additional fields for order line query with the Oracle Folder functionality (Folder > Show Fields). Additional fields available for display on the Line Information tab include:

   • Operating Unit

   • Actual Ship Date (From)

   • To (Actual Ship Date To)

   • Current Location

   • Lot Number

   • Ordered Item

   • Ordered Item UOM

   • Serial Number From

   • Serial Number To

   • Ship Set

   • Status

4. Click Advanced tab to enable the following options:

   Select from: Include Closed Orders, Include Closed Lines, Include Cancelled Orders, and Include Cancelled Lines. Additionally, choose to query RLM orders sequenced or not sequenced.

5. Click Holds Information tab to enter hold criteria to query.

6. Click Find.

   You can see the results in the Order Organizer window.

To Create a New Order

1. Navigate to the Order Organizer window.

   The Find Orders/Quotes window opens.

2. Click New Order.

To Create a New Return

1. Navigate to the Order Organizer window.

   The Find Orders/Quotes window opens.

2. Click New Order.

   See Overview of Returns.

Saving Personal or Public Queries

You can save the queries in the Find Orders window as personal or public queries for later use.

To Save a Personal or Public Query

1. Enter the query criteria in the Find Orders/Quotes window. Click Find from the View menu or click the Flashlight icon on the Oracle toolbar to access the Find Orders/Quotes window.

2. Click Find. You can see the orders highlighted that match the query criteria display in the Order Organizer and the Search Results node.

3. Right-click on the Search Results node, and click Save Query.

4. Enter a descriptive name for the query.

5. If the value of the profile option OM: Administer Public Queries is set to Yes, then the search queries are public. Select this check box to save this query under Public Folders and all users can access it. Leaving this check box blank, will save this query under Personal Folders and only you will have access to it.

   

   Note: If you select the Public Folder orPrivate Folder and then switch tabs, the system does not synchronize the data in the tabs (Summary and Lines) according to the last executed criteria. Public Folder and Private folders do not hold any search criteria and the system does not execute any query when these are active or focused nodes.

6. Click Ok to save your changes or click Cancel.

Deleting a Previously Saved Query

You can delete a previously saved query. Set the profile option OM: Administer Public Queries to Yes to delete public queries. Follow these steps to delete a previously saved query:

1. In the Order Organizer window, click the Public or Personal Folders to see your saved query.

2. Right-click the entry and select Delete Query.

Renaming a Previously Saved Query

You can rename a previously saved query. Set the profile option OM: Administer Public Queries to Yes to rename public queries. Follow these steps to rename a previously saved query:

1. In the Order Organizer window, double-click Public or Private Folders to show your saved query.

2. Right-click and select Rename Query.

3. Enter a new name for your query.

4. If the value of the profile option OM: Administer Public Queries is set to Yes, you can make your queries public. Select this check box to save under Public Folders that is accessible to all users. If you do not select this check box, your query is saved in the Personal Folders that is accessible only to you.

5. Click OK to save or click Cancel.

Summary Tab

The Summary tab region shows the header-level summary of all orders and returns corresponding to the folder selected in the Navigator Tree such as order numbers, order types, customer information, order totals. Some of the important operations you can perform from this window are:

• You can view and sort order details based on operating unit in the Summary tab. The Operating Unit field is a folder-enabled field.

• Open Order - Open and edit an existing order or a return.

• New Order - Enter a new order or a return.

• Actions - Perform any applicable action or operation on this order

• Mass Change - Multi-select and mass change order header information for multiple order. You can perform mass change from the Quick Order Organizer (Tools menu) too.

• View detailed workflow status information for an order header by selecting Workflow Status from the Tools menu.

• Right-click and select Additional Order Information to view additional order header related information such as holds history, delivery information, invoicing information, and quantity change history.

• View Shipping Status - View additional shipping details by selecting from the Actions menu.

• Query on invoice or credit memo number to display the original order or return related to the invoice on the Order Organizer. It does not display other documents related to the invoice or credit memo.

Lines Tab

Use the Lines tab region to see the order line level information of all lines across all orders and returns corresponding to the folder selected in the Navigator Tree. This includes line numbers, items, quantity and pricing information, ship to sites and ship-from warehouses, summary of the workflow stage, and tax. Additionally, you can folder-enable several fields to view applicable information.

Some of the important operations you can perform from this window are:

• You can view and sort order details based on operating unit in the Summary tab. The Operating Unit field is a folder-enabled field.

• Open Order - Open and edit the order or return that a line.

• New Order - Enter a new order or return.

• Actions - Perform any applicable action or operation on an order line

• Multi-select and mass change order line information for multiple lines, by selecting Mass Change from the Tools menu. You can perform mass change by using the Quick Order Organizer too.

• Workflow Status - Select Workflow Status from the Tools menu to view detailed workflow status information for an order line.

• Additional Line Information - Right click and select Additional Line Information to view additional order line related information such as holds history, delivery information, invoicing information, quantity change history.

• Assign, add, or remove lines to a ship set, to an arrival set, or to a fulfillment set.

• If you enter an incorrect or null value as a line number, the following error message displays: Enter a valid order/line number combination.

You can search for lines by line number. Line Number From and Line Number To are folder enabled fields. You can specify line numbers to search, for example, 100 to 150, and Order Organizer will return all the relevant lines of the order.

Pricing and Availability Overview

Pricing and Availability provides Oracle Order Management users with the two most common requirements concerning customers that request products:

1. How much is the product going to cost?

2. Do you have the product in stock now?

Using Oracle Order Management, you can quickly view the price of an item and additionally display the availability of the item (across all the organization setup in the sourcing rule) being priced utilizing the functionality provided within the Pricing and Availability window. The Pricing and Availability window enables you to perform a price check or an availability check by entering an item and then requesting the pricing and availability details for the item.

The Pricing and Availably function within Order Management also enables you to:

• Perform price and availability checking without creating an order.

• Perform price and availability checking without placing demand or reservations.

• Easily create an order or quote if the query results in a customer's decision to buy the item.

• Perform price and availability checking by item cross-reference, customer item, or item description.

• View both the Selling Price and List Price of a product.

• View price breaks, other automatic discounts, and Surcharges as well as other benefits not affecting the selling price currently available for a particular product or customer.

• Perform price and availability checking without consuming modifier limits.

  Note: All amounts displayed and calculated as a result of a price and availability search use the decimal precision defined for the currency entered or defaulted.

• Perform price check what if analysis based upon an Agreement, Price List, Pricing Attribute, Order Quantity, Customer, Currency, Ship To, Bill To, Order Type, Pricing Date, or Request Date.

• Perform price checks by specific currency and indicate in which currency you wish to view the calculated Selling Price.

• View a limited set of item attribute details.

• View related items such as upsell items or cross-sell items, substitutes, supercession items, etc.

• Validate your Pricing Setup by ensuring your selling price is correctly returned by the pricing engine prior to placing an order; the selling price will include any eligible discounts and surcharges you have defined.

  Note: Pricing and Availability results do not guarantee order line item price or the availability of an item. Within Oracle Order Management price is guaranteed only at the time an order is Booked.

The Available to Promise information in Order Management displays a window that is populated from either APS or on-hand inventory information. Since availability information can be viewed outside of Order Management, only primary inventory quantities are displayed. Secondary quantities that are available as a result of the converged inventory model are not displayed.

Availability is guaranteed only if a hard reservation is placed for an order line against available supply (supply has being allocated to the order line). Successfully scheduling an order line indicates that you have soft pegged existing supply for the item under normal circumstances should be available if you attempt to pick the order line).

Performing Pricing and Availability

The Pricing and Availability window enables you to perform price and availability checking.

Within this release of Oracle Order Management, you cannot use the Pricing and Availability window to perform price and availability checking for models, kits, service items, or Oracle Processing Manufacturing items.

Pricing and Availability results do not guarantee order line item price or the availability of an item. Within Oracle Order Management:

• Price is guaranteed only at the time an order is Booked.

• Availability is guaranteed only if a hard reservation is placed for an order line against available supply (supply has being allocated to the order line). Successfully scheduling an order line indicates that you have soft pegged existing supply for the item under normal circumstances should be available if you attempt to pick the order line).

The Pricing and Availability window currently does not support availability checking for substitute items.

Multi-Org Access Control in the Pricing and Availability window

The Operating Unit is a folder enabled field. It displays the default Operating Unit. You can choose a different Operating Unit that is accessible to you from the LOV. An Operating Unit is required to do a Pricing and Availability check. All the other fields in the window are grayed out if the Operating Unit field has no value. Initial defaulting will not occur unless the Operating Unit field has a value. Changing or clearing the Operating Unit will clear all the other fields.

Defaulting Rules

The Pricing and Availability window utilizes a subset of your existing defaulting rules currently enabled within the Sales Order window. While you can default many different attribute values within the Sales Order window, the Pricing and Availability window uses defaulting rules to include other attributes like Order Type, Bill To, Agreement, Ship To, Demand Class, Currency, Warehouse, demand class, item identifier type, order type, and item Primary UOM.

If defaulting rules are not enabled, Order Management attempts to default field values in the following manner:

• If you enter a Customer, Order Management will default the warehouse and Price List based upon the Customer setup for the Customer Name/Number entered.

• If you enter an Item, Order Management will default the Default Shipping Organization (warehouse) and Primary UOM for the organization item definition.

• If you enter the Ship To, Order Management will default the warehouse and Price List based upon the Customer setup for the Customer Name/Number entered.

• If you enter the Bill To, Order Management will default the Price List based upon the Customer setup for the Customer Name/Number entered.

• If you enter an Agreement, Order Management will use the Agreement Price List specified.

The Defaulting framework is used to determine the default warehouse for availability checking in this window. If the item has a preferred shipping location setup in the item definition (Order Management tab), then that location may be used if defaulting from item is part of the defaulting rule. If no warehouse is defaulted (because no rule is set up), then the availability call will be accomplished with a null warehouse, and the sourcing rules are used to determine the appropriate warehouse.

You can view availability across other warehouses that the item is enabled in by selecting the Global Availability tab in the Results block. Once there, you can automatically see the availability in each of the other locations, without taking any other action.

Note: If a warehouse is not defaulted or keyed, then the application initiates pricing and availability search with a NULL value for the Warehouse field; your Sourcing Rule definitions are then used to determine the appropriate Ship From warehouse. However, if defaulting rules for the attribute warehouse are enabled, then the application uses the defaulting rule to determine the warehouse value. If the customer and site information is not entered, then item availability assumes that the item will be shipped from the Warehouse specified in the search region. If the warehouse is not entered, and cannot default, then availability checking assumes that the item will be shipped from the item master validation organization.

The Pricing and Availability window does not default the line type from the order type. If you have set up modifiers that have line type as a qualifier, then you must folder enable the Line Type field under the Advanced tab. You must manually enter the value for the line type to understand the impact for these modifiers when you initiate the pricing and availability search.

Block Pricing Support

The term Block Price means an application method where the price will be defined for the entire set of a block. The use of this Block Pricing concept enables you to set up various price break scenarios, using Point and Range price break types with multiple application methods. For such price breaks, a lump sum price could be used for these blocks in addition to per unit or percent prices. Block Price means Lump sum price or rate. Block pricing details display in the Price Breaks tab as Price List price breaks only.

Additional Details

While working within the Pricing and Availability window, the default action when a user selects the Enter key is to execute a price and availability check; anytime you press the Enter key within the Pricing and Availability window, a new Price and availability check is always initiated.

For example, suppose you enter an item and select the Enter key; a pricing and availability check is initiated. Or, suppose you enter an item, customer name, and Bill To and then select the Enter key; a pricing and availability check is initiated.

Note: If you use Oracle Advanced Pricing Qualifiers and Modifiers to assist the pricing engine in determining selling price, then you must specify the qualifying attribute and their value in the Search Region when performing price and availability checking.

Note: For example, suppose you had a Qualifier attached to an item on a price list for a specific Customer: ensure you enter the qualifier, (Customer (name or number)) when performing price and availability checking in order for the pricing engine to properly qualify eligibility. Eligible modifiers attached to the qualifiers will be shown in the Summary Pricing Tab.

Add to Order and Add To Quote Capability

The Pricing and Availability window enables the creation of a quote or an order. To create an order, click Create Order, or to create a quote, click Save as Quote. If you do not want to order the item but instead want to look up the price and availability of another item, you can click New Inquiry to clear the window, or you can just enter another item and start over.

Two new seeded security functions Create Orders from the Pricing and Availability window and Create Quotes in Order Management determine if you can create orders and quotes respectively from the Pricing and Availability window. If these functions securities are not granted to the user of the attached menu, the Create Order and Save as Quote buttons will be hidden and you will not be allowed to create either or both orders and quotes.

Note: OM: Sales Order Form Preference controls whether you see the Sales Orders window or the Quick Sales Orders window once you have clicked to create an order or quote.

Find and Add Customer Integration

Find Customer

You can open the Find Customer window using the Tools menu. Once the search is complete, you can select a customer, and bring that information back to use it in the query of the price and availability of an item for an order.

For more information on the Find Customer window, please refer to the Finding Customer Information section.

Add Customer

You can open the Add Customer window using the Tools menu. After entering the Customer, Address, or Contact information, you can create the new information, to be used in the query of the price/availability of an item for an order. Add Customer functionality is enabled through the tools menu only if the user has the permission to create either Customer or Contact/Sites. This is determined based on the profile OM: Add Customer.

The Add Customer window enables you to create a customer that does not require extensive setup steps. Please refer to the Adding Customers using the Add Customer Window section.

See: Pricing and Availability Overview

Search Region

All Tabs within the Search region of the window make use of Oracle Applications Folder functionality, enabling you to modify the field's displayed within each tab. All tabs are seeded with the most common searchable attributes to enable complete flexibility to display your most-frequently used Pricing criteria on the Basic (search) Tab. All the items are present in all the tabs through folder functionality.

Basic Search Tab

The following search fields have been seeded in the default folder for this tab:

• Item: Enter an item or item description to check price and availability.

  This field is required unless you enter a value in the Item Description field.

• Qty (Quantity): Enter the quantity you wish to check pricing and availability for. This field is required and the default is 1.

• UOM (Unit of Measure): Select a unit of measure or accept the default to perform price and availability checking. This field is required and the default value is the Primary Unit Of Measure (within the item master validation organization) for the item entered.

• Warehouse: (Organization): Select an organization to perform price and availability checking. The default for this field is the value of the Default Shipping Organization for the organization item definition.

• Item Description: Enter an item description or item to check price and availability. This field is required unless you enter a value in the Item field.

• Request Date: Enter the Request Date to use within pricing and availability check. The default for this field is System Date.

  Note: When you perform price and availability checking within the Pricing and Availability window, availability check calculations are based upon Ship Date (ATP Type = Ship Date and Request Date = Ship Date).

• Price List: Select a Price list to use for determining the price returned when performing price and availability checking.

  Note: If the User Search Flag (within the Oracle Advanced Pricing Event Phases window) is set to Yes, Order Management will determine a price for an item if you do not enter a price list. Pricing Availability will not retrieve a list price or modifiers when the User Search Flag in pricing setup is set to No.

• Customer # (Customer number): Enter the Customer number when performing price and availability checking. When you search for a customer number or customer name, the Account Description and Registry ID columns are also available. This helps users better track customer information during searches.

• Item Identifier Type: Select an item identifier to use when performing price and availability checking. The default for this field is Internal Item Number.

  The List of Values (LOV) for this field will display:

  • Customer Item Number

  • All enabled Cross Reference Types (defined within the Oracle Inventory).

    Note: Ensure that the Order Management quickcode definition for quickcode = ITEM_IDENTIFIER_TYPE has the value INT (Internal Items) defined (default field value for Item Identifier Type).

    Note: If the value INT is not defined, then the Pricing and Availability window LOV display for the Item Identifier Type field will be null, and the LOV for both item and item description field will be restricted to Internal Items only.

    Note: The value selected for this field will limit the LOV that displays for the Item and Item description type fields; valid values for Item and Item description fields are based upon the value you selected in Item Identifier Type field.

    Note: For example, if you choose to enter a Customer Number and then select Customer Item Number for the Item Identifier Type field, the LOV for the Item and Item Description will be limited to displaying only Customer Item Numbers defined for the customer entered. Additionally, if you enter a value in the Item or Item Description fields, and then select a value (other than the default) for Item Identifier Type, both the Item and the Item Description fields are cleared of any data; you must re-enter or select the Item or Item Description again.

• Order Type: Enter an Order Type to be used when performing price and availability checking.

To derive unit cost conversion when currency of shipping warehouse in Advanced tab and Currency field in More tab of Pricing and Availability window are different, ensure that the following folder fields are enabled and have a value:

• Conversion Type: You can default the value by enabling defaulting rule for Conversion Type based on Order Type/Constant.

• Conversion Rate: Enter the applicable conversion rate if the conversion type is User.

Advanced Search Tab

The following search fields have been seeded in the default folder for this tab:

• Customer (Customer Name): Enter the Customer Name to be used when performing price and availability checking.

• Customer # (Customer number): Enter the Customer number to be used when performing price and availability checking. When you search for a customer number or customer name, the Account Description and Registry ID columns are also available. This helps users better track customer information during searches.

• Order Type: Enter an Order Type to be used when performing price and availability checking.

• Agreement: Select an Agreement to be used when performing price and availability checking.

• Price List: Select a Price list to use for determining the price returned when performing price and availability checking.

• Pricing Date: Enter a Pricing Date to be used when performing price checking. The Pricing Date entered is used by the pricing engine to ensure that only valid effective dates for qualifier, modifier, and discount breaks are used to determine price.

• Ship To Location: Select a value for the Ship To field to be used when performing price and availability checking.

• Bill To Location: Enter the Bill To Location to be used when performing price and availability checking.

  Note: You cannot enter a value for either the Ship To or Bill To fields without first entering a Customer Name or Customer Number.

• Warehouse (Organization): Select an organization to perform price and availability checking. The default for this field is the value of the Default Shipping Organization for the organization item definition.

More Search Tab

The following search fields have been seeded in the default folder for this tab:

• Promotion - Enter the name of an 'ask for' promotion modifier to be applied to this query.

• Coupon - Enter the number of a coupon to be applied to this query.

• Use the More Promotions button to enter more promotions or coupons, if desired.

• Pricing Context: Select a Pricing Context to be used when performing price and availability checking.

  The LOV for this field displays all enabled flexfield structures defined for the Oracle Advanced Pricing Descriptive flexfield Pricing Contexts.

• Pricing Attribute: Enter a Pricing Attribute based upon the Pricing Context entered. If you choose to enter a Pricing Attribute without entering a pricing Context, the Pricing Attribute Descriptive Flexfield will prompt you to first enter a Pricing Context.

• Currency: Select a currency to be used when performing price and availability checking. This field is required and the default value is the Ledger currency.

  The Ledger currency used within Order Management is determined by the Ledger linked to the value entered in Operating Unit field within the Order Management Parameters window.

• Pricing Date: Enter a Pricing Date to be used when performing price checking. The Pricing Date entered is used by the pricing engine to ensure that only valid effective dates for qualifier, modifier, and discount breaks are used to determine price.

Summary Tab

Summary Results

The following details are displayed within this results tab:

Pricing Block

This block does not enable the use of Oracle Applications Folder functionality.

• Unit Selling Price

• Unit List Price

• Price List

Availability Block

The Availability Block utilizes Oracle Applications Folder functionality, enabling you to modify the field's display within this tab. The following details (by default) are displayed within this block:

• Warehouse

• Earliest Available Date: This field will either contain:

  • A value in the future if the full quantity requested is not available on the Request Date

  • A value of the request date if the requested quantity is available on the requested date

  • A NULL value for items that are not ATP enabled

  • ATP Flag

    Available on Request Date (a value of a variable amount if the item is ATP enabled, or the message ATP not applicable for items that are not ATP enabled. If the item is not ATP enabled, then the application displays the message 'ATP not applicable' in the Error Message field. You must enable this field using the Folder tools.

    Note: if the requested qty is not fully available on the request date, then the field "Available on Request Date" shows the available qty on request date and the field "Earliest Available Date" displays the earliest date when the full requested quantity is available. A hint will also be added to the hints region for this.

• Reservable Qty

• On Hand Qty

  Note: Order Management also provides a hidden fields within the seeded folder for the Availability Block within the Summary Tab. The hidden fields is:

  • Default Source Type - shows the value 'internal' or 'external' depending on where the item is sourced from.

Pricing Results Region

Summary Region

The Summary Pricing Tab region utilizes Oracle Applications Folder functionality, enabling you to modify the field's display within this tab. The fields that are hidden in this folder are: List Price in Pricing UOM, Margin %, Margin Amount, Unit Cost, Pricing Date, Pricing Quantity, Pricing UOM, Ordered Quantity, Ordered UOM, Price List start and end dates, Price List Line start and end dates, and Price List Rounding Factor. The following details (by default) are displayed within this tab:

• Unit List Price

• Unit Selling Price

• Currency

• GSA Indicator

• Price List

• Extended Price

• Effective Until - this is the earliest date among the following: price list ending effectivity date and any modifier list line ending date

Details Region, Price Breaks Sub-Tab

The Price Breaks Sub-Tab does not utilize Oracle Applications Folder functionality. Any qualified price breaks (both price list and modifier breaks) are displayed in the Pricing Results tab, Price Break Sub-tab. There is a radio button you can use to switch between displaying modifier or price list breaks.

The following details are displayed when the Price List radio button is enabled within this tab:

• Value From

• Value To

• List Price (for the price break displayed)

• Break Type (Point, Block, or Range)

• Attribute (this is the attribute entered in the Value From refers to; for example Volume, Quantity, Weight)

The following details are displayed when the Modifier radio button is enabled within this tab:

• Modifier Name

• Value From

• Value To

• Type (of modifier)

• Value (a percent or amount, depending on the method)

• Method (percent, amount, lumpsum)

• Break Type (Point or Range)

• Attribute (this is the attribute entered in the Value From refers to; for example Volume, Quantity, Weight)

Details Region, Price Adjustments Sub-Tab

The Price Adjustments Sub-Tab does not utilizes Oracle Applications Folder functionality. Any automatic discounts (shown as a negative amount) available for your customer are displayed on this tab. Additionally, any modifiers that have changed the selling price of the item are displayed; pricing modifiers that do not affect the selling price are shown on the Additional Benefits sub-tab. The following details are displayed within this tab:

• Modifier Name

• Modifier Type

• Adjustment Amount – the net amount by which this adjustment has affected the selling price

• Net Price: the running total of the Unit List Price and the Modifier amount

• Automatic check box – this box is checked if the modifier has been automatically applied

• End Date (this is the ending effectivity date for this modifier list line)

To apply a manual modifier, click the Add Adjustment button and select the manual modifier you want to apply. You must have security to apply manual modifiers (based on the OM: Discounting Privilege profile) or you will not see this button.

Details Region, Additional Benefits Sub-tab

Additional benefits- are modifiers that are applicable but do not affect the selling price, including terms substitution, promotional goods, other item discounts, item upgrade, coupons, and accruals. Advanced pricing benefits may include free or promotional goods, favorable payment, or freight terms, coupons issued, accruals, etc. The customer service representative (CSR) can communicate the accompanying additional benefits to the customer.

What you see in this region depends on the type of additional benefit that is being displayed.

Note: If Advanced Pricing is not fully licensed, these benefits cannot be defined and this tab will not be visible. You can use the Pricing and Availability window with Basic Pricing, however you will not see Additional Benefits or Price List price breaks.

Item Availability Results Region

The Item Availability region utilizes Oracle Applications Folder functionality, enabling you to modify the field's display within this tab.

Note: If the Customer and site information is not entered, then item availability assumes that the item will be shipped from the Warehouse specified in the search region. If the warehouse is not entered, and cannot default, then availability checking assumes that the item will be shipped from the item master validation organization.

No data will be shown in this region unless sourcing rules are defined for that item. Even if the item is enabled in organizations, it will not show the availability in those organizations unless there are valid sourcing rules to source the item from those organizations.

Details

ATP inquiry within Order Management utilize Oracle Global Available To Promise data that has been previously collected. Oracle Global Available To Promise verifies that the quantity ordered is available on the request date you specify, and uses the item or organization ATP rule to determine the supply and demand to be considered in the calculation (for both collected and planned data). When you request availability within the Pricing and Availability window, Oracle Global Available To Promise supplies the ATP date and available quantity from APS.

See: Oracle Advanced Supply Chain Planning User's Guide and Oracle Global Available To Promise User's Guide for additional details.

• The Item Availability Tab displays multi-line availability data for all organizations defined by your sourcing rules.

• The profile option INV:Capable to Promise determines if you are performing availability checking against planned data or collected data.

• If the quantity requested is not available on the Request Date, then availability data will be displayed within the Earliest Available Date field. This date field will also show a date even if the requested quantity is available on the Requested date. It shows null for Non-ATP items in which case the Available Quantity fields shows 'ATP Not Applicable'

• Availability is always checked, whether an item is ATP enabled or not. If ATP is not enabled for an item, Order Management will display item availability information even for non-ATP items provided you have defined sourcing rules for the item. If there are no sourcing rules defined for the item, Order Management will not display any details other than the message ATP not applicable within the Available Qty field.

  Note: For ATP items, availability can be seen only when Oracle APS is installed.

The following field details are displayed within the Item Availability Tab:

Warehouse, Warehouse Name (either: the warehouse entered in the More Search Tab, the default warehouse as determined by sourcing rules, or the default warehouse as determined by enabled defaulting rules)

• Available on Request Date

• On Hand Qty

• Reservable Qty

• If the ATP flag for an item is not enabled, the following field details are displayed within the Item Availability Tab:

  • On-hand

  • Reservable Quantity

  • Earliest Available Date

    Note: ATP Inquiry is for informational purposes only and does not place demand or reserve on-hand inventory.

    Note: The Pricing and Availability window currently does not support ATP inquiry for any configurations you have defined, and pegging details are not displayed.

Item Information Results Region

Summary Region

The Summary Item Information Tab block utilizes Oracle Applications Folder functionality, enabling you to modify the fields displayed within this tab. The following fields are hidden in this tab – ATO item flag, ATP flag, Default Source Type, Description, Inventory Item Name, Item, Item Type, Make or Buy indicator, Orderable on the Web, Reservable, Returnable, Shippable, Stockable and Taxable flags. The following details (by default) are displayed within this tab:

• Warehouse (this field always displays the item validation organization (warehouse))

• Lead Time (Cumulative Total Lead Time item attribute)

• Primary UOM (not shown by default)

• Default Source Type

• User Item Type (User Item Type item attribute)

• Can Order Internally check box (Internal Orders Enabled item attribute)

• Weight and Weight UOM (not shown by default)

• Item Status (Item Status item attribute)

• Serviceable check box (Serviceable item attribute)

• Customer Can Order check box (Customer Orders Enabled item attribute)

• Volume and Volume UOM

Item Specific UOM Conversion Region

The Item Specific UOM Conversion block within the Item Information Tab region does not utilizes Oracle Applications Folder functionality. The following details are displayed within this tab:

• UOM / Conversion Rate

• Base UOM

  Note: Only Item specific (intra class) UOM conversions are to be displayed, along with Base UOM information; Standard and Inter-class UOM conversions are excluded from any UOM conversions that are displayed.

  Related Items Results Region

This tab for related items is folder enabled. The default display contains: Related Item, Description, UOM, type, Available Quantity, Unit Selling Price, Warehouse and Available Date. There are hidden additional fields, available through folder functionality. Additional fields include ATP Error Message, Extended Price, Price List, Request Date and Unit Price. The following types of item relationships are supported and are displayed in the related items tab. All the relationship types will be treated as Cross-sell except substitute, superceded and Up-Sell. Since there is no item attribute which distinguishes whether it is an add or replace, you must be aware that the Relationship Types 2, 4, and 8 will be treated as substitutions.

1. Related

2. Substitute

3. Cross-Sell

4. Up-Sell

5. Service

6. Prerequisite

7. Collateral

8. Superseded

9. Complimentary

10. Impact

11. Conflict

12. Mandatory Charge

13. Optional Charge

14. Promotional Upgrade

15. Split

16. Merge

17. Migration

Note: All the setup for Related Items must be done in Inventory before you can see them in the Pricing and Availability window.

Current Selections Region

Current Selections: The Pricing and Availability window contains a region used as a placeholder for multiple items to later create an order or quote from all or any of them. You can save items to the Current Selections without creating an order or quote. The profile OM: Show Current Selections Region for P/A will control whether the form will display this region or not.

If you select an up-sell, substitute or superceded item and then click Add to Selection, the selected item will replace the original item and be placed in the Current Selections region. You can only select one replacement item.

If you select one or more cross-sell items (or other relationship types) and then click Add to Selection, the original item and all of the selected items will be placed in the Current Selections region.

To clear the Current Selections region, click Clear Selections. To clear the entire window, click Clear Form. To clear only the inquiry section, click New Inquiry.

Repricing of the Current Selections region: Since the price of the main item or the items in the current selections region can depend on other items because there may be cross item discounts, we reprice all the items when an item is deleted from the current selections region. When we price the main item, we consider all the items present in the current selections region, so if there any discounts because of presence of other items, it will be shown. Also, the price of the items in the Current Selections region are updated, if a new item is added to that region as price may change because of additional modifiers because of the new item.

Hints Region

The Hints regions displays messages about the item being queried that alert you to view one or more Results regions. For example, if related items exist, a hint will be displayed. If additional pricing benefits apply to this item, a hint will be displayed. If price breaks exist, a hint will be displayed here. There is also an OM System Parameter where you can enter a Default Hint for Pricing & Availability. If you enter text in that parameter, it will be displayed in the Hints region.

To perform a price/availability check for a single item and then add it to an order:

When you perform a Price/Availability check, for performance reasons only the current tab in the results region is populated. As you navigate to other tabs data is populated.

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

3. Enter a customer account number (if known) or search for customer by name using the List of Values, or Find Customer.

4. Click Price and Availability. Review your information. When the customer agrees, click Add To Order, depending on the current selections displayed.

   Note: If the order type was already defaulted or entered before the Pricing and Availability query, then a message can be displayed saying 'Order xxxxx has been created. Do you want to open the order?' If the order type was not previously available, you will be asked to choose an order type, and then receive the same message as above. If you want to open the order, you will be transferred to either the Quick Sales Orders or the Sales Orders window with that order displayed. If you choose No, you will remain in the Price and Availability window to enter another query. The note displayed after a quote/order is created depends on the profile option Sales Order navigation from Pricing and Availability form. It can just display a note, ask you want to see the details or go directly to the Sales Orders window based on this profile.

To perform a price/availability check for a single item and then save it as quote:

You can create quotes/orders without doing a price/availability check. It is not always necessary to do a price/availability before creating a quote/order.

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Click Price and Availability.

5. The customer wants a quote. Click Save As Quote. See above note regarding selecting Order Type and viewing the resulting order or quote.

To perform a price/availability check with related items, and then add it to order (Selected items region not displayed):

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

   Note: The item turns a different color and a message is displayed in the hint region indicating that Related Items exist for this item.

   Note: If a line level modifier is applied to the main item in the search region, it is not applied to related items which does not substitute the main item. If the related item, is for instance 'up-sell,' that substitutes the main item, then the manual modifier applied to the item in the search region is carried over to the related item.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Click Price and Availability.

5. Select the Related Items tab in the results section to view Related Items. If the customer wants a related item, select the check box on the lines displaying the pertinent related item.

   Related Items tab.

   

6. If the customer wants an order, click Add To Order. See above note regarding selecting Order Type and viewing the resulting order or quote.

   Note: For automatic Item upgrade through pricing, the new item is added to the current selections region, The price shows for the old item, but the related_items and availability is for the new item.

To perform a price/availability check with manual adjustments applied, and then add it to an order (Selected items region not displayed):

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Click Price and Availability, then choose the Price Adjustments tab. Click Add Adjustment, and select a manual adjustment from the List of Values. The manual adjustment is applied and the unit selling price is updated to reflect the adjustment.

   The button Add Adjustment is displayed based on the combination of the profile "OM: Discounting Privileges" and the "enforce List price" flag for the Order Type. If the order type is not entered then we do not consider the "Enforce List Price" flag and assume it to be false. We look at the profile OM: Discounting Privilege to see if the user has the privilege to apply the manual adjustments. Also if this privilege is FULL, then if the Order Type has Enforce List Price, a manual adjustment cannot be applied. If the privilege is None the user can never apply a manual adjustment.

   Note: When the Enforce List Price is set to Yes, Automatic Modifiers are not applied regardless of the OM: Discounting Privilege profile.

   OM: Discount Privilege Options

   OM: Discounting Privilege	Enforce List Price	Apply Manual Adjustment?
   Full	Y	No
   Full	N	Yes
   Unlimited	Does not matter	Yes
   Non-overridable only	Y	No
   Non-overridable only	N	Yes
   None	Does not matter	No

5. Click Add To Order. See above note regarding selecting Order Type and viewing the resulting order or quote.

To perform a price/availability check with the customer providing a coupon number and asking for a specific promotion, and then add it to an order (Selected items region not displayed):

Note: In the promotions window, only "ASK FOR" promotions display. Ask for promotions can be either Manual or Automatic. Automatic Ask For promotions, are automatically applied to the promotion when you choose from the Promotions Lov. For Manual Promotions, you must first choose that promotion in the promotions Lov. Once this is done, then the promotion will appear in the Manual Adjustments Lov and you manually apply it.

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Choose the More tab. Enter the coupon number and promotion number, or optionally search for the promotion or coupon using the List of Values. If you have more than one promotion or coupon, click More Promotions to access the Promotions/Coupons window.

   Pricing and Availability Window displaying the region to Enter Additional Promotional/Coupon information window.

   

5. Click Price and Availability.

6. Select the Price Adjustments tab and click Add Adjustment. The List of Values displays the available manual adjustments. Choose a manual adjustment. The manual adjustment is applied and the unit selling price is updated to reflect the adjustment.

7. Click Add To Order. See above note regarding selecting Order Type and viewing the resulting order or quote.

To perform a price/availability check for multiple items, and then add them in a group to an order:

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Click Price and Availability, and then click Add To Selections. The item is added to the current selection region along with the related items. The data displayed includes the quantity, unit selling price, extended price.

5. Begin a new Pricing and Availability search as in the steps above, then click Price and Availability.

6. The customer wants both items, click Add To Order. See above note regarding selecting Order Type and viewing the resulting order or quote.

To perform a price/availability check for multiple items with related items, and then add them in a group to an order:

1. Navigate to the Pricing and Availability window.

2. Enter your item information, then tab out of the Item field. Choose your item from the List of Values. If there are related items, the item turns a different color and a message is displayed in the Hint region.

3. Enter a customer account number (if known) or search for customer by name using the List of Values or use Find Customer.

4. Click Price and Availability.

5. Select the Related Items tab in the results section to view Related Items. If the customer wants a related item, select the check box on the lines displaying the pertinent related item.

   Note: If the selected items results in “Add” (Cross-sell) then the item will be added to the current selection as mentioned below If the selected item results in a replace then a message results giving you the option to initiate a new pricing/availability inquiry for the replace item. If you select Yes then the results are re-displayed for the replace item. If you select No then the replace item is selected in the related items tab.

6. Click Add To Selections. The item is added to the current selection region along with the items selected in related items. If a replace item is selected then only the replace item is added and not the original item.

7. Start a new Pricing and Availability by entering an item, then tab out of the field. Select the item and enter the quantity and UOM.

   Note: The Pricing and Availability window calls the pricing engine in the Batch mode. If you define a Custom Phase and associate it with an event that is placed in sales order then that phase has also to be associated with the BATCH event to get the modifier in the Pricing and Availability window. If you define Custom Phases or end dates, in some phases in other events then do the same for the BATCH event.

8. Click Price and Availability. Click Add To Order.

   Note: If the order type was already defaulted or entered before the pricing and availability query, then a message is displayed saying 'Order xxxxx has been created. Do you want to open the order?' The order is created with both the items and with related items. If the order type was not previously available, you are asked to choose an order type, and then you receive the same message as above. If you want to open the order, you are transferred to the Quick Sales Orders window with that order displayed. If you enter No, you remain in the Price and Availability window to enter another query.

To perform Pricing and Availability checking:

1. Navigate to the Pricing and Availability window.

   Pricing and Availability Window

   

2. Determine your Pricing and Availability search criteria by entering specific or partial values for required fields within the Search Criteria Region. Required fields are Currency, UOM, Quantity and either item name or item description (Since either the item name or the description can be entered to check price and availability neither field is displayed with the mandatory field color).

   You must enter a value for all required fields, and you can enter additional optional values to further refine your search criteria within any of the three Search tabs available.

   Note: If you clear the form, and then requery for price and availability checking, the current tabs selected in both the Search and Results regions remains active.

   Note: For example, if you are currently viewing details within the Pricing tab, click the Clear button or Clear Record icon from the Toolbar, re-enter a new item, and click Price and Availability, the Pricing Tab details still displayed.

Overview of Find Customer Information

The Sales Orders and the Quick Order Entry windows contain an enhanced method of finding customers and addresses. Customers may have multiple accounts, so the account name is the same but the account number is different. When several instances of the same customer exist, locating an address or identifying a customer can be difficult. The same situation is applicable to customer contacts. Contacts are associated with either a customer account or an address. The Find Customer Information window enables these searches.

The Sales Order window displays only active customers whereas the Order Organizer displays all the customers as you might need to query based on old or inactive customers.

Finding Customer Information

You can use the Find Customer Information window to locate a customer account, address, or a contact. This search can be initialized from both the Sales Orders and Quick Order Entry windows.

The Find Customer Information window can be started four different ways:

1. Through the new Find Customer icon on the tool bar.

2. By invoking the List of Values from the following fields: Ship To City, Ship To Postal Code, Ship To Address2, Ship To Address4, Ship To Address5, Invoice To City, Invoice To Postal Code, Invoice To Address2, Invoice To Address4, Invoice To Address5, End Customer Address2, End Customer Address4, End Customer Address5, Customer Location Address2, Customer Location Address4, or Customer Location Address5. This allows you to search using different attributes.

3. By entering a partial value and then tabbing out of the above fields.

4. Through the right mouse menu Customer >Find Customer.

On the Quick Order Entry window the Find Customer Information window can be opened in the Addresses window either from the Tools menu, by a right mouse click, or from the Find Customer icon, in addition to the methods mentioned above.

Note: The Find Customer Information window can be invoked in the Quick Order Entry window from the Tools menu when the cursor is in the order header region.

Find Customer Information Window

The Operating Unit field is folder enabled in the Find Customer window. The field will default the Operating Unit from the Sales Order window. If there is no default then you can select an Operating Unit accessible to you from the LOV. An Operating Unit is required before you can specify other search criteria.

Phone country code & Phone extension are hidden fields and can be displayed using folder functionality.

The phone number field can be used for looking up a customer. The phone number can be either a customer phone number or a phone number associated with a specific address.

Note: The telephone number will search for a match at the customer or site level only. Searching on partial telephone numbers is not supported.

Advanced Item Search

Order takers need the ability to rapidly identify what product their customers want to order, and to search for items using different methods and parameters. Some of the parameters needed by customers include:

• Item description

• Category

• Catalog information

• Manufacturer

• Form, fit, and function

The list of specific parameters will vary by industry. Users need the ability to access electronic catalogs of goods supplied by different manufacturers and order by characteristics that vary frequently. For example, a distributor of CDs, DVDs, or videos may take orders by the Current Chart Position or the catalog number, artist, title, etc. All these methods of searching for the item are available from the Advanced Item Search window, which can be called from the Sales Orders or Quick Sales Orders windows, and once an item is selected, it creates the sales order line.

Note: The Advanced Item Search functionality will not support returns. In case of returns, you will need to identify the item to return. You can identify this item from the sales order or search for the item to return from the Simple Ordered Item Search LOV.

Advanced Item Search Major Features

Advanced Item Search From the Sales Orders Window

You can access the Advanced Item Search from the Sales Orders window. Once the item has been located, you can create an order line with the selected item.

Validation of the Item Sent to the Order Line

Using the Sales Orders window, choose the Actions menu to access the Advanced Search page. Along with entered search criteria as specified in the Advanced Search page, the following restrictions apply while performing the query:

• Items returned by the query must be customer order enabled.

• Items must be enabled in the inventory organization passed by Order Management. Order Management passes the item validation organization of the operating unit which is associated with the responsibility of the person entering the order. This ensures that the selected items will be valid when returned to the sales order.

  Note: It is not the item status that is considered during order entry. The flag Customer Order Enabled controls if an item can be entered through sales order pad and the flag Internal Order Enabled controls if an item can be ordered internally. Item status controls values of the 8 "status" attributes (stockable, transactable, purchasable, customer order enabled etc.). See the Oracle Inventory User's Guide, Item Setup.

Select Multiple Items From a Single Search

More than one item may be selected, and they are sent back to the Sales Orders window. The default quantity added to the order line will be 1.

Advanced Item Search Process Flow

User Procedures

The new Advanced Item Search is available from the Quick Sales Orders window, and Sales Orders window.

To access Advanced Item Search from the Sales Orders or Quick Sales Orders window:

1. Navigate to the Sales Orders or Quick Sales Orders window.

2. Enter the header information and choose the Line Items tab.

3. Choose Actions > Advanced Items Search. Click OK.

   Advanced Items Search Page

   

4. Enter your search criteria and click Search. The Advanced Items Search page displays.

5. Select the item(s) for the sales order and click Go. Optionally click the Item link to display the item details. After selecting the appropriate items, they are added to the sales order.

6. The Sales Orders window displays asking if the items are to be added. Click OK to create the new line items. If you click CANCEL all the item selection will be lost and no lines will be added to the sales order.

   Note: If you click OK or CANCEL in the Sales Orders window's Message window before completing item selection in the Advanced Item Search window, the synchronized Advanced Item Search session will be automatically inactivated and an error message displays in the Advanced item search window after you complete the item selection and click Go.

   Note: If any of the lines fail validation, a messages displays in the Processing Messages window. If you click Cancel the item selection is discarded. If the window of a previously synchronized session is used without closing it, after the items are added to Sales Orders window, an error message displays.

Messages

Message Name: ONT_AIS_ADD_LINES (Note)

Message Text: Please select items in the Advance Item Search page. Items selected in the Advance Item Search page will be added to the sales order. Do you want to continue?

Message Name: ONT_AIS_NO_ITEM_SELECTED (Note)

Message Text: No items were selected in the Advanced Item Search page.

Message Name: ONT_AIS_ QUICKSALES_LINES (Note)

Message Text: Please specify the header information and navigate to the line region to use this feature.

Message Name: ONT_ADVITEMSRCH_CONFIRM (Note)

Message Text: Confirmation message for the Advanced Item Search and Sales Orders window Synchronization.

Message Name: ONT_ADVITEMSEARCH_SELECTED (Note)

Message Text: Please close this Advanced Item Search page and go to the Sales Orders window to synchronize your item selection.

Message Name: ONT_ADVITEMSRCH_ERROR (Error)

Message Text: Error message for the Advanced Item Search and Sales Orders window Synchronization.

Message Name: ONT_ADVITEMSRCH_USEDSESSION (Error)

Message Text: This Advanced Item Search session has already been synchronized with the Sales Orders window. To make any new items selection please close the Advanced Item Search page and start a new Advanced Item Search operation from the Sales Orders window or use other Advanced Item Search page that is still not synchronized with the Sales Orders window.