My Oracle Support Banner

EAR 9.2 - AppEngine ARX32A01 Failing Because Of Invalid column name 'SYSDATE' (Doc ID 2426170.1)

Last updated on JULY 23, 2018

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Statements

When attempting to run AR Statements
the following error occurs.

ERROR
-----------------------
SQL error. Function: SQLExec
  Error Position: 0
  Return: 8010 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SYSDATE'.

SQL error in Exec. (2,280) ARX32A01.MAIN.GBL.default.1900-01-01.Step02.OnExecute PCPC:1743 Statement:9
Process 150792 ABENDED at Step ARX32A01.MAIN.Step02 (PeopleCode) -- RC = 24 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 11.33.19 2018-04-17


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Accounts Receivable > Customer Interactions > Statements > Create Customer Statements
2. Run the report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run AR statement.

Changes

Application engine people code have been modified to avoid the cross platform issue.

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.