Post Mass Additions Creates Assets Using Category Book Default Values Instead of User Provided Values. Prepare Mass Additions Throws Exception ORA-01001: invalid cursor (Doc ID 2958328.1)

Last updated on AUGUST 15, 2023

Applies to:

Symptoms

Post Mass addition creates assets using category book default values instead of user provided values for few attributes like method, convention, add to asset number.

When user prepares asset addition using FBDI/ADFDI, program "Prepare Mass Additions" is run. This program populates key values like method_id, convention_id based on user provided name(s). However, "Prepare Mass Additions" does not populates id columns due to recent performance improvement code changes. Though program completes in success status, but log shows "ORA-01001: Invalid Cursor" error. When user runs Post Mass Addition program, assets are created with values from category book defaults instead of user provided values in FBDI/ADFDI sheet. This issue is observed when number of total records in FA_MASS_ADDITIONS table is more than number used for profile value "FA_BATCH_SIZE" (or 10000 when profile value is not set).

Cause

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