Question

APPS 9 - Is it possible to schedule external customer invoices import?


Userlevel 6
Badge +11

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


This topic has been closed for comments

16 replies

Userlevel 3
Badge +6

HI, 

 

Yes, it is possible to schedule the import. 

  1. Enter the File Name. 
  2. Modify the External Invoice Template, add the file path if it is a shared DFS folder, Else create a Oracle Directory.

     

  3. Then Use the Batch Process of External import job. 
  4.  Then Schedule according to your need.

Thanks 

L P Reddy

Userlevel 6
Badge +11

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

Userlevel 6
Badge +11

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?

Userlevel 3
Badge +6

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 

Userlevel 6
Badge +11

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     

Userlevel 3
Badge +6

Hi, 

 

Folder access takes windows users credentials, not ifsapp. 

 

Thanks

Userlevel 6
Badge +11

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

Userlevel 6
Badge +11

Apologies, the error was not the same!

Batch Parameter not found                    ORA-20105: ExternalFileUtility.NOBATCHPAR

Userlevel 3
Badge +6

Try granting access to Everyone to share folder and thencheck.

This is an elimination method to verify. 

Userlevel 6
Badge +11

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?

 

Userlevel 3
Badge +6

Please add the information here, 

 

Userlevel 6
Badge +11

Ahh thaks.. i have one already setup

So do i put that load type into the PARAMETER_STRING on the scheduled job?

Userlevel 3
Badge +6

Load type should be there in the import assistant

Userlevel 6
Badge +11

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?

Userlevel 3
Badge +6

It should work without that parameter

Userlevel 6
Badge +11

Seems its a mandatory parameter unfortunately