In this Document
| Purpose |
| Scope |
| Details |
| A. Form / Functional Issues |
| "Add to Selection" Button |
| Are PTOs supported? |
| "Available to Promise" (ATP) Issues |
| "Blanket Sales Agreement" Integration |
| "Create Order" Issues |
| "Currency" Issues |
| "Current Selections" Region |
| "Customer" Issues |
| "Grade" Field |
| "Hints" Field |
| Item Cross Reference |
| "Modifier Name" Field |
| Modifier is Not Applied |
| New Inquiry |
| Onhand Availability Issues |
| Operating Unit / Organization |
| "Price List" Issues |
| "Quote" Issues |
| Related Item Issues |
| "Request Date" Field |
| Unit Cost |
| "Unit List Price" Field |
| "Unit Selling Price" Field |
| Warehouse |
| Zero Percent Modifier is Not Applied |
| B. Errors During Processing |
| C. Performance Issues |
| D. Special Considerations/Setup Examples |
| E. Diagnostics and Troubleshooting Tips |
| References |
APPLIES TO:
Oracle Order Management - Version 11.5.10.0 and laterOracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.
Form Name : OEXPRAVA
PURPOSE
<p >*Purpose
<span >Enter a clear description of what the document is trying to achieve.
Assist with problem resolution.
SCOPE
FAN (Friendly Application Navigation) R12 applicable documentation
Document is applicable for user of Oracle Order Management and Oracle Pricing.
DETAILS
Responsibility: Order Management Super User (or equivalent)
Navigate to: Orders, Returns > Pricing and Availability
Shortname: OEXPRAVA
A. Form / Functional Issues
"Add to Selection" Button
| Description | Document Number |
|---|---|
|
Fields Erased After Pressing Add To Selection On Pricing and Availability Form |
Are PTOs supported?
| Description | Document Number |
|---|---|
|
Does the Price And Avalablity Form Support PTOs? |
"Available to Promise" (ATP) Issues
| Description | Document Number |
|---|---|
|
ATP Information Is Only Displayed In Summary Screen After Clicking 'Recalculate Availability' button |
Document 1383685.1 |
| Incorrect Request Date Qty In Atp Availability Window | Document 1296946.1 |
| ATP Not Available Until Press The 'Recalcualte Availability' Button | Document 402207.1 |
| ATP window - Availability Shows Request Date Quantity Of 100000000000 | Document 303730.1 |
| How to Set Up Data Collection for Order Management ATP Availability | Document 401158.1 |
"Blanket Sales Agreement" Integration
| Description | Document Number |
|---|---|
|
Pricing And Availability Form Does Not Show The Blanket Sales Agreement Available For The Customers |
|
| Price List Created in Blanket Sales Agreement Does Not Display in LOV |
"Create Order" Issues
| Description | Document Number |
|---|---|
| Create Order Fails With Function Not Available To This Responsibility | |
| Unable To Create Sales Order From Pricing And Availability Form |
"Currency" Issues
| Description | Document Number | |
|---|---|---|
| Does Not Showing The Price And Adjustments For CAD currency | ||
| Form Fails Doing Multicurrency Conversion | ||
| Price & Availability Form Does Not Show Correct Currency Of Price List Defaulted From Customer | Document 1614883.1 |
"Current Selections" Region
| Description | Document Number |
|---|---|
| How can the Current Selections region be enabled (made visible) on the Pricing and Availability form? |
"Customer" Issues
| Description | Document Number |
|---|---|
| Add Customer Option Under Tools Menu Of Pricing & Availability Is Inactive | |
| Price List From Customer Does Not Default Price & Availability Form | |
| Pricing And Availability Default Customer |
Earliest Available Date
| Description | Document Number |
|---|---|
| Cannot View Earliest Available Date |
"Grade" Field
| Description | Document Number |
|---|---|
| How to have the Grade Field on Pricing and Availability Form |
"Hints" Field
| Description | Document Number |
|---|---|
| How to Update the Hints field in Pricing and Availability Form? |
Item Cross Reference
| Description | Document Number |
|---|---|
| Item Cross Reference LOV Does a Blind Query |
"Modifier Name" Field
| Description | Document Number |
|---|---|
| Incorrectly Displays the Modifier Number in the Modifier Name Field |
Modifier is Not Applied
| Description | Document Number |
|---|---|
| Form Does Not Apply Modifiers (Discount) With Line Type Qualifier | |
| Form is Not Working With Some Pricing Formula Modifiers | |
| Form (OEXPRAVA) and Custom Price | |
| Pricing Attribute for Freight Term Defined as Custom Qualifier for the Price List Does Not Work | |
| Form Does Not Show Modifiers Associated to Custom Pricing Attributes | |
| Form Ignores A Price List Modifier With Ship Method as a Qualifier | |
| R12.1.x Modifiers With Volume Qualifier Not Displaying In Pricing And Availability Form | |
| R12.0.x: OEXOEAVA: Volume Qualifier Does Not Work From Pricing and Availability Form |
New Inquiry
| Description | Document Number |
|---|---|
| Defaulted Values on the Price And Availibility Form Are Cleared When Using the New Inquiry Button |
Onhand Availability Issues
| Description | Document Number |
|---|---|
| Why Does The System Show Availability For A Model But No Availability For The Star Item? | |
| 'Item Availability' Tab Shows All Orgs, Even Where Item Not Assigned | |
| Price & Availability Tab Does Not Return Any Item Availability Information | |
| Pricing & Availability Shows On-Hand Quantity From Non ATP Subinventory |
Operating Unit / Organization
| Description | Document Number |
|---|---|
| How to view Item Availability In "Pricing And Availability" For Other Orgs Without Have To Hit CTRL– F11? | |
| Form Does Not Pull in Operating Unit as a Qualifier | Document 412822.1 |
"Price List" Issues
| Description | Document Number |
|---|---|
| Pricing And Availability Window Does Not Return Price When Price List Is Blank | |
| Price List Does Not Default | |
| Currency And Price List Not Defaulting Correctly | |
| Clicking On Pricing & Availability(button) Changes Default Price List And Order Type | Document 1549883.1 |
"Quote" Issues
| Description | Document Number |
|---|---|
| Quote Sales Orders Are Creating Demand and Showing Up In ATP Availability Results | |
| Cannot Open Quote Details From 'Save As Quote' | Document 551004.1 |
| How To Turn Off Capability To Create Quotes And Orders From Pricing and Availability Form | Document 362391.1 |
Related Item Issues
| Description | Document Number | |
|---|---|---|
| 11i Item Number Does Not Change Color When Related Item Exists | ||
| Pricing And Availability Form - Incorrect Unit Selling Price For 'Related Item' | ||
| Not Able To See Availability For Related Items In Pricing/Availability Form | Document 445330.1 |
"Request Date" Field
| Description | Document Number |
|---|---|
| Request Date In Pricing and Availability Form Does Not Work |
Unit Cost
| Description | Document Number | |
|---|---|---|
| Unit Cost is Not Visible | ||
"Unit List Price" Field
| Description | Document Number |
|---|---|
| Unit List Price Precision is Not Extended |
"Unit Selling Price" Field
| Description | Document Number |
|---|---|
| Unit Selling Price Shows Decimal Places For Yen Value | |
| Unit Selling Price in the Pricing & Availability Form is Different than in the Sales Order Form When using Multi Currency |
Warehouse
| Description | Document Number | |
|---|---|---|
| Warehouse Field Is Removed On Pricing & Availability Screen After Item Field is Erased | ||
| How Can We Restrict the Warehouse Field Entry on the Pricing and Availability form? | ||
| Why Does Warehouse In Related Items Tab of Pricing and Availability form Default From? | Document 1439382.1 |
Zero Percent Modifier is Not Applied
| Description | Document Number | |
|---|---|---|
| In the Pricing and Availability Form, a 0 % Modifier Does Not Display |
B. Errors During Processing
| Action | Error | Document |
|---|---|---|
| Enter item number and warehourse then click Price and Availability button | Exception:- 4062 ORA-0462: of has been changed and no “Unit Cost” | Document 1931743.1 |
| Pricing engine not taking into account qualifier precedence | Duplicate Price List Error | Document 1621767.1 |
| Attempting to create an order via the Pricing and Availability Form | Item Validation Resulted in Error(s) | Document 1591941.1 |
| Validating an item via the Pricing and Availability form results in complications when entering an Inactive item. | APP-FND-01048 Combination Restricted and FRM-40212: Invalid value for field ITEM_NAME | Document 1577462.1 |
|
Item Price Does Not Show Up In Pricing and Availibility Form Due to Log Showing Error in price break calculation. Issue can also be shown in iStore while entering an item on a cart. |
ORA-06512: at "APPS.OZF_VOLUME_CALCULATION_PUB" ORA-06512: at "APPS.QP_TM_RUNTIME_SOURCE" ORA-06512: at "APPS.QP_CALCULATE_PRICE_PUB" ORA-01403: no data found Error in calculate_priceORA-06502: PL/SQL: numeric or value error: character string buffer too small |
Document 1533846.1 |
| Clicking On Price/Availability Query Form Errors With FRM-40010: Cannot read form | FRM-40010 | Document 850165.1 |
| Price And Availability Form Gives Error FRM - 40831. Truncation occurred: value to long for field MODIFIER_NAME | FRM-40831 | Document 394944.1 |
|
Item Validation Error When Creating Order From Pricing & Availability |
item validation error | Document 351734.1 |
| Master: Common Reasons To Receive Item and UOM Not on Price List Error | Item and UOM Not on Price List Error | Document 605330.1 |
| Pricing And Availability Form Giving Error Message "ITEM" And "UOM" Not On "PRICE LIST" | Item and UOM Not on Price List Error | Document 1475275.1 |
| Error Price Was Not Found On Price List For This Item And UOm When Using A Custom Qualifier Defined Using Transactional Currency Code ( oe_order_pub.g_hdr.transactional_curr_code) | Item and UOM Not on Price List Error | Document 1459196.1 |
| Pricing And Availability Error: ONT_INLINE_CUSTOMER No APS Instance Defined. | ONT_INLINE_CUSTOMER | Document 343820.1 |
| Error 'ONT_PRICING_ERROR' From Pricing Availability Form | ONT_PRICING_ERROR | Document 742365.1 |
| ONT_PRICING_ERROR OCCURS ON PRICING/AVAILABILITY SCREEN - GSA VIOLATION | ONT_PRICING_ERROR | Document 603690.1 |
| ORA-01403 No Data Found Error In Pricing & Availability form OEXPRAVA | ORA-01403 | Document 1374542.1 |
| OEXPRAVA ORA-01403 Item Availability Not Displaying In Price and Availability Form | ORA-01403 | Document 290251.1 |
| OEXPRAVA: Error on Pricing/Availability Form ORA-04062: APPS.OE_OE_PRICING_AVAILABILITY | ora-04062 | Document 459574.1 |
C. Performance Issues
| Performance Issue | Document Number |
|---|---|
| Poor Performance On Pricing And Availability Form | Document 1550778.1 |
| OEXPRAVA Pricing And Availability Performance Is Slow | Document 390957.1 |
D. Special Considerations/Setup Examples
--None at this time.
E. Diagnostics and Troubleshooting Tips
| Troubleshooting | Document Number |
|---|---|
| How to Generate a Debug File on Pricing and Availability Form For Pricing Analysis | Document 1342995.1 |
| Troubleshooting a Price Issue on the R12 Pricing and Availability Form OEXPRAVA | Document 1346844.1 |
| Where Is The Pricing & Availability Form In OM? | Document 391226.1 |
REFERENCES
NOTE:726437.1 - OEXPRAVA: 'Item Availability' Tab Shows All Orgs, Even Where Item Not AssignedNOTE:1342995.1 - How to Generate a Debug File on Pricing and Availability Form For Pricing Analysis
NOTE:454732.1 - OEXPRAVA: Pricing And Availability Form Does Not Show Modifiers Associated to Custom Pricing Attributes
NOTE:845069.1 - Why Does The System Show Availability For A Model But No Availability For The Star Item?
NOTE:444769.1 - Unit Cost Not Visible In Price And Availability OEXPRAVA Form
NOTE:1379672.1 - Pricing and Availability Form Fails Doing Multicurrency Conversion
NOTE:437060.1 - Warehouse Field Is Removed On Pricing & Availability Screen After Item Field is Erased
NOTE:1585753.1 - Unit Selling Price in the Pricing & Availability Form is Different than in the Sales Order Form When using Multi Currency
NOTE:551004.1 - Cannot Open Quote Details From 'Save As Quote' On Pricing And Availability Form
NOTE:387995.1 - OEXOEAVA - Pricing & Availability: Price List Created in Blanket Sales Agreement Does Not Display in LOV
NOTE:1533846.1 - OEXPRAVA: Item Price Does Not Show Up In Pricing and Availibility Form Due to Log Showing Error in price break calculation: ORA-06503: PL/SQL: Function returned without value ORA-06512: at "APPS.OZF_VOLUME_CALCULATION_PUB"
NOTE:467956.1 - Fields Erased After Pressing Add To Selection On Pricing and Availability Form
NOTE:1383685.1 - ATP Information Is Only Displayed In Summary Screen After Clicking 'Recalculate Availability' button
NOTE:331267.1 - Item Cross Reference Lov Blind Query In Pricing & Availability Form
NOTE:781552.1 - Price and Availability Form Not Showing The Price And Adjustments For CAD currency
NOTE:788446.1 - Request Date In Pricing and Availability Form Doesnt Work
NOTE:888263.1 - ENH: How to have the Grade Field on Pricing and Availability Form
NOTE:1262954.1 - OM: How to Update the Hints field in Pricing and Availability Form?
NOTE:560561.1 - OEXPRAVA: Pricing Attribute for Freight Term Defined as Custom Qualifier for the Price List Does Not Work on the Pricing and Availability Form
NOTE:559875.1 - OEXPRAVA: Pricing & Availability Shows On-Hand Quantity From Non ATP Subinventory
NOTE:463773.1 - OEXPRAVA: Price List From Customer Does Not Default Price & Availability Form
NOTE:883429.1 - Add Customer Option Under Tools Menu Of Pricing & Availability Is Inactive
NOTE:1471145.1 - Price And Availability Form is Not Working With Some Pricing Formula Modifiers
NOTE:1937964.1 - OEXPRAVA In the Pricing and Availability Form, a 0 % Modifier Does Not Display
NOTE:362391.1 - How To Turn Off Capability To Create Quotes And Orders From Pricing and Availability Form
NOTE:1618183.1 - Defaulted Values on the Price And Availibility Form Are Cleared When Using the New Inquiry Button
NOTE:364888.1 - OEXPRAVA: Pricing and Availability form Current Selections Region is not Visible
NOTE:1499245.1 - How Can We Restrict the Warehouse Field Entry on the Pricing and Availability form?
NOTE:1550778.1 - Poor Performance on Pricing and Availability Form (OEXPRAVA) after Patch:14262288
NOTE:402207.1 - Atp Not Available Until Press The 'Recalcualte Availability' Button
NOTE:1516485.1 - Pricing And Availability Form Does Not Show The Blanket Sales Agreement Available For The Customers
NOTE:1581941.1 - E1: Patches: 9.1: Bug Fixes: JM14234
NOTE:393962.1 - Price And Availablity Form: Does it Support PTOs?
NOTE:1439382.1 - Why Does Warehouse In Related Items Tab of Pricing and Availability form Defaulted From ?
NOTE:1492513.1 - How to view Item Availability In "Pricing And Availability" For Other Orgs Without Have To Hit CTRL– F11?
NOTE:1549883.1 - Click On Pricing & Availability Changes Default Price List And Order Type
NOTE:1296946.1 - Incorrect Request Date Qty In Atp Availability Window
NOTE:833713.1 - OEXPRAVA: Pricing And Availability Form Does Not Apply Modifiers (Discount) With Line Type Qualifier
NOTE:1577462.1 - Pricing And Availability Form Issues APP-FND-01048 Combination Restricted and FRM-40212: Invalid value for field ITEM_NAME
NOTE:412822.1 - Pricing and Availability form does not pull in operating unit as a qualifier
NOTE:1308501.1 - R12.1.x Modifiers With Volume Qualifier Not Displaying In Pricing And Availability Form
NOTE:417948.1 - OEXPRAVA: Pricing And Availability Form Ignores A Price List Modifier With Ship Method as a Qualifier
NOTE:400170.1 - Unit Selling Price In Pricing & Availability Shows Decimal Places For Yen Value
NOTE:401158.1 - How to Set Up Data Collection for Order Management ATP Availability
NOTE:549309.1 - OEXPRAVA: Price & Availability Tab Does Not Return Any Item Availability Information
NOTE:1614883.1 - Price & Availability Form Does Not Show Correct Currency Of Price List Defaulted From Customer
NOTE:1621767.1 - After R12 Upgrade Duplicate Pricing Price List Error on Pricing and Availability Form
NOTE:303730.1 - ATP window - Availability Shows Request Date Quantity Of 100000000000
NOTE:1376053.1 - Pricing And Availability Create Order Fails With Function Not Available To This Responsibility
NOTE:397271.1 - Pricing And Availability Default Customer
NOTE:1078887.1 - R12.0.x: OEXOEAVA: Volume Qualifier Does Not Work From Pricing and Availability Form
NOTE:365826.1 - Pricing And Availability Window Does Not Return Price When Price List Is Blank
NOTE:434760.1 - OEXPRAVA: Unable To Create Sales Order From Pricing And Availability Form
NOTE:390957.1 - OEXPRAVA Pricing And Availability Performance Is Slow
NOTE:465131.1 - Pricing and Availability form (OEXPRAVA) and Custom Price
NOTE:362716.1 - OEXOEAVA - Pricing & Availability - Price List Does Not Default
NOTE:1534101.1 - Currency And Price List Not Defaulting Correctly In Pricing And Availability Form
NOTE:391226.1 - Where Is The Pricing & Availability Form In OM?
NOTE:1346844.1 - Troubleshooting a Price Issue on the R12 Pricing and Availability Form OEXPRAVA
NOTE:295310.1 - OEXOEAVA - Pricing & Availability - Cannot View Earliest Available Date
NOTE:833726.1 - Quote Sales Orders Are Creating Demand and Showing Up In ATP Availability Results.
NOTE:1931743.1 - "Exception:- 4062 ORA-0462: Of Has Been Changed" Error In Pricing And Availability Form