Hello,

I'm trying to create a BI Publisher report to update Salaries using the HCM Data Loader.

I have a calculated column to populate the proposed salary depending on grade:

CASE pgf.NAME WHEN 'T4' THEN '9.00'
WHEN 'T3' THEN '9.75' 
ELSE '' END AS 'Proposed_Salary'

And I have another column that concatenates the relevant fields needed for the HCM data loader:

||cs.SALARY_ID||'|'||paam.ASSIGNMENT_NUMBER||'|'||TO_CHAR(cs.DATE_FROM, 'YYYY/MM/DD')||'|'||TO_CHAR(cs.DATE_TO, 'YYYY/MM/DD')||'|'||Proposed_Salary||'|'||cs.MULTIPLE_COMPONENTS||'|'||csbt.SALARY_BASIS_NAME||'|'||cs.SALARY_APPROVED||'|'||pab.ACTION_CODE||'|'||parb.ACTION_REASON_CODE HDL

When I add the alias from the calculated column into the concatenation I get the following error:

ORA-00904: "PROPOSED_SALARY": invalid identifier

Please can you point me in the right direction? :)

||cs.SALARY_ID||'|'||paam.ASSIGNMENT_NUMBER||'|'||
TO_CHAR(cs.DATE_FROM, 'YYYY/MM/DD')||'|'||TO_CHAR(cs.DATE_TO, 'YYYY/MM/DD')||'|'||
CASE pgf.NAME WHEN 'T4' THEN '9.00' WHEN 'T3' THEN '9.75'  ELSE '' END
||'|'||cs.MULTIPLE_COMPONENTS||'|'||csbt.SALARY_BASIS_NAME||'|'||cs.SALARY_APPROVED||'|'||pab.ACTION_CODE||'|'||parb.ACTION_REASON_CODE HDL