Re: Archiving data from Glogowner to Archive Schema
Medhas,
You can try this.
select * from ARCHIVE.SHIPMENT_DMP...
19 results in 0.0056 seconds.
-
Re: Archiving data from Glogowner to Archive Schema
Medhas,
You will find the purged shipments in the Archive Schema. All...Leave a comment:
-
Re: scheduled report
We use the schedule window to set it up.
Thanks,
Prasad.Leave a comment:
-
Re: scheduled report
Sidhu,
To change the schedule, we cancel the old schedule and re-schedule the report.
Is...Leave a comment:
-
weblogic.ejb20.locks.LockTimedOutException
Hi,
We are seeing this integration error more often. This happens whenever we upload order release information via integration.
... -
Archiving data from Glogowner to Archive Schema
Hi,
Does anyone have any suggestions on the best practices for archiving & purging the data? We are in the process of moving old data... -
Re: Notification in OTM
Do you know where these templates reside? I could not find any in the config directory on the App side or the utils...Leave a comment:
-
Re: scheduled report
Baji,
Did you figure out how to stop a scheduled report? We can do it from the oracle enterprise manager....Leave a comment:
-
Re: UTC.GET_LOCAL_DATE SQL Performance
Gary & Chris.
Thank You for you hint. By narrowing the query, the performance increased...Leave a comment:
-
Re: Invoking a Custom python or Shell script
Thank You, Chris.
I will try this technique.
Regards,
Pra...Leave a comment:
-
Re: stored query
Nikesh,
I have a similar kind of requirement. Were you able to find a solution for this?Leave a comment:
-
UTC.GET_LOCAL_DATE SQL Performance
We are using utc.get_local_date function very frequently. Is there a better way to get the local date? This function call is taking a long time execute.... -
Invoking a Custom python or Shell script
Hi,
Can we invoke a custom python script from OTM?
We want to write a program/script that modifies certain data in the database... -
Re: Rate Service and Rest for Truck Driver
No, we did not specify a calendar in the rate service. Do you think we should specify one in...Leave a comment:
-
Rate Service and Rest for Truck Driver
Hi,
We have the following scenario, in which the rest hours are not being calculated properly. Due to this, the final delivery is delayed....
Leave a comment: