解决APP-FND-00204的错误

  下午接到工厂那边业务员的电话，说整个仓储部门都无法对物料做接收和退货操作，报错为APP-FND-00204。截图如下：

 

 

 

以TM-SVC LOCK HANDLE FAILED为关键在metalink上一搜索找到这样一篇文章：

 

Applies to:

Oracle Inventory Management - Version: 10.7 to 11.5.10
This problem can occur on any platform.

Symptoms

Unable to perform receipts due error

APP-FND-204 Concurrent Manager encountered an error while running the spawned concurrent program Receiving Transaction Manager - RCVOLTM for your concurrent request XXXXXX. TM-SVC LOCK HANDLE FAILED

RCV: Processing Mode is Online
The problem occurs in ONLINE mode
The problem happens with any type of routing and any type of receiving document.

Cause

This is  happening because of large number of receiving processes being spawned at the same time.

Check the number of process running for the RCVOLTM. If  the number of  Running and Max processes are the same, this means the Max number of processes are reached.  At this time this issue will occur.

Solution

Increase the Max number of processes associated with the receiving transaction manager.

To determine the number of processes review How Many Processes Should Be Set For The Receiving Transaction Manager (RTM)?

继续看404336.1这篇文章来确认怎样设置接受事务处理器的流程数。

Applies to:

Oracle Inventory Management - Version: 10.7 to 12.0
Information in this document applies to any platform.
RCVTPO - Receiving Transaction Manager

Goal

What Is Correct Number of Processes for Receiving Transaction Manager (RTM)?

Solution

The information below applies only if one or more of the following transaction activities are processed:
1. Core Receiving (Receipts, Receiving Transactions, Corrections, Returns, etc) whe Profile RCV: Processing Mode=On-line
2.  Confirm Receipts
3.  Ship Confirm for Internal Orders
4.  Inter-Organization Transfers
5.  Internet Procurement (iP) Receiving

The activities listed in 2-5 (above) always use On-line, regardless of the value set for Profile RCV: Processing Mode

Set the # Processes = 3 and consider increasing only if one of the following occurs routinely:
Records get stuck in rcv_transactions_interface table (processing_status_code=PENDING or RUNNING)
-OR-
Multiple Users report performance issues (or timeout error) after Save for transaction activities listed above

Navigation:

• System Administrator (or comparable) Responsibility > Concurrent > Manager > Define
• Query for Program Name (lower portion of form) = 'Receiving Transaction Manager'  
  **current # Processes is the value in the Target column
• Click Work Shifts button
• Change the value using guidelines referenced below
• Save

Note: additional Receiving Transaction Managers may be setup, so be sure to check for other records (use down arrow to go to the next record)

The # Processes should be calculated as noted below since the value is mostly based on the number of concurrent Users who perform Receiving activities using RCV: Processing Mode=On-line. 

Calculate the max number of concurrent Users:
Core Apps Receivers (Receipts, Receiving Transactions, Corrections, Returns, etc) whe Profile  RCV: Processing Mode=On-line +
iP Receivers +
Confirm Receipts Receivers +
Ship Confirms for Internal Orders +
InterOrg Transfer Creators

Divide the Total from above by 3 or 4. This is will be (approximately) the suggested value for # Processes.

Please do NOT indiscriminately set this to a high value, as the processing capability of your instance is also a factor (which cannot be included in the calculation as there are too many variables). Rather, increase # Processes by 5 or 10 then monitor for a week or more; repeat process until at or near calculated value from above.

Example:
There are 500 total Users who perform the transaction activities listed above, but the most Users work at the same time never exceeds 36.  For this Example, # Processes for Receiving Transaction Manager should be 12 or 9 (36 divided by 3 or 4).

按照这个算法，我们的流程数设置为2应该满足要求。问题发生后的半个小时业务员再做接收好像又没问题了，之前的报错没有了。其实关于APP-FND-00204的错误诊断，metalink上有另外一篇文章值得参考：

Applies to:

Oracle Inventory Management - Version: 11.5
Information in this document applies to any platform.

Goal

How to Troubleshoot APP-FND-00204 error messages with the Receiving Transaction Manager - RCVTPO or RCVOLTM

Solution

1. Relink receiving executables.
   cd $PO_TOP/bin
   $ adrelink force=y ranlib=y "PO RCVOLTM"
   $ adrelink force=y ranlib=y "PO RVCTP" 
2.  Bounce the Receiving Transaction Manager.
   a. $ps -ef | grep RCVOLTM (to see how many processes are running)
   b. Deactivate Receiving Transaction Manager
   (System Administrator > Concurrent > Manager > Administer)
   c. $ps -ef | grep RCVOLTM (repeat until no processes are running)
   d. Restart Receiving Transaction Manager
3. Verify rvacj.lpc file version is at 115.30 or higher. If not apply .
   cd $PO_TOP/bin
   strings -a RVCTP|grep -i 'Header: rvacj.lpc'
   
4. Verify rvtth.lpc file version is at 115.27 or higher. If not apply .
   cd $PO_TOP/bin
   strings -a RVCTP|grep -i 'Header: rvtth.lpc'
5. Verify if 11i.INV.G(2004922) or a patch containing this patch has been applied. If so, is required and should be applied.
6. As a workaround, test changing the RCV: Processing Mode profile option to Immediate or Batch and verify if the problem is reproducible.
   

虽然问题到这流程能走下去没有报之前的错误，但业务数据好像出现了一些逻辑上的错误。以下是我协助同事提交的一个SR。

Abstract RECEIP NUMBER MISSING AFTER DOING RECEIPT

Resolution History


24-AUG-09 08:57:57 GMT

.

24-AUG-09 08:59:04 GMT

UPDATE
=========
Customer has done the receipt. But could not find the receipt number when attempting to do inspection.
Asked the customer to upload the screenshots

Faye

24-AUG-09 09:09:06 GMT

New info : [e-mail]
hi
'Receiving Transaction Processor' finished, but the result has not changed.


24-AUG-09 09:13:21 GMT

New info : [e-mail]
hi:
can not update the pic


24-AUG-09 09:24:57 GMT

-- Client called back --

24-AUG-09 09:29:27 GMT


.
** HUB **

CUSTOMER UPDATE
================
Customer contact name (if not same as in SR header): MR DING
Verify preferred method of contact: PHONE OR METALINK
Phone#: [phone]
Email: [e-mail]

Comments for this update:
Customer called in and stated that he can't upload screenshot via metalink. He want the owner engineer give him an email address.
Also he need translation service for his SR.
@Pinged engineer Faye to help.


Thank you.
Joyce
Oracle HUB Team



24-AUG-09 09:42:19 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
error1.zip


24-AUG-09 09:45:41 GMT

TAR has been assigned to an analyst -- Sending email.

24-AUG-09 09:52:06 GMT

.
**Unpublished**
.
TRANSFER JUSTIFICATION
=======================
misrouted tar. tranfer to receiving -po team.




24-AUG-09 10:04:33 GMT

(Update for record id(s): 373837628)

UPDATE
======
Hi Mr,

We received and will review your updates.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@WIP - Work In Progress



24-AUG-09 11:24:34 GMT

(Update for record id(s): 373850165)

UPDATE
======
Hi Mr,

1. can you pls confirm is your porblem occured for particular receipt Only or can be
reprodcued for any receipt done ?

2. can you pls upload following diag as like analyse status of document

Please provide output of the script rcv11i_sa.sql for a problematic document.
Please refer to the Metalink Note 402245.1 "Receiving Transactions Data
Collection Script rcv11i_sa.sql".

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response



24-AUG-09 11:24:35 GMT

Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 02:02:38 GMT

-- Client called back --

25-AUG-09 02:09:02 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
error.zip


25-AUG-09 02:10:15 GMT

-- Client called back --

25-AUG-09 02:41:22 GMT

.
** HUB **

CUSTOMER UPDATE
================
Customer contact name (if not same as in SR header): MR DING
Verify preferred method of contact: PHONE OR METALINK
Phone#: [phone]
Email: [e-mail]

Comments for this update:

Customer called in that he needed help from our translation service, he had uploaded the file which including screenshot and explaination of the error.
I have translated the Chinese verion of explaination into English version in the
file, and also I have uploaded the file with English version explaination to th
is SR.

Translation are as follows:
Error APP-FND-00204 (as Picture 1) happened at 1:30PM(GMT +8) on 24-AUG-2009, and customer couldn't do receipt and return, a
nd customer didn't know the reason, then it reverted one hour later.
In this period, the recipt number appeared error in Picture 2, the quantity showed 0, and c
ustomer didn't know the reason.
In Picture 3, it showed the shipment information of PO, quantity is 10000, last week customer received 5000, and at 1:30PM(GMT +
8) on 24-AUG-2009, customer had already received 5000. There is no maturity date
quantity in the shipment lines, but receipt quantity didn't change to 10000.
Customer thought that there were many these kinds of errors, and they couldn't che
ck the amount. In about one hour, customer didn't know how may receipts happened
.

Because now customer didn't sure about the quantity, ASCP is not accurate, so customer couldn't estimate the effection.
Customer's expectation:
1. check out the quantity of error lines.
2. what kinds of requests could be run in order to make the data is correct.
3. ask for the reason of this problem
4. don't want to install patch and datafix

Pinged the engineer and sent him e-mail about this.

Thank you.
Joy Zhao
Oracle HUB Team





25-AUG-09 05:20:00 GMT

(Update for record id(s): 374010222)

UPDATE
======
Hi Mr,

We received and will review your updates.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@WIP - Work In Progress



25-AUG-09 06:04:36 GMT

(Update for record id(s): 374010391)

UPDATE
======
Hi Mr,

1. can you pls reply for section 1 above
as got no reply for it

can you pls confirm is your problem occured for particular receipt Only or can be reprodcued for any
receipt done ?
i asked this in order to know if issue occured only one time ?

2. you have sent file error.zip and i cannot open it as got following message

".cannot open file it does not appear to be avalid archive...

so pls upload file again and make e sure you upload following for your porblematic
document

Please provide output of the script rcv11i_sa.sql for a problematic document.
Please refer to the Metalink Note 402245.1 "Receiving Transactions Data
Collection Script rcv11i_sa.sql".



Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response


Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 06:35:12 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
error.pdf


25-AUG-09 06:46:41 GMT

-- Client called back --

25-AUG-09 06:48:49 GMT

(Update for record id(s): 374010586)

UPDATE
======
Hi Mr,

We received and will review your updates.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@WIP - Work In Progress



25-AUG-09 06:50:51 GMT

(Update for record id(s): 374010592)

UPDATE
======
Hi Mr,

sorry but you are not reply to my questions

1. can you pls confirm is your problem occured for particular receipt Only? or can be reprodcued for any receipt done ?
i asked this in order to know if issue occured only one time ?

2. pls upload file again and make e sure you upload following for your porblematic document


Please provide output of the script rcv11i_sa.sql for a problematic document.
Please refer to the Metalink Note 402245.1 "Receiving Transactions Data
Collection Script rcv11i_sa.sql".
.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response


Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 07:00:35 GMT

.
** HUB **

CUSTOMER UPDATE
================
Customer contact name (if not same as in SR header): MR DING
Verify preferred method of contact: PHONE OR METALINK
Phone#: [phone]
Email: [e-mail]

Comments for this update:

Customer called in and said he didn't know how to run the script provided in the note 402245.1.

Thank you.
Loki Zhong
Oracle HUB Team



25-AUG-09 07:19:02 GMT

New info : [e-mail]
hi:
1. I can't confirm the number of the problem,because in an hour , we didn't know how many receiving data.
Now we find one problem,but we can't know any problem else.

we always think it is an accident.


25-AUG-09 07:21:03 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
C:\1.JPG


25-AUG-09 07:22:03 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
C:\2.JPG


25-AUG-09 07:23:05 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
C:\3.JPG


25-AUG-09 07:24:04 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
C:\RCV11i_PR_100261-145_.html


25-AUG-09 07:33:14 GMT

(Update for record id(s): 374010865)

UPDATE
======
Hi Mr,

We received and will review your updates.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@WIP - Work In Progress



25-AUG-09 07:40:02 GMT

(Update for record id(s): 374010886)

ISSUE CLARIFICATION
===================
-- Problem Statement:
when ct try perform receipt for One record he got following error

App-fnd-00204 Tm-svc lock handled failed

issue occured for particular receipt for blanker release
po is 100261-145


(Update for record id(s): 374010888)

ISSUE VERIFICATION
==================
verfided by screen shot


25-AUG-09 07:43:57 GMT

(Update for record id(s): 374010932)

UPDATE
======
Hi Mr,

thanks for uploaded file but if you look at diag you will see that file contain and error at end of
it and the file not contain all data
so pls upload file again as followed



Upload to the SR the output of the script rcv11i_sa.sql for the PO. Please
download the script from Metalink Note 402245.1 "Receiving Transactions Data
Collection Script rcv11i_sa.sql".

Please run the script with the following parameters:

1. Please enter source document type [PO (Purchase Order), PR (Purchase order
release (blanket or scheduled release)),
RQ (Requisition), RMA (Return Material Authorization), IOT (Inter-organization
Transfer or inter-organization Shipment)]: Enter -->PR
2. Please enter Document Number (PO Num, IR Num, RMA Num, or Shipment Num):
ENTER PO NUMBER -->100261

3. Please enter Release Number (or just press ENTER if not applicable):
ENTER--145

4. Please enter Operating Unit ID (or just press ENTER): enter the Operating
Unit ID for the PO-->101

5. Include ROI tables summary query? [Y]es, [N]o, [O]nly summary: [N] ' : Enter N

6. For ROI summary query, enter GROUP_ID (or just press ENTER for null group_id):
press ENTER

7. Output Destination? Please enter destination type (SO or UFD): [SO] ' : Enter
UFD

8. Please enter the Destination directory (For UFD, you will be prompted to
enter any utl_file_dir directory from the utl_file_dir list): enter the
directory

9. Please, concisely describe the issue (press ENTER to finish your statement):
press ENTER

The script output will be generated in the directory entered in the Destination
directory parameter.



Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response


Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 08:56:05 GMT

New info : [e-mail]
hi:
The output file is 4M, i can't upload.it is so solwly.
Please give me a e-mail address , i mail you !


25-AUG-09 08:59:42 GMT

(Update for record id(s): 374021316)

UPDATE
======
Hi Mr,

Pls upload it to [e-mail]

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response



25-AUG-09 08:59:43 GMT

Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 09:06:07 GMT

The customer : [e-mail] : has uploaded the following file via MetaLink:
C:\RCV11i_PR_100261-145_N.html


25-AUG-09 09:12:45 GMT

(Update for record id(s): 374021407)

UPDATE
======
Hi Mr,

We received and will review your updates.

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@WIP - Work In Progress



25-AUG-09 09:27:48 GMT

(Update for record id(s): 374021490)

UPDATE
======
Hi Mr,

Thanks for the file Uploaded and have seen from Uploaded file that you got 5 stucked records in
rcv_transactions_interface
so that might explain that issue where you have qty zero

Pls run following first in your TEST environment clone from production

Update rcv_transactions_interface rti
set processing_mode_code ='BATCH' ,
processing_status_code = 'PENDING' ,
transaction_status_code = 'PENDING',
processing_request_id = NULL,
validation_flag = NULL
where rti.interface_transaction_id in (1606678,1606703,1606685,1606693,1606699);
.
Commit;

now pls run the receiving trannsaction processor and see if concurrent completed fine if no
then pls upload Log file of it



Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response



25-AUG-09 09:27:49 GMT

Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 09:42:09 GMT

New info : [e-mail]
hi:
Thank you for your help!
I will try in test system,but it need few days!



25-AUG-09 09:49:16 GMT

(Update for record id(s): 374021626)

UPDATE
======
Hi Mr,

Thanks wil wait for your reply

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response


Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 10:05:07 GMT

New info : [e-mail]
Must clone test environment from production？ Can i backup this table(rcv_transactions_interface) first and then perform
update action in production?


25-AUG-09 11:04:54 GMT

(Update for record id(s): 374021913)

UPDATE
======
Hi Mr,

yes Ok you can do that .

Thank You,
Zohar Tur
Global Customer Services

STATUS
======
@CUS - Waiting for customer response


Email Update button has been pressed: Sending email to [e-mail].


25-AUG-09 11:34:07 GMT

New info : [e-mail]
Ok，I will direct perform update action in production. i do not plan on clone ebs system.


25-AUG-09 11:47:47 GMT

(Update for record id(s): 374039120)

UPDATE
======
STATUS
======
@CUS - Waiting for customer response

update表后，运行receiving trannsaction processor问题解决。