There is an order in the status of "Delivered" that cannot be moved to the "Invoiced" status.
What is the reason my Customer Order does not change to invoice?
When I attempt to create an invoice, I can see the option to create an invoice. However, the customer order does not change to the "Invoiced" status
Thanks,
Page 1 / 1
@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.
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.
@Vimukthi Mahakumbura
@faruk.azakli
However, ZETEC_ZCC_SA was not the name of the custom event, so I searched by LU and searched each custom event separately to determine the variable.