Issue/Symptom/Question

I am trying to interface equipment timecard records to a work order and I am receiving this error: "Work Order distributions are only allowed on Work Order or Crew Activity Log processes". How can still process the interface record without utilizing a Work Order or Crew Activity Log process?

Applies To

Interfaces > Processing > Initiate Batch Interface Request

Resolution/Fix/Answer

When utilizing the table-driven interface process, the following stored procedure must be used to begin the interface process to process the data in the temporary interface tables:

pk_interface.f_process('PENTA', 'EQT301', 'EQT', 'N', 'Y', 'N')

The following parameters are included in the stored procedure:

a. User Id (PENTA)

b. Interface Request Id (EQT301)

c. Interface Request Type Code (EQT)

d. Resubmit Code (N)

e. Work Order Process Code (Y)

f. Workflow Process Code (N)

In this scenario, please make sure that the Work Order Process Code is set to a value of Y - the system will produce the error message above if the Work Order Process Code is set to N but will allow the interface process to complete without errors when it is set to a value of Y.