R12: AP: Two Vendors of Same Employee Has Been Created Automatically, Being Unable to Open Invoices Form with Error: "FRM-40735 post-query trigger raised unhandled exception ORA-01403" Blocking Submitting Expenses from iExpense Portal (Doc ID 2908885.1)

Last updated on MARCH 27, 2023

Applies to:

Symptoms

Two vendors of same employee has been created automatically, being unable to open invoices of this employee and employee is also facing issue while submitting expenses from iExpense portal

Steps:

=====

1. Payables Responsibility
2. Invoice > Entry > Invoices
3. (B) Find > Query invoices for two specific employees, the following error occurs:
4. FRM-40735 post-query trigger raised unhandled exception ORA-01403

Changes

 Allow from iExpense to create automatically vendors and created a manual vendor from Payables. More details are included in the following note:

Doc ID 1377888.1 Technical Brief: Understanding and Working with Employee Suppliers in R12

Cause

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