You are browsing the archive for Oracle Work In Process.

Resource Transaction Report

Resource Transaction report provides the list of all resource transactions (charges) to a discrete job / repetitive schedule.

Navigation: WIP Super User -> Report -> Single Request -> Select report name as ‘Resource Transaction Report’

resource transaction report

resource transaction report

Report Parameters:

  • Sort By
  • Show Details
  • Jobs/Schedules From
  • Jobs/Schedules To
  • Resources From
  • Resources To
  • Lines From
  • Lines To
  • Assemblies From
  • Assemblies To
  • Dates From
  • Dates To
  • Employees From
  • Employees To
  • Reasons From
  • Reasons To
  • Activities From
  • Activities To

Click ‘Submit’ to launch the report request.

Navigate to View -> Requests -> Find the request -> Click on View Output

Report Output:

resource transaction report output

resource transaction report output

Resource Performance Report

Resource performance report provides the efficiency of resources by each department. This will be helpful for analyzing the low performing resources and root causes for improving the shop floor efficiency.

Navigation: WIP Super User -> Report -> Single Request -> Select report name as ‘Resource Performance Report’

resource performance report

resource performance report

Report Parameters:

  • Resources From
  • Resources To
  • Departments From
  • Departments to
  • Job/Schedule Active Dates From
  • Job/Schedule Active Dates to
  • Minimum Efficiency
  • Maximum Efficiency

Click ‘Submit’ to launch the report request.

Navigate to View -> Requests -> Find the request -> Click on View Output

Report Output:


Repetitive Shop Packet Report

Repetitive Shop Packet Report is a report set that consists of four reports.

  • Repetitive Job Pick Slip Report
  • Repetitive Job Routing Sheet
  • Repetitive Line Report
  • Repetitive Job Shortage Report.

Navigation: WIP Super User -> Report -> Request Set Request -> Select report name as ‘Repetitive Job Packet Report’.

repetitive shop packet report

repetitive shop packet report

Select the parameters for each of the report.

Click ‘Submit’ to launch the report request.

Navigate to View -> Requests -> Find the request -> Click on View Output