Search Results rules_import

Overview

CN_IMP_RULE_PVT is a private PL/SQL package in the Oracle EBS Advanced Pricing and Channel Revenue Management (formerly Trade Management) schema, owned by APPS. Its documented purpose is to import configuration data from the staging tables into the Ruleset, Rule, and Rule Attribute destination tables. The package implements the transformation layer that moves validated rows from the interface tables into the operational rule model, building rulesets first and then loading the associated rule and rule attribute records. Once a ruleset and all its dependent rules and attributes have been loaded, the package synchronizes the ruleset so that it becomes usable by downstream pricing and revenue processes. The package is classified as PVT, indicating it is intended for internal consumption by the import framework rather than as a public integration API, and it is not referenced by any other documented package.

Key Procedures and Functions

The package exposes five documented procedures, several of which are called exclusively from within the package's own import flow.

• RULES_IMPORT — The public entry point invoked by the import module. It coordinates the overall transfer of data from the staging tables to the destination tables, accepting the import header identifier and organization context to scope the load.
• LOAD_RULES — Invoked by RULES_IMPORT. Loads rule data from the staging table into the rules and rules hierarchy tables, taking ruleset identity, name, effective dates and type, along with the import header structure. It returns error messaging, a return code, the import line identifier, and failed and processed row counters.
• LOAD_RULE_ATTRIBUTES — Invoked by LOAD_RULES. Loads rule attribute data from the staging table into the rule attribute tables, completing the rule definition before synchronization.
• UPDATE_ON_ERROR — Handles error-state processing for import rows that fail validation or loading.
• UPDATE_IMP_LINES — Updates the CN_IMP_LINES staging rows, typically to record processing status, error information, and completion flags. This is the procedure most commonly referenced when troubleshooting import line status in the interface table.

Tables Accessed

The package reads and writes a defined set of APPS synonyms:

• CN_IMP_LINES and CN_IMP_HEADERS — the staging/interface tables holding inbound ruleset, rule, and attribute data; also updated to reflect processing status.
• CN_RULESETS, CN_RULES — the destination tables for ruleset and rule definitions.
• CN_DIM_HIERARCHIES, CN_HEAD_HIERARCHIES, CN_HIERARCHY_NODES — hierarchy structures referenced when building rule conditions and groupings.
• CN_OBJECTS, CN_REPOSITORIES, CN_REVENUE_CLASSES, GL_CODE_COMBINATIONS — supporting reference and validation data used during rule construction.
• CN_PROCESS_AUDITS — audit logging of import activity.

Usage Notes

CN_IMP_RULE_PVT is normally invoked indirectly through the Channel Revenue Management / Advanced Pricing import concurrent programs and the associated import forms, rather than being called directly by custom code. Because the package is classified PVT and is referenced by no other documented package, direct invocation from custom extensions is not recommended; the supported integration path is to populate CN_IMP_HEADERS and CN_IMP_LINES and then submit the standard import process. When diagnosing import failures, the UPDATE_IMP_LINES procedure is the relevant point of interest, as it maintains the status and error columns on the staging lines. Organizations should confirm procedure signatures against the specific 12.1.1 or 12.2.2 instance before attempting any direct call, as the documented metadata is version-sensitive.