My Oracle Support Banner

Receipt Workbench Giving Error ORA-28112 and ORA-06512 When Trying To Go To Last Record By Clicking "Continue to End" Button (Doc ID 2727604.1)

Last updated on NOVEMBER 11, 2020

Applies to:

Oracle Receivables - Version 12.2.9 and later
Information in this document applies to any platform.


When user tries to go to the last record in the receipts summary screen, the following error occurs:

ORA-28112: failed to execute policy function
ORA_06512: at "APPS.ARP_PROCESS_RCTS", line 723
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-00604

Steps to Reproduce:

Responsibility: Receivables Manager
: Receipts > Receipts Summary

  1. Click on Find icon
  2. Enter Receipt Numbers From 1 To 1 (All receipts with receipt_number = 1)
  3. Click Find button
  4. Get the results and select menu option: View > record > Last
  5. Get the message: 100 more records have been retrieved, and an unknown number of additional records remain
  6. Click button: Continue to End




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.