OIC: How to perform FBDI GL File Upload

In my previous post we did Currency and Daily Rates FBDI upload.
Here is the link for that post https://dobbylearns.wordpress.com/2021/07/23/oic-load-fbdi-and-callback/

That FBDI file upload was kind of Straight forward.
However now we will see how to load a FBDI file where the Process expect some Extra Parameters.
Example : The Import Journal process.

The best way to do this is to Generate the FBDI file manually and then load it in Oracle Fusion.
Followed by that we can try automating the process.

Highlights of Manual Upload

Now Go to TOOLS > JOURNALS > TASKS > Manage Journals and locate any existing period.

Click and open any Journal to get an idea of it.

Now we can download the template file and generate the sample data file to load.
The template file for Journal Import can be downloaded from here :-
https://docs.oracle.com/en/cloud/saas/financials/21c/oefbf/general-ledger.html#journalimport-3144

Which fields can be filled example:-

Column HeaderValue
*Status CodeNEW (to be filled in two lines)
*Ledger ID300000012783507 (to be filled in two lines)
(You can get this one from any Import Journal process Parameter List)
*Effective Date of TransactionPut any date from the Open Period (to be filled in two lines)
(I have chosen 15th Feb as the Period is Feb-21 for me)
*Journal SourcePut the System Name. (to be filled in two lines)
(I have put ‘Spreadsheet’)
*Journal CategoryPurchase Invoices/Sales Invoices etc (to be filled in two lines)
(You will get this from Existing Journal’s Category from Front End)
*Currency CodeUSD (to be filled in two lines)
(As I am operating with US Ledger)
*Journal Entry Creation DatePut similar date from the Open Period (to be filled in two lines)
(I have chosen 15th Feb as the Period is Feb-21 for me)
*Actual FlagThis decides the Balance Type of the Journal. I have put ‘A’ (to be filled in two lines)
Segement 1 to Segment 6Not mandatory . but you can get it from Front End.
Or modify and use this below query:-
SELECT
.* from
gl_je_lines L,
gl_je_headers H,
gl_je_batches B,
GL_CODE_COMBINATIONS GLC
WHERE
l.je_header_id=h.je_header_id and
b.je_batch_id = h.je_batch_id and
h.ACTUAL_FLAG = 'A' and
h.name = '' and
L.CODE_COMBINATION_ID= GLC.CODE_COMBINATION_ID;

(to be filled in two lines)
Entered Debit AmountEnter some Value for Line1
Entered Credit AmountLeave Empty for Line 1, Enter some amount in Line 2.
Should match with the Debit Amount.
Converted Debit AmountLeave Empty for both lines.
Converted Credit AmountLeave Empty for Line 1, Enter some amount in Line 2.
Should match with the Debit Amount.
REFERENCE1 (Batch Name) (to be filled in two lines) Same value.
REFERENCE2 (Batch Description) (to be filled in two lines) Same value.
REFERENCE4 (Journal Entry Name) (to be filled in two lines) Same value.
REFERENCE5 (Journal Entry Description) (to be filled in two lines) Same value.
Interface Group IdentifierPut some Value.

Once data is populated “GenerateCSV” using the template.

Now Tools > Scheduled Processes > Schedule New Process

Now once this process and its child processes are completed this will load data in the Staging area which GL_INTERFACE Table.

Now we need to run “Import Journals” job upon completion of the previous job. This will load the Journal.


Highlights of Automated Upload via OIC

Main Process RecipeCallback process Recipe
1) Create a Global Variable called FileName.
2) List All Files from Input folder
3) For Each Files
– Download File
– Assign the Global Variable FileName with FileName_CurrentDateTime
– Read File in Segment and Write it in Stage Area
– Write the Property File
– Zip both the files
– Write the ZIP File to SFTP
– Perform ERP connection Bulk Import
– Archive Source File
1) Receive Callback Event
2) Move Output Zip file to Archive location which was generated from the Main Process
3) Download the Process Log Files.

Property file mapping :-

<ns25:recordSet>
   <ns25:record>          
   <ns25:C1>oracle/apps/ess/financials/generalLedger/programs/common</ns25:C1>
   <ns25:C2>JournalImportLauncher</ns25:C2>
   <ns25:C3>GlInterface</ns25:C3>
   <ns25:C4>300000055788898</ns25:C4>
   <ns25:C5>Spreadsheet</ns25:C5>
   <ns25:C6>300000012783507</ns25:C6>
   <ns25:C7>123</ns25:C7>
   <ns25:C8>N</ns25:C8>
   <ns25:C9>N</ns25:C9>
   <ns25:C10>N</ns25:C10>
   </ns25:record>
</ns25:recordSet>


Callback Process:-


Once everything is completed Status should be like this:-

Thanks for reading.
Please follow the blog for more updates.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.