Oracle 收货时，Form报错：APP-FND-01048

显示全部楼层 · 2007-10-20 08:38:44

本帖最后由 rj411-sunny 于 2012-9-27 14:01 编辑
在输入Location后，出现下面错误：
APP-FND-01048: Use of this combination restricted by WHERE clause' (*DISABLE_DATE>SYSDATE OR DISABLE_DATE IS null) AND (NVL(SUBINVENTORY_CODE,'Z')) =NVAL (:RCV_TRANSACTION.SUBINVENTORY_DSP,'Z'))'
请高手指教

千问 · 2007-10-20 08:38:44

本帖最后由 rj411-sunny 于 2012-9-27 13:57 编辑
上个图。有哪位高手知道是什么问题不，谢谢

千问 · 2007-10-20 08:38:44

NVAL (:RCV_TRANSACTION.SUBINVENTORY_DSP,'Z')

千问 · 2007-10-20 08:38:44

有没有高手知道，先自己顶顶~

千问 · 2007-10-20 08:38:44

rj411-sunny 发表于 2012-9-28 08:20
有没有高手知道，先自己顶顶~
我回复就被你无情忽略了，注意红色部分
NVAL应该改成NVL

千问 · 2007-10-20 08:38:44

哦这个是我手误，写错了，原本的错误我图贴出来了，是没有多出来的，就是NVL. 谢谢

千问 · 2007-10-20 08:38:44

检查下你接收的这个item有没失效，再检查下接收的subinventory

千问 · 2007-10-20 08:38:44

如果都没问题，再检查下这个item的属性定义

千问 · 2007-10-20 08:38:44

Cause
In Oracle Purchasing, onreceiving a shipment with multiple distributions for items with different locator setup, error would beraised because :
The locator flex field gets defined as "Restricted" or "Unrestricted" in when-new-item-instance and when-validate-item of
RCV_TRANSACTION block. Suppose a purchase order is created having items with both Restricted and Unrestricted locators.While Receiving the same the locators are defined in the triggers as told above.
But while saving the locators are not redefined i.e if the purchase order has line as
1- Restricted
2- Unrestricted
3- Restricted then on saving, the flex definition for the line in which the cursor is maintained across all the lines. So the 2nd line is also considered as Restricted locator and the error is raised.
In the above case if the cursor is placed in the 2nd line before saving the transaction no error gets raised because all the locators are assumed as Unrestricted and only check that is done is to check whether the locator is enabled.
This is explained in Bug 4230754 - Error Receiving Multiple Lines of Mixed Locator Controlled Items
Solution
WORKAROUND
1. For the item which does not have restricted subinventory and locator, setup a subinventory and locator.
Organization Items / (Query for Item) / Tools / Item Subinventories /
Define a Subinventory and Locator.
SOLUTION
To implement the solution, please execute the following steps:
SOLUTION FOR 11.5.9
===================
1. Please download and review the readme and pre-requisites for Patch 4230754.
2. Apply Patch 4230754 in a test environment.
3. Please confirm the following file versions:
RCVCOTRX.pld 115.140.1159.30
strings -a $AU_TOP/resource/RCVCOTRX.pll | grep -i '$Header'
4. Retest the issue.
5. If the issue is resolved, please migrate the solution as appropriate to other environments.
SOLUTION FOR 11.5.10
======================
1. Download and review the readme and pre-requisites for Patch 4705988.
2. Ensure that you have taken a backup of your system before applying the recommended patch.
3. Apply the patch in a test environment.
4. Confirm the following file versions:
RCVCOTRX.pld version 115.201.11510.19
You can use the commands like the following:
strings -a $AU_TOP/resource/RCVCOTRX.pll | grep -i '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.

千问 · 2007-10-20 08:38:44

-- ERROR
APP-FND-1048 Use of this combination is restricted by where clause.
The issue described in 11.5.9 Note 399083.1 but is should be solved in 11.5.10 .
Why sometime this subinventory field is left blank at PO receipt ?
This happens randomly for few transactions,for PO receipts .
-- Steps To Reproduce:
1. Create a PO with project and task.
2. Go to receiving and perform a receipt such that MTLL combination is unique so that it will be dynamically inserted into the system.
3. Get the error APP-FND-1048
4. See that the locator entered in the form is created (with valid locator/project/task ) but is missing the subinventory_code in mtl_item_locations table
The script
SQL> SELECT mil.INVENTORY_LOCATION_ID, mil.SEGMENT1, mil.SEGMENT2,mil.SEGMENT3,mil.SEGMENT19, mil.SEGMENT20,
mil.subinventory_code , mil.organization_id
FROM mtl_item_locations mil
WHERE mil.subinventory_code IS NULL
order by mil.organization_id ;
returns some records
-- Workaround
Manually enter the subinventory from the Define Stock Locator form
Cause
The cause of the issue is low file version of RCVRCERL.pll and RCVCOTRX.pll
The following bug was logged to development
Bug 8595061 PROBLEM WHILE DYNAMIC INSERT APP-FND-01048 STOCK LOCATOR
Oracle Development stated that patches 8329194 and 8534633 should resolve the issue.
These patches would bring the file versions of RCVRCERL.pll and RCVCOTRX.pll
to a higher level - there are quite a few fixes on locator and others.
The 2 patches are for other issues but they contain fixes for the reported locator issue as well

Solution
-- To implement the solution, please execute the following steps:
1. Download and review the readme and pre-requisites for Patch 8329194 and Patch 8534633
2. Ensure that you have taken a backup of your system before applying the recommended patches
3. Apply the patches in a test environment.
4. Confirm the following file versions:
RCVCOTRX.pld 115.201.11510.60
RCVRCERL.pld 115.157.11510.67
You can use the commands like the following:
strings -a $AU_TOP/resource/RCVCOTRX.plx |grep '$Header'
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.