Results for “price_request_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_VALIDATE is a core Order Management validation package in Oracle E-Business Suite, delivered under the APPS schema. Its principal business function is to centralize attribute-level validation logic for the Order Management schema so that validations are applied consistently whether an order is entered through the Order Management forms, loaded through the Order Import concurrent program, or processed through public APIs such as OE_ORDER_PUB. The package body carries the header comment for OEXSVATB.pls (120.11) and declares the global constant G_PKG_NAME as "OE_Validate" together with G_RLM_INSTALLED_FLAG, which controls behavior contingent on whether Release Management functionality is installed.
The user search term "fptval-21779" is a known EBS error reference associated with order validation failures surfaced by OE_VALIDATE-based logic; errors of this class are raised when an attribute fails a mandatory, reference, or business-rule check during order booking or import. The package is documented in the ETRM repository for both 12.1.1 and 12.2.2 with an API classification of OTHER, and it is referenced by 22 other packages, confirming its role as a widely reused validation utility.
Key Procedures and Functions
The ETRM metadata documents 354 procedures and functions in this package body. Notable examples include:
- GET_ATTR_TBL – Initializes FND_API.g_attr_tbl with the ordered list of attribute names validated by this package. The generator appends new attributes before the end-generate marker; the source header instructs "DO NOT REMOVE," because the table drives dynamic validation dispatch.
- Attribute validators such as ACCOUNTING_RULE, ACCOUNTING_RULE_DURATION, AGREEMENT, BLANKET_NUMBER, BOOKED, CANCELLED, CANCELLED_QUANTITY, AUTO_SELECTED_QUANTITY, ACTUAL_ARRIVAL_DATE, and ACTUAL_SHIPMENT_DATE – each validates a specific order header or line attribute against configured reference data and business rules.
- Configuration validators such as ATO_LINE, COMPONENT, COMPONENT_NUMBER, COMPONENT_SEQUENCE, and CONFIG_HEADER – these enforce rules for configured (ATO/PTO) items and their component lines.
- Service and subscription validators such as SERVICE_COV_TEMPLATE_ID, SERVICE_BILLING_PROFILE, SERVICE_BILL_OPTION, and SERVICE_SUBS_TEMPLATE_ID – these validate service contracts, billing profiles, and subscription templates.
Tables Accessed
OE_VALIDATE reads reference and setup data through APPS synonyms, including:
- OE_ORDER_SOURCES and OE_AGREEMENTS_B – order source and agreement validation.
- OE_SALES_CREDIT_TYPES – sales credit type validation for order lines.
- MTL_GRADES_B – grade code validation for inventory items.
- AR_RECEIPT_CLASSES, AR_RECEIPT_METHODS, and IBY_FNDCPT_TX_EXTENSIONS – receipt class, receipt method, and payment transaction extension lookups used in order and return validation.
- HZ_CUST_ACCOUNT_ROLES, HZ_CUST_SITE_USES, HZ_CONTACT_POINTS, and HZ_ROLE_RESPONSIBILITY – customer, site use, contact, and role validation.
- JTF_RS_SALESREPS and JTF_RS_RESOURCE_EXTNS – salesperson and resource validation.
- PLITBLM – a PL/SQL table used for temporary storage during validation.
Usage Notes
OE_VALIDATE is not typically called directly by end users. It is invoked indirectly by Order Management forms, the Order Import concurrent program, and public APIs such as OE_ORDER_PUB during order entry, booking, and import. The package relies on FND_API.g_attr_tbl to map attribute names to validation routines, so customizations should extend this table rather than alter existing entries. Because it is referenced by 22 other packages, changes to OE_VALIDATE signatures or validation rules can have broad impact across Order Management. When diagnosing errors such as "fptval-21779," the failing attribute name can be used to locate the corresponding validator in this package for troubleshooting.
-
PACKAGE: APPS.OE_VALIDATE 12.1.1
-
This table holds details of all the transactions which consumed or increased the available balance on all the limits.
-
This table holds details of all the transactions which consumed or increased the available balance on all the limits.
-
QP_LIMIT_BALANCES holds the balances for a limit.
-
PACKAGE: APPS.OE_VALIDATE 12.2.2
-
QP_LIMIT_BALANCES holds the balances for a limit.
-
View: QP_DEBUG_REQ_LINES_V 12.2.2
View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced.
APPS.QP_DEBUG_REQ_LINES_V·↳ QP_DEBUG_REQ_LINES·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →
-
Table: QP_PREQ_LINES_TMP_T 12.1.1
-
View: QP_PREQ_LINES_TMP 12.2.2
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINES_TMP·↳ QP_PREQ_LINES_TMP_T·Explore QP module →
-
View: QP_PREQ_LINES_TMP 12.1.1
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINES_TMP·↳ QP_PREQ_LINES_TMP_T·Explore QP module →
-
This table contains information about the lines being priced.
-
This table contains information about the lines being priced.
-
View: OE_AK_ORDER_HEADERS_V 12.1.1
APPS.OE_AK_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
Table: QP_PREQ_LINES_TMP_T1 12.2.2
-
View: OE_BLANKET_HEADERS_V 12.2.2
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: QP_DEBUG_REQ_LINES_V 12.1.1
View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced.
APPS.QP_DEBUG_REQ_LINES_V·↳ QP_DEBUG_REQ_LINES·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →
-
Table: QP_INT_LINES_T 12.1.1
Permanent table for holding the elements in the calling application that requires a base and adjusted price.
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
Table: QP_INT_LINES_T 12.2.2
Permanent table for holding the elements in the calling application that requires a base and adjusted price.
-
View: OEFV_ORDER_HEADERS 12.2.2
APPS.OEFV_ORDER_HEADERS·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ FND_USER·Explore ONT module →
-
View: OE_BLANKET_HEADERS_V 12.1.1
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
This view is used to retrieve the Order History. This is used by the history form.
APPS.OE_ORDER_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.1.1
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_ORDER_LINES_HIST_V 12.2.2
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
Table to capture sales agreement header details..
-
Stores history of attribute change for Order Headers
-
This view is used to retrieve the Order History. This is used by the history form.
APPS.OE_ORDER_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OEFV_ORDER_HEADERS 12.1.1
APPS.OEFV_ORDER_HEADERS·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ FND_USER·Explore ONT module →
-
This is a multi-org table for sales order lines open interface.
-
Table to capture sales agreement header history. Primary for storing revisions.
-
View: OE_BLKT_LINES_HIST_V 12.1.1
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
View: OEFV_ORDER_LINES 12.2.2
Full BIS View for Order lines
APPS.OEFV_ORDER_LINES·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_SYSTEM_ITEMS_VL·Explore ONT module →
-
View: OE_AK_ORDER_HEADERS_V 12.2.2
APPS.OE_AK_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
View: OEFV_ORDER_LINES 12.1.1
Full BIS View for Order lines
APPS.OEFV_ORDER_LINES·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_SYSTEM_ITEMS_VL·Explore ONT module →
-
View: OE_BLANKET_HDRS_HIST_V 12.1.1
APPS.OE_BLANKET_HDRS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
Stores history of attribute change for Order Headers
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.1.1
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.2.2
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
View: OE_BLANKET_HDRS_HIST_V 12.2.2
APPS.OE_BLANKET_HDRS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
Table to capture sales agreement header history. Primary for storing revisions.
-
View: OE_BLKT_HEADERS_HIST_V 12.1.1
This view is used to get BSA history headers information, and which is used in BSA organizer.
APPS.OE_BLKT_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLKT_LINES_HIST_V 12.2.2
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.2.2
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
This is a multi-org table for sales order headers open interface.