EAR9.2: Automatic Maintenance Process Abended at Step AR_AUTOMNT.PREP.ITEMOPEN With An Error 'ORA-00936: missing expression' (Doc ID 2180114.1)

Last updated on NOVEMBER 28, 2016

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, Automatic Maintenance

When attempting to run the Automatic Maintenance process, the following error occurs.

ERROR
-----------------------

-- 02:48:48.031 Process 7735278 ABENDED at Step AR_AUTOMNT.PREP.ITEMOPEN (Action SQL) -- RC = 936
ROLLBACK
/
-- 02:48:48.107 SQL Error: ORA-00936: missing expression


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Setup Automatic Maintenance Method.
1. Navigate to Main Menu, Accounts Receivable, Receivables Maintenance, Automatic Maintenance, Request Automatic Maintenance.
2. Run AR_AUTOMNT process.

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