New and Improved Patch for FRM-40654 Errors in Purchase Orders and Requisitions
Posted
by user793044
on Oracle Blogs
See other posts from Oracle Blogs
or by user793044
Published on Fri, 9 Nov 2012 02:01:19 +0000
Indexed on
2012/11/09
5:13 UTC
Read the original article
Hit count: 196
Filed under:
/Oracle/Procurement
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!
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!
© Oracle Blogs or respective owner