Thursday Nov 08, 2012

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

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!

About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« November 2012 »
SunMonTueWedThuFriSat
    
3
4
10
11
13
16
17
18
20
22
23
24
25
27
28
30
 
       
Today