My Oracle Support Banner

Error ORA-30926 and ORA-01476 While Running Uploadsales.ksh Not Fully Processing POSU Files With Retail And Tax Zero Value (Doc ID 2783331.1)

Last updated on JUNE 25, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

When attempting to run uploadsales.ksh having transaction with retail and tax zero value the following error occurs.


Error ORA-30926: unable to get a stable set of rows in the source tables returned by program unit CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_ITEM_LOC_HIST_MTH.
Error ORA-01476: divisor is equal to zero returned by program unit CORESVC_SALES_UPLOAD_SQL.WORK_TABLE_DENORMALIZE.
Invalid Value Added Tax (VAT) code.

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.