My Oracle Support Banner

"A SQL Error Encountered. Please consult your system log for details." Error on Accounting Tag Favorites List of Values or Prompt button in Fluid Requisition Checkout Distribution Page (Doc ID 2855396.1)

Last updated on MARCH 17, 2022

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

During checkout in fluid requisition distribution page, the accounting tags favorites raises a SQL error if you use the list of values or prompt button.

Steps to reproduce the issue:

1) Enable Accounting tags for eProcurement under Setup Financials/Supply Chain > Common Definitions > Design ChartFields > Accounting Tags > Tag Registration by Products
2) Navigate to Fluid eProcurement tile -Create Requisition tile
3) Create Requisition using a Favorites item
4) Go to checkout page and go to Distribution page
5) Click on Accounting Tag link
6) Click on Manage Favorites
7) click on filter icon in this page
8) Click on Accounting tag lookup prompt
9) Get SQL error below:

Error:





 

Cause

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
Symptoms
Cause
Solution
References


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