Results for “agreement_num”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OE_VALIDATE_ATTR is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides attribute-level validation services for Order Management (OE). Its primary business function is to evaluate and validate the many configurable attributes associated with order entities—such as pricing, agreements, customers, and inventory items—before those values are committed to the transactional tables. The package body is classified as OTHER in the ETRM API registry, meaning it is an internal utility rather than a public, versioned API with a formal interface contract. In Oracle EBS 12.1.1 and 12.2.2, it operates beneath the Order Management forms and concurrent processes, ensuring that user-entered or interface-supplied attribute values conform to the master data, pricing, and currency rules defined in the underlying schemas.

Key Procedures and Functions

The documented metadata identifies 95 procedures and functions exposed by the package. The central entry point is GET_ATTR_TBL, which assembles the attribute table structure consumed by downstream validation logic. A substantial group of routines targets agreement and pricing validation: AGREEMENT, AGREEMENT_CONTACT, AGREEMENT_NUM, AGREEMENT_TYPE, PRICE_LIST, PRICING_CONTRACT, and DISCOUNT. These routines verify that agreement identifiers, agreement types, contacts, price lists, pricing contracts, and discount values are valid and consistent. A second group addresses customer and party attributes, including CUSTOMER and INVOICE_CONTACT. A third group handles date and lifecycle attributes: START_DATE_END_DATE, END_DATE_ACTIVE, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, which support auditing and effective-dating checks. Descriptive and classification attributes are handled by DESC_FLEX, which validates descriptive flexfield segments, and by FREIGHT_TERMS and ACCOUNTING_RULE, which validate respective order-level codes. This distribution demonstrates that the package is a consolidated validator spanning pricing, customer, agreement, freight, and flexfield attribute domains.

Tables Accessed

According to the dependency information, OE_VALIDATE_ATTR references several APPS synonyms. MTL_SYSTEM_ITEMS is accessed to validate inventory item attributes, confirming that referenced items exist and are valid for order entry. MTL_UNITS_OF_MEASURE supports validation of unit-of-measure codes associated with items. PLITBLM is the pricing transaction line table, referenced to validate pricing and discount attributes against the pricing engine's data. The package additionally references QP_PRICE_LIST_LINES_V, the pricing price list lines view, for price list validation. Supporting dependencies include FND_API for standard API error-handling and message-stack routines, FND_CURRENCY for currency attribute validation, FND_MESSAGE for message retrieval and error reporting, and OE_MSG_PUB for Order Management message publication. The metadata states that OE_VALIDATE_ATTR is not referenced by any database object, though it is referenced by 11 other packages, confirming its role as a shared internal utility rather than a top-level entry point.

Usage Notes

OE_VALIDATE_ATTR is typically invoked indirectly rather than by end users or custom callers. It is called by Order Management forms when users enter or modify order lines and headers, by concurrent programs that process orders through open interfaces, and by the 11 dependent packages that rely on its validation routines. Because the package body has no documented public API classification and no formal published parameter signatures, direct invocation in custom code is discouraged; instead, developers should use the documented Order Management public APIs, which internally route attribute validation through this package. The presenc