25 August 2010

RVTTH-010: Subroutine rvtthins() returned error

Goal
While making Receipt, Receiving Transaction Processor Landing into following error:-

RVTTH-010: Subroutine rvtthins() returned error

Cause: Subroutine rvtthins() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system administrator for assi
RVTTH-192.rvtthins: Subroutine ORA-20001: APP--20110: Encountered the error in trigger JAI_RCV_RT_BRIUD_T1ORA-20001: APP--20110:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.JAI_RCV_RT_BRIUD_T1", line 490
ORA-040 returne
Concurrent program RVCTP returned error

What is the cause and how to resolve the same?

Solution
The above error encountered becuase the PO against which the receipt is being created does not have the tax currency for the tax being used. In order to resolve the error please perform the following steps:-

1. Please copy and delete the existing tax applied.
2. Reapply the taxes ensuring that the tax currency is getting defaulted
3. Apply and Save
4. Retest the issue
5. Migrate the solution to appropriate environment

If the removal and deletion of taxes is not possible then please cancel this PO and create new PO.
Clear the Alert Log
cat alert_xxx.log|gzip -c >alert_xxx_`date +%m%d%Y`.gz;>alert_xxx.log

ORA-01654: unable to extend index PO.RCV_TRANSACTIONS_N15 by 16
>> in tablespace APPS_TS_TX_IDX returned error
alter tablespace APPS_TS_TX_IDX add datafile '/u01/ACETEST/db/apps_st/data/IDX100.dbf' size 1G autoextend on;

2 comments:

Upendra Vishwakarma said...

Hi ,
I have same issue when making a mrn and i checked in tax there is tax currency available. then why this error coming..

Please resolve this issue

Upendra Vishwakarma said...
This comment has been removed by the author.