WS: 74: SQL Errors, Double Quotes and Passing From and To Dates (P74R0921) (Doc ID 2280609.1)

Last updated on JUNE 26, 2017

Applies to:

JD Edwards World General Ledger - Version A9.4 and later
Information in this document applies to any platform.

Symptoms

During the execution of program P74R0921 - Statutory Account Summary Report, two SQL issues are encountered:

  1. An SQL condition populates double quotes instead of single quotes
  2. The From and To dates passed to an SQL statement are incorrect

 

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