oracle 事务补全,接收事务处理错误提示

看看这篇文章

11.5.10 or R12 Unable to Deliver, Inspect, Correct or Return PO Receipts: RVCTP Fails RVTTH-115d: or RVTTH-115F: Subroutine Process_transaction() [ID 415816.1]

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

Modified 07-JUL-2010     Type PROBLEM     Status PUBLISHED

In this Document

Symptoms

Changes

Cause

Solution

References

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

Applies to:

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

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:RCVTXERT.FMB - Enter Receiving Transactions

FORM:RCVTXERE.FMB - Enter Returns

FORM:RCVTXECO.FMB - Enter Corrections

RVCTP - Receiving Transaction Processor

Symptoms

When attempting to deliver, inspect, return or correct a Purchase Order (PO) receipt tied to an item, the following error(s) occur:

ERRORS

The errors are broken down to where you might see them based on how you performed the transaction. For example, the error that you see in online receiving, immediate mode, or in the debug file are shown. (Refer to Note 197860.1 for explanation of receiving processing modes).

On line Receiving Error:

RVTTH-115d: Subroutine process_transaction() returned error

Immediate mode (RVCTP module: Receiving Transaction Processor) Error:

RVTTH-115f: Subroutine process_transaction() returned error

STEPS

Responsibility: Purchasing or Inventory

1. Go to Receiving / Receiving Transactions

. or Receiving / Corrections

. or Receiving / Returns

2. Enter Receipt or Purchase Order Number

3. Select the receipt line to be transacted

4. Enter Subinventory and Save

5. Error occurs

Changes

Possible changes are, but not limited to:

- Upgrade to 11.5.10

- Item attribute changes including item status.

Cause

The cause is a missing Move Order line for the receive transaction (in MTL_TXN_REQUEST_LINES (MTRL) table). If the item was inactive at the time of receipt, the Move Order line was not created, but the system is validating for the Move Order line at the time of correct/return, even if the item is inactive.

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

NOTE - See what the item status is by querying it in the Inventory > Items > Master Items screen.

Also, look at the "Inventory Organization Item" setup by then choosing Menu: Tools > Organization Assignments, and selecting the inventory organization in question. Here is a screen shot of the status field in the "Inventory Organization Item" setup: screen where you would see the item is active or inactive:

Solution

1. Apply Patch 5507513

The patch provides RCVTXECO.pld 115.67.11510.15

RCVTXERE.pld 115.71.11510.6

This patch will allow the user to return or correct the receive transactions for the inactive item.  If the item is inactive and the user is trying to perform an inspect or deliver, the transaction will NOT be allowed. It is not possible to inspect or deliver an inactive item.

2. Please note: This solution DOES NOT apply if the item is now active. If the item is active, follow the steps outlined in Note 301524.1 for the solution: Receiving Transactions Fails With RVTTH-115F / RVTTH-115D Error (Missing Move Order Datafix)

To prevent future occurrences:

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

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:

INVIDI3B.pls 115.48.115100.12

You can use the commands like the following:

grep '$Header' $INV_TOP/patch/115/sql/INVIDI3B.pls

5. Retest the issue.

6. Migrate the solution as appropriate to other environments.

References

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

BUG:5507513 - ITEM INACTIVATED - BUT STILL ABLE TO PEFORM PO RECEIPTS APP-FND-01048

NOTE:301524.1 - Receiving Transactions Fails With RVTTH-115F / RVTTH-115D Error

NOTE:973580.1 - RVTTH-115d, RVTTH-115f or RVTTH-115h Error While Receiving Or Returning POs And RMAs

Attachments

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

Item screen shot (937.55 KB)

Related

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

Products

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

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

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

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

Keywords

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

MTL_TXN_REQUEST_LINES; RCVTXERE.FMB; RCVTXECO.FMB; RCVTXERT.FMB; RVCTP; RECEIVE~CORRECTIONS; RECEIVE~RETURNS

Errors

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

115 ERROR

Back to top

Rate this document

Article Rating

Rate this document

Excellent

Good

Poor

Did this document help you?

Yes

No

Just browsing

How easy was it to find this document?

Very easy

Somewhat easy

Not easy

Comments

Provide some feedback

Cancel