ERPstuff - Oracle EBS Community

Hi

How can I change the schdule ship date and time...in the Sales order line. When I save the line in Sales order it takes the default time as : 23.59

But when i change it and try to save it it save it again with the same time. How can i change this default time. Please answer asap. Thanks for your assistance in advance.

Regards
Sandeep

Hi,

By using CUSTOM.pll u can alter the schedue_ship_date and time.

the code in two events,
1. if event = when_new_form_instance

2. if event = when_validate_record

for time stamp you can use bulit-in function CURRENT_TIMESTAMP it returns a timestamp with timezone value.

or else u can use LOCALTIMESTAMP

Thx