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

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Site Hub - Version 12.1.3 and later
Information in this document applies to any platform.

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

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