BI Publisher Transaction Audit Report (EOAW_AUDIT) abends at Step EOAW_AUDIT.MAIN.Step01 with ORA-00936: missing expression (Doc ID 1959957.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When running the BI Publisher Transaction Audit Report (EOAW_AUDIT), the provess abends at Step EOAW_AUDIT.MAIN.Step01 with an error.

ERROR
SQL error. Function: CreateSQL
 Error Position: 160
 Return: 936 - ORA-00936: missing expression
 Statement: select a.eoawparent_thread,a.eoawprcs_id, min(b.dttm_created) from ps_pv_req_aw a,ps_eoaw_step_vw b where a.eoawthread_id = b.eoawthread_id and a.eoawdefn_id = SHARE GROUP BY A.EOAWPARENT_THREAD,A.EOAWPRCS_ID HAVING MIN(B.DTTM_CREATED) BETWEEN TO_TIMESTAMP(:1,'YYYY-MM-DD-HH24.MI.SS.FF') AND TO_TIMESTAMP(:2,'YYYY-MM-DD-HH24.MI.SS.FF')
 Original Statement: select A.EOAWPARENT_THREAD,A.EOAWPRCS_ID, MIN(B.DTTM_CREATED) from %Table(:1) A,PS_EOAW_STEP_VW B WHERE A.EOAWTHREAD_ID = B.EOAWTHREAD_ID and A.EOAWDEFN_ID = SHARE GROUP BY A.EOAWPARENT_THREAD,A.EOAWPRCS_ID HAVING MIN(B.DTTM_CREATED) BETWEEN %DateTimeIn(:2) AND %DateTimeIn(:3)

SQL error in Exec. (2,280) EOAW_AUDIT.MAIN.GBL.default.1900-01-01.Step01.OnExecute PCPC:5215 Statement:100

Process 1731100 ABENDED at Step EOAW_AUDIT.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
1. Navigate to Main Menu > Enterprise Components > Approvals > Approvals > Transaction Audit Report
2. Run the report
3. Process ends to ‘No Success’

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