R12: AP: Querying Invoices Using Folder Errors with FRM-41051 and ORA-06512 at APPS.GL_CURRENCY_API and FRM-40735 WHEN-VALIDATE-ITEM
Last updated on APRIL 18, 2017
Applies to:Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
APXINWKB - Invoice Workbench
-- Problem Description
When using folders, invoice screen is throwing following error when opening in query mode (Invoice Inquiry Screen), also in case of batch control enabled and opening entry invoices screen.
FRM-41051 You Cannot Create Records Here
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.GL_CURRENCY_API", line 58
ORA-01403: no data found
ORA-06512: at "APPS.GL_CURRENCY_API", line 482
FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06510.
APP-SQLAP-10186: Please commit or clear your changes before continuing
-- Steps To Reproduce:
Payables > Invoices > Entry > Invoices
Setup folders for the Invoices Workbench
Navigate to: Invoices / Inquiry / Invoices
-- Business Impact:
Users cannot use folders to change the way the invoices are shown in the Invoices Workbench.
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