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:
- Login to RMS application with an user (for example "RMS_USER").
- Create a transfer
- Add the transfer details
- Submit and approve the transfer.
- Save the transfer.
- 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