My Oracle Support Banner

R12: AP: Querying Invoices Using Folder Errors with FRM-41051 and ORA-06512 at APPS.GL_CURRENCY_API and FRM-40735 WHEN-VALIDATE-ITEM (Doc ID 757322.1)

Last updated on MARCH 29, 2021

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



Join our growing Oracle Payables Community and learn from your peers and Oracle on how to address your unique issues in AP.

-- 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.




To view full details, 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 a vibrant support community of peers and Oracle experts.