Registering a table and its columns within Oracle E-Business Suite
We need to register our table that we are going to load data into within EBS. This is required when we create the integrator, so that we can see the table definition in the user interface. We will run the script to register the XXHR_PARTY_UPLOAD table and all of its columns.
How to do it...
To run the script to register the XXHR_PARTY_UPLOAD table, perform the following:
Start SQL Developer and open the
XXHR_PARTY_UPLOAD_REG.sqlfile available from the download bundle.Click the run script icon from the toolbar as shown in the following screenshot.
You can run the script in SQL*Plus or another development tool such as TOAD if you prefer.
Now we have run the script to register the table, we can check that it has been successfully registered in EBS.
How it works...
To register the table, we must use the AD_DD package that is provided by Oracle, as the form does not allow users to enter records. The script has been provided and this...
