A customer order does not move to Invoice

@ZTC ZTC JGOTA there can be many reasons for this. Firstly, can you check the status of the background message? If the order is processing in a background job. 

Hello @Vimukthi Mahakumbura 

I received a warning message 

Order: S54633   ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2070
ORA-06512: at line 10
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2066
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2075
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 1934
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 1954
ORA-06512: at "ZETE1APP.EVENT_SYS", line 199
ORA-06512: at "ZETE1APP.EVENT_SYS", line 199
ORA-06512: at "ZETE1APP.ZETEC_ZCC_SA

@ZTC ZTC JGOTA users usually get this error when a particular value is too long in characters that the system cannot accept it. 

You can check whether there are any values used in the CO with lengthy texts and then try to reduce them if possible. Wild guess - I can see your sales part description is very long :)
However, there are situations where IFS increased the field size in updates considering some business scenarios too. 
My guess above would be wrong, but if you are clueless you will need to technically investigate the error and find the cause.

Hello @Vimukthi Mahakumbura 

What appears to be very strange is when I run the same Customer Order in another environment. I have been able to create the invoice. In the customer order, I did not make any changes.  

See screenshot below for more details.

ZTC ZTC JGOTA wrote:

Hello @Vimukthi Mahakumbura 

 

I received a warning message 

Order: S54633   ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2070
ORA-06512: at line 10
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2066
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 2075
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 1934
ORA-06512: at "ZETE1APP.FND_EVENT_ACTION_API", line 1954
ORA-06512: at "ZETE1APP.EVENT_SYS", line 199
ORA-06512: at "ZETE1APP.EVENT_SYS", line 199
ORA-06512: at "ZETE1APP.ZETEC_ZCC_SA

 

 

Check your Custom Event (ZETEC_ZCC_SA) and  Make sure you do not exceed the variable/column sizes  in the event.