Accrual Write Off Form Errors FRM-40735: ORA-01403 POST-QUERY TRIGGER RAISED UNHANDLED EXCEPTION ORA-01403 (Doc ID 1075219.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Purchasing - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle Cost Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

The Write Off form  ( CSTACRMI ) form produces error and no data when it should be returning information for write-off


Error:

ORA-01403: no data found
FRM-40735: Post-Query trigger raised unhandled exception ORA-01403


Replication Steps:
The issue can be reproduced at will with the following steps:
1. Purchasing Responsibility
2. Accrual Write-offs
3. Miscellaneous
4. Enter Operating Unit
5. Select find --> Error Appears


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