Whats your error message?

I assume this is within 10g version but you may try if you have similar init block in rpd

Check the connectionpool settings. Looks like your db password is expired!

Looks like your approach is too critical to BI !! go for sql expression filter on column Time."Enterprise Quarter"= (case when PresentationVar='Next Qtr' then Next_entrprice_quarter when PresentationVar='Curr Qtr' then Current_entrprice_quarter end) just tweak it if not working

Whats difference in your report and ootb report? you said same!!

Try to check doc something like https://docs.oracle.com/cd/E51479_01/doc.111181/e51480/toc.htm

Follow 3 and 5 chapters from Contents

Try to read this https://docs.oracle.com/cd/E23943_01/doc.1111/e18562/schedconcepts.htm#BIESJ1430

I see as below for this TaskName: Load into Position Dimension Cmd for Full load: SIL_PositionDimension_Full Cmd for Incr load: SIL_PositionDimension I dont find any of DAC object as @DAC_SIL_PositionDimension_FULL_TD_CMD you need to takeout and run with above info that should work.

I've changed the expression as below Case when "Time"."Date"= MAX("Time"."Date" by "Time"."Month") then "Time"."Date" end I do see some data wherever its applicable as per logic. I think you need to refine the expression with else part, I dont see any value in my local beside some metrics ;( When I set is not null to the…

Whats the DAC task to see this?

Also you may Unit Test the task 'Extract for Internal Organization Dimension Hierarchy BU Temporary' from dac execution plan. let me know log message from both.

Singh, If you are storing parameter files at dac folder then keep in Informatica folder and try to run the workflow from Workflow manager. let me know how this works for you. then we go to dac!

Check this Doc ID 2099310.1

Check the session parameter file exists or not with that variable? is it very fresh load or error from stable environment?

Just in case post here

Search more you should find something similar to latest version https://docs.oracle.com/cd/E63231_01/doc/BIAFC/GUID-7A5F4EDD-640A-4CE3-9C40-D13E7D5A08CC.htm#IT_46

Check this https://docs.oracle.com/cd/E14223_01/bia.796/e14216/anyimp_oracle_apps.htm

hmm i dont think so can you explain by splitting the function?

Make sure you have this file at sqljdbc.jar at location in bifoundation\dac\lib