Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts

New and Improved Patch for FRM-40654 Errors in Purchase Orders and Requisitions

Guest Author
Development has modified the code in purchase orders and requisition forms to prevent error FRM-40654 when there are trailing spaces in the tables for most of the fields.  After applying the patch, the form will still display the error but a requery will allow you to save the transaction.

For the scenarios not covered in the fix, the FND log will now display the specific field that causes the error.  This an example of the FND log for one document where the note_to_vendor has trailing spaces:

Form note_to_vendor oldvalue Database  note_to_vendor newvalue

Failed first if statement when comparing fields

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

This new patch includes the fix in Patch 14204845:"In Oracle Purchasing, leading or trailing spaces in po lines data was resulting in errors".  For more information on FRM-40654 errors see the patching section of Note 1203796.1.

Be proactive and apply Patch 14479586:R12.PO.B for 12.1.3 or Patch 14569747 for 11.5.10 now!

Join the discussion

Comments ( 2 )
  • James Tuesday, August 6, 2019
    this error is also happening on AR interface. It accepts trailing spaces on special instructions, but when it displays on the screen, it throws re-query to see changes.

    Any patch that should be applied?
  • Andrea Wednesday, August 7, 2019
    FRM-40654 errors are quite generic, and this post does not relate to 2019 patching levels. Please post your issue on the Accounts Receivable My Oracle Support Community - https://community.oracle.com/community/support/oracle_e-business_suite/receivables, or log a service request for our team to review.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.