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

Symptoms

 

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.

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