Skip to main content

AP: File Based Data Import (FBDI) Process - Open Invoices Conversion Process

 

File Based Data Import (FBDI) Process - Open Invoices Conversion Process             
Note: we can load only unpaid invoices by using the FBDI Template. We cannot load paid invoices using FBDI templates             
              
Process             
1.Download FBDI Templates from Oracle Oracle Enterprise Repository (OER) PathOracle OER website >> Cloud Applications >> Financials >> All Books >> FBDI for Financials >> Download Payables Standard Invoice Import.          
2.Populate data in templates    AP FBDI Invoice Seeded Data Templates        
3.Create CSV Files             
4.Place CSV Files in Universal Content Management (UCM) (Optional)             
5.Load data into interface tables             
6.Import data into base tables             
              
For AP FBDI Invoices             
To Populate the Data into Interface Tables              
1. Run Load Interface File for Import Job in Scheduled Process.    AP FBDI Invoice with Actual Data Templates        
* Here in this job select Import Process as " Import Payables Invoices. "             
              
System will run sub jobs              
a. Load Interface File for Import              
b. Transfer File             
c. Load File to Interface             
d. Load File to Interface             
              
To Populate data from interface tables to base tables             
1. Run " Import Payables Invoices " Job in Schedule Process.             
Here system will generate " Import Payables Invoices Report ".             
              
Note: If you want to create a source navigate to " Manage Payables Lookups " and search Lookup type as " Source "             
* Now when you run " Import Payables Invoices " we can find all the sources which are created under lookups.             
              
* From Correct Import Errors we can correct the errors at interface table level. And after correcting the data in correct import error sheet clickon save and submit invoice import. Then the invoice will be created in the system.              
              
* If you run " Validate Payables Invoices " Job system will validate all invoices.             
              
              
              
              
              
              
              
              
              
              
              
              
              
              
              
* If you want to create Accounting for all the invoices Run " Create Accounting. " Job or you can run the process from Payables >> Invoices >> Taskpane >> create Accounting.             
              
 * Here system will run sub jobs when you submit create accounting process             
 a. Create Accounting            
 b. Create Accounting: Sub Process             
 c. Post Sub Ledger Journal Entries            
 d. Post Sub Ledger Journal Entries: Sub Process            
 e. Import Journals: Child            
 f. Post Journals for Single Ledger            
 g. Maintain Payables Trial Balance Report            
              
              
              
              
              
              
              
             

Comments

Post a Comment

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  
Post a Comment
Read more