@randevperera, Usually, this error appears when transactions are being created for the part. So the creation of the part seems to be doing something else it seems at the part creation. 

To confirm, can you check below,
for once allow zero cost for the inventory part and see if any transactions are created in the inventory transactions history window?

I cannot think of any setting which could do this somehow for now. 

Hi @Vimukthi Mahakumbura ,

After some investigations, this error seems to be relating to a data migration issue as some inventory transactions have been migrated to a fresh environment without records of the parts. There seems to also be a server error when trying to create a part with Zero Cost Allowed:

Will confirm if the migration seems to be the issue.

Thanks for your reply!

Hi @randevperera ,

So far, I couldn’t find any basic data setting that would restrict the creation of an inventory part with the given conditions.

But looking at your second screenshot, I can see that a master part has already been created earlier. (master part step has not appeared in the wizard).

Are there any other inventory parts created for that master part (MS004429)? If not, please try creating the same inventory part to another site and see whether the error occurs. If the error didn’t appear, then we can at least assume that the problem is site specific and continue investigations.

Regards,
Kethaka

Hi @KethakaG, @Vimukthi Mahakumbura 

A purge of the data in the Inventory Parts in Stock window seemed to have fixed the cost error. However, I followed the steps as mentioned by @KethakaG  and the server error is persistent. The full error is mentioned below:

IFS Web Version: 24.1.0.20240503204405.0
Date: 2024-10-14T08:24:20.487Z

---------------------------------------------------------------------------

NewPartAssistant/Assistant (server error)
Database error occurred. Contact administrator.
Error details: a{"code":1400,"message":"ORA-01400: cannot insert NULL into (\"IFSAPP\".\"QMAN_MANDATORY_PART_TAB\".\"SIMPLIFIED_REV_HANDLING\")"}]

Server stack trace error(s):
  Failed to execute the generated database statement
  ORA-01400: cannot insert NULL into ("IFSAPP"."QMAN_MANDATORY_PART_TAB"."SIMPLIFIED_REV_HANDLING")
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1324
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1542
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1571
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1595
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1316
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 10258
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 10273
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8759
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8776
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8809
ORA-06512: at "IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC", line 3136
ORA-06512: at "IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC", line 1491
ORA-06512: at line 2

  ORA-01400: cannot insert NULL into ("IFSAPP"."QMAN_MANDATORY_PART_TAB"."SIMPLIFIED_REV_HANDLING")
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1324
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1542
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1571
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1595
ORA-06512: at "IFSAPP.QMAN_MANDATORY_PART_API", line 1316
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 10258
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 10273
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8759
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8776
ORA-06512: at "IFSAPP.INVENTORY_PART_API", line 8809
ORA-06512: at "IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC", line 3136
ORA-06512: at "IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC", line 1491
ORA-06512: at line 2

Request Id: b00cd52f-6bc7-4f0d-a26e-dd6e587b9d4a

Method: POST
Url: /main/ifsapplications/projection/v1/NewPartAssistantHandling.svc/CreateInventoryPart
Response Code: 500 - Internal Server Error

---------------------------------------------------------------------------

{"headers":{"normalizedNames":{},"lazyUpdate":null,"lazyInit":null,"headers":{}},"status":200,"statusText":"OK","url":"https://dss-test.inivosglobal.com/main/ifsapplications/projection/v1/NewPartAssistantHandling.svc/CreateInventoryPart?odata-debug=json","ok":true,"type":4,"body":{"request":{"method":"POST","uri":"https://dss-test.inivosglobal.com/main/ifsapplications/projection/v1/NewPartAssistantHandling.svc/CreateInventoryPart?odata-debug=json","protocol":"HTTP/1.1"},"response":{"status":{"code":"500","info":"Internal Server Error"},"headers":{"OData-Version":"4.0","Content-Type":"application/json"},"body":"{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":e{\"code\":1400,\"message\":\"ORA-01400: cannot insert NULL into (\\\"IFSAPP\\\".\\\"QMAN_MANDATORY_PART_TAB\\\".\\\"SIMPLIFIED_REV_HANDLING\\\")\"}]}}"},"server":{"version":"odata-server-core Version 4.9.0.2-ifs","environment":{"authType":"BASIC","localAddr":"10.1.16.19","localName":"ifsapp-odata-556f4967cd-knf25","localPort":"8080","pathInfo":"/NewPartAssistantHandling.svc/CreateInventoryPart","pathTranslated":"/opt/ifs/wlp/usr/servers/defaultServer/apps/expanded/ifs-odata-provider.war/NewPartAssistantHandling.svc/CreateInventoryPart","remoteAddr":"10.1.16.23","remoteHost":"10-1-16-23.ifsapp-proxy.dsstst.svc.cluster.local","remotePort":"59228","remoteUser":"ifsapp","scheme":"https","serverName":"ifsapp-odata","serverPort":"8080","servletPath":"/main/ifsapplications/projection/v1"},"uri":{"kind":"resource","uriResourceParts":c{"uriResourceKind":"action","segment":"CreateInventoryPart","isCollection":false}],"customQueryOptions":{"odata-debug":"json"}},"runtime":r{"class":"ODataHandlerWrapper","method":"process","duration":43652,"unit":"µs","children":c{"class":"ODataHandlerWrapper","method":"fillODataRequest","duration":43,"unit":"µs","children":"{"class":"ODataHandlerWrapper","method":"copyHeaders","duration":28,"unit":"µs"},{"class":"ODataHandlerWrapper","method":"fillUriInformation","duration":12,"unit":"µs"}]},{"class":"ODataHandler","method":"process","duration":43608,"unit":"µs","children":s{"class":"ODataHandler","method":"processInternal","duration":41917,"unit":"µs","children":�{"class":"Parser","method":"parseUri","duration":196,"unit":"µs"},{"class":"UriValidator","method":"validate","duration":4,"unit":"µs"},{"class":"ODataDispatcher","method":"dispatch","duration":41714,"unit":"µs"}]},{"class":"ODataHandler","method":"handleException","duration":1679,"unit":"µs","children":"{"class":"ErrorProcessor","method":"processError","duration":1627,"unit":"µs"}]}]}]}],"stacktrace":{"exceptions":r{"class":"com.ifsworld.fnd.common.exceptions.DatabaseException","message":"Failed to execute the generated database statement","invocation":{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1284}},{"class":"java.sql.SQLIntegrityConstraintViolationException","message":"ORA-01400: cannot insert NULL into (\"IFSAPP\".\"QMAN_MANDATORY_PART_TAB\".\"SIMPLIFIED_REV_HANDLING\")\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1324\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1542\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1571\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1595\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1316\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 10258\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 10273\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8759\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8776\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8809\nORA-06512: at \"IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC\", line 3136\nORA-06512: at \"IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC\", line 1491\nORA-06512: at line 2\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":526}},{"class":"oracle.jdbc.OracleDatabaseException","message":"ORA-01400: cannot insert NULL into (\"IFSAPP\".\"QMAN_MANDATORY_PART_TAB\".\"SIMPLIFIED_REV_HANDLING\")\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1324\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1542\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1571\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1595\nORA-06512: at \"IFSAPP.QMAN_MANDATORY_PART_API\", line 1316\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 10258\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 10273\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8759\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8776\nORA-06512: at \"IFSAPP.INVENTORY_PART_API\", line 8809\nORA-06512: at \"IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC\", line 3136\nORA-06512: at \"IFSAPP.NEW_PART_ASSISTANT_HANDLING_SVC\", line 1491\nORA-06512: at line 2\n","invocation":{"class":"oracle.jdbc.driver.T4CTTIoer11","method":"processError","line":530}}],"stacktrace":5{"class":"com.ifsworld.fnd.storage.StorageProviderUtils","method":"createODataProviderExceptionFrom","line":1284},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"executeStatement","line":143},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":112},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":86},{"class":"com.ifsworld.fnd.storage.PlsqlStatementExecutor","method":"execute","line":63},{"class":"com.ifsworld.fnd.storage.invoker.PlsqlOperationInvoker","method":"invoke","line":56},{"class":"com.ifsworld.fnd.storage.invoker.BpaInvokerWrapper","method":"invoke","line":183},{"class":"com.ifsworld.fnd.provider.processor.FndActionProcessor","method":"processActionVoid","line":823},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleActionDispatching","line":227},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"handleResourceDispatching","line":143},{"class":"org.apache.olingo.server.core.ODataDispatcher","method":"dispatch","line":119},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"processInternal","line":168},{"class":"org.apache.olingo.server.core.ODataHandlerImpl","method":"process","line":89},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":64},{"class":"com.ifsworld.fnd.provider.ODataHandlerWrapper","method":"process","line":77},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"serviceODataRequest","line":330},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"serviceProjectionRequest","line":163},{"class":"com.ifsworld.fnd.web.api.FndODataServletBase","method":"service","line":112},{"class":"javax.servlet.http.HttpServlet","method":"service","line":791},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"service","line":1258},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"handleRequest","line":746},{"class":"com.ibm.ws.webcontainer.servlet.ServletWrapper","method":"handleRequest","line":443},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"invokeTarget","line":193},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":98},{"class":"com.ifsworld.fnd.web.api.ResponseFilterBase","method":"doFilter","line":60},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ifsworld.fnd.web.api.InitConfigurationFilterBase","method":"doFilter","line":218},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ibm.ws.security.jaspi.JaspiServletFilter","method":"doFilter","line":56},{"class":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","method":"doFilter","line":201},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","method":"doFilter","line":91},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","method":"doFilter","line":1002},{"class":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","method":"invokeFilters","line":1140},{"class":"com.ibm.ws.webcontainer.webapp.WebApp","method":"handleRequest","line":5049},{"class":"com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2","method":"handleRequest","line":316},{"class":"com.ibm.ws.webcontainer.WebContainer","method":"handleRequest","line":1007},{"class":"com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2","method":"run","line":281},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper","method":"run","line":1184},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink","method":"wrapHandlerAndExecute","line":453},{"class":"com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink","method":"ready","line":412},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"handleDiscrimination","line":566},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"handleNewRequest","line":500},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"processRequest","line":360},{"class":"com.ibm.ws.http.channel.internal.inbound.HttpInboundLink","method":"ready","line":327},{"class":"com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback","method":"sendToDiscriminators","line":167},{"class":"com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback","method":"complete","line":75},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"requestComplete","line":504},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"attemptIO","line":574},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager","method":"workerRun","line":958},{"class":"com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker","method":"run","line":1047},{"class":"com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper","method":"run","line":238},{"class":"java.util.concurrent.ThreadPoolExecutor","method":"runWorker","line":-1},{"class":"java.util.concurrent.ThreadPoolExecutor$Worker","method":"run","line":-1},{"class":"java.lang.Thread","method":"run","line":-1}]}},"ifs-trace":{"authStatus":"authorized","trace":a{"origin":"MT","type":"Framework","text":"Initializing the session"},{"origin":"DB","indentation":"9","time":"88545698","category":"FRAMEWORK","level":"DEBUG","type":"Framework","text":"Package: LOGIN_SYS"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Login_SYS.Init_Fnd_Session__ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Context: "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Foundation User: IFSAPP"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calendar: GREGORIAN"},{"origin":"MT","type":"Framework","text":"Initializing the session"},{"origin":"DB","indentation":"9","time":"88545698","category":"FRAMEWORK","level":"DEBUG","type":"Framework","text":"Package: LOGIN_SYS"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Login_SYS.Init_Fnd_Session__ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Context: "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Foundation User: IFSAPP"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calendar: GREGORIAN"},{"origin":"MT","type":"Framework","text":"Initializing the session"},{"origin":"DB","indentation":"9","time":"88545698","category":"FRAMEWORK","level":"DEBUG","type":"Framework","text":"Package: LOGIN_SYS"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Login_SYS.Init_Fnd_Session__ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"============================ "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Context: "},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Foundation User: IFSAPP"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code Rfc3066: en-US"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Current Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Language Code: en"},{"origin":"DB","indentation":"7","time":"88545698","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calendar: GREGORIAN"},{"origin":"MT","type":"sql","text":"BEGIN\n\tNew_Part_Assistant_Handling_SVC.Do_Create_Inventory_Part('R-SWR', 'MS004429', '2109955-MS0044-BLACK 29', NULL, NULL, NULL, '*', NULL, NULL, 'prs', NULL, '4', 'N', NULL, NULL, 'NEG ONHAND NOT OK', 0, unbound## => '');\nEND;","textWithBinds":"BEGIN\n\tNew_Part_Assistant_Handling_SVC.Do_Create_Inventory_Part(:Contract, :PartNo, :Description, :AccountingGroup, :PartProductCode, :PartProductFamily, :PlannerBuyer, :PrimeCommodity, :SecondCommodity, :InventoryUnitMeas, :CatchUnitMeas, :TypeCode, :ZeroCostLevel, :InventoryPartCostLevel, :InventoryValuationMethod, :NegativeOnHandAllowed, :EstimatedMaterialCost, unbound## => '');\nEND;","bindParams":{"Contract":{"value":"R-SWR","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"PartNo":{"value":"MS004429","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"Description":{"value":"2109955-MS0044-BLACK 29","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"AccountingGroup":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"PartProductCode":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"PartProductFamily":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"PlannerBuyer":{"value":"*","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"PrimeCommodity":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"SecondCommodity":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"InventoryUnitMeas":{"value":"prs","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"CatchUnitMeas":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"TypeCode":{"value":"4","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"ZeroCostLevel":{"value":"N","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"InventoryPartCostLevel":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"InventoryValuationMethod":{"value":"null","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"NegativeOnHandAllowed":{"value":"NEG ONHAND NOT OK","direction":"IN","dbColumn":"null","dbType":"VARCHAR2"},"EstimatedMaterialCost":{"value":"0","direction":"IN","dbColumn":"null","dbType":"NUMBER"}}},{"origin":"DB","indentation":"15","time":"88545701","category":"APPLICATION","level":"TRACE","type":"Application","text":"Creating a product structure"}]}}}

A certain table, QMAN_MANDATORY_PART seems to be the issue here as it has a validation rule. This error is not present in other environments.

Hi @randevperera ,

Can you please check if the site, “R-SWR”, is available under ‘Quality Options for Sites’ screen?

If not, please add the site to that basic data screen, and then run the flow again.

I believe with the suggested change, the server error would disappear.

It is a long shot, but worth giving a try :)

Regards,
Kethaka