R12 Generate FRM-40735 Error While Doing LINE Adjustment

(Doc ID 1489390.1)

Last updated on MARCH 09, 2016

Applies to:

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

Symptoms

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

ERROR
-----------------------
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.

Cause

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 hundreds of Community platforms