FRM-40735: on-insert trigger raised unhandled exception ORA-01403

Issue:
FRM-40735: on-insert trigger raised unhandled exception ORA-01403

Form Path : /u01/install/APPS/fs1/EBSapps/appl/ar/12.0.0/forms/US/ARXTWMAI.fmx

Form Version : 12.0.149.12020000.17

Form Last Modified : $Date: 2014/04/02 23:09  $

Solutions:

Review the HR: Security Profile option to be sure it has been assigned at the Responsibility level

before the User is assigned to the Responsibility

Responsibility:  System Administrator 

Navigation:  Profile > System > Set HR Security Profile at responsibility level.

Also check the profile MO: Security Profile.  The two profiles must be same, otherwise the error will occur.

Oracle Assets Profile Options

 

Below profile options are using the oracle asset module.

FA: Allow Swiss Special Assets

FA: Annual Rounding

FA: Archive Table Sizing Factor

FA: Batch Size

FA: Cache Sizing Factor

FA: Custom Generate CCID

FA: Default DPIS to Invoice Date

FA: Deprn Single

FA: Enable Depreciation Override

FA: Generate Asset Level Account

FA: Generate Book Level Accounts

FA: Generate Category Level Accounts

FA: Generate Depreciation Expense Accounts

FA: Japan 2007 Tax Reforms Features

FA: Mass Copy All Cost Adjustments

FA: Maximum Projection Extent

FA: Number of Parallel Requests

FA: Print Debug

FA: Print Timing Diagnostics

FA: Security Profile

FA: Tax Asset Type Category Segment for Japanese Depreciable Assets Tax Report

FA: Use Threshold

FA: Use Workflow Account Generation

FADI: Create Asset Privileges

FADI: Physical Inventory Privileges

APP-SQLAP-10771: Could not reserve record.

 

Error:

APP-SQLAP-10771: Could not reserve record.

Unable to pay the AP invoice in full, Got above error while performing the action –> pay in full

Solution:

Database lock from another session is present on the table AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL for the same record that user was trying to modify from application.

1) To determine what session has a lock on this record, please execute the following steps:
         a) Run the following to determine what tables are locked:
                --- --- ---
                SELECT a.object_id, a.session_id, substr(b.object_name, 1, 40)
                FROM v$locked_object a, dba_objects b
                WHERE a.object_id = b.object_id
                AND b.object_name like 'AP_%'
                ORDER BY b.object_name;
                --- --- ---
         b) Look at the results and insert whatever AP_% tables are returned from a) into the script below:
                --- --- ---
                SELECT l.*, o.owner object_owner, o.object_name
                FROM SYS.all_objects o, v$lock l
                WHERE l.TYPE = 'TM'
                AND o.object_id = l.id1
                AND o.object_name in ('AP_INVOICES_ALL', 'AP_INVOICE_LINES_ALL', 'AP_INVOICE_DISTRIBUTIONS_ALL');
                --- ---
                SELECT SID, SERIAL#
                FROM v$session
                WHERE SID = <SID from b)>;
                --- --- ---
  2) Once the locking sessions have been identified, please use the below command to kill such sessions.
            --- --- ---
            ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;
            ---
            Note: SID and serial# to be taken from the output from 1c).
            --- --- ---

Alternative Solution
==============
If there are many items locked you may find it easier to follow this alternative solution:
   a) Ensure no-one is working and no processes are running in the system.
   b) Bounce the database.
   c) Retest the issue.