IMMEDIATE HELP NEEDED: PICK LISTS CANNOT BE CREATED USING SCHEDULED DATABASE TASK

Hello,

We are currently having a very important issue in our 22R2 IFS Cloud environment. Our customer orders need pick lists automatically created, which has been working fine with a scheduled database task, but now the database task, after more than a month of running, has been failing. The error we get is this: “The State Codes does not exist. ORA-20111: StateCodes.FND_RECORD_NOT_EXIST” and “Country / State: US, State Code: *” for the value of the error. We are trying to run this database task schedule: Create Consolidated Pick List for Customer Orders and below are our conditions: 

Any and all help would be greatly appreciated. We arent sure what change has caused this issue to occur but if anyone has any information, please add it to this post.

Thanks,
Bryan