Tsfclose Not Closing Transfer Correctly (Doc ID 2009527.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising System - Version 13.1.2.4 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.

Symptoms

The tsfclose.pc batch closes unshipped transfers (TSF) after a period of time. The job updates TSF records resulting in inconsistent data. It is expected to set cancelled quantity equal to the unfulfilled quantity which is not the case and the transferred quantity is not decremented by the same quantity. Also, close date is not populated.

Steps to recreate:

  1. Run tsfclose.pc to close a unshipped transfer.
  2. Check tsfdetail table, cancelled_qty is updated , but tsf_qty is not decremented.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms