Receiving->Receipts Searching Receipt Fails with APP-PO-14142

纵横四海

采购->接收->接收，然后点击查询



该贴已经同步到 纵横四海的微博

纵横四海

纵横四海 发表于 2011/11/1 14:19
设置接收选项(必需)
注意: 该步骤必须为每个库存组织进行设置。
菜单：设置组织接收选项

问题已经解决是，采购接收选项的问题。之前采购接收选项忘记设置了。
解决问题的过程是曲折的，解决方法是简单的。。。

纵横四海

纵横四海

纵横四海 发表于 2011/11/1 13:56

在 Metalink 上查询到了一篇和我一样错误的文章
Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403 [ID 267010.1]

Applies to:
Oracle Inventory Management - Version: 11.5.9 to 12.0.0
This problem can occur on any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI

Symptoms
Searching Receipt Fails with APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403: no data found
In R12 the error may be:
APP-PO-14142: rcv_receipts_eh.event-000: ORA-0000: normal, succesful completion
Cause: A SQL error has occurred in rcv_receipts_eh.event. The SQL error is ORA-0000: normal,
successful completion

Steps to reproduce:
1 Navigate to Receiving>Receipts
2 Enter PO number, PO line and press Find
3 Receive the following error: APP-PO-14142: rcv_receipts_eh.event-000 ORA-1403: no data found
4 Trace shows, the following statement returns 0 rows :

SELECT ROUTING_NAME
FROM
RCV_ROUTING_HEADERS WHERE ROUTING_HEADER_ID = :b1

Cause
The Routing could not be set up correctly for the PO.

Use the following scripts to find out if the routing is not setup for the PO:

select po_header_id,
from po_headers_all where segment1 = 'PO#'; Insert the problem PO number

select po_line_id, line_num
from po_lines_all
where po_header_id = 'value returned from above';

select line_location_id, receiving_routing_id
from po_line_locations_all
where po_header_id = value returned from #1 and po_line_id = value returned
from #2

select routing_name, description
from rcv_routing_headers
where routing_header_id = insert value returned for receiving_routing_id from #3

If the last query does not return any rows then the Routing has not been set up correctly.

Solution

Check the routing for the PO.

The Receipt Routing can be set at 5 places:

1) While Creating the Purchase Orders. At shipment level.

2) Item Definition Level.

3) At the Supplier Definition level.

4) Shipping Networks During Inventory Setup.

5) At the Organizational Level. Receipt Options.

Every level overrides the following ones, therefore the Purchase Order level is the highest
level and Organization level is the lowest one.

The Receipt Routing Information Provided while Creating the Purchase Order
Takes precedence than the other two ways.

There is also a Profile Option :- RCV: Allow Routing Override whose value namely
Yes or No indicates whether the receiving routing assigned during requisition or
purchase order entry can be overridden at receipt time.

This profile is updatable at the site, application, and responsibility, levels.
ReferencesBUG:2778003 - RECEIVE APP-PO-14142 WHEN PRESSING FIND IN THE RECEIVING FORM RCVRCERC

纵横四海

Rcv_receipts_eh.Event-000: Ora-0000: Normal, Successful Completion - After Searching for a Purchase Order Number in Enter Receipts Form [ID 790881.1]

Applies to:
Oracle Inventory Management - Version: 11.5.10 to 12.1.3 - Release: 11.5 to 12.1
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts
FORM:RCVTXERT.FMB - Enter Receiving Transactions
FORM:RCVTXERE.FMB - Enter Returns
FORM:RCVTXECO.FMB - Enter Corrections
Symptoms
When attempting to enter receiving details in any of the receiving forms,
the following error occurs after searching for a purchase order number:

APP-PO-14142: rcv_receipts_eh.event-000: ORA-0000: normal, successful completion.
Cause: A SQL error has occurred in rcv_receipts_eh.event. The SQL error is ORA-0000: normal,
successful completion.
Action: Take note of both these error numbers and the actions you were trying to perform. Contact
your system administrator for further assistance.


Click OK, and another message returns:
APP-14094: No records meet your search criteria.
Cause: There are no records that match your search criteria.

The problem appears to occur only for the purchase order with a line that has more than one
shipment line location.

In iProcurement the same transactions can be successfully performed

Steps To Reproduce:
1. Purchasing Responsibility -> Receiving -> Receipts
2. Enter order number and click Find.
3. Receive the error messages.
Cause
The exact root cause is not known; it is supposed that invalid / uncompiled libraries caused the issue.

This issue has been fixed ensuring to upgrade to latest available versions of receiving forms and
RCVTXECO.pld file.

This is explained in the following bug:
Bug 5205575 ALL RECEIVING FORMS: APP-PO-14094 NO RECORDS MEET YOUR SEARCH CRITERIA

Solution
To implement the solution, please execute the following steps:

0. First ensure to follow the steps of

    * Note 1325394.1 Troubleshooting Guide - invalid objects in the E-Business Suite Environment 11i and 12 ); and
    * Note 141118.1 to have the invalid objects / libraries in the database recompiled.


If problem persists, in 11.5.10:

1. Download and review the readme and pre-requisites for Patch 7377152

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:

    po forms/US RCVCOFND.fmb 115.118.11510.19
    po forms/US RCVRCERC.fmb 115.129.11510.29
    po forms/US RCVRCMUR.fmb 115.38.11510.9
    po forms/US RCVRCVRC.fmb 115.78.11510.15

    po forms/US RCVTXECO.fmb 115.79.11510.11
    po forms/US RCVTXERE.fmb 115.79.11510.11
    po forms/US RCVTXERT.fmb 115.106.11510.15
    po patch/115/odf poxrcv.odf 115.109.11510.24
    po resource RCVTXECO.pld 115.67.11510.25
    po resource RCVTXERE.pld 115.71.11510.16

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.  

纵横四海

纵横四海 发表于 2011/11/1 14:01
Rcv_receipts_eh.Event-000: Ora-0000: Normal, Successful Completion - After Searching for a Purchase  ...

这个是我发现的另外一个文档对这个问题的描述。

纵横四海

设置接收选项(必需)
注意: 该步骤必须为每个库存组织进行设置。
菜单：设置组织接收选项
接收选项用来设置一些进行采购接收时的一些控制和缺省内容。如下为具体内容：
接收日期控制：用户可以设置接收日期的早或晚的天数及过早或过晚到货后，系统如何反映，发出警告，拒绝接收或没有反应。
接收数量控制：接收的数量与订购数量有出入，是否可以接收。用户可以设置数量在怎样的范围内可以接受，一旦超过范围，系统应如何反应，发出警告，拒绝接收或没有反应。
接收路径控制：用户可定义如何进行采购接收。系统提供了三种方式。分别为
‘标准接收’：接收，然后入库。
‘需要检验’：接收，检验合格后入库。
‘直接接收’：直接入库。
接收控制：系统提供了一些选项来开关一些系统功能，例如：
是否允许替代接收：即用替代件来代替订购的物品进行接收。
是否允许盲目接收：即在收货时，用户不知道订购的数量。
是否允许无定单接收：若没有采购定单，是否可以收下。
接收号控制：每一次接收有一个编号，该编号如何生成，自动或手动；编号为字符或数字类型。
操作步骤：
根据菜单进行窗口，设置相应的控制选项和缺省值后存盘。

pregod

正好这两天也遇到这个问题了，谢谢四海的整理！