My Oracle Support Banner

R12: AP: Error Applying 1099 Patch 32072819. Failed to find column 'SYS_NC00165$' in table 'AP_SUPPLIER_SITES_ALL' for index 'AP_SUPPLIER_SIT_IDX$$_EE550079' (Doc ID 2746844.1)

Last updated on FEBRUARY 02, 2021

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Error Applying 1099 Patch 32072819. Failed to find column 'SYS_NC00165$' in table 'AP_SUPPLIER_SITES_ALL' for index 'AP_SUPPLIER_SIT_IDX$$_EE550079'

Symptoms

Error applying patch 32072819

ATTENTION: All workers either have failed or are waiting:

  FAILED: file apssit.odf on worker 2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

-----------------------

Reading table AP_SUPPLIER_SITES_INT from AP schema ...
Reading table AP_SUPPLIER_SITES_ALL from AP schema ...

AD Worker - aduoixrc: ERROR: Failed to find column 'SYS_NC00165$' in table 'AP_SUPPLIER_SITES_ALL'
for index 'AP_SUPPLIER_SIT_IDX$$_EE550079'


AD Worker - aduotbri2: ERROR: Failed to read column for index 'AP_SUPPLIER_SIT_IDX$$_EE550079'
  in table 'AP_SUPPLIER_SITES_ALL' from RDBMS


AD Worker - aduobbrt2: ERROR: Failed to read index for table 'AP_SUPPLIER_SITES_ALL' from RDBMS


AD Worker - aduortrb2: ERROR: Failed to read table from RDBMS


AD Worker - aiccep: ERROR: Unable to read objects from RDBMS

Steps to Reproduce:

-------------------------

  1. Apply patch 32072819
  2. Database Table Column "SYS_NC00165$" is not found in the table AP_SUPPLIER_SITES_ALL
  3. Index AP_SUPPLIER_SIT_IDX$$_EE550079 is defined with column AP_SUPPLIER_SITES_ALL.SYS_NC00165$

Changes

 

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
Changes
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.