Importing Data Using RRS_SITES_INTERFACE But Columns Missing for Site Hub (Doc ID 1533140.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

 You are trying to import site data from an external system and are using RRS_SITES_INTERFACE table to do this. Problem is you are not finding some appropriate columns from the external systems which maps to OIT. So you are thinking of creating a UDA or mapping them to other columns that are available. Question is if you create UDA's then how do you make sure that the OIT column in which we are mapping the external data points to the column the UID is mapped to? Is there a process or document to find out which OIT column maps to which base column or table in Oracle apps?
From the Oracle apps UI we need to know which  table and column is being referred by a field on the screen.(ex. Site number) ?

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.