I am new to Cloud, we are on 24R2 (not live yet). I’m trying to fix some one of my lobbies that was converted with an IFS script. It should return one record but it returns 0. Any help would be appreciated.
Question
Lobby not selecting data (date parameters)
+7Hi
Could you share the WHERE condition? I’ll check and see if I can help you out.
Thanks,
Sarasi
Hi Sarasi,
The view is Shipment_Line_Ovw and the where statement is:
&AO.Shipment_Source_Utility_API.Get_Line_Planned_Ship_Date__(SOURCE_REF1,SOURCE_REF2,SOURCE_REF3,SOURCE_REF4, SOURCE_REF_TYPE_DB) between trunc(to_date( '#TODAY#', 'YYYY-MM-DD-HH24:MI:SS' )) and trunc(to_date( '#TODAY#', 'YYYY-MM-DD-HH24:MI:SS' )) + ( 1 - 1/ ( 60*60*24 ) ) and (CONTRACT = '2210' or CONTRACT = '2220') AND upper( SHIPMENT_STATE ) = upper( 'Preliminary' )
Thank you for any help you can provide
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.