out with error numbers RVTTH-445, RVTBM-008 & RVTBM-120
Description:
receipts against the Purchase Orders, the Receiving Transaction Processor will end-up
in error with the error numbers RVTTH-445, RVTBM-008 & RVTBM-120.
Message:
Subroutine returned error
you are trying to perform. Contact your system administrator for assistance.
error
error. Parameters:
RVCTP,IMMEDIATE,417042,
actions you are trying to perform. Contact your system ad
Subroutine rvtbm_immediate_mngr() returned error
returned an internal error.
you are trying to perform. Contact your syste
Subroutine rvtptcontrol() returned error
internal error.
you are trying to perform. Contact your system administrator
error while attempting to start your immediate concurrent program RVCTP.
Routine &ROUTINE received a return code of failure.
representative.
To Reproduce:
- ·
Navigation:
Receiving > Receipts - ·
Query the PO
by entering the PO Number that you would like to perform Receipts - ·
Select the
Checkbox and enter the Sub-Inventory - ·
Save. - ·
Check the
“Receiving Transaction Processor” status by navigating View > Requests from Tools Menu. - ·
“Receiving Transaction Processor”
request will be in Error status. - ·
Check the
Log File by clicking “Log File“ - ·
You will
find the above error message.
Processor errors out with the combination of all the above three error messages
then you can check the UOM code in PO_LINES_ALL and PO_LINE_LOCATIONS_ALL
tables for that problematic Purchase Order.
table, use the below SQL query.
pha.po_header_id, pha.org_id
pla.line_num, pla.po_line_id, pla.UNIT_MEAS_LOOKUP_CODE
pll.shipment_num, pll.line_location_id, pll.UNIT_MEAS_LOOKUP_CODE
po_lines_all pla
po_line_locations_all pll
pla.po_line_id
pha.po_header_id
NUMBER>;
code is same “Each” in PO Lines and Shipments regions for that PO.
PO_LINES_ALL and PO_LINE_LOCATIONS_ALL tables then apply the below DATAFIX
script in test environment and test the solution.
problematic Purchase Order.
1. Create backup table:
create table po_line_locations_all_bak
as select *
from po_line_locations_all where line_location_id= 1412290
and po_header_id=1103297;
2. Run the following script in a TEST environment:
Update po_line_locations_all
set UNIT_MEAS_LOOKUP_CODE = ‘Each’
where line_location_id= 1412290
and po_header_id=1103297;
3. Once the script completes, confirm that the data is corrected.
You can use the following SQL to confirm:
select UNIT_MEAS_LOOKUP_CODE
from po_line_locations_all
where line_location_id= 1412290
and po_header_id=1103297;
The value returned must be the same as the UNIT_MEAS_LOOKUP_CODE
value from po_line_locations_all table.
Conclusion:
Once it’s performed, try to perform the Receipts. Now, system will
allow you to take a receipts.
