My Oracle Support Banner

Field RET_AUTH_NUM in RTV_HEAD table is set to Null during Integration (Doc ID 2777627.1)

Last updated on MAY 23, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.


After creating a return to vendor(RTV) in UI, when RTV webservice is called the field RET_AUTH_NUM in the RTV_HEAD table is set to null.

Steps to Recreate:

  1. Create and approve an RTV via front-end
  2. Call the IGS webservice  for the RTV created previously, without the field RET_AUTH_NUM
  3. Observe that the  RTV_HEAD table having STATUS_IND = 15 and RET_AUTH_NUM is set to NULL




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.