Joined: 05 Jun 2012
|Posted: Wed Aug 01, 2012 1:11 am Post subject: DL stops on the way
We are professional user of DL for EBS.
But DL doesn’t work well.
We need some help as we are not able to record (exactly to say, some record is registered but some is not.).
We write down that occurred situation as below.
Procedure of calendar exceptions at Workday Calendar in EBS by DL script.
>Inventory admin > Set Up > organization > Calendars
1. Search Workday Calendar
2. In next window push the button of [Exception List]
3. Register calendar exceptions in that window.
Procedure (logging in Japanese Language)
I. Above1-3 steps would be registered in DL script.
II. Put the script on the server and execute it.
III. But forms doesn’t work (like as freezing). After finding this situation, kill this DL task with task manager.
IV. When Re-open EBS and confirm the registered records,
We can find DL is stopped and some records is registered some is not.
It seems that on the serch section DL doesn't wait for server response and DL try to execute next step with on result, because we find DL stops after [KEY Execute_query] like that.
# 999 - FNDSCSGN:NAVIGATOR.TYPE.1340350031677582000
WINDOW FNDSCSGN NAVIGATOR ACTIVATE 1
# 1000 - FNDSCSGN:NAVIGATOR.TYPE.1340350031677627000
# 1001 - FNDSCSGN:NAVIGATOR.TYPE.1340350031685010000
USER_EXIT LOV XXXXXXXXX BOM_BOMFDCAL
# 1002 - FNDSCSGN:<null>.<null>.1340350031774594000
WINDOW FNDSCSGN NAVIGATOR DEACTIVATE 1
# 1003 - BOMFDCAL:B_CALENDARS.CALENDAR_CODE.1340350031774650000
WINDOW BOMFDCAL B_CALENDARS ACTIVATE 89
# 1004 - BOMFDCAL:B_CALENDARS.CALENDAR_CODE.1340350031774706000
# 1005 - BOMFDCAL:B_CALENDARS.CALENDAR_CODE.1340350031792686000
VALUE BOMFDCAL B_CALENDARS CALENDAR_CODE 1 CONVTT003
# 1006 - BOMFDCAL:B_CALENDARS.CALENDAR_CODE.1340350031792712000
If this situation is as same as topic of [How to "delay a moment" in the source of playback], is there no way to make??
If you need the script and logs, we would like attach the files
but, I don't know hot to attach. We am wondering if you would let me known.
As below there are the foundations.
What is the DataLoad version?
=>Production release - V220.127.116.11
What is the Oracle version?
=>Oracle Database 11g R2(18.104.22.168) Enterprise Edition
Are you using JInitiator or JRE for the Java client deployment?
Does this happen with all playbacks or just this particular load?
=>Simple load success, but some load failed.
Does Oracle crash/error if the data is entered manually?
=> Manual register does works.
If the ICX: Forms Launcher profile option value at user level for your playback user contains the text "&config=playback" or "&code=oracle.forms.engine.MainRT" then please remove this text, save the change, logout and try another playback. What happens?
⇒ We tried some of the following page.