You are browsing the archive for Oracle Work In Process.

WIP-S02 Work In Process Profile Options

Oracle WIP Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
WIP_NON_STD_MRP_NET WIP: Enable MRP Net for Non-standard Job Requirements
WIP_MES_OPS_FLAG WIP: MES for Discrete Manufacturing Install
WIP:CONFIGURATION_RESERVATION_LEVEL WIP:Configuration Reservation Level
WIP_COMPLETION_MTL_TRANSACTION TP:WIP Completion Material Processing
WIP_COMPLETION_TRANSACTION TP:WIP Completion Transactions Form
WIP_COMPLETION_TXNS_1ST_FIELD TP:WIP Completion Transactions First Field
WIP_DEFAULT_START_DATE WIP:Default Job Start Date
WIP_DISCRETE_DEFINE WIP:Define Discrete Job Form
WIP_JOB_PREFIX WIP:Discrete Job Prefix
WIP_JOB_UPDATABLE WIP:Job Name Updatable
WIP_MATERIAL_TRANSACTION TP:WIP Material Transactions Form
WIP_MATERIAL_TXNS_1ST_FIELD TP:WIP Material Transactions First Field
WIP_MOVE_COMPLETION_DEFAULT WIP:Move Completion Default
WIP_MOVE_TRANSACTION TP:WIP Move Transactions Form
WIP_MOVE_TXNS_1ST_FIELD TP:WIP Move Transactions First Field
WIP_MOVE_TXN_QTY_DEFAULT TP:WIP Move Transaction Quantity Default
WIP_OSP_WF WIP:Enable Outside Processing Workflows
WIP_RELEASED_REVS WIP:Exclude ECOs
WIP_REQUIREMENT_ATT_OPTION WIP:Requirement Nettable Option
WIP_RESOURCE_TXNS_1ST_FIELD TP:WIP Resource Transactions First Field
WIP_SEE_ENG_ITEMS WIP:See Engineering Items
WIP_SHOP_FLOOR_MTL_TRANSACTION TP:WIP Move Material Processing
WIP_WORKORDERLESS_COMP_FORM_DEFAULT TP:WIP Work Order-less Default Scheduled flag
WIP_PURCHASING_BY_REVISION WIP:Purchasing By Revision
WIP_WOL_COMPLETION_TRANSACTION TP:WIP Work Order-less Completions Form
WIP_CONC_MESSAGE_LEVEL TP:WIP Concurrent Message Level
WIP_LEADTIME_ROUND_MIN WIP: Round Off Resource Usage to Minutes in Lead Time Calculations

Work In Process Tables

Oracle Work In Process (WIP) Tables:

  • WIP_ACCOUNTING_CLASSES
  • WIP_BIS_EFF_TEMP
  • WIP_BIS_MNRA_TEMP
  • WIP_BIS_PERF_TO_PLAN
  • WIP_BIS_PERIOD_BALANCE
  • WIP_BIS_PROD_ASSY_YIELD
  • WIP_BIS_PROD_ASSY_YIELD_TEMP
  • WIP_BIS_PROD_DEPT_YIELD
  • WIP_BIS_PROD_DEPT_YIELD_TEMP
  • WIP_BIS_PROD_INDICATORS
  • WIP_BIS_PROD_INDICATORS_TEMP
  • WIP_BIS_UTZ_TEMP
  • WIP_BIS_YLD_TEMP
  • WIP_COST_TXN_INTERFACE
  • WIP_DEF_CAT_ACC_CLASSES
  • WIP_DISCRETE_JOBS
  • WIP_DJ_CLOSE_TEMP
  • WIP_EAM_DIRECT_ITEMS
  • WIP_EAM_PARAMETERS
  • WIP_EAM_PERIOD_BALANCES
  • WIP_EAM_WORK_REQUESTS
  • WIP_EAM_WORK_REQ_NOTES
  • WIP_EMPLOYEE_LABOR_RATES
  • WIP_EMPLOYEE_LABOR_RATES_EFC
  • WIP_ENTITIES
  • WIP_EXCEPTIONS
  • WIP_FLOW_SCHEDULES
  • WIP_INDICATORS_TEMP
  • WIP_INTERFACE_ERRORS
  • WIP_JOB_DTLS_INTERFACE
  • WIP_JOB_SCHEDULE_INTERFACE
  • WIP_LEADTIME_TEMP
  • WIP_LINES
  • WIP_LPN_COMPLETIONS
  • WIP_LPN_COMPLETIONS_LOTS
  • WIP_LPN_COMPLETIONS_SERIALS
  • WIP_MOVE_TRANSACTIONS
  • WIP_MOVE_TXN_ALLOCATIONS
  • WIP_MOVE_TXN_INTERFACE
  • WIP_MSC_OPEN_JOB_STATUSES
  • WIP_MTL_ALLOCATIONS_TEMP
  • WIP_OPERATIONS
  • WIP_OPERATION_NETWORKS
  • WIP_OPERATION_OVERHEADS
  • WIP_OPERATION_OVERHEADS_EFC
  • WIP_OPERATION_RESOURCES
  • WIP_OPERATION_RESOURCES_EFC
  • WIP_OPERATION_RESOURCE_USAGE
  • WIP_OPERATION_YIELDS
  • WIP_OPERATION_YIELDS_EFC
  • WIP_OP_RESOURCE_INSTANCES
  • WIP_OP_YIELD_HISTORY
  • WIP_OP_YIELD_REALLOCATIONS
  • WIP_PAC_ACTUAL_COST_DETAILS
  • WIP_PAC_ACTUAL_COST_DETAIL_EFC
  • WIP_PAC_PERIOD_BALANCES
  • WIP_PAC_PERIOD_BALANCES_EFC
  • WIP_PARAMETERS
  • WIP_PERIOD_BALANCES
  • WIP_PERIOD_BALANCES_EFC
  • WIP_PREFERENCES
  • WIP_PREFERENCE_DEFINITIONS
  • WIP_PREFERENCE_LEVELS
  • WIP_PREFERENCE_VALUES
  • WIP_PURGE_TEMP
  • WIP_REPETITIVE_ITEMS
  • WIP_REPETITIVE_SCHEDULES
  • WIP_REQUIREMENT_OPERATIONS
  • WIP_REQ_OPERATION_COST_DETAILS
  • WIP_REQ_OPERATION_COST_DET_EFC
  • WIP_RESOURCE_ACTUAL_TIMES
  • WIP_SCHEDULE_GROUPS
  • WIP_SCHEDULING_EXCEPTIONS
  • WIP_SCHEDULING_INTERFACE
  • WIP_SCHED_RELATIONSHIPS
  • WIP_SCRAP_VALUES
  • WIP_SCRAP_VALUES_EFC
  • WIP_SERIAL_MOVE_INTERFACE
  • WIP_SERIAL_MOVE_TRANSACTIONS
  • WIP_SHOP_FLOOR_STATUSES
  • WIP_SHOP_FLOOR_STATUS_CODES
  • WIP_SO_ALLOCATIONS
  • WIP_SO_ALLOCATIONS_TEMP
  • WIP_SUB_OPERATION_RESOURCES
  • WIP_SUB_OPERATION_RESOURCE_EFC
  • WIP_TEMP_REPORTS
  • WIP_TRANSACTIONS
  • WIP_TRANSACTIONS_EFC
  • WIP_TRANSACTION_ACCOUNTS
  • WIP_TRANSACTION_ACCOUNTS_EFC
  • WIP_TXN_ALLOCATIONS
  • WIP_TXN_INTERFACE_ERRORS
  • WIP_VALID_INTRAOPERATION_STEPS

Schedule Group Listing Report

Schedule Group Listing displays all information about schedule groups.

Navigation: WIP Super User -> Report -> Single Request -> Select report name as ‘Schedule Group Listing Report’

schedule group report

schedule group report

Report Parameters:

  • Schedule Group From
  • Schedule Group To

Click ‘Submit’ to launch the report request.

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

Report Output: