Forum Stats

  • 3,854,212 Users
  • 2,264,340 Discussions
  • 7,905,609 Comments

Discussions

Configuration Required Before A Full Load for Financial Analytics

user12164083
user12164083 Member Posts: 21
Hi all,

is any configuration necessary before full load for Financial or any other modules or is it enough to run execution plan without any configurations on csv or other files??

Best Regards,
Kenan
Tagged:

Answers

  • No. A lot of configuration is required before your first full load. See Oracle® Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users Version 7.9.6.1 Part Number E14844-01 http://download.oracle.com/docs/cd/E14847_01/index.htm
  • coolmesh84
    coolmesh84 Member Posts: 30
    I am trying to configure OBIA for oracle financial analytics with EBS source data. I am referring to

    oracle configuration document
    [http://download.oracle.com/docs/cd/E13697_01/doc/bia.795/e13766/anyimp_configfinance.htm#CHDEEJIF ]

    and I am at the step 5.2.2.2 in the configuration.

    The steps ask you to modify SQL of certain source qualifier SQ_MTL_TRANSACTION_ACCOUNTS to include transaction_type_id.

    my question is how to edit the sql? and is it ok to edit the seeded sqls?

    If i have to include transaction_type_id in the select statements where I should include it( I mean the order of the selection not affect the ETL behavior?).
This discussion has been closed.