My Oracle Support Banner

'Final Allocated Quantity Is Zero For All Item Sources' Error While Approving Allocations (Doc ID 2582098.1)

Last updated on OCTOBER 24, 2019

Applies to:

Oracle Retail Allocation - Version 14.0.4 and later
Information in this document applies to any platform.


When Trying to Approve Allocations, the following error is prompted.

Error: Final Allocated Quantity Is Zero For All Item Source.

Steps To Reproduce:

  1. Create a Warehouse based Allocation.
  2. Make sure final quantity gets populated (either using manual policy or history).
  3. Calculate Allocation.
  4. Submit or Approve Allocation.
  5. Notice, the following error in the server log "java.sql.SQLSyntaxErrorException: ORA-00980: synonym translation is no longer valid".




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.