Bug 1931470: RCVTXERE ERROR ON RECEIVING RMA RETURNS APP-PO-14142
________________________________________
Bug Attributes
________________________________________
Type
B - Defect
Fixed in Product Version
11.5.8
Severity
2 - Severe Loss of Service
Product Version
11.5.4
Status
81 - Q/A to Dev/Patch or Workaround Avble
Platform
453 - Oracle Solaris on SPARC (32-bit)
Created
10-Aug-2001
Platform Version
-
Updated
05-Jul-2005
Base Bug
-
Database Version
8.1.7.1
Affects Platforms
Generic
Product Source
Oracle
Related Products
________________________________________
Line
Oracle E-Business Suite
Family
Logistics
Area
Logistics
Product
508 - Oracle Inventory Management
Hdr: 1931470 8.1.7.1 RECEIVING 11.5.4 RMA PRODID-508 PORTID-453
Abstract: RCVTXERE ERROR ON RECEIVING RMA RETURNSAPP-PO-14142
*** 08/10/01 11:10 am ***
Client is trying to complete a Receiving Return.Enter quantity and a 'Return
To' value of Customer.When save, the following message is displayed:
APP-PO-14142: rcv_transactions_1.event-000: ora-6502: PL/SQL: numeric or
value error
Cause: A SQL error has occurred in rcv_transactions_1.event.The SQL error is
&LSQL_ERR.
*** 08/10/01 11:12 am *** (CHG: Sta->16)
*** 08/14/01 07:52 am ***
*** 08/14/01 07:52 am *** (CHG: Sta->11)
*** 08/14/01 09:50 am ***
*** 08/14/01 11:59 am *** (CHG: Sta->30)
*** 08/14/01 11:59 am ***
Please provide a database trace file for this transction.
*** 08/22/01 01:24 pm *** (CHG: Sta->11)
*** 08/22/01 01:24 pm ***
*** 08/23/01 09:30 am *** (CHG: Sta->30)
*** 08/23/01 09:30 am ***
Can you get me a forms trace instead? Also get the versions of the foll
files
RCVRCERL.pll
RCVCOTRX.pll
RCVRCERC.fmb
RCVRCPQB.pls
Please ask them to check whether the plx have been generated successfully and
whether any view or procedure is invalid.
*** 08/23/01 10:17 am ***
*** 08/23/01 01:25 pm *** (CHG: Sta->11)
*** 08/23/01 01:25 pm ***
Here are the file versions:
RCVRCERL.pll - 115.70
RCVCOTRX.pll - 115.82
RCVRCERC.fmb - 115.62
RCVRCPQB.pls - 115.11
Client did not see any invalid views or procedures.
*** 08/23/01 03:56 pm *** (CHG: Sta->30)
*** 08/23/01 03:56 pm ***
*** 08/31/01 02:34 pm *** (CHG: Sta->33)
*** 08/31/01 02:34 pm ***
*** 09/10/01 02:24 pm *** (CHG: Sta->92)
*** 09/10/01 02:24 pm ***
*** 09/12/01 09:39 am *** (CHG: Sta->30)
*** 09/12/01 09:39 am ***
*** 09/13/01 11:14 am ***
*** 09/13/01 11:14 am *** (CHG: Sta->11)
*** 09/17/01 10:20 am *** (CHG: Sta->30)
*** 09/17/01 10:20 am ***
Dial-in will not help. Can they get us forms trace? That would be definitely
helpful. Last time, they had given us a wrong trace. Please make sure
that you get the correct one. Did they apply any new patch from PO
for them to get this version of the return forms?
*** 09/17/01 02:20 pm ***
*** 09/17/01 02:20 pm *** (CHG: Sta->11)
*** 09/18/01 03:46 pm *** (CHG: Sta->30)
*** 09/18/01 03:46 pm ***
Ask the client to do the foll.
SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
FROM
SYS.DUAL
Also i have put the file RCVTXERE.pll in ess30 with some debug statements.
Ask them to generate RCVTXERE.plx , backup the original plx and use this
instead. Get the statements that they get on the screen before they
get the error.
*** 09/24/01 07:01 pm *** (CHG: Sta->11)
*** 09/24/01 07:01 pm ***
Hi,
My customer in Taiwan is also experiencing the same problem. The customer is
on 11.5.2. They have also realised that they do not hit this error if thet
reduce the size of the customer name to 30 characters. But their problem is
that all their customers have really long names and this is definitely
becoming an issue for them.
Setting this to status 11 to catch your attention.
Please help.
Thanks
Uma.
*** 09/25/01 09:45 am ***
Thanks for the info. I had put debug statements to make sure that it
failed before it inserted into rti. But you have given the actual column
which gives the problem. Madhu, can you confirm from your customer whether
they have their rcv_transaction.customer greater than 30? Thanks.
Uma will your customer want a one-off. Since this will be a very small
fix (change l_customer varchar2(30) to varchar(50)), can you find out
whether they will accept an on-site fix. If so, then i will update the bug
as to how to do it. Thanks.
*** 09/25/01 09:57 am *** (CHG: Sta->37)
*** 09/25/01 09:57 am ***
Developer info:
Steps to reproduce: Create an RMA for a customer whose name is greater than
30 chars, receive and return it. When saving the return transaction, will
get the error
Technical Analysis and resolution: In the procedure INSERT_INTERFACE_CODE,
the variable l_customer is defined as varchar2(30). This should be 50.
Changed the size.
Files fixed: RCVTXERE.pld 115.31
Aru'chkined.
**************************************************************************
This fix is a very small fix, one-off will be very difficult, since this
will be on top of the opm pre-requisite which has 800 files. So an one-off
for this will be unnecessary. The change will be as follows
Open the library RCVTXERE.pll. In the procedire INSERT_INTERFACE_CODE,
you will find
l_customer
VARCHAR2(30):= name_in('RCV_TRANSACTION.CUSTOMER');
Here 30 should be changed to 50.
Generate RCVTXERE.plx and then copy it to the correct place for the
apps to pick it up.
*** 01/31/02 04:15 pm ***
*** 08/15/02 05:34 pm ***
*** 12/16/02 05:28 pm ***
*** 12/16/02 05:32 pm *** (CHG: Sta->81)
*** 12/16/02 05:32 pm ***
*** 06/11/03 01:01 pm ***
*** 09/17/04 05:16 pm ***
*** 07/05/05 12:51 pm ***
按这个做了现在能做return to customer了，但订单行状态还是awaiting_return
|
