Publish Item Balance Updates Fails To Process Items With Transactions Updated In The Last X Hrs (Doc ID 1927020.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Application Integration Architecture Foundation Pack - Version 2.5 to 2.5 [Release 2]
Information in this document applies to any platform.

Symptoms

Running the Concurrent Program Publish Item Balance Updates for item Item1. The process successfully populated Agile with the Available, On Hand, and Quantity Reserved.

Output of the Concurrent Program:

Entering PublishService
Processing for LanguageCode=US
Calling PublishItemBalance.getItemBalanceList
*********************************Concurrent Program Input
Parameters*********************************
Parameter Name: Item Name
Parameter Value: Item1
Parameter Name: Organization Code
Parameter Value:
Parameter Name: From Date
Parameter Value:
Parameter Name: To Date
Parameter Value:
Parameter Name: Updated in the last X Hrs
Parameter Value:
******************************************************************************
***********************
Database SID: SIDNAME
Service endPoint
is:http://hostname:port/orabpel/default/UpdateItemBalanceListEbizReqABCS
Total Number of Batches: 1
******************************************************************************
****************
Processing Batch: 1
Items to be Updated in this Batch: Item1,V1;
Successful Update of Values
Successful Completion Of BPEL instance Id 270042
Concurrent Request Completed Successfully !!!

 

Now in Oracle E-Business Suite reduce the onhand quantity for Item1 and rerun the Concurrent Program Publish Item Balance Updates for item Item1 with parameter 'Updated in the last X Hrs' set to 1. The transaction was done within the hour, however the output of the Concurrent Program returns zero rows.

Output of the Concurrent Program:

Entering PublishService
Processing for LanguageCode=US
Calling PublishItemBalance.getItemBalanceList
*********************************Concurrent Program Input
Parameters*********************************
Parameter Name: Item Name
Parameter Value: Item1
Parameter Name: Organization Code
Parameter Value:
Parameter Name: From Date
Parameter Value:
Parameter Name: To Date
Parameter Value:
Parameter Name: Updated in the last X Hrs
Parameter Value: 1
******************************************************************************
***********************
No Items available to Process
Concurrent Request Completed Successfully !!!



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