My Oracle Support Banner

Request To Trigger E1 UBE Exports And Imports Using Batch Scripts (Doc ID 2490147.1)

Last updated on FEBRUARY 23, 2021

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.6 and later
Information in this document applies to any platform.

Goal

On : 11.6 version, PIP Setup in All instances:

Users are checking on enhancement request Bug 23074204 - ENHANCEMENT REQUEST TO TRIGGER E1 UBE EXPORTS AND IMPORTS USING BATCH SCRIPTS FR - They want to know when it will be implemented

ER details

This enhancement requests for a standard integration package to synchronize E1 UBE inbound and outbound with ODI Collections in such a way that one follows the other automatically.

Existing documentation on this:
-------------------------------
Oracle Value Chain Planning Integration Base Implementation Guide, Chapter 7: Configuring JD Edwards EnterpriseOne UBEs, Section: Creating Runubexml Template Files" , "You can optionally trigger UBE exports and imports using batch scripts. To run outbound inbound processors from a batch script, you must create
runubexml files that are used with the runubexml command.  A runubexml template file must be created for each processor version for the Demantra integration. UBE launch scripts call XML files to launch appropriate processor version."

Chapter 5: Alternate Integration Scenarios
Section:  Combining Extracts and Collections Across Systems
There are two ways that user extension can be used to perform the extraction and collection processes with a single action. For JDE E1 users only: On the JDE E1 server, all JDE E1 UBEs support pre-process and post-process command scripts. In this case, the UBE post process script can be used to activate the collection process on the EBS
server
On the VCP Server, all-concurrent processes support pre-process and post-process ODI packages and SQL hooks. In this case, the pre-process can be used to call a runubexml extract script on the JDE E1 server.
Example: Using a JDE E1 Script to Call VCP Collections
As an example, consider the main JDE E1 extract and Legacy Planning Load. You could trigger the combined process from JD E1 by following these steps:

1. Create a remote script on the JDE E1 server that calls the VCP Base Pack
Integration collections process on the VCP server.

2. Call the script created above from the UBE post-process option. 60 Oracle Value Chain Planning Integration Base Pack Implementation Guide In this setup, every time you trigger the JDE E1 extract, the VCP Base Pack Integration collections process is automatically triggered when the extract finishes.
Example: Using a VCP Script to Call JDE E1 Extracts
You could also trigger the combined process from VCP JDE E1 Collections Menu by following these steps:

1. Create a RUNUBEXML batch script to run the planning extracts on the JDE E1 server.

2. On the VCP server, create a script to call the JDE E1 RUNUBEXML script remotely.

3. Incorporate this script into the ODI pre-process script. In this case, triggering the collections load from within the VCP Base Pack Integration menu. Before running the collections process, the extracts on the JDE E1 server trigger automatically.
 

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.