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:

  1. Start SQL Developer and open the XXHR_PARTY_UPLOAD_REG.sql file available from the download bundle.
  2. 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, ...

Get Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.