Previous  Next          Contents  Index    Library

Predefined Inquiry Flows

This section describes the predefined inquiry flows installed with Oracle Web Customers, Oracle Web Employees, and Oracle Web Suppliers.

You can use the information below to customize the predefined inquiries, or to help you design your own custom inquiries.

Many inquiries have predefined securing and / or excluding attributes. These are listed below with the description of the inquiry. There may also be securing or excluding attributes predefined at the responsibility level. For a list of predefined securing and excluding attributes at the responsibility level, see: Data Security.

Viewing and Modifying an Inquiry Flow

Each of the predefined inquiries has a 1st flow page ID and a 1st region ID that you use to query the details using the Web Applications Dictionary. For example, the Margin Analysis by Customer's 1st flow page ID is ICX_CUSTOMER_MARGIN; the 1st region ID is ICX_90DAY_ANALYSIS_BY_CUSTOMER.

Each inquiry retrieves data from one or more Oracle Applications. For example, the Outbound Request for Quotes retrieves data from Oracle Purchasing.

   To modify or view an inquiry flow:

Automotive Inquiries

The automotive inquiries provide information on demand transactions passed through the Oracle Demand Stream Processor to the internal demand manager and the customer's supply manager. With these inquiries, you can view details of each transaction, including transaction date and time, whether the transaction was processed without errors, the number of records processed, the quantity of demand by customer item, and the individual demand records with job sequence and job number.

View Demand by Item

Provides summary information on like item orders between customers and suppliers.

1st Flow Page ID ICX DEMAND BY ITEMS
1st Region ID ICX TRANSMISSIONS BY ITEMS
Application(s) Accessed Oracle Automotive
Securing Attribute(s) ICX_CUSTOMER_ORG_ID, ICX_CUSTOMER_SITE_ID. See: Data Security.

View Demand by Order Number

Provides information by order number.

1st Flow Page ID ICX DEMAND BY SO
1st Region ID ICX TRANSMISSIONS BY SO
Application(s) Accessed Oracle Automotive
Securing Attribute(s) ICX_CUSTOMER_ORG_ID, ICX_CUSTOMER_SITE_ID. See: Data Security.

Customer Summary Inquiry

Customer Summary

Provides a view of the entire customer relationship, including profile information and order information such as sales orders, returns, cancellations, and service orders. With this inquiry, customers can view their own profile, service coverage, order status, service requests, and so on. Field service and sales personnel can look up information on their customers, and senior management can view a complete customer profile.

1st Flow Page ID ICX_PANEL_CUSTOMERS_ALL
1st Region ID ICX_CUSTOMER_LIST
Application(s) Accessed Oracle Service, Order Entry, Receivables
Securing Attribute(s) ICX_CUSTOMER_ORG_ID. See: Data Security.

Engineering Change Order (ECO) Inquiry

Engineering Change Order

Employees and suppliers can view ECO information, including revised items and components. This inquiry also provides detailed information derived from Oracle Purchasing, Order Entry, Planning, and Service.

1st Flow Page ID ENG_ECO_REVISIONS
1st Region ID ENG_ECO_HEADER
Application(s) Accessed Oracle Engineering, Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, and Service

Item Forecasts Inquiry

Item Forecasts

Provides information on items in a particular forecast.

1st Flow Page ID ICX_MRP_FORECASTS_D
1st Region ID ICX_MRP_FORECASTS_D
Application(s) Accessed Oracle Master Scheduling / MRP and Supply Chain Planning
Securing Attribute(s) ICX_CUSTOMER_ORG_ID. See: Data Security.

List of Users Inquiry

List of Users

Provides a list of the users that have prepared the requisition.

1st Flow Page ID ICX_PO_LIST_USERS
1st Region ID ICX_PO_LIST_USERS
Application(s) Accessed Oracle Purchasing

Margin Analysis Inquiries

The Margin Analysis inquiries are extensions to the Margin Analysis report in Oracle Cost Management. The Margin Analysis inquiry describes how parts of the business contribute to the gross margin of the company. See: Margin Analysis Report.

Margin Analysis by Customer

This inquiry enables you to analyze margin analysis data by customer over the past 90 days, one month, and one week.

1st Flow Page ID ICX_CUSTOMER_MARGIN
1st Region ID ICX_90DAY_ANALYSIS_BY_CUSTOMER
Application(s) Accessed Oracle Cost Management
Securing Attribute(s) ICX_CUSTOMER_ORG_ID. See: Data Security.

Margin Analysis by Item

This inquiry enables you to analyze margin analysis data by item over the past 90 days, one month, and one week.

1st Flow Page ID ICX_ITEM_MARGIN
1st Region ID ICX_90DAY_ANAYLYSIS_BY_ITEM
Application(s) Accessed Oracle Cost Management

Margin Analysis by Sales Representative

This inquiry enables you to analyze margin analysis data by sales representative over the past 90 days, one month, and one week.

1st Flow Page ID ICX_SALESREP_MARGIN
1st Region ID ICX_90DAY_ANALYSIS_BY_SALESREP
Application(s) Accessed Oracle Cost Management

Margin Analysis by Territory

This inquiry enables you to analyze margin analysis data by territory over the past 90 days, one month, and one week.

1st Flow Page ID ICX_TERRITORY_MARGIN
1st Region ID ICX_90DAY_ANALYSIS_TERRITORY
Application(s) Accessed Oracle Cost Management

Outbound Request for Quotes Inquiry

All Open Requests for Quotes

Suppliers can view and respond to quote requests published by the enterprise.

1st Flow Page ID ICX_ALL_OPEN_RFQ
1st Region ID RFQ_HEADER_SUMMARY
Application(s) Accessed Oracle Purchasing
Securing Attribute(s) ICX_SUPPLIER_ORG_ID, ICX_SUPPLIER_SITE_ID, ICX_SUPPLIER_CONTACT_ID. See: Data Security.

Project Manufacturing Inquiries

Customers and employees can access project-related sales information, and suppliers can access project-related purchase order and requisition information.

All Projects

Intended for a super user, this flow has access to all project manufacturing inquiries.

1st Flow Page ID ICX_ALL_PROJECTS
1st Region ID ICX_ALL_PROJ_SUM
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management

Buyer / Supplier Projects

Used by an external project manager to access project information from a specific buyer.

1st Flow Page ID ICX_BUYER_SUPPLIER_PROJECTS
1st Region ID ICX_BUYER_SUPPLIER_PROJ_SUM
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management
Securing Attribute(s) ICX_SUPPLIER_ORG_ID, ICX_HR_PERSON_ID. See: Data Security.

Customer Projects

Provides customer access to project-related sales order information.

1st Flow Page ID ICX_CUSTOMER_PROJECTS
1st Region ID ICX_CUSTOMER_PROJ_SUM
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management
Securing Attribute(s) ICX_CUSTOMER_ORG_ID. See: Data Security.

Customer Sales Order Projects

Used by a customer to access project-related sales orders.

1st Flow Page ID ICX_PROJECT_SALES_ORDER
1st Region ID ICX_MFG_SO
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management
Securing Attribute(s) ICX_CUSTOMER_ORG_ID, ICX_CUSTOMER_CONTACT_ID. See: Data Security.

Key Member Projects

Used by an external project member to access project-related information.

1st Flow Page ID ICX_KEY_MEMBER_PROJECTS
1st Region ID ICX_KEY_MEMBER_PROJ_SUM
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management
Securing Attribute(s) ICX_HR_PERSON_ID. See: Data Security.

Planner Projects

Used by a project manager at a customer site to access project information by planner.

1st Flow Page ID ICX_PLANNER_PROJECT
1st Region ID ICX_PLANNER_PROJ_SUM
Application(s) Accessed Oracle Purchasing, Order Entry, Master Scheduling / MRP and Supply Chain Planning, Work in Process, Inventory, Projects, Cost Management
Securing Attribute(s) ICX_HR_PERSON_ID. See: Data Security.

Purchase Order Change History Inquiry

Purchase Order Change History

Provides historical information on purchase order changes to employees, suppliers, and customers. Making this information available on the web can decrease calls related to purchase order changes. Employees can avoid reversing purchasing decisions and make future decisions more intelligently. Employees, suppliers, and customers can share information rapidly, reducing lead and cycle times involved in your purchasing operation.

1st Flow Page ID ICX_REVISED_PO_ALL
1st Region ID ICX_HEADERS_ARCHIVE_CHANGES
Application(s) Accessed Oracle Purchasing, Payables
Excluding Attribute(s) DISTRIBUTION_NUM
Securing Attribute(s) ICX_SUPPLIER_ORG_ID, LEVEL_ALTERED. See: Data Security.

Requisition Inquiries

The requisition inquiries provide header, line, and historical information to purchasing buyers, planners, and managers.

Open Requisition by Users

Provides header information on open requisitions by user.

1st Flow Page ID ICX_PO_OPEN_REQS_BY_USERS
1st Region ID ICX_PO_OPEN_REQS_BY_USERS
Application(s) Accessed Oracle Purchasing

Open Requisition Lines

Provides line information on open requisitions by user.

1st Flow Page ID ICX_RQS_OPEN_1
1st Region ID ICX_RQS_OPEN_1
Application(s) Accessed Oracle Purchasing

Requisition by Users

Provides requisition header information by user.

1st Flow Page ID ICX_PO_REQS_BY_USERS
1st Region ID ICX_PO_REQS_BY_USERS
Application(s) Accessed Oracle Purchasing

Requisition Distributions

Displays General Ledger account distribution information on requisition lines.

1st Flow Page ID ICX_RQS_LINES_DIST
1st Region ID ICX_RQS_LINES_DIST
Application(s) Accessed Oracle Purchasing

Requisition History

Provides historical requisition information.

1st Flow Page ID ICX_RQS_HISTORY_1
1st Region ID ICX_RQS_HISTORY_1
Application(s) Accessed Oracle Purchasing

Service Request Inquiries

Customer Products Summary

Provides a summary of service requests by customer product.

1st Flow Page ID CS_CP_SUMMARY
1st Region ID CS_CP_SUMMARY
Application(s) Accessed Oracle Service
Securing Attribute(s) ICX_CUSTOMER_CONTACT_ID, ICX_CUSTOMER_ORG_ID. See: Data Security.

Repairs Summary

Provides a summary of repairs to a particular product.

1st Flow Page ID CS_DR_SUMMARY
1st Region ID CS_REPAIRS_SUMMARY
Application(s) Accessed Oracle Service
Securing Attribute(s) ICX_CUSTOMER_CONTACT_ID, ICX_CUSTOMER_ORG_ID. See: Data Security.

Service Requests Summary

Provides a summary of service requests on a particular product.

1st Flow Page ID CS_INCIDENT_SUMMARY
1st Region ID CS_INCIDENT_SUMMARY
Application(s) Accessed Oracle Service
Securing Attribute(s) ICX_CUSTOMER_CONTACT_ID, ICX_CUSTOMER_ORG_ID. See: Data Security.

Supplier Catalog Summary Inquiry

Supplier Catalog Summary

Displays available items and number of items ordered from the catalog.

1st Flow Page ID ICX_CATALOG_SUMMARY
1st Region ID ICX_CATALOG_SUMMARY_R
Application(s) Accessed Oracle Purchasing
Securing Attribute(s) ICX_SUPPLIER_ORG_ID. See: Data Security.

Supplier Schedule Inquiry

Schedule Summary

Suppliers can view planning and shipping schedules, including consolidated forecast and release information.

1st Flow Page ID ICX_SHIP_PLAN_SCHEDULE
1st Region ID ICX_CHV_HEADERS_SUM
Application(s) Accessed Oracle Supplier Scheduling

         Previous  Next          Contents  Index    Library