My Oracle Support Banner

R12: FRM-40654 Trying To Update The Distribtuion Account on PO Matched Invoice with Freight/Misc Allocated (Doc ID 1275654.1)

Last updated on MARCH 29, 2021

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
APXINWKB - Invoice Workbench


-- Problem Description
When attempting to update the distribution account for the freight line, the following error occurs.

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

Invoice is Matched to PO with a description of 240 Chars
Freight/Misc is allocated to the item line

-- Steps to Reproduce
Create a PO with Description 240 Chars.
Create a Invoice and match item line to PO
Also allocate the Item to Freight/Misc Line
Notice that Description on Freight/Misc is appended with Text "Created by Allocation" with Leading/Trailing Spaces
Update distribution on freight line you get FRM-40654 Error.

-- Business Impact
Unable to update the invoice distribution account.




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

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

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