EGL: Journal Workflow Routing Based On Journal Date (Doc ID 2200958.1)

Last updated on MARCH 08, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Journal Entry

Date format journal workflow

User is configuring out journal workflow to route based on journal date. They receive errors and I believe the issue is the date format I'm using in the configuration. What is the correct date format to use?

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details.

From app server:
msg=ORA-00932: inconsistent datatypes: expected DATE got NUMBER




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

  1.  Setup Process definition Main Menu > Enterprise Components > Approvals > Approvals > Approval Process Setup
  2.  Click Criteria Definition, Criteria Type: User Entered
  3.  Select Record = JRNL_HEADER and Field Name = JOURNAL_DATE
  4.  Criteria Operator = Equals and Value = 2016-08-31 (or any date)
  5.  Create Journal (General Ledger > Journals > Journal Entry > Create/Update Journal Entries)
  6.  Edit Journal
  7.  Click Approval Tab and Click Submit
  8.  Error "A fatal PeopleCode SQL error occurred. Please consult your system log for details"



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