R12.1.3 :Unable to submit XML Report Publisher Program
Step1. We ran one of our FSG with output set to XML.
Step 2:We tried to submit XML Report Publisher program. It allowed to pass all the parameter values except for the "Output Format Parameter"
Parameter Template passed was :FSG: Basic Excel Drilldown Template
Error thrown for "Output Format" is as below:
No entries found for List of Values
--------------------------------------------------------------
APP-FND-01436: List of Values cannot find any values for you to choose
Cause: The List of Values execution failed to find any values.
Cause: The SQL statement specified to fdlfch() failed to return any values.
Action: Check the message stack for any SQL statement failure messages. Check to make sure your SQL statement works in SQL*Plus. (ROUTINE=fdlfch)