Iterative Periodic Average Processor Parameter "Run Option" No LOV CST_PAC_PROCESS_PHASES (Doc ID 2906410.1)

Last updated on MARCH 27, 2024

Applies to:

Symptoms

On : 12.2.4 version, Inventory Costing

When attempting to run Iterative Periodic Average Cost Processor
the following error occurs.

 cannot execute concurrent program Iterative Periodic Average Cost Processor due to an error of "No entries for List of Values" while choosing the parameter "Run Option".

Checking the SQL for the LOV, we learned that the problem traces back to table cst_pac_process_phase and there, for period_id 158009, the process_status is stuck as 1 for each of the 5 rows where process_phase is 7.
For comparison, to the other Cost Type, which period_id is 158010, every row where process_phase is 7, the process_status is 4

The user terminated the program execution, therefore the program didn't change the process_status back to 4 so it could be executed later.


ERROR
-----------------------
error parameter
Run Options error no LOV listed
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)
No entries found for List of Values


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 1. View -> Requests -> Query for "Iterative Periodic Average Cost Processor" and fill out the parameters "Legal Entity" and "Cost Type".
2. The next one, which is "Period", fills out automatically and the next one to that,
3. "Run Options" should also fill automatically, but that isn't happening now.

Changes

Cause

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