My Oracle Support Banner

SFO Order Import Fails To Create SFO Order ORA-01403: no data found code UNEX_EXEC_IMPRT_UDA_FUNC (Doc ID 2981658.1)

Last updated on OCTOBER 18, 2023

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When attempting to pull SFO order, Intragovernmental Orders Interface Program finishes without errors however order is not pulled.

PO_INTERFACE_ERRORS table shows the following error record:

  ACTION                                  NEW
  AGENCY                                 REQUESTING_AGENCY
  AGENCY_LOCATION_CODE     17010023
  ASSISTED_ACQUISITION_IND N
  CLM_AWARD_TYPE                AWARD
  CURRENCY_CODE                  USD
  DOCUMENT_SUBTYPE            STANDARD
  DOCUMENT_TYPE_CODE        PO
  ERROR_MESSAGE                  User-Defined Exception Error occurred while importing UDA.
  IGT_BUSINESS_TXN_ID         0877b38f-019f-40bc-bd6c-450b75295729
  IGT_DOCUMENT_ID               O2309-018-018-136633
  IGT_DOCUMENT_NUMBER     O2309-018-018-136633.0
  IGT_GTNC_NUMBER              A2309-018-018-031337.0
  IGT_REQUEST_MODE            PULL
  IGT_REQUEST_TYPE              GET_ORDER_BY_ID
  IGT_STATUS                          SP2_SFO
  INTERFACE_SOURCE_CODE   PO
  INTERFACE_TYPE                   IGTORD_CREATE_INTERFACE
  ORDER_ORIGINATING_IND    S
  PROCESS_CODE                   NEW
  REQUEST_STATUS                ERROR
  RESPONSE_CODE                200
  RESPONSE_XML                  (BLOB)
  TABLE_NAME                       IGT_DOCUMENT_REQUESTS


FND debug log shows the following errors:

  ORA-01403: no data found in Package po.plsql.PO_PDOI_ERR_UTL. Procedure add_error.0;SQLERRM = ORA-01403: no data found
  IN HANDLE ERROR : Exception in add_to_error_table with ERROR : ORA-01403: no data found code UNEX_EXEC_IMPRT_UDA_FUNC for attr grp id
  x_return_status after import udas : E
  After import uda attrs E
  PO_IGTORD_POSTPROC.process: Inside l_import_uda_exception
  Start of subprogram.
  User-Defined Exception Error occurred while importing UDA.
  End of subprogram.
  ...
  Start of subprogram.
  User-Defined Exception Error encountered while autocreating IGT Order or Modification.
  End of subprogram.
  ...
  ;SQLERRM = User-Defined Exception
  ;SQLERRM = User-Defined Exception
  After create_igt_order call x_document_id=>
  Error occured while creating IGT order for igt_request_id => 13845
  User-Defined Exception Error occurred while importing UDA.
  User-Defined Exception Error encountered while autocreating IGT Order or Modification.


Issue occurs even after recompiling the UDA Templates and applying Patches 35231635:R12.PO.D and 35319927:R12.PO.D.


Steps to reproduce:
  1. Navigate to Purchasing responsibility -> Requests.
  2. Submit Intragovernmental Orders Interface Program with the following parameters:
       AGENCY_TYPE value: REQUESTING_AGENCY
       REQUEST_MODE value: PULL
       REQUEST_TYPE value: GET_ORDER_BY_ID
       ORG_ID value: 127
       AGENCY_LOCATION_CODE value: 17010023
       DOCUMENT_NUMBER value: O2309-018-018-136633
 3. Request completes normally. PO_INTERFACE_ERRORS table shows "User-Defined Exception Error occurred while importing UDA" error

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


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