Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIA 7964 - inserting wrong datasource number id into W_ETL_Run_S

Received Response
11
Views
2
Comments
User_DLSC0
User_DLSC0 Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hi All,

Informatica inserting wrong Data source id into W_ETL_RUN_S, when i ran EBS source system loads it is picking Data Source Num as '1'.

but i have configure DAC parameter value is '9' in physical datasource and generate the parameters.

please any advise what is the issue??

Regards,

Avinash

Answers

  • S R Battula
    S R Battula Rank 4 - Community Specialist

    insert data source number in DAC at Setup->Physical Data sources->Edit -> Data Source Number.

  • User_DLSC0
    User_DLSC0 Rank 2 - Community Beginner

    Added Custom property in Informatica Admin Console then  loading correct value.

    overrideMpltVarWithMapVar=Yes

    Regards,

    Avinash