Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with Configuring LOV Source for Validation Status in Scheduled Process - JBO-27120 Error

Received Response
3
Views
1
Comments
Ishita
Ishita Rank 0 - Community Observer
in Oracle Transactional Business Intelligence Forum

I'm encountering difficulties while configuring a List of Values (LOV) source for the 'Validation Status' parameter in a scheduled process within Oracle Fusion Payables. Despite following the guidelines provided in Oracle documentation and trying various SQL query formats, I am consistently receiving a 'JBO-27120' error message.

ORIGINAL SQL QUERY IN BIP REPORT FOR VALDATION STATUS:

SELECT 'APPROVED' VALIDATION_STATUS

FROM DUAL

UNION

SELECT 'NEVER APPROVED' VALIDATION_STATUS

FROM DUAL

UNION

SELECT 'NEEDS REAPPROVAL' VALIDATION_STATUS

FROM DUAL

Answers