Skip to main content
Solved

Importing Wrok Center

  • Oct 16, 2023 9:14 AM UTC
  • 4 replies
  • 258 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.

View original

4 replies

Forum|alt.badge.img+21

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

Easy to check like this:

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • Oct 16, 2023 10:12 AM UTC

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
  • Oct 16, 2023 10:28 AM UTC

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)
  • Oct 16, 2023 1:18 PM UTC

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