Wednesday, September 2, 2009

Where is the tables, forms?

Tables are stored in DB datafiles(.dbf extension) on machine(ioversondb2) in this folder:/u02/oracle/iosatestdata

Importants tables:
FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS
for doing query into database you can use:
sqlplus user/password@instance_name
one trick for know the names of tables are use :


Forms are stored in OAS machine(ioversonas2) in this folder:/u02/oracle/iosatestappl/au/11.5.0/forms and US(for United State language) or E(for spanish language)

one trick is recover form name from eBS menu directly:

othe trick is use help-About Oracle Applications

No comments:

Post a Comment