When customer reports data already exists in OJA.

When customer reports data already exists in OJA.

"Job # vacancy date data already exists, please change the value and try again" - This error comes when the data is in intermediate table. We need to delete the data in such cases.
When this happens open the respective intermediate table and copy the entire data into excel sheet as a backup.
Then delete all records from the table.


The following are the names of the intermediate table -
[2_2374_Open Job Assignment] - STAA
[2_2287_Open Job Assignment] - STAC

These can be found in the following db -
[Kezava_DM_SubwaysWMS_Prod_WMS-STAA]
[Kezava_DM_SubwaysWMS_Prod_WMS-STAC]

    • Related Articles

    • When job is not available for assignment / CTA Job not listing under OJA

      Case 1] Please find the below steps for the analysis Step 1: Check Crewing Job master if the given Job no booth is closed. Step 2: Check the Deviation sheet. Please find the screenshots from ticket 2514 Case 2] If an Employee is on Absence, and if ...

    • What to do when VR Bid Email receipt fails

      Make sure there is no new entries in the table 'VR_Bid_Preference_Submission' which is found in Subways_Prod_VRSTAA or Subways_Prod_VRSTAC DB 15 mins prior to starting this process. select * from VR_Bid_Preference_Submission order by 1 desc To check ...

    • When a VR employee is not able to bid -

      Try logging in the VR bid link for that employee using his credentials. Check if the employee is active in employee master. Check the current job assignment details in employee master. If the select pick is Open Job Bid, then the employee is no more ...

    • When job numbers are missing from VR Bid week/Posting report –

      Check the job effective date and end date in the backend. If the job end date is before the VR bid week and if it is open job, then that job won’t appear in the posting report. It can be manually added to the VR Bid week. Check if the jobs are Extra ...