Oracle Fusion #37: Journal Import using FBDI

-- Oracle Fusion Video Series : Video 37
#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant
Join Our Telegram Group:
t.me/techtalks...
FOLLOW US :
============
KZbin : / techtalkwithnaresh
For More details Contact Us:
Email: [e-mail]
-------------------------------------------------------------------------------------------------------------------------------------------------------------
In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics in Oracle fusion you can reach out me at [e-mail]. Please do like, share and Subscribe the channel to get latest videos.
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Journal Import using FBDI (Interface)
Step1: Download the template from bellow link,
fusionappsoer.oracle.com
Step2: Insert the required fields in the Template.
-- Validation Queries:
I. select * from gl_ledgers where name like '%US%';
II. select * from gl_he_sources
III. select * from gl_je_categories.
IV. select * from gl_code_combinations;
Step3: Go to Import and Export and upload the zip file.
-- where account: fin/generalLedger/import
Step4: Schedule the program Load Interface File for Import.
Parameter: Import Process: Import Journal
Step5: Schedule the Import Journal Program/JOB.
Source: spreadsheet

[@ananddeepak1984]

you can attach file at " Load Interface File for Import" step. NO need to do extra step of loading file using File Import/Export. Video is good

[@TechTalkwithNaresh]

@Deepak 👍

[@sandeepb911]

Thanks for the video. It was very clear. I have one doubt. How did you get the group ID '9999' at import Journals job. I didnt see an option in FBDI template as well. Is it auto generated ? When i did, i didnt get the group id. can you please answer.

[@TechTalkwithNaresh]

@sandeep Please write in detail [e-mail] with both screenshots from my video and your template. Subscribe to get latest updates.

[@radhanarayanan4443]

Hi - is it possible to bring in journal header level attachments using this import method? If not, is there any suggested work around to achieve this?

[@TechTalkwithNaresh]

@Radha Import program is used to insert the data in header table.

[@yvettehamilton9543]

When importing to the base table and in your example it goes into warning, what are the steps if it goes into warning or error? Do you purge the data then start over?

[@TechTalkwithNaresh]

@ Yvette Need not to purg the data..

[@yvettehamilton9543]

@@TechTalkwithNaresh ok so can make corrections on the template then upload again?

[@TechTalkwithNaresh]

Yes

[@soundaryasureshmohan7524]

Make some videos for interviews pls

[@TechTalkwithNaresh]

@Soundary I will try to upload the video on mention topic asap. Subscribe to get latest update.

[@aryasreedhar2981]

The requirement is to run this journal import in daily basis, how to send the file in fusion and get processed ?

[@TechTalkwithNaresh]

@Arya In the video I had explained how to upload the file. If it have any issues let me know.

[@gaddey.n.saiteja1336]

Hi how to get the active flex field value (Code Combinations)?

[@TechTalkwithNaresh]

@Gaddey From which screen you want to get the active flex field values or ccid?

[@gaddey.n.saiteja1336]

@@TechTalkwithNaresh As shown in the video in the templet we have to give the code combination right so where we can get the active code combinations?

[@TechTalkwithNaresh]

@Gaddey you can get the code combination in GL_CODE_COMBINATION table.

[@ainsalleh]

how to write .properties file for this?

[@TechTalkwithNaresh]

@Hell Smell which . properties u are trying to say