Audit Information Report
The Audit Information Report displays the number of incidents retrieved by a particular audit statement and occurrences of data that are retrieved by an audit statement.
Report Submission
In the Submit Requests window, enter Audit Information Report in the Name field.
Report Parameters
Show
Choose one of the following options:
Errors only: Report information that can cause your concurrent program to fail.
Warnings and errors: Report information that can cause your concurrent program to fail, as well as information that does not cause your concurrent program to fail, but is still questionable data.
Warnings only: Report information that does not cause your concurrent program to fail, but is still questionable data.
Application
Enter the application for which to run the audit.
Audit
Choose one of the following options:
Accounting period start dates that do not fall on week start dates: Identify accounting period start dates that do not fall on week start dates.
All audits: Identify the nature of all suspected incidents. If there are any incidents, you can use the other choices in this form for a more detailed audit that pinpoints the exact occurrence of the incident.
Duplicate suppliers: Identify duplicate supplier entries.
Bills common to non-existent bills: Identify bills that are common references to non-existent bills.
Bills common to other bills with different alternate designator: Identify bills that are common references to other bills that have a different alternate designator.
Bills in bom_inventory_components but do not exist in bom_bill_of material: Identify components on bills that do not have a valid bill of material.
Bills that are buy items: Identify bills that have an item planning attribute of Buy.
Bills that do not exist in the item master: Identify bills that do not exist in the item master.
Bills that exist in both manufacturing and engineering: Identify bills that exist in both manufacturing and engineering.
Bills with BOM enabled flag set to No: Identify bills that have their BOM enabled flag set to No.
Bills with no components: Identify bills with no components.
Capacity modifications that add already existing workdays: Identify capacity modifications that add workdays that already exist in the workday calendar.
Components that do not exist in item master: Identify components that do not exist in the item master.
Components with BOM enable flag set to No: Identify components that have their BOM enabled flag set to No.
Components with incorrect number of reference designators: Identify components on bills of material that have the incorrect number of reference designators.
Components with revised_item_sequence_ids that do not exist in eng_revised_items: Identify components with revised item sequence numbers that do not exist for engineering revised items.
Components with zero usage quantity: Identify components that do not have a usage quantity.
Costed items not assigned to the costing category set: Identify costed items that are not assigned to a costing category set.
Costed items with no frozen costs: Identify asset items with no frozen costs.
ECOs with no schedule date: Identify engineering change orders that do not have a schedule date.
ECOs have future implementation dates: Identify engineering change orders that have future implementation dates.
Forecast entries with a zero confidence percent: Identify forecast entries with a zero confidence percent.
Forecasted items that are not planned and are not planning items or models: Identify forecasted items that are not planned and are not planning items or models.
Items that are MRP or MPS planned but with no planning exception set: Identify items that are MRP or MPS planned but do not have a planning exception set.
Items that are not planned: Identify items with no planning type.
Items that are planned as buy but are not purchasable: Identify items that have an item planning attribute of Buy but are not purchasable.
Items that are planned as make but are not made in WIP: Identify items that have an item planning attribute of Make but are not buildable in work in process.
Items that are planned but not in the planning category set: Identify items that are planned but are not in the planning category set.
Items that do not have revisions: Identify items that do not have revisions.
Items that have incorrect summary costs: Identify items whose summary costs do not agree with the detailed cost information.
Items with an invalid shrinkage: Identify items with an invalid shrinkage factor.
Op res with autocharge of PO Move or PO Receipt and no location: Identify resources assigned to operations with an autocharge type of PO move or PO receipt that do not have a location.
Op res with autocharge of PO Move or PO Receipt and negative usage rates: Identify resources assigned to operations with an autocharge type of PO move or PO receipt that have negative usage rates.
Operation sequences that use invalid resources: Identify operation sequences that use invalid resources.
Operations that have lead time percents or offset percents exceeding 100%: Identify operations where lead time and offset percents exceed 100%.
Operations with non-existent routing_sequence_ids: Identify operations with non-existent routing sequences.
Planned items with no gross requirements or scheduled receipts: Identify planned items with no gross requirements or scheduled receipts.
Planned items with zero full lead time: Identify MPS and MRP planned items where the sum of their pre, post, and processing lead times equals zero.
Planned make items with postprocessing lead time: Identify items with an item planning attribute of Make with postprocessing lead time.
Planned, purchased bills ignored by MRP: Identify planned and purchased bills that the planning process ignores.
Planning organizations with invalid quarterly calendar types: Identify organizations whose quarterly calendar has twelve periods per year, based on calendar months.
Repetitive items with pre or postprocessing lead time: Identify repetitive parts with preprocessing or postprocessing lead time.
Repetitive master schedule entries with invalid work dates: Identify repetitive master schedule entries with invalid workdays.
Repetitive planning flag in mtl_system_items is null: Identify items that do not have a value for the repetitive planning item attribute.
Repetitively planned purchased components: Identify repetitively planned components that are purchased.
Routings common to non-existent routings: Identify routings that are common to non-existent routings.
Routings common to other routings with different alternate designator: Identify routings that are common references to other routings that have a different alternate designator.
Routings that exist in both manufacturing and engineering: Identify routings that exist in both manufacturing and engineering.
Routings with zero processing time: Identify routings with zero processing time.
Routings without corresponding revisions: Identify routings without corresponding revisions.
Rows that errored in the table MRP_RELIEF_INTERFACE: Identify rows that failed in the MRP_RELIEF_INTERFACE table.
Rows that failed in MRP_LOAD_PARAMETERS: Identify rows that failed in the MRP_LOAD_PARAMETERS table.
Rows that failed in MRP_SALES_ORDER_UPDATES: Identify rows that failed in the MRP_SALES_ORDER_UPDATE table.
Rows that failed in the forecast interface table: Identify rows that failed in the forecast interface table.
Rows that failed in the schedule interface table: Identify rows that failed in the schedule interface table.
Schedule date rows with sales order orig that have null source sales order id: Identify schedule date rows with sales order origination that do not have a source sales order identifier.
Schedule entries for discrete items no original quantities: Identify master schedule entries for discrete items with no original quantities.
Schedule entries for discrete items end date: Identify master schedule entries for discrete items with end dates.
Schedule entries for repetitive items with no end date: Identify master schedule entries for repetitive items with no end dates.
Scheduled items that are not planned: Identify master schedule entries that are not planned.
Standard operations which use invalid resources: Identify standard operations that use invalid resources.
Summary
Choose one of the following options:
No: Report a list of the items that match your audit. For example, if you entered All audits in the Audit field, Oracle Master Scheduling/MRP and Supply Chain Planning prints a list of the items that are discretely planned, but have a schedule entry with a start date, a rate, and an end date.
Yes: Report a list of the items that match your audit and can cause your concurrent program to fail, and a count of the items that match your audit that does not cause your concurrent program to fail, but is still questionable data. For example, if you entered All audits in the Audit field, Oracle Master Scheduling/MRP and Supply Chain Planning prints a list of the items that are discretely planned, but have a schedule entry with a start date, a rate, and an end date. It also prints a count of the items that are not planned.
See Also
Submitting a Request