Monitoring business transactions


This topic discusses the type of business transaction information that can be monitored by PATROL. The business transaction information is displayed in reports. These reports are found in the various applications.

This topic contains the following information:

Accounts Payable (AP)

The Oracle Payables module, commonly known as Accounts Payable, allows you to keep track of vendors with whom your company does business. It allows you to enter invoices from those vendors, set up and track all the necessary approval steps necessary to fit your internal procedures, and then track payments against those invoices. PATROL monitors the following:

  • AP user information
  • AP processes n AP concurrent requests
  • AP Critical Tables with extents over a user defined threshold
  • Number of invoice headers and lines entered (all and by personnel)
  • Invoices on hold
  • Number of checks issued
Accounts Receivable (AR)

The Oracle Receivables module, commonly referred to as Accounts Receivable, allows the user to enter various types of transactions. Among those are invoices for which customers owe your company money. Customers can be internal or external to the company. Receipts can also be entered into the system to record payment toward customer invoices, credit memos or crackerjacks. Other types of transactions that are entered into the Accounts Receivable module include credit memos and adjustments. PATROL monitors the following:

  • AR user information
  • AR processes
  • AR concurrent requests
  • AR Critical Tables with extents over a user defined threshold
  • Number of invoice headers and lines entered (all and by personnel)
  • Disputed invoices entered
  • Adjustments entered
  • Receipts entered
Bill of Materials (BOM)

The Bill of Materials module allows an Oracle Applications organization to define and maintain its BOMs. The most common type of bill is a standard bill of material. A standard bill lists the assembly or subassembly that are associated with a product. It specifies the required quantity for each component plus other information to control work in process, material planning, and other Oracle Manufacturing functions. Because each of the components in a bill of material is a part or item of its own, BOM relies on data in the Inventory module. Those inventory items must be defined before you can reference them in a bill of material. An Oracle Applications user can set up base models for a bill of material, and can even store revisions of a bill of material. A routing defines the operations you perform to manufacture an item. For routings, you define operations, the sequence to perform them, and the resources required at each operation. PATROL monitors the following:

  • BOM user information
  • BOM processes
  • BOM concurrent requests
  • BOM Critical Tables with extents over a user defined threshold
  • List and number of items affected by "mass change bills of material"
  • List and number of BOM headers and lines entered
  • List and number of change orders
  • List and number of routings
General Ledger (GL)

The General Ledger module allows you to manage the financial information of your company within any company structure. It allows you to set up multiple company structures (sets of books), each with different accounting structures, and still allows you to do consolidated company wide financial reporting. One of the main types of transactions handled within the General Ledger module is the Journal Entry. Data for journal entries can be entered via on line screens, or through an import (or batch interface) feature from another Oracle Applications module or even an external application. PATROL monitors the following:

  • GL user information
  • GL processes
  • GL concurrent requests
  • GL Critical Tables with extents over a user defined threshold
  • Number of journal entry headers and lines (all, by source and by category)
Human Resources (HR)

The Human Resources module provides a flexible employee management system that enables you to organize your employees exactly as you require. Using the Oracle HRMS you can hold, inquire about, and track a wide range of personal data including employee addresses, work schedules, and contact information. You can also enter, maintain, report and inquire about all aspects of employment information such as assignment details, performance ratings, pay and benefits, and employee development. You can customize Oracle HR using Special Information Types to record particular information you need to know. PATROL monitors the following:

  • HR user information
  • HR processes
  • HR concurrent requests
  • HR Critical Tables with extents over a user defined threshold
  • List of HR applicant records entered
  • List of HR assignment records entered
  • List of HR employee records entered
Inventory (INV)

The Inventory module allows an Oracle Applications organization to define and maintain its inventory. When defining items in your inventory you can categorize them in various different ways, specify the units of measure (UOM) as well as conversion rules to go from one UOM to another. An Oracle Applications user can tie one piece of inventory to another and define a sub-inventory. In maintaining inventory, there are several types of transactions that can take place that will alter the level of inventory of a particular item. These transactions will be accounted for within this application. An Oracle Applications user can track physical inventory, perform cycle counts, provide demand and reservation information and forecasting information. PATROL monitors the following:

  • INV user information
  • INV processes
  • INV concurrent requests
  • INV Critical Tables with extents over a user defined threshold
  • Material transaction statistics
  • Cycle count information
Master Scheduling/Material Requirements Planning (MRP)

The Master Scheduling/Material Requirements Planning module assists the user in planning and scheduling work to be done and resources needed to complete that work. Material requirements planning and scheduling is a vital part of the entire manufacturing life cycle, regardless of the industry or type of manufacturing. Also, using the knowledge of past schedules and resource requirements can aide in the development of accurate forecasting for future work. This can save both time and money for a manufacturing facility. PATROL monitors the following:

  • MRP user information
  • MRP processes
  • MRP concurrent requests
  • MRP Critical Tables with extents over a user defined threshold
  • Number of schedule headers entered
  • Number of schedule lines entered
  • Number of forecast headers entered
  • Number of forecast lines entered

 

 

Order Entry (OE)

 

Note

On Oracle Applications server version 11i or later, the equivalent Order Management module is monitored.

The Order Entry (OE) module allows you to enter sales orders, requests for material authorization (RMAs, known also as Returns), keep track of customer information like addresses, contacts, phone numbers, type of customer, and maintain price lists, discounts, and agreements with the customer. PATROL monitors the following areas:

  • OE user information
  • OE processes
  • OE concurrent requests
  • OE Critical Tables with extents over a user defined threshold
  • Number of sales order headers entered
  • Number of order lines entered
  • Number of RMA headers entered
  • Number of RMA lines entered
  • Customer database statistics
  • List of price lists/lines that have expired
Order Management (OM)

 

Note

On Oracle Applications 11.0.x, the equivalent Order Entry module is monitored.

Using the Order Management Suite, you can enter sales orders, calculate the price of items on order lines, fulfill the orders, and send information to an accounts receivable system so that invoices are created. The core OM products are Oracle Order Management, Oracle Shipping Execution, and Oracle Pricing. The business processes supported by Order Management include standard sales orders, returns, and drop ship. For Shipping Execution these processes include shipping and container management. The Pricing setup enables you to create pricing information such as price lists and modifiers. PATROL monitors the following:

  • OM user information
  • OM processes
  • OM concurrent requests
  • OM Critical Tables with extents over a user defined threshold
  • Number of OM order headers created
  • Number of OM sales order lines created
Payroll Runs and Processes (PAY)

The main purpose of the payroll run is to calculate employee pay at regular intervals. In addition, Oracle Payroll enables you to perform other payroll processes to ensure accuracy and provide flexibility within your organization. For example, you can roll back a payroll run when you want to carry out a test run without keeping any record of it occurring. You can run a RetroPay process when you want to make retrospective adjustments to allow for backdated pay awards. In addition, you can run a partial payroll if you need to calculate pay for an individual employee, or specify particular types of earnings or particular categories of employee to be included in a payroll run. PATROL monitors the following:

  • PAY user information
  • PAY processes
  • PAY concurrent requests
  • PAY Critical Tables with extents over a user defined threshold
  • Number of payroll MIX (mass information exchange) lines from a batch created or
    processed since last discovery
  • Number of errors generated when processing a MIX line from a batch processed since last discovery
Purchase Order (PO)

The Purchase Order module allows a user to manually or automatically enter requisitions of material. It has interfaces to and from many other application modules and, as with all the other modules, can be easily interfaced with custom or legacy systems as well with the interface files provided. The PO system will track all levels of approval and then ultimately can be used to generate purchase orders. An Oracle Applications user can compare planned expenses to your budget by performing on-line funds checking prior to creating requisitions. Vendor information can be entered, along with delivery information, free form notes, currency and pricing information. You can also track receipts, inspection results, transfers and deliveries. PATROL monitors the following:

  • PO user information
  • PO processes
  • PO concurrent requests
  • PO Critical Tables with extents over a user defined threshold
  • Number of purchase order lines entered
  • Number of requisition headers entered
  • Number of requisition lines entered
  • Number of receipt headers entered
  • Number of receipt lines entered
  • Number and list of purchase order headers entered by category and source per hour
Sales Compensation (CN)

The Sales Compensation module is a CRM (Customer Relationship Management) module that provides an online application for the design, distribution, and administration of variable compensation plans. Based on logic configured by the end user, the application determines what events are eligible for incentive payments, who should receive credit, and how credits are calculated and paid. Everyone who needs to work with incentive information can do so online as part of a single, coherent system of compensation management. PATROL monitors the following:

  • CN user information
  • CN processes
  • CN concurrent requests
  • CN Critical Tables with extents over a user defined threshold
  • Number of commission lines entered
  • Number of commission headers entered
  • Number of commission lines API transactions entered
Supply Chain Management Planning (MSC)

The Supply Chain Management (SCM) solution optimizes the flow of material, cash, and information across your virtual supply chain. PATROL supports three planning (MSC) modules in the Supply Chain Management solution: Demand Planning, Advanced Supply Chain Planning, and Global ATP Server. The following aspects of Supply Chain Management Planning are monitored:

  • MSC user information
  • MSC processes
  • MSC concurrent requests
  • MSC Critical Tables with extents over a user defined threshold
  • Number of Bills of Material created
  • Number of components used in a Bill of Material entered
  • Number of operation components entered
  • Number of operation resources entered
  • Number of operation resources for each routing operation entered
  • Number of operations composing each routing entered
  • Number of organization items entered
Work in Progress (WIP)

The Work in Process module of Oracle Applications provides a work order tracking system. Oracle WIP enables you to produce assemblies in discrete batches, also known as discrete jobs. An Oracle Applications user can control jobs from planning to completion, including such activities as rework, field service repair, upgrade, disassembly, maintenance, engineering prototypes, and other projects. It allows you to schedule jobs, reschedules jobs (manually or automatically), plan for future jobs, and track discrete job costs including variances. PATROL monitors the following:

  • WIP user information
  • WIP processes
  • WIP concurrent requests
  • WIP Critical Tables with extents over a user defined threshold
  • List and number of transactions entered by type
  • Number of lines entered by transaction type

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*