Hello matheo,

Unfortunately this functionality doesn’t exist until now. There is no Public API available from Oracle to update AR invoice.

And regarding the API you mentioned in your question it’s not the correct API, and please don’t use it because basically it’s not public and official released from oracle as per this Doc ID 1388129.1.

The only way for now to update AR transaction is to perform this action from application specifically from  transaction workbench.

Hope That will help you.

Best Regards.

Hello Rain ,

Oracle Descritption for this error is given below:
ORA-29275:
partial multibyte character
Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.
Action: Ensure that the complete multibyte character is sent from the remote server and retry the operation. Or read the partial multibyte character as RAW.

Mainly reason for this type or ora error is that there is a junk/invisible or special character available ,but unfortunately the cause and action that oracle give it to us is not that much descriptive, so to investigate more and figure out the problem and fix it let’s try this:

First try to select columns individually like below example:

SELECT COL1 FROM TABLENAME;
SELECT COL2 FROM TABLENAME;

until reach to the column that causing your problem and raise this ORA error.

so far so good for now that we identified the column that has junk/invisible character we can fetch the column data and overcome this issue by using CONVERT function in oracle like below example :

SELECT CONVERT(COL1, ‘US7ASCII’, ‘WE8ISO8859P1’) FROM TABLENAME;

Hope that this answer was helpful. 

Hi Marito

You cannot delete the invoice. Only canceling the invoice is possible.

CANCELLING INVOICE RESTRICTIONS:
INVOICES TO WHICH YOU HAVE APPLIED PREPAYMENTS: You cannot cancel an invoice to which you have applied a prepayment. You must first reverse the prepayments.

INVOICES YOU HAVE MATCHED TO PERMANENTLY CLOSED PURCHASE ORDERS: You cannot cancel an invoice that you matched to a permanently-closed purchase order.

PREPAYMENTS: You cannot cancel a prepayment that you have applied to an invoice. You must first unapply any prepayments and void the payment that paid the prepayment. You can then cancel the prepayment.

GL DATE: You cannot change the GL Date if you use Encumbrance and the distribution has been encumbered or is part of a reversal pair.

The only way to do is to void the payment then cancel the invoice from invoice workbench only.

Hope that may help.

Regards.