G-Invoicing - Incremental Data Load Is Erroring Out unknown field 'SFO_GTC' (Doc ID 2905641.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Symptoms

Using Purchasing, Version 12.2

Actual:
Pulling Orders for G-Invoicing - causes incremental load to fail.

Expected:
The incremental load should not fail.

Errors:
and nvl(agr.advance_required, 'N') = 'Y' and pd.performance_type = '548' and upper(pd.perf_process_status) in ('SUBMITTED', 'SUCCESS', 'RECEIPT FAILED', 'RECEIPT SUCCESS')
then nvl(pd.transfer_amt,0) else 0 end) over (partition by o.order_id) ADV_PERF_SUBMITTED_ORD,sum(case when agr.status = 'A' and agr.current_flag = 'Y' and nvl(agr.advance_required, 'N') = 'Y' and pd.performance_type = '548'
and upper(pd.perf_process_status) in ('SUBMITTED', 'SUCCESS', 'RECEIPT FAILED', 'RECEIPT SUCCESS') then
....
....
....
= to_timestamp ( '03-AUG-22 09.37.14.000000 AM' )) or (ph_last_update_date >= to_timestamp ( '03-AUG-22 09.37.14.000000 AM' ))
or (pd_last_update_date >= to_timestamp ( '03-AUG-22 09.37.14.000000 AM' )) or (pe_last_update_date >= to_timestamp ( '03-AUG-22 09.37.14.000000 AM'))

  startTime: Thu Aug 11 09:02:53 EDT 2022
  endTime: Thu Aug 11 09:02:58 EDT 2022
  status: FAILURE
  sql time: 0:0:0
  total elapsed time: 0:0:5
  statusMessage: There are 0 documents processed successfully and 112 documents failed to be processed.


 JOB Details:
 Please check the output Log of Concurrent program for error details
 Error Details:
10:02:58.291 [pool-48-thread-2] ERROR 2.o.e.i.u.services.impl.IndexerImpl - Unrecoverable error. Skipping the whole batch here for collection IGT_ORDER
org.apache.solr.client.solrj.impl.HttpSolrClient$RemoteSolrException: Error from server at http://nbsveccpjd3ap01.cit.nih.gov:7776/core_ecc/IGT_ORDER: ERROR: [doc=A2208-075-075-015628~~~~0] unknown field 'SFO_GTC'
...
...
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604) ~[na:1.8.0_321]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_321]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_321]

Replication Steps:
The issue can be reproduced at will with the following steps:
1. G-Invoicing orders are created.
2. Incremental load is submitted, and error occurs.
3. It fails on the incremental load
4. The full load is then submitted and it does complete without error
    - also all incremental loads after the full load now are no longer having errors

Changes

Cause

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