I am implemnting BIAPPS 18.104.22.168 for 5 analytics and the source system is EBS.
I have installed BI Apps 22.214.171.124 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.