Cannot create journal by Mass Allocation Function

Cannot create journal by Mass Allocation Function

Login to apps Tier:

$ cd /u01/oracle/VIS/apps/apps_st/appl/gl/12.0.0/patch/115/xdf/

The odf-files are available in Release 10.7, 11.0.3, 11i and R12. But the odf-files are more and more replaced by the xdf-files, starting with the Release 11i and further implemented in R12.

Create or verify a DatabaseObject using a odf or xdf file

To verify and create Database Objects, defined in a odf-File you are using the Utility adodfcmp, which is located under the $AD_TOP/bin.

To verify and create Database Objects, defined in a xdf-File you are using the Java Utility FndXdfCmp, which is located under the $JAVA_TOP/oracle/apps/fnd/odf2

Usage of the Utility adodfcmp :

Syntax :adodfcmp odffile=<Filename> mode=<Objects to be checked/updated> changedb=NO \
userid=<User>/<Password> touser=<User>/<Password> priv_schema=SYSTEM/<Password>

Usage of the Java Utility FndXdfCmp :

Syntax : adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp <Oracle_Schema> <Oracle_Password>
<apps_schema> <apps_password> <jdbc protocol> <JDBC_Connect_String> <Object Type> \
<full path to xdf file> <full path of $FND_TOP/patch/115/xdf/xsl>

Oracle Schema à Username of oracle schema e.g GL,AL,AP,AR and their password

Apps_schemae à Apps username and passworf

$ adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin \

 maxdemo:1521:VISMAX all gl_alloc_int_1.xdf $FND_TOP/patch/115/xdf/xsl

$ adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin \

 maxdemo:1521:VISMAX all gl_alloc_int_2.xdf $FND_TOP/patch/115/xdf/xsl

$ adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp gl gl apps apps thin \

 maxdemo:1521:VISMAX all gl_alloc_int_3.xdf $FND_TOP/patch/115/xdf/xsl

Note \ will take you to new line when you  hit enter key