Order Management Suite - Pricing and Availability Form Library

时间：2022-09-02 16:20:45

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 later

Oracle 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

Document 467956.1

Are PTOs supported?

 
Description Document Number
Does the Price And Avalablity Form Support PTOs?

Document 393962.1

"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

Document 1516485.1
Price List Created in Blanket Sales Agreement Does Not Display in LOV

Document 387995.1

"Create Order" Issues

 
Description Document Number
Create Order Fails With Function Not Available To This Responsibility

Document 1376053.1
Unable To Create Sales Order From Pricing And Availability Form

Document 434760.1

"Currency" Issues

 
Description Document Number  
 Does Not Showing The Price And Adjustments For CAD currency

Document 781552.1

  
Form Fails Doing Multicurrency Conversion

Document 1379672.1

  
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?

Document 364888.1

"Customer" Issues

 
Description Document Number
Add Customer Option Under Tools Menu Of Pricing & Availability Is Inactive

Document 883429.1
Price List From Customer Does Not Default Price & Availability Form

Document 463773.1
Pricing And Availability Default Customer

Document 397271.1

Earliest Available Date

 
Description Document Number
 Cannot View Earliest Available Date

Document 295310.1

"Grade" Field

 
Description Document Number
 How to have the Grade Field on Pricing and Availability Form

Document 888263.1

"Hints" Field

 
Description Document Number
 How to Update the Hints field in Pricing and Availability Form?

Document 1262954.1

Item Cross Reference

 
Description Document Number
 Item Cross Reference LOV Does a Blind Query

Document 331267.1

"Modifier Name" Field

 
Description Document Number
 Incorrectly Displays the Modifier Number in the Modifier Name Field

Document 360837.1

Modifier is Not Applied

 
Description Document Number
 Form Does Not Apply Modifiers (Discount) With Line Type Qualifier

Document 833713.1
Form is Not Working With Some Pricing Formula Modifiers

Document 1471145.1
Form (OEXPRAVA) and Custom Price

Document 465131.1
Pricing Attribute for Freight Term Defined as Custom Qualifier for the Price List Does Not Work

Document 560561.1
Form Does Not Show Modifiers Associated to Custom Pricing Attributes

Document 454732.1
Form Ignores A Price List Modifier With Ship Method as a Qualifier

Document 417948.1
R12.1.x Modifiers With Volume Qualifier Not Displaying In Pricing And Availability Form   

Document 1308501.1
R12.0.x: OEXOEAVA: Volume Qualifier Does Not Work From Pricing and Availability Form   

Document 1078887.1

New Inquiry

 
Description Document Number
Defaulted Values on the Price And Availibility Form Are Cleared When Using the New Inquiry Button

Document 1618183.1

Onhand Availability Issues

 
Description Document Number
Why Does The System Show Availability For A Model But No Availability For The Star Item?

Document 845069.1
'Item Availability' Tab Shows All Orgs, Even Where Item Not Assigned

Document 726437.1
Price & Availability Tab Does Not Return Any Item Availability Information

Document 549309.1
Pricing & Availability Shows On-Hand Quantity From Non ATP Subinventory

Document 559875.1

Operating Unit / Organization

 
Description Document Number
How to view Item Availability In "Pricing And Availability" For Other Orgs Without Have To Hit CTRL– F11?

Document 1492513.1
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

Document 365826.1
Price List Does Not Default

Document 362716.1
Currency And Price List Not Defaulting Correctly

Document 1534101.1
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

Document 833726.1
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

Document 453472.1

  
Pricing And Availability Form - Incorrect Unit Selling Price For 'Related Item'

Document 1083293.1

  
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

Document 788446.1

Unit Cost

 
Description Document Number  
 Unit Cost is Not Visible

Document 444769.1

  
     

"Unit List Price" Field

 
Description Document Number
Unit List Price Precision is Not Extended

Document 1435040.1

"Unit Selling Price" Field

 
Description Document Number
Unit Selling Price Shows Decimal Places For Yen Value

Document 400170.1
Unit Selling Price in the Pricing & Availability Form is Different than in the Sales Order Form When using Multi Currency

Document 1585753.1

Warehouse

 
Description Document Number  
Warehouse Field Is Removed On Pricing & Availability Screen After Item Field is Erased

Document 437060.1

  
How Can We Restrict the Warehouse Field Entry on the Pricing and Availability form?

Document 1499245.1

  
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

Document 1937964.1

  

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 Assigned

NOTE: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

Order Management Suite - Pricing and Availability Form Library的更多相关文章

  1. Order Management Useful Scripts

    Listed some useful queries scripts for Oracle Order Management Flow. (For Order Management Detailed ...

  2. Oracle Order Management DropShip Flow for R12

    Oracle Order Management DropShip Flow for R12 Email ThisBlogThis!Share to TwitterShare to FacebookSh ...

  3. 查找EBS中各种文件版本&lpar;Finding File Versions in the Oracle Applications EBusiness Suite - Checking the &dollar;HEADER&rpar;

    Finding File Versions in the Oracle Applications EBusiness Suite - Checking the $HEADER (文档 ID 85895 ...

  4. Oracle Advanced Pricing White Papers

    Oracle Order Management - Version 11.5.10.0 and later Oracle Advanced Pricing - Version 11.5.10 and ...

  5. Inventory Transactions Manager

    Overview Inventory Transaction Manager用于处理库存接口表(MTL_TRANSACTION_INTERFACE或者MTL_MATERIAL_TRANSACTIONS ...

  6. DLL Dynamic-Link Library Search Order

    http://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx A system can contain ...

  7. How to Simulate the Price Order or Price Line Function using API QP&lowbar;PREQ&lowbar;PUB&period;PRICE&lowbar;REQUEST Includes

    How to Simulate the Price Order or Price Line Function using API QP_PREQ_PUB.PRICE_REQUEST Includes ...

  8. Oracle E-Business Suite Maintenance Guide Release 12&period;2（Patching Procedures）

    更多内容参考: http://docs.oracle.com/cd/E51111_01/current/acrobat/122ebsmt.zip Preparing for Patching For ...

  9. B4 and After&colon; Managing Hierarchy&comma; Partitioning&comma; and Asymmetry for Availability and Scale in Google’s Sofware-Defined WAN

    B4及之后:为谷歌软件定义WAN的可用性和扩展管理层次化.划分和不对称 本文为SIGCOMM 2018会议论文,由谷歌提供. 笔者翻译了该论文.由于时间仓促,且笔者英文能力有限,错误之处在所难免:欢迎 ...

随机推荐

  1. phpcms无法读取index&period;html的解决步骤

    代码如下: phpcms\modules\content\classes\html.class.php 查找 复制代码 代码如下: /** * 更新首页 */ public function inde ...

  2. &lbrack;MetaHook&rsqb; R&lowbar;RicochetSprite

    By hzqst void R_RicochetSprite(float *pos, model_t *pmodel, float duration, float scale) { TEMPENTIT ...

  3. javaweb学习总结十九&lpar;http协议概述以及http请求信息分析&rpar;

    一:http协议概述 1:http协议定义 2:使用telnet程序连接web服务器,获取资源 3:http协议:超文本传输协议,它是基于tcp/ip协议,就是建立在tcp/ip之上工作的, http ...

  4. 【HDOJ】1097 A hard puzzle

    题目和1061非常相似,几乎可以复用. #include <stdio.h> ][]; int main() { int a, b; int i, j; ; i<; ++i) { b ...

  5. 基于Jcrop的图片上传裁剪加预览

    最近自己没事的时候研究了下图片上传,发现之前写的是有bug的,这里自己重新写了一个! 1.页面结构 <!DOCTYPE html> <html lang="en" ...

  6. ls -l 显示年份

    默认情况下ls -l命令只显示月和日,不显示年份: $ ls -llrwxrwxrwx 1 root root 7 Feb 27 16:12 bin -> usr/bin 如要要显示年份,就要使 ...

  7. 安装VMware错误&comma;Microsoft Runtime DLL 安装程序未能完成安装

    安装VMware-workstation-full-12.5.6-5528349, 出现如下错误: 这时候,要注意了,不要点击"确认",如果手快点击了,没关系再次运行VMware安 ...

  8. vue省市区三级联动

    仿照小米之家做的一个省市区三级联动,先上代码: HTML: <template> <section class="myAddress"> <secti ...

  9. tomcat启动命令行中文乱码

    1.找到${CATALINA_HOME}/conf/logging.properties 2.添加语句:java.util.logging.ConsoleHandler.encoding = GBK ...

  10. Appium &plus; Python环境搭建（移动端自动化）

    安装JDK,配置JDK环境    百度搜索下载就行,这里分享一个下载链接:https://pan.baidu.com/s/1snuTOAx 密码:9z8r. 下载好后点击进行安装.安装好后进行环境变量 ...

相关文章