My Oracle Support Banner

Unable To Update Schedule Ship Date At Sales Order Line Item (Doc ID 2865072.1)

Last updated on MAY 02, 2022

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

On : 12.1.3 - 12.2.10 versions, Tax Calculation

Unable to Update Schedule Ship Date At Sales Order Line Item

Business is facing the Issues for the Sales Orders created new for Updating Schedule Ship Date on Line Item and while Splitting the Sales Order Lines.

Unable to process transaction.

 Error: An Unexpected Error has Occurred.

 Error in fnd log:

ZX.PLSQL.ZX_SRVC_TYP_PKG.CALCULATE_TAX_PVT.END 2 ZX_SRVC_TYP_PKG: CALCULATE_TAX_PVT()- RETURN_STATUS = S
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS.BEGIN 1 ZX_SRVC_TYP_PKG:DB_INSERT_LINE_DET_FACTORS()+
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS 1 INSERTING in ELSE...
ZX.PLSQL.ZX_SRVC_TYP_PKG.DB_INSERT_LINE_DET_FACTORS 6 ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
ZX.PLSQL.ZX_SRVC_TYP_PKG.CALCULATE_TAX 1 RETURN_STATUS = U
ZX.PLSQL.ZX_API_PUB.CALCULATE_TAX 1 ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax  returned errors
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()+
ZX.PLSQL.ZX_API_PUB.DUMP_MSG 2 0 Error Message(s) dumped into Zx_Errors_GT.
ZX.PLSQL.ZX_API_PUB.DUMP_MSG.BEGIN 2 ZX_API_PUB: DUMP_MSG()-

Solution

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
Goal
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.