Skip to main content
Solved

Importing Wrok Center

  • October 16, 2023
  • 4 replies
  • 198 views

Forum|alt.badge.img+1

Hi,

From IFS Cloud, on my second migration job (Migrate Source Data), this error happened :

ORA-20124: WorkCenter.FND_ITEM_FORMAT: The value "InfiniteCapacity" has incorrect format for [SCHED_CAPACITY] in Work Center.

 

API recommendation is respected when using InfiniteCapcity, so, what’s wrong ?

 

Thanks for help

 

PS : trying with uppercase et underscore between two words, same error

Best answer by Tomas Ruderfelt

API documentation shows how you shall call the Rest API’s, which is not what the data migration tool is using. So to check the values you need to check how the data looks like in the view, like in my picture.

As you say the client values are often similar to what you see in the API documentation with spaces so you could do trial and error to find it, if there are no bigger differences.

4 replies

Forum|alt.badge.img+21
  • Superhero (Employee)
  • October 16, 2023

The English client value for that IID is: “Infinite capacity”.

Easy to check like this:

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • October 16, 2023

Thanks for answering so quickly. I was using the value defined in the Api documentention. Is there an easy way to determine the good value ? Separate words with a space car ?


Forum|alt.badge.img+21
  • Superhero (Employee)
  • Answer
  • October 16, 2023

API documentation shows how you shall call the Rest API’s, which is not what the data migration tool is using. So to check the values you need to check how the data looks like in the view, like in my picture.

As you say the client values are often similar to what you see in the API documentation with spaces so you could do trial and error to find it, if there are no bigger differences.


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • October 16, 2023

Once again Thomas, thank you very much for your help.