APXVDVSR Suppliers Report Getting ORA-01403 C_iby_infoformula, ORA-01422 IBY_DISBURSE_SUBMIT_PUB_PKG (Doc ID 2097063.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

Run APXVDVSR module: Suppliers Report, it fails on:

MSG-00000: B9395838 Beginning suppliers report...
MSG-01005: get_company_name 005
MSG-01010: get_company_name 010
MSG-10015: get_company_name 015
MSG-01020: get_company_name 020
MSG-01025: get_company_name 025
MSG-00002: After Get_Company_Name
MSG-00050: Value for nls_end_of_report :||:c_nls_end_of_report
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00004: After Giving messages
MSG-00010: Getting supplier information, order by name...
REP-1401: 'c_iby_infoformula': Fatal PL/SQL error occurred.
ORA-01403: no data found
ORA-06512: at "APPS.AP_INVOICES_PKG", line 3131

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-01005: get_company_name 005
MSG-01010: get_company_name 010
MSG-10015: get_company_name 015
MSG-01020: get_company_name 020
MSG-01025: get_company_name 025
MSG-00002: After Get_Company_Name
MSG-00050: Value for nls_end_of_report :||:c_nls_end_of_report
MSG-00003: After Get_NLS_Strings
MSG-00004: After Get_Base_Curr_Data
MSG-00004: After Giving messages
MSG-00010: Getting supplier information, order by name..
...

IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:Fatal: Exception when attempting to perform exact match for given payee context.6
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL code: -14226
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:SQL err msg: ORA-01422: exact fetch returns more than requested number of rows6
IBY_DISBURSE_SUBMIT_PUB_PKG.deriveExactPayeeIdFromContext:EXIT

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