We have a process that outputs a CSV file which we manually load into IFS using the external customer load assistant.
Is there a way of scheduling this task??
Thanks for your help
We have a process that outputs a CSV file which we manually load into IFS using the external customer load assistant.
Is there a way of scheduling this task??
Thanks for your help
Seems its a mandatory parameter unfortunately
It should work without that parameter
Yep, this is what i have - Load_Type = EXTINV (The same as the invoice parameter screen)
So is the PARAMETER_STRING_ = ‘1’ as per the Set ID above?
Load type should be there in the import assistant
Ahh thaks.. i have one already setup
So do i put that load type into the PARAMETER_STRING on the scheduled job?
Please add the information here,
Done, still the same issue with the ‘batch parameter not found’.
Each time i add a new scheduled task using the batch option from the external customer load assistant it creates a job, adding 1 to each parameter string vale (As you can see i have had a few attemempts to set up.
Any other elimination steps you can think of that i can try?
Try granting access to Everyone to share folder and thencheck.
This is an elimination method to verify.
Apologies, the error was not the same!
Batch Parameter not found ORA-20105: ExternalFileUtility.NOBATCHPAR
Thanks, but i tried with my IFS user account, and i do have access to the folder but job completed with the same error so am a little stumped
Hi,
Folder access takes windows users credentials, not ifsapp.
Thanks
Strange, i did set up that way - Used IFSAPP as has permissions as part of MIG jobs to that file path
Am still receiving the error when i try to run the scheduled job
ORA-20110: ExternalFileUtility.File \\VM-FTP-02\FOLDER$\LIVE\Incoming\ARInvoice\ not exist
Hi,
It Should be Oracle Directory or Shared folder from DFS server or your application server like \\SERVER_NAME\FOLDER\ User should have an access to the location.
Thanks
Found out what i did wrong! I put the client file path in as the ORACLE DB file path
How can i point to a file location on the DB?
Thanks for info! Am running through that setup but when i try to setp the process option as ‘Batch Process’ i am not getting any options to proceed. ‘Next’ is grey’d out
HI,
Yes, it is possible to schedule the import.
Then Schedule according to your need.
Thanks
L P Reddy
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.