EAP: "Ora-00933: SQL Command Not Properly Ended" Error With APBRL001 Report (Doc ID 2149947.1)

Last updated on AUGUST 03, 2016

Applies to:

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

Symptoms

SQL error occurs while running the SQR report APBRL001

Steps:
--------
  1: Navigate:
        Statutory Reports --> Account Payable --> Auxiliary Daily
  2: Select the parameters on Run Control page
  3: Run the report

  
  
Error:
-------
 PROCESS-JOURNALS-PO
(SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 25:
  ORA-00933: SQL command not properly ended
SQL: SELECT TMP.BUSINESS_UNIT, TMP.DESCR, TMP.ACCOUNTING_PERIOD, TMP.ACCOUNT,
  TMP.DEPTID, TMP.PRODUCT, TMP.PROJECT_ID, TMP.OPERATING_UNIT,
  TMP.FUND_CODE, TMP.PROGRAM_CODE, TMP.CLASS_FLD, TMP.BUDGET_REF,
  TMP.PRODUCT, TMP.AFFILIATE, TMP.AFFILIATE_INTRA1, TMP.AFFILIATE_INTRA2,
  TMP.CHARTFIELD3, TMP.CHARTFIELD1, TMP.CHARTFIELD2, 'No', 'No', 'No',
  'No', 'No', 'No', TMP.DOCUMENT, TMP.ACCOUNTING_DT, TMP.MONETARY_AMOUNT,
  TMP.HIST_PART_BRL_1, TMP.HIST_PART_BRL_2, TMP.HIST_PART_BRL_3,
  TMP.HIST_PART_BRL_4 FROM PS_AP_DIA_BRL_TMP TMP WHERE OPRID = :1
  AND RUN_CNTL_ID = :2 ORDER BY TMP.BUSINESS_UNIT, TMP.ACCOUNTING_PERIOD,
  TMP.ACCOUNT, TMP.DEPTID, TMP.PROJECT_ID
  TMP.ACCOUNTING_DT, TMP.DOCUMENT, TMP.MONETARY_AMOUNT

Error on line 2400:
  (SQR 3722) Could not set up cursor.

Replication Steps

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