Oracle eBS經驗分享

怎麼找”Generate Constraints Validation Packages”會產生的package

Generate validation package 是抓取”Validation Template”的設定

The generated validation packages all live in the apps schema.

The easiest way to get the name of your package(s) is from the validation_pkg column of the oe_pc_validation_pkgs table. The format is:
OE_{ a }PC{ b }_{ c }_{ d }

where:
a = the validating_entity_id
b = the validation_entity_id
c = the validation entity short name (LINE, ORDER, BLKTHDR, HDRADJ etc.)
d = the validation template short name (i.e. the short name you used when defining the template)