Error FRM-40735 On-error Trigger Raised Unhandled Exceptions ORA-01001 On Revenue Line Forms

Last updated on MARCH 08, 2017

Applies to:

Symptoms

Performance issue in PAXRVRVW Revenue Review form, which in turn is sporadically causing the following error when clicking on the lines for a revenue:

FRM-40735: ON-ERROR trigger raised unhandled exception ORA-01001.

User click on OK and gets Note:

Your log on session has become invalid. Exiting Oracle Applications.

Query shown as the issue:
      SELECT DISCOUNT_PERCENTAGE,RATE_DISC_REASON_CODE,TASK_NUMBER,EXPENDITURE_TYPE,EXPENDITURE_ITEM_DATE,EMPLOYEE_VENDOR_NAME,REVENUE_AMOUNT,BORROW_LENT_FLAG,FUNCTION_TRANSACTION_NAME,
QUANTITY,UNIT_OF_MEASURE_M,EXPENDITURE_ORGANIZATION_NAME,NON_LABOR_RESOURCE,NLR_ORGANIZATION_NAME,ROW_ID,PROJECT_ID,TASK_ID,DRAFT_REVENUE_NUM,DRAFT_REVENUE_ITEM_LINE_NUM,
CODE_COMBINATION_ID,REVERSED_FLAG,EXPENDITURE_ITEM_ID,FUNCTION_TRANSACTION_CODE,LINE_NUM,TASK_NAME,EMPLOYEE_NAME,EMPLOYEE_NUMBER,JOB_NAME,VENDOR_NAME,EMPLOYEE_VENDOR_NUMBER,
EXPENDITURE_COMMENT,USER_TRANSACTION_SOURCE,ORIG_TRANSACTION_REFERENCE,EXPENDITURE_GROUP,RAW_COST,ACCRUED_REVENUE,ACCRUAL_RATE,RECEIPT_CURRENCY_CODE,
RECEIPT_CURRENCY_AMOUNT,RECEIPT_EXCHANGE_RATE,DENOM_CURRENCY_CODE,DENOM_RAW_COST,ACCT_CURRENCY_CODE,ACCT_RATE_DATE,ACCT_RATE_TYPE,USER_ACCT_RATE_TYPE,ACCT_EXCHANGE_RATE,
ACCT_RAW_COST,PROJECT_CURRENCY_CODE,PROJECT_RATE_DATE,PROJECT_RATE_TYPE,USER_PROJECT_RATE_TYPE,PROJECT_EXCHANGE_RATE,JOB_BILLING_TITLE,EMPLOYEE_BILLING_TITLE,CREATION_DATE,
CREATED_BY,Bill_Trans_Currency_Code,Bill_Trans_Amount,Bill_Rate,Bill_Trans_Bill_Amount,ProjFunc_Currency_Code,ProjFunc_Rev_Rate_Type,ProjFunc_Rev_Rate_Date,ProjFunc_Rev_Exchange_Rate,Project_Revenue_Amount,
Project_Rev_Rate_Type,Project_Rev_Rate_Date,Project_Rev_Exchange_Rate,Funding_Currency_Code,Funding_Revenue_Amount,Funding_Rev_Rate_Type,Funding_Rev_Rate_Date,Funding_Rev_Exchange_Rate,
REVTRANS_CURRENCY_CODE,REVTRANS_AMOUNT,REVPROC_REVTRANS_RATE_TYPE,REVPROC_REVTRANS_RATE_DATE,REVPROC_REVTRANS_EX_RATE FROM PA_CUST_REV_DIST_LINES_V WHERE (PROJECT_ID=:1) and (DRAFT_REVENUE_NUM=:2) and (DRAFT_REVENUE_ITEM_LINE_NUM=:3) order by EXPENDITURE_ITEM_ID

Cause