Getting Invalid BETC in Payables Open Interface Import While Creating A Refund In AR

(Doc ID 2041283.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.2.3 and later
Oracle U.S. Federal Financials - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

Why may the Payables Invoice Import Process fail with the error    INVALID_BETC for AR refund receipts related invoices?

The debug log may show something like:

 

fv.plsql.FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE. Start Validating   BETC
fv.plsql.FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE. BETC is null
fv.plsql.FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE. Get default BETC
fv.plsql.FV_GTAS_UTILITY_PVT.VALIDATE_AP_INV_INTERFACE. Begin
fv.plsql.FV_GTAS_UTILITY_PVT.GET_DEFAULT_BETC. Begin AP_GET_FUND_VALUE
AP_GET_FUND_VALUE. v_sob_id: 1
AP_GET_FUND_VALUE. l_coa_id: xxxxxx    pToken: .
AP_GET_FUND_VALUE. l_ccid  : xxxxxxxxx
AP_GET_FUND_VALUE. l_ccid_seg  :
AP_GET_FUND_VALUE. calling get_fund_value using ccid passed
AP_GET_FUND_VALUE. Begin
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. l_coa_id: xxxxx
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. l_bal_seg: SEGMENT1
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. before the select statement
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. p_ccid: xxxxxx
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. after the select statement
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. l_fund_val_select SELECT SEGMENT1 FROM gl_code_combinations WHERE code_combination_id = xxxxxx
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. p_fund_value: 00000000000000
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. End
fv.plsql.FV_GTAS_UTILITY_PVT.GET_FUND_VALUE. End
AP_GET_FUND_VALUE. l_fund_val: 00000000000000
fv.plsql.FV_GTAS_UTILITY_PVT.GET_DEFAULT_BETC. l_sob_id: 1
fv.plsql.FV_GTAS_UTILITY_PVT.GET_DEFAULT_BETC. p_def_betc:
fv.plsql.FV_GTAS_UTILITY_PVT.GET_DEFAULT_BETC. Error: Default BETC not found.
fv.plsql.FV_GTAS_UTILITY_PVT.GET_DEFAULT_BETC. End

Solution

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