My Oracle Support Banner

'Process Supply Chain Orchestration Interface' ESS Job is not processing records (Doc ID 2154596.1)

Last updated on SEPTEMBER 27, 2019

Applies to:

Oracle Fusion Supply Chain Financial Orchestration Foundation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Some items are not generating entry in SCO interface tables.  Few of the records present in SCO interface table are not getting picked up by 'Process Supply Chain Orchestration Interface' ESS Job


When select all the supply orders which are in error and CLICK RE-SUBMIT.  Some have no errors.

Interface tables:

select * from fusion.dos_supply_HEADERs_int where interface_batch_number
like 'MINMAX%' order by creation_date desc;

select * from fusion.dos_supply_lineS_int where interface_batch_number like
'MINMAX%' order by creation_date desc;
 

Solution

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