How to Fix Issue in Accessing the Oracle Financials Schema

Asked By Sara Wrightstone 20 points N/A Posted on - 12/03/2012

Our company employs Oracle Financials products. However, I am facing the problem with accessing the schema with my administrator username and password. How could I verify if the Oracle Financials schema is correctly generated for my account?

• Status: Open
• Question Views: 815
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Algren Nathan

Go To Solution

Answered By Shifflett Laurel 0 points N/A #153019

How to Fix Issue in Accessing the Oracle Financials Schema

Hello Sara Wrightstone,

Oracle Financials is installed with the VIS demo. It is installed in a number of schemas. Some of the important ones are:

– GL: General Ledger
– AP: Payables
– AR: Receivables
– FA: Fixed Assets

You can connect through the front end with user OPERATIONS (password WELCOME). I think he has all the financial responsibilities. Probably there are other users created with the demo that can access the Financials modules as well. If you are not able to connect with them because of incorrect pwd, login with user SYSADMIN / SYSADMIN and change the password.

I hope it will be more effective..

Regards.

Shiifflett Laurel

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/21/2013
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Algren Nathan 0 points N/A #153018

How to Fix Issue in Accessing the Oracle Financials Schema

Dear,

Oracle databases keep information about the logical and physical structure of a database. Actually the oracle regularly accesses the data dictionary to parse. Operation of oracle always depends when it is ready to access to the data dictionary. Oracle users can be affected by the performance bottlenecks what is in the data dictionary. For that reason administrator should be aware of the cache. He should ensure enough capacity to cache.

Most Oracle database installations traditionally come with a default schema called SCOTT. After the installation process has set up the sample tables, the user can log into the database with the username Scott and the password tiger. (The name of the SCOTT schema originated with Bruce Scott, one of the first employees at Oracle (then Software Development Laboratories), who had a cat named Tiger.)

Thank You.

About Algren Nathan

Questions
1

Answers
26

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 02/09/2013
• Question Category: Oracle Database