AMX DAS-AMP4 Guia de preparacion descargar pdf (Pagina 314)

D-6 Oracle Application Management Pack for Oracle E-Business Suite Guide

Standard Name Description

Admin Dbdrv none

check

All files under [PROD_TOP]/admin must have only dbdrv: none

NLADD Sql Check There should be no [PROD]NLADD.sql files in R12 patches

FNDLOAD ldt phase dbdrv: FNDLOAD ldt files must have correct phase

Menu file location Menu files must be located under one of following directories:

resource,admin/template,admin/template/*

WFX file location check WFX files must be located under one of following directories:

patch/[some dir]/xml,admin/template,admin/template/*

Create single line check In SQL files, CREATE command must occur on one line only.

SQL exit check SQL files must end with exit

Package SpecBody Same

file

The package specification and body should be in different files

SQL Absolute path

Check

SQL files should not have absolute path in a @ or @@ statements

Calling SQL script check Use start or @ when calling a SQL script within a SQL script. Do not

use @@.

Applsyspub Schema

Check

Custom scripts are not allowed to modify APPLSYSPUB schema

Custom File Naming

Standard

All files involved in the package must be for a product prefixed

with xx""

Pkg body creation

Standard

Package body creation scripts should not be in pkh files

Pkg spec creation

Standard

Package Spec creation scripts should not be in pkb and plb files

Mview Build deferred

Standard

Materialized Views must be created with BUILD DEFERRED

option

1 2 ... 309 310 311 312 313 314 315 316 317 318 319 ... 337 338

Sin comentarios

AMX DAS-AMP4 Guia de preparacion Pagina 314