+14
Hello IFS Community,
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,
Best answer by ZTC ZTC JGOTA
View original
+18
+14
Hello
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
+18
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.
+14
Hello
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.
+1
Hello
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.
+14
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.
Each of you provided me with valuable assistance.
Thank you very much for all of your assistance.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.