Same Password for APPS and APPLSYS

on Saturday, December 26, 2009

The need to have the same password for Apps and Applsys is because when you sign on to apps, initially it connects to a public schema called APPLSYSPUB. This validates AOL username and password that we enter (operations/welcome using guest user account.

Once this is verified we select responsibility, this is validated by APPLSYS schema and then it connects to APPS schema.

Since it uses both applsys and apps during sign on process this expects both the password to be identical.

Try changing apps password to something else and try to login, the validation at the last stage would fail.

This would result in failure of application login. Apps is a universal schema has synonyms to all base product tables and sequences.

This also has code objects for all products (triggers, views, packages, synonyms etc.).

Applsys schema has applications technology layer products like FND and AD etc.

Definition of AIM Methodology

on Tuesday, December 22, 2009

Application Implementation Method is a proven approach for all the activities required to implement oracle ERP applications.

The scope of the AIM is focused on an enterprise as a whole. There are eleven processes of implementation.

1. Business Process Architecture [BP]

This phase outlines:

ž

Existing business practices

ž

Catalog change practices

ž

Leading practices

ž

Future practices

2. Business Requirement Definition[RD]

This phase explains about the initial baseline questionnaire and gathering of requirements.

3. Business Requirement Mapping[BR]

In this phase the requirements of business are matched with the standard functionality of the oracle applications.

4. Application and Technical Architecture [TA]

This outlines the infrastructure requirements to implement oracle applications.

5. Build and Module Design [MD]

This phase emphasizes the development of new functionality (customization) required by the client. It mainly details how to design the required forms, database and reports.

6. Data Conversion [CV]

Data Conversion is the process of converting or transferring the data from legacy system to oracle applications.
Ex. Transferring customer records from the legacy to the Customer Master.

7. Documentation [DO]

Documentation prepared per module that includes user guides and implementation manuals.

8. Business System Testing [TE]

A process of validating the setup's and functionality by QA(functional consultant) to certify status.

9. Performance Testing [PT]

Performance testing is the evaluation of transactions saving time, transaction retrieval times, workflow background process, database performance, etc…

10. Adoption and Learning [AP]

This phase explains the removal of the legacy system and oracle application roll out enterprise wide.

11. Production Migration [PM]

The process of "decommissioning" of legacy system and the usage(adoption) of oracle application system.

Preference in APPS Start Page

on Friday, December 18, 2009

"Applications Start Page" feature provides a user an option to set a particular page as his/her preferred start. The user will be taken to this page at login.

A user can choose from the set of functions available under his/her responsibilities. The value is recorded in a profile option named "Applications Start Page (APPLICATIONS_START_PAGE)" as
"functionId$$$respId$$$appId".

Usage of the Feature

ž

Make sure the profile "Self Service Personal Home Page Mode" is set to "Framework only" at site level or at user level for which user you intend to provide "Applications Start Page" feature

  

ž

Login to Applications as the End user

  

ž

Navigate to Preferences link on top of the page.

  

ž

You can find a section "Start Page" under General Preferences page.  Select the Responsibility from which you would like to choose the Function (For e.g. Payables Super User). It then lists the functions available for this user under this responsibility.  Choose the Function as Start page (e.g, Invoices). Apply the changes.

  

ž

Logout and Log back in. Your Start Page is now effective.

After personalizing the 'start page' to directly open a Form, how do I reset the User Preferences and the start page?

Disabling the Feature

ž

When you are on Self-service Framework page, you can Navigate to Preferences Link and de-select the values (choose blank) for Responsibility and Page drop down lists.

  

ž

When you are in Forms based Applications, navigate to menu  Edit => Preferences => Profile

  

ž

Search for "Applications Start Page", remove the value from User Value field and Save.

  

ž

Next time when you login to Applications, you get Self-service Framework Homepage.

OR

After logging in, replace the login link with:
http://<initial part of path>/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE

This should get you to the Personal Home Page.

OR

Either use the Responsibility Hat to change to the System Administrator responsibility or Login as another user and have them use the System Administrator responsibility.

Then do a find for the Start Page profile option: Profile > System  for the User Name that is needing to reset their 'Start Page' profile.

Delete the start page for the user, save the changes. This will allow the user to get back to the Personal Home Page, and then they can reset their 'Start Page'.