Unaccounted Transaction Sweep Program (ARTRXSWP) ends with ORA-00933
(Doc ID 2593630.1)
Last updated on MARCH 01, 2021
Applies to:Oracle Receivables - Version 12.2.7 and later
Information in this document applies to any platform.
Unaccounted Transaction Sweep Program (ARTRXSWP) ends with ORA-00933 after upgrade to 12.2.7. ARTRXSWP Unaccounted Transaction Sweep Log shows error:
Calling XDO Data Engine...
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Steps to Reproduce:
Navigation: Control > Accounting > Open/Close Periods > Manage Exception
The issue can be reproduced at will with the following steps:
- Control > Accounting > Open/Close Periods
- Attempt to close period
- Click on Manage Exceptions
- Program completes successfully but period is not Closed
- Review Request "Unaccounted Transaction Sweep Program"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document