"Retrieve Time from OTL" Errors With PO-120- Calculate the RTI values (Doc ID 1940524.1)

Last updated on MARCH 03, 2020

Applies to:

Symptoms

On : 12.2.3 version, Receiving Functions

When attempting to run RCVOTLR module: Retrieve Time from OTL, report runs into the following error:

ERROR
-----------------------
Creating new RTI rows
after po_line_id 13268**po_header_id 10080**line_num 22**unit_price 104**matching_basis AMOUNT**purchase_basis TEMP LABOR**order_type_lookup_code RATE**start_date 04-FEB-14**expiration_date 30-MAR-14**job_id 1172**line_location_id 8285**approved_flag Y**cancel_flag N**closed_code CLOSED FOR INVOICE**qty_rcv_exception_code NONE**tolerable_amount 765211.2**timecard_amount 0**ship_to_organization_id 83**ship_to_location_id 142
Initialized transaction_date=26-AUG-14
Set receive_rti_id=382975, deliver_rti_id=382976
End Derive_Correction_Values
End Derive_New_Block_Values
Done deriving ROI values. Calling iSP to store timecard detail information...
Finding ROI rows: p_rhi_rows.COUNT=0 p_rti_rows.COUNT=2 p_attributes.po_distribution_id=
rti_idx=
Exception trying to call iSP store_timecard_details: x_return_status=, x_msg_data=, sqlerrm=ORA-06502: PL/SQL: numeric or value error: NULL index table key value
PO-120- Calculate the RTI values - StartUnexpected exception while processing results from Generic Retrieval: User-Defined Exception

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.