4 Replies Latest reply: Apr 14, 2013 10:31 PM by 1002672 RSS

    BI Apps Configuration : USER for the transactional data sources in DAC

    Abhishek Anand
      Hi

      I am implemnting BIAPPS 7.9.6.4 for 5 analytics and the source system is EBS.

      I have installed BI Apps 7.9.6.4 and configured informetica and DAC, now I am setting Physical Data Sources and gave data warehouse credential, but for the transactional data source i need to give APPS user according to the Doc E35271-01section 4.12.3 Setting Physical Data Sources,

      Select 'Source' for the database connection for a transactional (OLTP) database.

      Note: The transactional (OLTP) database user that you register should be the database table owner. Alternatively, at a minimum, the user must have read privileges on the transactional database for all tables and aliases.

      Its clearly mentioned that *"the user must have read privileges on the transactional database for all tables and aliases."*

      But they just want to confirm whether APPS user is required or can create a user for the tables which is required for the analytics.

      Need suggestion


      Thanks

      Abhishek