Cannot add a new column to invoice_tab 24R1

​@SAMLK ,

Could you please add the erroneous line in .apy file if possible. And the Screen shot from Developer studio is not that clear to see the error.

I hope you have deployed the changes in .cre file before deploying the .api and .apy. If you did not, please deploy .cre file first.
 

Hi ​@AvinduHendawitharana 

Thanks for your response. We are experiencing this issue only with this particular API in 24R1. Yes, the .cre file has already been deployed, as it is a mandatory step. Interestingly, I have not encountered this issue with any other entity, and the same problem occurs in a similar environment as well. This is leading me to believe that it could be a potential issue with code generation.

As seen in the screenshot I shared, the issue occurs at the cursor fetch, where it returns an invoice_rec_ record type that does not include the new field. To address this, I manually overrode the invoice_rec_ record type in the code, as the new field should have been automatically generated by the code generator. The "wrong number of arguments" error indicates that the new field was not included in the record type.

Although the overridden code resolved this issue, we then encountered another error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" while loading the relevant window in IFS Cloud.