Skip to main content

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,

 

 

 

@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. 

 

Each of you provided me with valuable assistance.

 

Thank you very much for all of your assistance.


Reply