Ingest Joint Venture Data

The data ingest process is index-based. To perform the ingest of the data, you must run the process over each of the following predefined joint venture indexes:

• fa-fin-jv-transactions

• fa-fin-jv-distributions

• fa-fin-jv-invoices

The process creates the index definition in the Oracle Search Cloud Service (OSCS) database and simultaneously loads joint venture data from specific columns of various tables.

Subsequent data ingest occurs when users run Oracle Joint Venture Management processes to identify joint venture transactions and create distributions and invoices. When the processes create records and update existing records, they also use the attributes defined in the index to collect, load, and classify new records and update existing records in the work areas.

You must run the process for each index in the following cases:

• To perform an initial ingest and load of data in the work areas.

• To reingest data after a release update or upgrade if there are changes to an index. Refer to Oracle Cloud Application Update Readiness for Joint Venture Management updates that require you to run the data ingest process again.

• To reingest data after performing a "Production-to-Test" data movement.

  "Production-to-test" is the movement of application data from a source to a target Oracle Fusion Cloud applications installation. For example, you would reingest data after refreshing a test database with production data.

To run the ingest process for each of the predefined joint venture indexes:

1. Navigate to Tools, Scheduled Processes.

2. Click Schedule New Process.

3. On the Schedule New Process dialog box, select Job as the Type.

4. In the Name field, enter "ESS job to create index definition and perform initial ingest to OSCS", click Enter, and then click OK.

5. In the Basic Options section, complete the Index Name to Reingest field:

   • Enter fa-fin-jv-transactions for the Joint Venture Transactions work area.

   • Enter fa-fin-jv-distributions for the Joint Venture Distributions and Joint Venture Invoices work areas.

   • Enter fa-fin-jv-invoices for the Joint Venture Invoices work area.

   Caution: If you leave this field blank, the process creates index definition and ingests data for all predefined indexes for all products that use Oracle search extension framework.

6. Click Submit.