My Oracle Support Banner

Create ID And Approval ID from TSFHEAD table are Incorrectly Populated On Transfer Creation (Doc ID 2376772.1)

Last updated on OCTOBER 15, 2020

Applies to:

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


When creating a transfer, CREATE_ID and APPROVAL_ID columns from TSFHEAD table are populated with different user id than the one used at login.

Steps to recreate:

  1. Login to RMS application with an user (for example "RMS_USER").
  2. Create a transfer
  3. Add the transfer details
  4. Submit and approve the transfer.
  5. Save the transfer.
  6. Looking on TSFHEAD table, both CREATE_ID and APPROVAL_ID columns for this created transfer are filled with "RMS_ADMIN" information even if the user used to create and approve the transfer is "RMS_USER".


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.