GetReIMJournalsToOracle for BPEL Process Consideration Receipt Date with Date and Time Stamp (Doc ID 1919573.1)

Last updated on AUGUST 25, 2014

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 10.1.3.1 and later
Information in this document applies to any platform.

Goal

Using the GetReIMJournalsToOracle BPEL process and trying to retrieve the receipt date as data from the gl_interface table.  Normally the GetReIMJournalsToOracle ( v. 1.5 ) BPEL process can send REIM data to Oracle EBS. It Take data from REIM IM_FINANCIALS_STAGE table and then passes it to the Oracle EBS gl_interface table.

When checked, the REIM IM_FINANCIALS_STAGE table receipt_date has a date format with no time stamp but when data is moved to the EBS gl_interface table, the 
 receipt_date is formatted as a time stamp.


 

Solution

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