My Oracle Support Banner

ELM 9.2: Message JOURNAL_GEN_APPLID_ID_FULLSYNC Inserts One Row with Blanks and NULL Values with Error Message: No Transformation found in IA Transformation Schema 0000, message JOURNAL_GEN_APPL_ID_FULLSYNC (18137,202) (Doc ID 2870996.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Full Data Publish runs for JOURNAL_GEN_APPLID_ID_FULLSYNC in Financials (FMS), in the ELM application, the message inserts one row with blanks and NULL values in  table LM_JRNLGEN_TMPL and receives an error message in Asynchronous Service Monitor.
 



Steps to Replicate Issue:

Pre-requisites:
Ensure Financials (FMS) service operation JOURNAL_GEN_APPL_ID_FULLSYNC.VERSION_1 is integrated with ELM service operation JOURNAL_GEN_APPL_ID_FULLSYNC.VERSION_1

Steps
1. In Financials (FMS), run Run Full Data Publish Process to generate
  messages JOURNAL_GEN_APPL_ID_FULLSYNC to ELM.

  Navigation:  Enterprise Components >Integration Definitions > Initiate Processes


2. In ELM, navigate to the Peopletools > Integration Broker > Service Operation Monitor > Asynchronous Service Monitor, and notice that message JOURNAL_GEN_APPL_ID_FULLSYNC is in Error status.



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