R12: EBTAX: Invoice Validation Ends in Error: ORA-20001, ORA-06503 PL/SQL: Function Returned Without Value

(Doc ID 2409181.1)

Last updated on JUNE 08, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Invoice validation ends in the following error

p_Operator_Code: BETWEEN, p_condition_value:, p_trx_value: E17.1646.000000.000.000.151220, p_value_low: E17.1646.000000.000.000.778083, p_value_high: E17.1646.ZZZZZZ.ZZZ.ZZZ.778083, p_det_factor_templ_code: ACCOUNTING_FLEXFIELD, p_chart_of_accounts_id:
-20001: ORA-20001: EXT.to_segmentarray. SQLERRM : ORA-20001: EXT.to_segmentarray. Invali
-6503: ORA-06503: PL/SQL: Function returned without value
condition is false
ZX_TDS_RULE_BASE_DETM_PVT: process_set_condition(-), p_return_status = U, p_error_buffer = -6503: ORA-06503: PL/SQL: Function returned without value
Incorrect return_status after calling process_set_condition() , p_return_status = U
alphanumeric_result:
ZX_TDS_RULE_BASE_DETM_PVT: process_rule_code(-)
Incorrect return_status after call process_rule_code() OR l_found is true., return_status: U
l_rec_rate_code :
l_rec_rate_id :
l_rec_rule_code : UPS HU RECOVERY RULES - E17
l_def_rec_rate_code :
l_def_rec_settlement_code : IMMEDIATE
l_def_rec_rate_code :
l_rec_rate_code = STANDARD-0
Tax accounts not defined for recovery rate id 36181
Reverse flag and freeze flag are not Y.
Recoverable flag is N
Account source tax rate id for non recoverable dist 19508
p_rec_nrec_dist_tbl(2).rec_nrec_rate = 100
ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate(-)
Incorrect return_status after calling ZX_TRD_INTERNAL_SERVICES_PVT.get_rec_rate()U
After calling calc_tax_dist x_return_status = U
ZX_TRD_SERVICES_PUB_PKG.DETERMINE_RECOVERY(-)
 RETURN_STATUS = U
ZX_API_PUB: DETERMINE_RECOVERY:ZX_SRVC_TYP_PKG.determine_recovery returned errors



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms