Apps Initialize

When Oracle Applications is running, its running with the apps logon. When you develop for oracle applications, you should allways connect as the apps user. All database objects is accessible from the apps user.

When you connect to the database from sqlplus using: apps/apps@dev – the session is not prepared to do any work on the Oracle Applications database. You need to do an apps initialize (@ai ) with a proper responsibility. The apps initialize will prepare the session for all sorts of transactions. Try to do a connect without apps_initialize, and execute the @info script – no information is set, try to do an apps initialize and execute the @info again…