My Oracle Support Banner

Salesprocess Produces Unique Constraint Violation Error When Processing POSU File for VFP Income (Doc ID 2197230.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

The Salesprocess batch produces a unique constraint violation error when processing a POSU file for Vendor Funded Promotion (VFP) income.

Steps to Recreate:

  1. Create a Vendor Funded Deal.
  2. Change vdate to the start date of the deal.
  3. Create a vendor funded promotion (simple percent off).
  4. Create a Retail Sales Audit (ReSA) transaction and add the promotion.
  5. Run the saexprms batch to generate the POSU file.
  6. Run the uploadsales.ksh batch.
  7. Run salesprocess batch.




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.