BI Publisher
Discussion List
-
What is the Logic behind "Average Balances Trial Balance Report"?Summary: What is the Logic behind "Average Balances Trial Balance Report", also looking "GL_TRIAL_BALANCE_AVG_RPT_PKG" package. Content (required): Logic for the calcula…Naushad15 81 views 2 comments 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
Withholding tax base on rateSummary: withholding tax report, invoice with withholding base particular rate Content (required): transaction date, withholding rate and amount, invoice number Version … -
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 208 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Can someone help me with the query for customizing the trial balance report.Summary: Currently i am trying to customize the oracle standard trial balance report for fetching the YTD,PTD and QTD balances. Need someone who can help with the logic …Rudraksha Vishnu 144 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany -
GL_PERIOD_STATUSES in BIP not up to date?Hi Guys I must be doing something wrong because I am not seeing the same values in the oracle backend database via BIP that I am seeing in the Oracle Front End. In the f…
-
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 546 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Table gl_je_batches not up to date in BIP?Hi Guys I have an issue today when accessing table gl_je_batches via BIP, I am not seeing the very latest batches in there which I know have been created because I can s…
-
Spain SAF-T chart of accounts mapping requirements. ?Summary: Spain SAF-T chart of accounts mapping requirements. ? Content (required): Hello Will you please let me know the mapping and report requierements ? If you can sh…martingabriel Kinovisques 43 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Is there any Oracle seeded report which shows reconciliation status as one of its column?Summary: Oracle seeded report showing "Reconciliation status" (Reconciled/Unreconciled) as output. Content (required): Oracle seeded report showing "Reconciliation statu…User_2025-03-10-17-00-26-818 55 views 1 comment 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany
-
What the the tables containing the daily balances for all code combinations and cat codes?Summary: What is the table containing the daily balances for all code combinations and cat codes? Content (required): Hello, I understood that in JD Edwards it is a tabl…Teodora Bulancea 52 views 3 comments 0 points Most recent by Nitin Kumar05 General Ledger & Intercompany
-
FEC - Audit report for France - huge data problemSummary: FEC - Audit report for France - huge data problem Content (required): We are concerned about the high volume of data generated by the FEC ( Audit report for Fra…Patrick Chrabieh 109 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 138 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Localization Report for TurkeySummary: Need E-Ledger Report for Turkey Content (required): Hi All, We have Turkey localization and below reports are required: Quarterly Advance Tax Declaration (Incom…Jakeeagarwal 145 views 2 comments 0 points Most recent by Jakeeagarwal General Ledger & Intercompany
-
After Upgrade 23A Account Analysis Report is emptySummary: Scheduled update was made for 23A and when generating the report Account Analysis with any account and parameters does not return data. Content (required): Sche…Yerwin Blanco 241 views 1 comment 0 points Most recent by Haripriya-Oracle General Ledger & Intercompany -
Join Subledger Tables to AP_INVOICE_DISTRIBUTIONS_ALLSummary: I'm not sure if this belongs more in the Reporting forums, however I am looking to join any of the following Subledger accounting tables to the AP_INVOICE_DISTR…
-
Need Journal Posted By detailsSummary: We need a a field that maps with Journal Posted by details Content (required): In EBS JE_Batches table we have Posted by field available. In fusion we don't hav…Raavi Srikanth -Oracle 61 views 3 comments 0 points Most recent by Raavi Srikanth -Oracle General Ledger & Intercompany
-
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI Publisher for reportingContent WRS vs BI PublisherWhere is it recommended to develop a complicated financial report with compairsons Oracle BI Publsihe…Umer.Farooq 34 views 2 comments 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany -
Regarding Alternate Fusion Application function for XLA_CONDITIONS_PKG.DISPLAY_CONDITIONSummary: Hi Team, We are migrating a few reports from EBS to Fusion and we have found that the XLA_CONDITIONS_PKG.DISPLAY_CONDITION function is not available in the Fusi…Ankit GML 53 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Close Monitoring and outstanding subleger TransactionSummary: Hi, close monitoring and outstanding subledger not cover the customer requirement , is need one dashboard for monitoring 9 business units and ledgers , my custo…Mahgoub S.Mohamed 41 views 1 comment 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany -
Journal ApprovalSummary: Report that reflects Journal Approval Content (required): Is there any report or sql that reflects the approvers of GL Journals. Looking for an approval report …CraigX 42 views 2 comments 1 point Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany
-
JE_Lines_ DFF in OTBISummary: JE_Lines_ DFF in OTBI Content (required): Which of the GL subject area can I find the DFF when creating an Analysis? Will the field name listed as Atribute1,2,3…CraigX 63 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Ledger & Intercompany
-
Override AP Transaction not captured by Budgetary control ModuleSummary: Hi All, Please note that actually when I'm proceeding with Override of a transaction in AP module same is not being capture in the Budgetary Module. For example… -
User GUID populated for field Created byHi All, We would like to understand why user GUID is captured for few records in GL_CODE_COMBINATIONS table and for few records we have username populated. We could see …Swapnil Kashid 31 views 1 comment 0 points Most recent by Cezar - Fusion Oracle Support-Oracle General Ledger & Intercompany -
Need to schedule a BI Publisher report to run on Business Day2Summary: Need to schedule a BI Publisher report to run on Business Day2 Content (required): How to schedule a BI Publisher report to run on Business Day2 from schedule p…User_2025-02-11-23-30-56-074 23 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri General Ledger & Intercompany -
Manual Set up or use of Rapid Implementation file for loading chart of accounts, hierarchies, legalSummary Manual Set up or use of Rapid Implementation file for loading chart of accounts, hierarchies, legal entities, accounting calendar, primary ledgers, business unit…
-
Restructuring Oraganization - Restructuring HierarchiesSummary: We are restructuring the organization. Currently, we have the cost centre hierarchy based on business areas which would be demised going forward. New business a…Tousif A 51 views 3 comments 0 points Most recent by User_2025-02-10-18-44-43-184 General Ledger & Intercompany
-
Which roles are required to get BI Administration Privilege.Summary: I want to grant access to other users so they can have access to standard oracle intercompany reports in BI Catalog. For that I need to assign myself a role whi…
-
Budget Data from PBCS for Reporting (not control) - what reports exactly is it visible in?Summary: When you load budget data from PBCS to Fusion Financials General Ledger for reporting (not control budgets) can anyone confirm exactly which OTBI subject areas …User_2025-02-10-15-12-48-631 11 views 2 comments 1 point Most recent by User_2025-02-10-15-12-48-631 General Ledger & Intercompany
-
Journal Issue - "No sequence version is enabled or defined for sequence **** XX GL Accounting SequencContent Hi Guys I would just like to inquire if anyone of you have encountered this kind of error for created journals? Please kindly refer below "No sequence version is…User_2025-02-11-12-30-38-982 271 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany