My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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!

In this Document
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps

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