Select Accrual Accounts ERROR: No Data Found .FRM-40735, ORA-06508 (Doc ID 2298832.1)

Last updated on AUGUST 19, 2017

Applies to:

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

Symptoms

Trying to use the "Accrual Write off" functionality in R12 for the first time.
 As a first step, when  click on "Select Accrual Accounts" , we are getting "No data found" error.
  We already have the Accrual Account set up in Purchasing Options and Inventory Org parameters.
When Attempt to enter an Account get the error:

FRM-40735:WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06508
Please see loaded file: Error_screenshots.docx.

when click on "Select Accrual Accounts" , Getting
"No data found" error.
Once the Customer select the Operation Unit from the form CSTACRAA.fmx, the
error message "No Data Found" is raised immediately.

Inside the form the code is

HEADERS_C.OPERATING_UNIT_FIELDS('WHEN-VALIDATE-ITEM');
HEADERS_C.FLEXFIELD_DEFINE;

Which does:
--
  l_org_id := name_in('ou_master.operating_unit_id');

  if(EVENT = 'WHEN-VALIDATE-ITEM') then

  select gsb.chart_of_accounts_id,
  gsb.set_of_books_id
  into l_coa_id,
  l_sob_id
  from gl_sets_of_books gsb,
  financials_system_params_all fsp
  where gsb.set_of_books_id = fsp.set_of_books_id
  and fsp.org_id = l_org_id;

  copy(l_coa_id, 'parameter.coa_id');
  copy(l_sob_id, 'parameter.sob_id');
  copy(l_org_id, 'parameter.operating_unit_id');

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