Skip to main content

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

 

File Based Data Import (FBDI) Process - Suppliers Conversion Process             
Steps             
1.Download FBDI Templates from Oracle Oracle Enterprise Repository (OER) >>  we have to download the sheets from Oracle OER website - fusionappsoer.oracle.com goto procurement >> Clickon all books*from this website we have to download import suppliers template       
2.Populate data in templates     * In one template we cannot create supplier, supplier address, supplier site and assign it to Business Unit (BU). We have to use different templates to create supplier definition.       
3.Create CSV Files  Suppliers InterfaceInvoices Interface         
4.Place CSV Files in Universal Content Management (UCM) (Optional) Under prc/supplier/import account we have to place the zip file in UCM account    Supplier Seeded data FBDI Templates       
5.Load data into interface tables             
6.Import data into base tables             
              
Process             
1.Create Supplier Profile             
2.Create Supplier Address    Base Table         
3.Create Supplier Site * These are the different templates     Supplier Actual Data FBDI Templates      
4.Assign Supplier Site to Business Unit which are used to create supplier            
  we cannot create full supplier by            
  using one FBDI Template           
              
For Suppliers             
To Populate the Data in interface tables we have to run Note: At interface level we cannot edit the data when we are creating suppliers in the system. Whereas while creating AP Invoice in the system we can edit the data at interface table level.           
1. Run Load Interface File for Import Job in Scheduled Process. * we cannot edit suppliers data which is in interface tables.            
* Here in this job select Import process as Import Suppliers.             
After submitting this job system will run sub jobs.             
a. Load Interface File for Import              
b. Transfer File.             
c. Load File to Interface.             
              
To Populate the Data from Interface tables to base tables              
1. Run Import Suppliers Job in Scheduled Process.             
System will run sub process              
a. Update Supplier Key Word Search Index and source to settle Counts             
* After the job was successfully completed system will generate a report called " Suppliers Import Report ".             
a. We can download Supplier Import Report after successful of Import Suppliers Job. By clicking that job we can download PDF format of that report.             
*In Suppliers Import Report we can see what are all the suppliers are created in the system and if there are any duplicates also.             
              
For Supplier Addresses             
To Populate the Data into Interface Tables              
1. Run Load Interface File for Import Job in Scheduled Process.             
* Here in this Job select Import Process as " Import Supplier Addresses. "             
After submitting this job System will run sub jobs             
a. Load Interface File for Import              
b. Transfer File             
c. Load File to Interface             
              
To Populate data from interface tables to base tables             
1. Run Import Supplier Addresses Job in Schedule Process             
No Sub Jobs will be runned by the system.             
              
For Supplier Sites             
To Populate the Data into Interface Tables              
1. Run Load Interface File for Import Job in Scheduled Process.             
* Here in this job select Import Process as " Import Supplier Sites. "             
After submitting this job 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 Supplier Sites Job in Schedule Process.             
No Sub Jobs will be runned by the system.             
              
For Supplier Site Assignment to Business Unit             
To Populate the Data into Interface Tables              
1. Run Load Interface File for Import Job in Scheduled Process.             
* Here in this job select Import Process as " Import Supplier Site Assignments. "             
After submitting this job System will run sub jobs             
a. Load Interface File for Import              
b. Transfer File             
c. Load File to Interface             
              
To Populate data from interface tables to base tables             
1. Run " Import Supplier Site Assignments " Job in Schedule Process.             
No Sub Jobs will be runned by the system.            

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