My Oracle Support Banner

ORA-01403 in LINE_AMOUNT_WINTHIN_TOL in POSCHORD After Supplier Acknowledges Order (Doc ID 1370372.1)

Last updated on FEBRUARY 01, 2019

Applies to:

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

Symptoms

On Applications 12.1.3 :
In Oracle iSupplier Portal, When Supplier Tries to acknowledge the PO at Shipment level with a change to Supplier Order Number at header level, Work flow Errors Out.

-- Error
LINE_AMOUNT_WINTHIN_TOL #EXCEPTION 100
ORA-01403: no data found
ORA-01403: no data found

POSCHORD.LINE_AMOUNT_WITHIN_TOL(POSCHORD, 1308320-0-P-276705, 208533, RUN)
Wf_Engine_Util.Function_Call(POS_SCO_TOLERANCE_GRP.LINE_AMOUNT_WITHIN_TOL, POSCHORD, 1308320-0-P-276705, 208533, RUN)


STEPS TO REPRODUCE
1. Create a PO With Acceptance required as 'Document Or Shipment'.
2. As Supplier, login from iSupplier Portal application and query for the order.
3. Select the PO and click on Acknowledge.
4. Modify the 'Supplier Order Number' at header level and accept the PO at shipment level.
5. See workflow errors as above.

Cause

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
Symptoms
Cause
Solution
References


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