EGL9.2: When Running Journal Generator(FS_JGEN) With a Custom Accounting Entry Record Encountered "ORA-00936: missing expression" error at step FS_JGEN_JRNL.uDrill.uDrill (Doc ID 1957809.1)

Last updated on NOVEMBER 25, 2016

Applies to:

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

Symptoms

Issue:
-------

When attempting to run JGEN for custom accounting entry record encountered "ORA-00936: missing expression" error at step FS_JGEN_JRNL.uDrill.uDrill

 

Steps:
------

1. Setup Accounting Entry Definition using a custom record as accounting entry record & select the checkbox against 'Cross Product Drill down'
2. Set up Journal Generator Template to 'Retail Detail'
3. Run process to Generate journals from custom accounting entry record

Error
-----------------------

-- 12:16:07.150 ........................(FS_JGEN_JRNL.uDrill.uDrill) (SQL)
UPDATE PS_I2L_MP_ACCT1STG SET JOURNAL_ID = :1, JOURNAL_DATE =
TO_DATE(:2,'YYYY-MM-DD'), FISCAL_YEAR = :3, ACCOUNTING_PERIOD = :4,
GL_DISTRIB_STATUS = 'D', JOURNAL_LINE = :5 ,DTTM_STAMP=CAST(SYSTIMESTAMP AS
TIMESTAMP) WHERE
/
-- Bind variables:
-- 1) 0000173919
-- 2) 2016-10-31
-- 3) 2016
-- 4) 7
-- 5) 1
-- Row(s) affected: 0
-- 12:16:07.304 Process 2955903 ABENDED at Step FS_JGEN_JRNL.uDrill.uDrill (Action SQL) -- RC = 936
ROLLBACK
/
-- 12:16:07.517 SQL Error: ORA-00936: missing expression

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