My Oracle Support Banner

R12 Generate FRM-40735 Error While Doing LINE Adjustment (Doc ID 1489390.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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


The following error is generated while performing a Line Adjustment with a Non-Recoverable Receivable Activity with Tax Rate that was removed and recreated.

FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01422.

Responsibility:  Tax Manager
Navigation:  Tax Configuration > Tax Rates
Create Tax Rate without Tax Jurisdiction and Save it
Navigation:  Tax Configuration > Tax Rates
Search newly created Tax Rate Code
Click Update icon
Click Remove icon and then press Yes button to remove this Tax Rate
Navigation:  Tax Configuration > Tax Rates
Recreate Tax Rate with same code without Tax Jurisdiction

Responsibility: Receivables Manager
Navigation: Setup > Transactions > Receipts > Receivable Activities
Create following Receivable Activities
   Type: Adjustment
   Active: On
   GL Account Source: Activity GL Account
   Tax Rate Code Source: Activity
   Recoverable: Off
   Non-Recoverable: On
   Tax Rate Code: Created Tax Rate
Navigation: Transactions > Transactions
Create a transaction
Adjust newly created transaction as follows:
   Activity Name: created Receivable Activity.
   Type: Line
   Amount: 100

When moving Focus from Amount, FRM-40735 error is generated.




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.