Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, July 19, 2007

Table which stores the config.txt file in Release 12

FND_OAM_CONTEXT_FILES

SQL> desc fnd_oam_context_files
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NOT NULL VARCHAR2(512)
VERSION NOT NULL VARCHAR2(30)
PATH NOT NULL VARCHAR2(1024)
LAST_SYNCHRONIZED NOT NULL DATE
TEXT NOT NULL CLOB
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NOT NULL NUMBER(15)
NODE_NAME NOT NULL VARCHAR2(30)
STATUS VARCHAR2(1)
SERIAL_NUMBER NUMBER
EDIT_COMMENTS VARCHAR2(2000)
CTX_TYPE NOT NULL VARCHAR2(1)

SQL> select name from fnd_oam_context_files
2 /

NAME
--------------------------------------------------------------------------------
gpslmpd3_rel12
TEMPLATE
METADATA
gpslmpd3_rel12
TEMPLATE
METADATA
gpslmpd3_apptier1
config.txt
gpslmpd3_apptier2

9 rows selected.

SQL>

No comments: