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

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

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

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?

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 

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, 

Folder access takes windows users credentials, not ifsapp. 

Thanks

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

Apologies, the error was not the same!

Batch Parameter not found                    ORA-20105: ExternalFileUtility.NOBATCHPAR

Try granting access to Everyone to share folder and thencheck.

This is an elimination method to verify. 

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?

Please add the information here, 

Ahh thaks.. i have one already setup

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

Load type should be there in the import assistant

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?

It should work without that parameter

Seems its a mandatory parameter unfortunately