Journals
Discussion List
-
How to give username in journal if created through integrationSummary: When we are creating a journal through Integration service, created by has OIC username populated but we would like to have the username who has created the jou…Sukrita_Budhiraja 23 views 3 comments 0 points Most recent by asurnilla General Ledger & Intercompany -
Prohibit self approval when creator and initiator are differentSummary: Prohibit User Self-Approval is enabled for Journal WF with the payload attribute task: creator. However in occasions when journal creator and approval initiator…Akshaykshaji 70 views 2 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany -
journals accounting date tableDear All, Can anyone tell me where's the accounting date of the journal is stocked? I queried date_created column in the GL_JE_HEADERS table, but I noticed that I am obt…George Mattar 380 views 4 comments 0 points Most recent by Sridhar_Rejeti_1423 General Ledger & Intercompany
-
In oracle fusion cloud, how to get the creation date for deleted journalIn oracle fusion cloud, how to get the creation date for deleted journals from database table It is possible to get from table "GL_JE_HEADERS_"?
-
Connecting ADFDI journal upload file to the ApplicationSummary: Connecting ADFDI journal upload file to the Application Content (please ensure you mask any confidential information): I opened the ADFDI journal upload file, w…ramesh.sivapalan 15 views 0 comments 0 points Started by ramesh.sivapalan General Ledger & Intercompany
-
Enable of Sequencing at Specify ledger option affects the Create Journal formSummary: Content (please ensure you mask any confidential information): We had a requirement in AR to enable the Invoice numbering, and we got to know we need to enable …Vikram_Patel 9 views 1 comment 0 points Most recent by CA Nitesh Sharma General Ledger & Intercompany
-
How to keep track of the creation date, created by of the journal batch deleted itselfSummary: I have enabled audit on Journal Batch, Journal Header. They both don't track the insert action. What to do in case when User A created a random journal A, say a…
-
Jouarnal Line Description for Subledger JournalsCurrently we have non Oracle system accounting entries transferring to GL through Accounting Hub (FAH). We have setup the Journal Line Description rule to include the re…
-
Restricting Usage of Statistical Accounts against STAT currency onlySummary: We need to restrict the usage of Statistical natural accounts against STAT currency only. Content (please ensure you mask any confidential information): This is…Iffat Shaikh 105 views 6 comments 1 point Most recent by Venkatesh Padamwar General Ledger & Intercompany -
How to setup a Context Sensitive DFF to work based on GL Journal Category?Summary: How to setup a Context Sensitive DFF to work based on GL Journal Category? Content (please ensure you mask any confidential information): We have a requirement …ramesh.sivapalan 26 views 0 comments 0 points Started by ramesh.sivapalan General Ledger & Intercompany
-
Delete approved but unposted journals from Spreadsheet sourceSummary: We had created a journal batch which was then approved. During posting, an issue came up with Intercompany due to which the journals could not be posted. Now we…
-
Ledger Set Access not working as expectedSummary: Hi Team, We have faced a strange system behaviour where an user is not able to post a journal in the reporting ledger even though she had a ledger set access wh…Arjunayan 55 views 3 comments 1 point Most recent by Cornelius Durai C General Ledger & Intercompany
-
Accounting Date Range in AutoPost Criteria SetSummary: Query: The user wants to post journals based on the Accounting Date. Does the “Autopost Journals” process work based on the Submission Date or the Accounting Da…Rama Mohan ReddyB 22 views 1 comment 0 points Most recent by Jamal Saboonchi General Ledger & Intercompany
-
can’t delete the journals that are currently in an error statusHello, In GL, I have journal entries that were imported and ended in error, and cannot be deleted. I have already executed the "Delete Import Data" and "Purge Interface …Teresa Martinez-Oracle 19 views 1 comment 0 points Most recent by George-Oracle General Ledger & Intercompany
-
While creating journal entry, JE creation date is overridden by system dateWhile importing journals through FBDI spreadsheet, the journal entry creation date is getting override by the sys date. Is it possible to populate the date that is given…Dharanidhar 54 views 5 comments 0 points Most recent by Karun Jain-Oracle General Ledger & Intercompany
-
What will be the ideal number oIf rows we can have in Journal Import FBDI template and the file sizeSummary: I have a requirement where i need to upload 20+ millions of data on a daily basis via OIC integration through Journal Import FBDI Template. Row Count per File –…Samadhan_Kshirsagar 41 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Unable To Delete The Unposted SLA Journal in GLHi, We are busy introducing a GL housekeeping / maintenance process to clean up the GL after ledger close each month. As part of the process, we would like to delete any…Steve Collop 49 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
whats argument2 in Load Interface File for ImportSummary: whats argument2 in Load Interface File for Import Content (please ensure you mask any confidential information): Im trying to submit Load Interface File for Imp…Jaeyshree Kumaran Kalpana 33 views 2 comments 0 points Most recent by Mahindra reddy-Oracle General Ledger & Intercompany
-
How to remove "Post" action from General Accountant roleMy client has a requirement for journal creation. They have three people (GL preparer, GL reviewer, GL approver) with three different duties to process a manual journal.…Alfred Choi 35 views 2 comments 0 points Most recent by Service Desk Claremont General Ledger & Intercompany
-
Custom journal category for Revaluation Journal only for the Poland ledgerSummary: Is it possible to use a custom journal category only for the Poland ledger, where the reversal method is Change Sign, while other country ledgers use Switch Dr/… -
How Accounting Date is arrived at Journal HeaderSummary: How Accounting Date is arrived at Journal Header when we upload Journals using spreadsheet under Multiple Journals section with different accounting dates for e… -
Journal Line description amendmentSummary: Journals were posted with line description containing certain sensitive information. How to amend these line description. Content (please ensure you mask any co…Srivatsav PR-Oracle 24 views 3 comments 1 point Most recent by Garry_Lee General Ledger & Intercompany -
Derive Secondary ledger COA segment in a GL_JE_lines based on Primary ledger DFF at line levelSummary: Is there any functionality in GL available to map Secondary ledger COA segment in a journal line level based on Primary ledger Journal line level DFF value Cont…raveenasingla 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Client is having an issue using ADFDI for Journal Creation 'Import Journals: Child' goes to errorMy client is trying to upload journal via spreadsheet. When clicks Submit the Journal Lines Row Status say "Row inserted successfully" but when she checked her Scheduled… -
Performance impact in Journal Posting due to sequencingNeed confirmation if there will be any performance impact while posting journals if we enable accounting and reporting sequence. Please note that we have 185 primary led…Dwaipayan 25 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Receipt accounting's entry not derive to journal descriptionSummary: In Journal from receipt accounting, description is [Journal Import Created], but user want it derived from subledger entry description so that they can refer an…Lia lin 28 views 1 comment 0 points Most recent by Harish Kumar Raghu-Oracle General Ledger & Intercompany
-
Supervisory hierarchySummary: GL Journal Approval Flow – Issue with Supervisory Hierarchy Setup with Approver Level 2 Content (please ensure you mask any confidential information): Hi Team, …
-
GL: Why is Journal Approval Rules Spreadsheet password protected??Summary: Why is Journal Approval Rules Spreadsheet password protected?? I am able to insert records but cannot delete them once added. It says sheet is password protecte…Rakesh Viswambharan 26 views 4 comments 0 points Most recent by A Lotfy General Ledger & Intercompany
-
How to get Request Id for Import Journals ESS Job using ImportBulkData Operation using REST API?I am invoking the importBulkData(Operation) REST API to run the Import Journals job for loading journal FBDI files. While I can retrieve the Request Id of the "Load Inte…Srinath Anbarasu 431 views 5 comments 0 points Most recent by Raluca Chivu-Oracle General Ledger & Intercompany
-
Auto Reversal of accrual journal entries to first day of next quarter?Requirement is to have auto reversal of the accrual journal entries to first day of next quarter. Not able to setup the same in Journal Reversal Criteria Set setup. Is t…