Skip to main content
Solved

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

  • September 1, 2023
  • 1 reply
  • 154 views

Forum|alt.badge.img+17

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

Best answer by bdoucette

This was caused by a setting change that forced addresses to have certain formats. This error-ed out the database task schedule causing it all to fail.

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 250 replies
  • Answer
  • September 6, 2023

This was caused by a setting change that forced addresses to have certain formats. This error-ed out the database task schedule causing it all to fail.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings