GL Inquiry
Discussion List
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…User_2025-02-11-12-30-38-982 1.3K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
GL Accounting Period Open/Close Update REST APIHi, We need to create a PAAS application to allow users to enter the period details to open and close the STAT leger periods. By using PAAS application to implement that…Praveen_Paul_raj 590 views 4 comments 0 points Most recent by Praveen_Paul_raj General Ledger & Intercompany -
How to create Recurring entries in GL for fixed amounts every month?Summary: How to create Recurring entries in GL for fixed amounts every month? We have a requirement to create recurring journal entries every month and once we pass an e…
-
How to change default period in General Ledger infoletHi, There is no preference that has been set by the user. When he logs in to the instance and navigates to the General Ledger infolets, the period seen is Apr-24 and the…
-
Do we have an archive functionality for Journals in GL (Oracle Fusion)Summary: Do we have an archive functionality for Journals in GL (Oracle Fusion). In Oracle R12, we have Archive and purge functionality. Wanted to know whether similar f…
-
Do we have archive functionality in GLSummary: Do we have archive functionality in GL. In EBS version of Oracle, we have Archive and purge functionality. Wanted to know whether similar functionality i availa… -
Has anyone implemented Multiple primary GAAP ledgers?In Oracle Fusion, is it possible to have 2 primary GAAP ledgers? What are the stipulations to having a second primary ledger? -
Is there any possibility to make PO Number as a Hyperlink from GL Journal for Source: PO ReceiptSummary: Is there any possibility to make PO Number as a Hyperlink from GL Journal for Source: PO Receipt (That GL Journal belongs to PO Receipt) Content (please ensure …Vasu N0897645321-Oracle 11 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Funds Check SQL or APISummary: Is there a REST / SOAP API available to check funds in Oracle ERP Cloud General Ledger? If not, what would be the SQL / related tables to fetch the fund availab…Prithis 71 views 2 comments 0 points Most recent by Pooja Asthana-Oracle General Ledger & Intercompany
-
Es posible crear una nueva clase de cuenta aparte de Activo, pasivo, patrimonio, etcSummary: Requerimos crear unas cuentas de orden , que no afectan los estados financieros solo son de control, es posible esto?, gracias Content (please ensure you mask a…Amanda Ríos Velasquez 11 views 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany -
How to upload Accounting sequence number through Journal Import FBDI TemplateSummary: How to upload Accounting sequence number through Journal Import FBDI Template Content (required): I am migrating Journals from EBS system to Fusion system. Busi… -
Segarate roles for secondary ledger open close periodSummary: We want to set up a user with full transactional access to both the primary and secondary ledgers. However, the user should only be able to perform open/close p…
-
GL Detail Custom Report fetching additional detailsSummary: GL Detail Custom Report is fetching the Invoice numbers and PO numbers which belongs to journal batch which is unexpected, since the application also showing th…Dinesh Krishna 31 views 2 comments 0 points Most recent by Dinesh Krishna General Ledger & Intercompany
-
Why does autopost journals program do not pick up the errored journalsSummary Why does autopost journals program do not pick up the errored journalsContent Suppose there is a case where a journal with source payables is getting created by …User_C3J94 113 views 6 comments 3 points Most recent by thegouravarora General Ledger & Intercompany
-
GL_BALANCES table doesn't match GL Balances CubeWe recently noticed that on the Inquire on Detail Balances page, for certain code combinations the ending balance from one period (Jan-24) doesn't match to the beginning…
-
Add Previous Year to GL Accounting CalendarSummary: Hi, Is it possible to add previous year to existing accounting calendar in GL when Calendar is already created, but First period is not opened for the ledgers a…
-
Journal didn’t post after approvalSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…prashanth.r.r-Oracle 11 views 1 comment 0 points Most recent by thegouravarora General Ledger & Intercompany
-
How to update the DFF on a posted Journal line? System is not allowing.Summary: Manual Journals have been posted in the system and the period is closed. The user wants to update the Journal lines descriptive flexfield values for such journa…Divesh S 747 views 3 comments 0 points Most recent by Giuseppe Abatiello General Ledger & Intercompany
-
inquire Detail BalancesHi Team, In Inquire Detail Balances Report screen I am trying to put version and description field by swapping the fields from left to right or right to left and when I …
-
Rest or Soap API to enabled or disabled GL code combinationsDear , We need API to enabled or disabled GL Code Combinations Means through api we can enabled or disabled GL code combinations is there any API for that ThanksMirza_Adeel 11 views 3 comments 0 points Most recent by Muhammad Asif R General Ledger & Intercompany -
General Ledger journal reportsSummary: As per below oracle link, we are supposed to have a seeded report called Journal Reports that allows us to run and view journals by selecting specific journal b…
-
SQL to find the link between Intercompany transaction in AR and AP ?Summary: SQL to find the link between Intercompany transaction in AR and AP ? Content (please ensure you mask any confidential information): Hello I have the following S…Cesar Saveedra 497 views 2 comments 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany
-
How is the group ID logic work in GL_JE_BATCHESSummary: Hi, I have try to load a few sources i.e.Global Intercompany,Manual,Payables and Revaluation as below(highlighted in yellow) from FBDI and try to compare with t…yee lin ooi 133 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
Create GL Code Combination using webserviceSummary: Hi Everyone, There is one requirement to create GL Code combination dynamically while creating Movement Request using Webservice. Integration should check if Co…ROHIT CHARAYA 61 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Clearing account automatically reconcilliationDear all kindly find the below: I have done the clearing account reconciliation manually it is done i created a transaction in the journal ledger and went to do the auto… -
GL Retained Earnings Balance Update incorrect amountSummary: We noticed that one of the retain earnings account with one of the entered currency has a negative ending balance and the ledger currency has a positive balance…
-
Create extensible flexfields for journal.Hello, I have to create extensible flexfields for sales tax journal. Is is possible because I can only see DFF for sales tax journal. Please help.
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
Account Inquiry screen similar to EBSSummary: Account Inquiry screen similar to EBS Content (please ensure you mask any confidential information): User checking account inquiry in EBS system and they need s…