BI Publisher
Discussion List
-
Conversion RatesSummary: Conversion Rates Content (required): We have "MY IFRS Primary" Primary ledger ledger currency for this Primary ledger is "MYR" as we are creating a custom repor… -
Manage General Ledger Lookup Values - Seeded Export and ImportSummary: Manage General Ledger Lookup Values - Seeded Export and Import is not generating expected output. Need to design a custom report to generate output file similar…Rajeswari B 121 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany -
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 95 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 222 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 160 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 571 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 46 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 59 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 56 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 104 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 154 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 151 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 244 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 65 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 36 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 57 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 47 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 45 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 75 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 34 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 29 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 52 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…