My Oracle Support Banner

E1: ORCH: Orchestration Return DateTime null Value As Double Quote Character "null" (Doc ID 2898003.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Orchestration returns DateTime null Value As Double Quote Character "null"

Steps to replicate:

  1. create an orchestration with Data Request on F0101 table
  2. select at least one datetime filed as output like User Date
  3. execute the orchestration filtering by an existing Address Number
  4. Output:
    "F0101": {
       "tableId": "F0101",
       "rowset": [
         {
           "Address Number": "321",
           "User Date": "null",
           "Date Updated": "2008-01-30",
           "Work Stn ID": "OWNTS1",
           "Time Updated": 134736
         }

Changes

 Upgrade Tools Release to 9.2.4.

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