EAP: Period End Accruals Process FS_PEACCRL Abends at Step AP_PEACCRL.A0002.STEP01 With ORA-00911 Error.
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.
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'.
SQL Error: ORA-00911: invalid character
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms