You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time

in Reporting and Analytics for HCM 1 comment

I need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this

CASEWHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) <= 5 THEN '1-5 'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 6 AND 15 THEN '6-15'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) BETWEEN 16 AND 30 THEN '16-30'WHEN Timestampdiff(sql_tsi_day,"Shipping Real Time"."- Shipment Details"."WSH_NEW_DELIVERIES_A3PL_NTRFC_TNSTNP_",current_date) > 30 THEN '> 30'ELSE 'NA'END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!