patch 12378114:R12.PJ_PF.B failing with ORA-01422 ORA-06512: at "APPS.AD_TSPACE_UTIL", line 283 Er

Hi,


ll worker log file are failing with this error for different database objects:

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.AD_TSPACE_UTIL", line 283
ORA-06512: at line 3

AD Worker error:

Error in aictsuGetTSForObject while EXECUTE statement:
[
Begin
AD_TSPACE_UTIL.get_object_tablespace
(
  :l_product_short_name,

:l_object_name ,

:l_object_type ,
'Y',
'Y',

       :l_is_object_registered,

       :l_ts_exists,

       :l_tspace

);
End;].


AD Worker error:

Failed when calling aictsuGetTSForObject() in aicdic2()


thanks a lot for your help.

Best Regards,
Eric.