Setup guide

Customization Manager Coding Standards D-9
Standard Name Description
JDBC TimeStamp
Compliance
The proper column bind type should be used when
sending/fetching DATE columns. Do not use Types.TIMESTAMP
or OracleTypes.TIMESTAMP.
Do not use ~FILE or
~PATH in .drvx files
~FILE and ~PATH cannot be used in a dbdrv: command in a .drvx
file, even within checkfile. A .drvx file is not loaded into the
database.
dbdrv: fdfcmp should
not be called
The database driver should not call fdfcmp.
Files with .drvx
extension must contain
'dbdrv: command'
For each driver exception ( .drvx ) file the line dbdrv: command
must exist. The command must be in all lowercase. The line
dbdrv: none commands fail also.
No drvx files should
contain XDOLoader
For all new patches containing Oracle XML Publisher files, the
dbdrv command should be added to the file directly instead of
using a separate drvx file.
No drvx files should
contain dbdrv: PYLOAD
PYLOAD should not be in any automatically generated database
driver.
dbdrv: FFXBCP must
have correct syntax
dbdrv: FFXBCP must have correct syntax:
exec ff bin FFXBCP bin &phase=last(+##) &ui_apps 0
Y( -S | -U | -SU | )
dbdrv: FFXMLC must
have correct syntax
FFXMLC command must contain the following syntax:
exec ff bin FFXMLC bin (&phase=dat(+##)) &ui_apps
0 [yY]
dbdrv: FNDLIBR must
have correct syntax
FNDLIBR command must contain the following syntax:
exec fnd bin FNDLIBR bin <phase> FND FNDCPBWV
&ui_apps
SYSADMIN 'System Administrator' SYSADMIN
dbdrv: java
htmlLoad.class must
have correct syntax
Java htmlLoad.class command must contain the following syntax:
exec java oracle/apps/per htmlLoad.class java
-username &un_apps -password
&pw_apps -database &jdbc_db_addr -file <.html
file>