No Data Found ORA-06512: At "APPS.POS_ASN_NOTIF" (Doc ID 2913843.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

On Oracle iSupplier Portal: 12.2.4 version

When submitting ASNs, notifications are not sent to the buyer and the following error notification is sent to the SysAdmin.

ERROR
-

Error Name = 100
Error Message = ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "APPS.POS_ASN_NOTIF", line 569
ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(POS_ASN_NOTIF.GET_ASN_BUYERS, POSASNNB, POSASNNB_xxxx_xxxx, xxxxx, RUN)

Activity Id = xxxx
Activity Label = BUYER_NOTIFICATION:SET_BUYER_USERNAME
Result Code = #EXCEPTION
Notification Id =
Assigned User =


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. iSupplier Portal Full Access
2. Shipments
3. Shipments Notices
3. Create Advance Shipment Notices ABCD
4. View: Shipments Due Any Time
5. Select Shipment ABCD
6. Add to Shipment Notices
7. Fill in the fields Shipment Number, Expected Receipt, Date, Shipment Date
8. Your Advance Shipment Notice ABCD has been submitted.

Cause

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