My Oracle Support Banner

R12:AP: Signature ID 418 "Non-standard characters exist" with Error 'FRM-40654: Record has been updated. Requery block to see change' while Cancelling an Invoice (Doc ID 2224983.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


When user tries to cancel the invoice, below error message is shown:


FRM-40654: Record has been updated. Requery block to see change

The Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax as per note 1360390.1 is showing:

Invoice Data Validation
Results for Signature ID 418: Non-standard characters exist in the descriptions of imported invoices which can cause errors in invoice cancellation and other invoice workbench actions and warnings in some reports
Impact Area(s): Invoice Cancellation, Invoice Data

Script Name: ap_invld_chars_inv_desc_sel.sql
SOLUTION: Generate the APList output for the affected invoices and log a Service Request to obtain the data fix.

Invoice_Id Invoice_Num Invoice_Date Org_Id  Description
123             xxx           30-SEP-19          85  三太郎ã...


The issue can be reproduced at will with the following steps:
1.  In the Invoice Workbench create an invoice with a special character in the description.
2.  Go to the Invoice Actions window and select Cancel Invoices and OK and the error occurs.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.