My Oracle Support Banner

Interface Trip Stop Errors With ORA-20004: This Dependent Product Line References A Line Number Greater Than Itself (Doc ID 3037830.1)

Last updated on JULY 30, 2024

Applies to:

Oracle Shipping Execution - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Interface Trip Stop (ITS) is failing with the following error:


ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_ERROR Transfer_Mode: PLS
ZX_API_PUB.CALCULATE.Statistics Start Time:24-07-2024 13:46:34
ZX_API_PUB.CALCULATE.Statistics End Time:24-07-2024 13:46:35
ZX_API_PUB.CALCULATE.Statistics Total Time:0:0:1
ZX_API_PUB.Calculate.Statistics Number of partner calls :1
ZX_API_PUB.Calculate.Statistics Time taken by partner(secs) :0
Message returned by tax API ZX_API_PUB.calculate_tax: 1return statusE current org: 101
Message returned by tax API ZX_API_PUB.calculate_tax: ORA-20004: This dependent product line references a line number greater than itself.return statusE current org: 101
ORA-20004: This dependent product line references a line number greater than itself. current org: 101
LEAVING OE_MSG_PUB.ADD current org: 101
tax engine call returned error current org: 101
ENTER SET RECURSION MODE current org: 101
ENTITY CODE-11 current org: 101
ENTRY-EXIT MODE -0 current org: 101
RECURSION MODE AT ENTRY -N current org: 101
RECURSION MODE WITHOUT EXP AT ENTRY -N current org: 101
RECURSION MODE AT EXIT -N current org: 101
RECURSION MODE WITHOUT EXP AT EXIT -N current org: 101
execution error current org: 101
error in Handle_Bulk_Mode_Per_Order User-Defined Exception current org: 101
ENTER Save_API_Messages current org: 101
l_errmsg User-Defined Exception current org: 101
L_MSG_DATA=Error: ORA-20004: This dependent product line references a line number greater than itself. current org: 101
Order Number :18201129 Line Number :1.1
Message :Error: ORA-20004: This dependent product line references a line number greater than itself.
EXIT Save_API_Messages current org: 101
error in Handle_Bulk_Mode User-Defined Exception current org: 101
ship_confirm_new EXC ERROR: User-Defined Exception current org: 101



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

1. Order Management Super User Responsibility
2. Shipping
3. Interfaces
4. Run Interface Trip Stop

Changes

 

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
Changes
Cause
Solution


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