oracle 采购入库 退货,采购退回供应商报错(rvtptcontrol failed)

这应该是个Bug.

Receiving Transactions Fails With RVTTH-115B, RVTTH-115D, RVTTH-115F, RVTTH-115H, RVTTH-115J [ID 301524.1]

--------------------------------------------------------------------------------

Modified 22-SEP-2010     Type PROBLEM     Status PUBLISHED

In this Document

Symptoms

Changes

Cause

Solution

For Release 11.5.10

For Release 12.0.x

For Release 12.1.1+

References

--------------------------------------------------------------------------------

Applies to:

Oracle Inventory Management - Version: 11.5.10 to 12.1.2 - Release: 11.5 to 12.1

Oracle Inventory Management - Version: 11.5.10.0 to 12.1.2   [Release: 11.5 to 12.1]

Information in this document applies to any platform.

FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI

Symptoms

On  a non-Warehouse Management System (WMS) Organizations, when attempting to perform Correction/Deliver/Inspection/Return one of the following error occurs.

Error

RVTTH-115j Subroutine process_transaction() returned error

RVTTH-115h: Subroutine process_transaction() returned error

RVTTH-115d:Subroutin process_transaction() returned error.

RVTTH-115f: Subroutine process_transaction() returned error

RVTTH-115b: Subroutine process_transaction() returned error

Old Behaviour:

Move Order can be created during receiving for non-WMS organizations

New Behaviour:

Move Order cannot be created during receiving for non-WMS organizations

WMS Enabled?

You can see if an organization is WMS Enabled reviewing the Inventory > Setup > Organization > Parameters screen. There is a WMS Enabled flag for each organization. You could also run SQL like the following:

SELECT   mp.ORGANIZATION_ID

, ood.ORGANIZATION_CODE

, ood.ORGANIZATION_NAME

, mp.WMS_ENABLED_FLAG

FROM   org_organization_definitions ood, mtl_parameters mp

WHERE  ood.ORGANIZATION_ID = mp.ORGANIZATION_ID

ORDER BY 1;

* Note that the flag is WMS_ENABLED_FLAG. There is a slightly different column name that is NOT the same (WSM_ENABLED_FLAG) so make sure you use the WMS column (WMS_ENABLED_FLAG). The flag will be Y for Yes and N for No.

Changes

For some cases, this issue began after an upgrade to 11.5.10 from earlier release (like 11.5.9).

However, there are also scenarios where the upgrade did NOT occur.

Cause

There are several causes for this issue.

1. The corresponding putaway Move Order (MO) record created during initial PO or RMA receipt in table MTL_TXN_REQUEST_LINES (MTRL) is missing.

2. The corresponding putaway MO record created during inital PO or RMA receipt in table MTRL is present but has invalid data.

In Bug 8731994 it has been decided to not to create putaway MOs for receipts in non-WMS enabled organizations

Solution

NOTE:

If the item is active and performing a deliver, return, or correction, but getting this error, see the solution below.

However, this solution DOES NOT apply to Inactive Item.  If item is inactive and performing a return or correction, see Note 415816.1 outlining specific steps / patches. If the item is inactive and performing a deliver, the transaction will NOT be allowed. It is NOT possible to deliver an inactive item. The item must be active. If the item is activated but the transaction still fails with this error, follow the steps below to deliver the active item.

To implement the solution, please execute the following steps:

For Release 11.5.10

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

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:

INVRCVVB.pls 115.107.115100.102

You can use the commands like the following:

strings -a $INV_TOP/patch/115/sql/INVRCVVB.pls | grep -i '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

For Release 12.0.x

1. Download and review the readme and pre-requisites for Patch 8731994:R12.INV.A

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:

INVRCVVB.pls 120.77.12000000.42

You can use the commands like the following:

strings -a $INV_TOP/patch/115/sql/INVRCVVB.pls | grep -i '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

For Release 12.1.1+

1. Download and review the readme and pre-requisites for Patch 8731994:R12.INV.B

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:

INVRCVVB.pls 120.92.12010000.19

You can use the commands like the following:

strings -a $INV_TOP/patch/115/sql/INVRCVVB.pls | grep -i '$Header'

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

DATAFIX

With the application of the root cause fix patches listed above for the respective application release there is no datafix required. However, if customer is not able to apply the root cause patch to resolve this issue and requires a datafix, please log a service request with Oracle Inventory Support to obtain the datafix script.

References

BUG:4232608 - RECEIVING TRX FAILS WITH RVTTH-115F ERROR

BUG:5077618 - ITEMS FORM ALLOWS CHANGING REVISION CONTRL EVEN THOUGH PENDING DELIVER TXN EXIST

NOTE:197860.1 - Explanation of RCV: Processing Modes, Pending Transactions and Destination Types

NOTE:568012.1 - FAQ: Inventory Standard Datafixes

Attachments

--------------------------------------------------------------------------------

Where to see item status (54.7 KB)

invinbup_inv_orgs.sql (13.47 KB)

Related

--------------------------------------------------------------------------------

Products

--------------------------------------------------------------------------------

Oracle E-Business Suite > Logistics > Logistics > Oracle Inventory Management

Oracle E-Business Suite > Logistics > Logistics > Oracle Inventory Management

Keywords

--------------------------------------------------------------------------------

RVTTH-115; MTL_TXN_REQUEST_LINES; RCVTXERT.FMB; PROCESS_TRANSACTION; INVINBUP.SQL; RECEIVING~TRANSACTION~PROCESSOR; RVCTP; SUBROUTINE~PROCESS_TRANSACTION