Compensation Workbench - Download Spreadsheet - get Error "Cannot execute SQL Statement" (Doc ID 1668984.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Compensation Workbench - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

In TEST instance
R12.HR_PF.B.delta.6

Compensation Workbench, download spreadsheet gives
following error for EMEA plans :

ERROR
----------------------------------
A problem has been encountered initializing the control for importing data as detailed below
Cannot execute SQL Statement.
Number of valid rows
BNE_ROWCOUNT




STEPS TO REPRODUCE
----------------------------------
Use responsibility : compensation workbench for administrators
Navigation : switch to manager
on page that shows compensation summary team
1. press download to spreadsheet link
2. download default definition
3. open

get error

ADDITIONAL INFORMATION
----------------------------------

Allthough all formulas on system are compiled successfully, BNE log shows
Query: SELECT EMP_NAME, PL_OTH_COMP_VAL, OPT1_XCHG_RATE, OPT1_ELIG_SAL_VAL, OPT1_WS_VAL, OPT2_XCHG_RATE, OPT2_ELIG_SAL_VAL, OPT2_WS_VAL, OPT3_XCHG_RATE, OPT3_WS_VAL, EMPLOYEE_NUMBER, CUSTOM_SEGMENT10, CUSTOM_SEGMENT13, CUSTOM_SEGMENT15 FROM BEN_CWB_WS_DOWNLOAD_V WHERE MGR_LER_ID = :RSQLP1
1/23/14 1:29 PM AJPRequestHandler-HTTPThreadGroup-9 ERROR BneBaseSQL.executeBneQuery: Args : 1881978.0
1/23/14 1:29 PM AJPRequestHandler-HTTPThreadGroup-9 ERROR BneBaseSQL.executeBneQuery: Stack trace: java.sql.SQLException: ORA-20001: A compiled version of the formula cannot be found. Check that it exists and has been compiled before attempting to run it.


 

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