My Oracle Support Banner

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

Last updated on DECEMBER 09, 2022

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
Information in this document applies to any platform.


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 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
Result Code = #EXCEPTION
Notification Id =
Assigned User =

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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