Setup guide

Customization Manager Coding Standards D-5
Standard Name Description
Pkg Replace Check Use CREATE OR REPLACE PACKAGE for package creation. Do
not omit OR REPLACE
Pkg Create IS Check Package creation must not use IS. Instead should always use AS
Xml Parse Standard XML files should be well-formed
Control M Standard Text files should not have control M [^M] character
SQL NoLogging Check Using NOLogging in SQL scripts is not recommended
SQL Serveroutput Check Using set serveroutput on in SQL scripts is not recommended
Wfx File Naming
Standard
WFX filename must end in s, e, or a, ie. [s|e|a].wfx.
16.3 File Naming
Standard
Filename should adhere to the 16.3 naming standard
Set Scan Off Standard Package creation scripts containing ampersand must have SET
SCAN OFF
Drop Table check Drop table should not be used in SQL/PLSQL files as it can result in
loss of data
SQL Max Line
LengthStandard
No line in a SQL file should be longer than 255 characters
FNDSLOAD Check
Standard
FNDSLOAD is obsolete. No dbdrv: hints should refer to
FNDSLOAD
Drop Column check Drop Column should not be used in SQL/PLSQL files
Long Raw check LONG or LONG RAW columns should not be used
Insert Column check INSERT SQL statements, should explicitly list the columns about to
insert
FNDLOAD/FNDLOADS
O syntax check
FNDLOAD/FNDLOADSO must have correct syntax