Re: adcfgclone.pl errors

Posted by ErmanArslansOracleBlog on Jun 21, 2016; 6:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adcfgclone-pl-errors-tp265p1085.html

Did you check the table?
Did you read the defitinion which is publicly available?

FND_OAM_CONTEXT_FILES stores all context files and metadata file belongs to the application instance. Each Row contains context name, actual context file, and version of file. There will be one metadata file for the entire Applications instance.

Also Check this note Autoconfig Reverts To Old Context File Values (Doc ID 357922.1)


Note that, there is a column named "text" there. It is a clob and context file contents are stored there.
See its defitinion below;

->
Columns

Name Datatype Length Mandatory Comments
NAME VARCHAR2 (512) Yes Context Name parsed from context file
VERSION VARCHAR2 (30) Yes File version parsed from file
PATH VARCHAR2 (1024) Yes Full file path
LAST_SYNCHRONIZED DATE
Yes Last upload or download time
TEXT CLOB (4000) Yes File contents
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column
NODE_NAME VARCHAR2 (30) Yes Node name where context file is located
STATUS VARCHAR2 (1)
status of writing back file to file system
SERIAL_NUMBER NUMBER

serial number used for comparing file system contents with db contents
EDIT_COMMENTS VARCHAR2 (2000)
user specified comments
CTX_TYPE VARCHAR2 (1) Yes used to specify context file for Database/Apps