How to Manage Auto Invoice Import Interface from Fusion application

How to Manage Auto Invoice Import Interface from Fusion application

 

Hi friends, in this post , we will discuss Auto Invoice interface in Oracle Fusion. In fusion , oracle has given functionality to download all the records available in AR Auto Invoice interface tables in an excel file and make them changes or corrections in these records from this excel and then process these records again directly from the downloaded Excel File.

 

Step1:- :- Navigate to Mange AutoInvoice Lines.

Navigator-->Receivables>Billing-->Tasks/ Transactions/ Manage AutoInvoice Lines

 

 

Step2:-This below Template will be download in your system.

Enter the Required Details in the template as per the requirement.

One you fixed the Search Criteria then Click on Search Button as below.

 

Search Button will fetch all the records from AR interface to this Excel Sheet as per your Search Criteria.

 

You can do the changes in the records directly in this Excel Template and you can also see the error reasons for the rejected records. You can either delete these records from this template by click on Clear.

 

 

 

Step3:- Submit the Final changes again in AR Interface to import in Fusion Receivables.

 

You can see the Manage Auto Invoice Tab in your Excel Template.

click on Submit button as below to process the changed records in AR.

 

 

Oracle Fusion FBDI : AR Auto Invoice Import

Oracle Fusion FBDI : AR Auto Invoice Import

 Steps to Import AR Invoices Through FBDI.

Step1:- Go to Oracle Repository to Download FBDI Data Templates

Step2:- Enter the Data in Data Template. Please be sure , your Transaction Batch Source Name should be created in the System

Step3:- Then click on the First tab of This Data Template and Click on 'Generate CSV File'

Step4:- This is the Zip file created from this Data Template.

Step5:- Go to Oracle Fusion and Then go to Navigator and Click on File Import and Export.

Step6:- Then Upload the ZIP file here below and select the UCM Account.

Step7:- Then go to Navigator again and click on Scheduled Processes.

Step8:- Then Run the Load Interface File Import as below.

 

 

Enter Parameters for this Program.

 

 

Step9:- Then Again click on Scheduled New Processes as below and run the second program.

Step10 :- Run the Second ESS job Import auto Invoice.

 

Enter the Job Parameters and Select the BU and Source Accordingly as per the sheet.