In this Post I will show you how to create the Payable Invoice using FBDI.
To Successfully Create the Invoice , we need to follow the below steps .
Get the FBDI file from OER - oracle Enterprise repository
Access the below link and go to the
![](https://static.wixstatic.com/media/672833_d002e20ad4584723af7c875cf4044c1f~mv2.png/v1/fill/w_980,h_333,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_d002e20ad4584723af7c875cf4044c1f~mv2.png)
Download the FBDI and Prepare the sample data. Click On the XLSM Template.
![](https://static.wixstatic.com/media/672833_152e2a7891aa4c40a7e67d147ac9ccbd~mv2.png/v1/fill/w_836,h_371,al_c,q_85,enc_auto/672833_152e2a7891aa4c40a7e67d147ac9ccbd~mv2.png)
![](https://static.wixstatic.com/media/672833_2262d886a1624a638bf3804873d4e536~mv2.png/v1/fill/w_980,h_307,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_2262d886a1624a638bf3804873d4e536~mv2.png)
Generate the csv files
![](https://static.wixstatic.com/media/672833_e64230c3d0f74c4ead7b6151b71cfed7~mv2.png/v1/fill/w_742,h_430,al_c,q_85,enc_auto/672833_e64230c3d0f74c4ead7b6151b71cfed7~mv2.png)
Files Got Generated to my Local .
![](https://static.wixstatic.com/media/672833_81c67b3620f54488ad0b01b94a97bd8b~mv2.png/v1/fill/w_980,h_177,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_81c67b3620f54488ad0b01b94a97bd8b~mv2.png)
Transfer the same to UCM
We need to Run the below ESS Job by Uploading the above zip file to the UCM Payable Account.
Navigate to Tools > Schedule Procersses .
![](https://static.wixstatic.com/media/672833_18671bd439cd4f37965c3570f8c79cd1~mv2.png/v1/fill/w_776,h_411,al_c,q_85,enc_auto/672833_18671bd439cd4f37965c3570f8c79cd1~mv2.png)
Click On Schedule New Process
![](https://static.wixstatic.com/media/672833_5a8c115077b1477db49467d9a2e2a189~mv2.png/v1/fill/w_893,h_144,al_c,q_85,enc_auto/672833_5a8c115077b1477db49467d9a2e2a189~mv2.png)
Search for the job "Load Interface File for Import" and Press ok
![](https://static.wixstatic.com/media/672833_ea88e96267dd4d4fb2563d6609c809bf~mv2.png/v1/fill/w_896,h_352,al_c,q_85,enc_auto/672833_ea88e96267dd4d4fb2563d6609c809bf~mv2.png)
In the next Screen , Enter the Import Process as " Import Parables Invoices" and upload the zip file we prepared in the earlier Step and submit the job.
![](https://static.wixstatic.com/media/672833_61e10c3e6af546ba886c812740bc22ee~mv2.png/v1/fill/w_724,h_402,al_c,q_85,enc_auto/672833_61e10c3e6af546ba886c812740bc22ee~mv2.png)
you can see that all the jobs got successfully completed and data loaded to the interface tables .
![](https://static.wixstatic.com/media/672833_ad3fdcba3e23483bb8539b592f72d069~mv2.png/v1/fill/w_980,h_184,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_ad3fdcba3e23483bb8539b592f72d069~mv2.png)
One can verify the data by running the below BI Queries .
select * from AP_INVOICES_INTERFACE order by creation_date desc
select * from AP_INVOICE_LINES_INTERFACE order by creation_date desc
Lets Run the Payable Import job to load the data to the Base tables .
![](https://static.wixstatic.com/media/672833_29c6a6c98ac1478e891e61280e2e7991~mv2.png/v1/fill/w_783,h_476,al_c,q_90,enc_auto/672833_29c6a6c98ac1478e891e61280e2e7991~mv2.png)
Jobs Got Successfully completed and the Invoice got Generated .
![](https://static.wixstatic.com/media/672833_2317e5c9d65e4ecea804d4193c0fcc69~mv2.png/v1/fill/w_920,h_88,al_c,q_85,enc_auto/672833_2317e5c9d65e4ecea804d4193c0fcc69~mv2.png)
Payable Import Report reflecting the invoice created
![](https://static.wixstatic.com/media/672833_580e52a973d1435da9235ac58dc2f87b~mv2.png/v1/fill/w_980,h_319,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_580e52a973d1435da9235ac58dc2f87b~mv2.png)
Now , Lets Go to the Invoices Page and Verify the created invoice .
![](https://static.wixstatic.com/media/672833_d86e3b4365de421ea0527633fda28d5b~mv2.png/v1/fill/w_980,h_302,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/672833_d86e3b4365de421ea0527633fda28d5b~mv2.png)
Hope this Helps . happy Learning ..
Do FBDi for Payable Invoice creation supports updating of existing invoices and line ?