FUSION_APPS_FIN_ODI_ESS_APPID Does Not Exist In ODI Repos When Running Transfer FAH To PSFT Process (Doc ID 1938966.1)

Last updated on JUNE 03, 2017

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Financials Common Module - Version 11.1.8.0.0 and later
Oracle Fusion Accounting Hub - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On-premise inplementation of FAH ( rel 8) to PSFT (FSCM9.2/PT8.51)
 
Getting above error when running ESS job to transfer Accounting entries from FAH to PSFT
ESS job is submitted as user FAAdmin ( FAAdmin was granted contingent worker - Job role - to enable scheduling/submit )

Using MOS Doc 1609436.1 ( FAH to PSFT GL Integration).

Completed ODI setup as per White paper Pages 37 - 53.

Tested connection for each of DataSources , ( ORACLE_FUSION, ORACLE_PSFT, FILE_OUTPUT_FIN) using Agent FusionCrmOdiAgent - successfully.

odiconsole runs from http://crm-dev.ops.tiaa-cref.org/odiconsole

Login as FAAdmin ( as it is not possible to login as SUPERVISOR).


ESS job is submitted as User FAAdmin.


Following patches have been applied

1. 18690404
2. 18373562
3. 18651563
4. 18197142

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