EAP: Period End Accruals Process FS_PEACCRL Abends at Step AP_PEACCRL.A0002.STEP01 With ORA-00911 Error. (Doc ID 2053576.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

Period End Accrual Process abends at step AP_PEACCRL.A0002.STEP01 with the following error when configured to exclude Balance Sheet Accounts using 'Chartfiled Value Sets'.

Error
---------
SQL Error: ORA-00911: invalid character

Steps
--------
 1. Navigate to Setup Financials/Supply Chain > Business Unit Related > Procurement > Procurement Control and select 'Accrue Unprocessed Vouchers at Period End' option.
 2. Navigate to Setup Financials/Supply Chain > Product Related > Procurement Options > Voucher > Period End Accrual Options and add ChartField Value Sets under Excluded Accounts tab.
 3. Create a Voucher.
 4. Navigate  to Accounts Payables > Batch Processes >Vouchers > Period End Accrual >Create Period End Accruals and run the process.
 
What is Working
-------------------
The Process does not fail when Balance Sheet Accounts are excluded individually.

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