BI Publisher
Discussion List
-
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 141 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 533 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 42 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 54 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 101 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 134 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 144 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…Umer272 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 51 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 42 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 41 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 61 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 21 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 272 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany
-
FBDI - Hierarchy Error MessageContent Hi All, Attached is the screenshots of the FBDI I need to use, on validating the segment Hierarchies (GL_SEGMENT_HIER_INTERFACE), I am getting error messages lik…Kanika Mahajan 218 views 2 comments 2 points Most recent by Aishwarya Thapar-Oracle General Ledger & Intercompany
-
eText Template File for Journals Import InterfaceSummary Looking for an existing eText Template to use for importing journal entriesContent Has anyone created an eText Template for the Journal Import Interface that can…Meredith Bickell 33 views 5 comments 2 points Most recent by Meredith Bickell General Ledger & Intercompany -
How to call GL Journal Load Webservice in a SaaS environmentSummary How to call GL Journal Load Webservice in a SaaS environmentContent We have a requirement of calling the GL web service, we are able to load this using SOAP call…Sam Samaddar 92 views 3 comments 2 points Most recent by Daniel Perez Soto General Ledger & Intercompany