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 index metadata:

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.
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 reingest data after a change to an active invoicing partner namer or stakeholder name.

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

Navigate to Tools, Scheduled Processes.
Click Schedule New Process.
On the Schedule New Process dialog box, select Job as the Type.
In the Name field, enter "ESS job to create index definition and perform initial ingest to OSCS", click Enter, and then click OK.
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 indices for all products that use Oracle search extension framework.
Click Submit.