BI Publisher
Discussion List
-
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed… -
Creating ESS job set's to parameterSummary: Hi Everyone, I hope all doing well out there! I have a BIP report, using which team is extracting output for 9 countries. now user is asking to automate it to a…VasanthaFusion90 21 views 4 comments 0 points Most recent by VasanthaFusion90 General Ledger & Intercompany
-
From custom BI report Can we add 'From and To date' for seeing GL balances with backdated.Hi All, Business wanted to have one custom BI report for seeing GL balances and in that they want one parameter that is 'From and to date' to see the GL Balances with ba…Vasu N0897645321-Oracle 1 view 1 comment 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
Unable to find the Purge interface table import process nameHi Team, One user scheduled Purge Interface table ess program on weekly basis and the user was left the customer organization (User end dated) . Due to this the schedule…Somasekhar Basetty -Oracle 41 views 2 comments 0 points Most recent by Gianni Carrero General Ledger & Intercompany
-
GL Account Analysis ReportSummary: Can you please share the values to be passed for the table name parameters of the GL Account Analysis Report Content (please ensure you mask any confidential in…Aishwarya Penchala-Oracle 2 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Query to retrieve entity code and gl account code from oracle fusionI need to develop a query to retrieve both entity code and gl account code from oracle fusion tables. But unable to link both the tables. Can anyone please help in devel…
-
Custom ESS job is running long for one particular userWe have custom ESS job which is running long for one particular user. For other users it is completed in 3-5 mins for the same parameters.(Both users are having same set…Thanigainathan R 4 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle General Ledger & Intercompany
-
Table to get Natural Account segment hierarchy in Oracle FusionSummary: Looking for Table to get Natural Account segment hierarchy in Oracle Fusion Content (required): I am trying to retrieve GL balances using SQL query in data mode…
-
implement Segment Value Data Security (SVS) in BI Publisher ReportHi All, Could someone provide insights on how to implement Segment Value Data Security (SVS) in a BI Publisher Report on the GL budget balance table? We have a requireme…
-
What would cause a journal batch to go from STATUS_VERIFIED='Y' to STATUS_VERIFIED='N'Hi Guys We have a BIP report based on journal batches/headers/lines developed by an outside consultancy that has the filter below on it: GJB.STATUS_VERIFIED='Y' All good…
-
How to auto-increment the accounting period on Trial balance report in BIPSummary: We have General Ledger Trial Balance in BIP and every month, end user needs to change the accounting period. Is there a way to auto-increment the accounting per…TBIRD1 16 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Chart of Accounts Hierarchy Sort Order Field NameSummary: I'm building a custom BIP data model and report and I'm looking for the User-Defined hierarchy Sort Order field name info (table, field) schema = FUSION Content…Emile Helegbe 42 views 3 comments 0 points Most recent by Emile Helegbe General Ledger & Intercompany
-
How can we fetch the pdf output of the Journal Details Report using OICSummary: We are trying to send the pdf output of Journal Details report(report which gives detailed summary of FBDI load) using OIC. And as this ESS job output doesn't g…Abhinav Patil-Oracle 29 views 3 comments 0 points Most recent by Abhinav Patil-Oracle General Ledger & Intercompany
-
How to output GL Amount for two months with parameter?I need to output GL amount for two months with BIP. There should be one parameter for setting Period. Then I need to output GL Amount for the month set by the parameter …Ayumi 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can we customize the GL Journals seeded report to add a bursting query to send its output to ucmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Abhinav Patil-Oracle 1 view 2 comments 0 points Most recent by Abhinav Patil-Oracle General Ledger & Intercompany
-
What's the best way to view a report of journal submitters and approvers?When we want to view a report of journal submitters and journal approvers, we run the Journal Approval Rules Report and the Approval Groups Report. But is there an easie…
-
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…
-
Data missing in xla_transaction_lines tableWe could see the data available from 07-Nov-2024. Previous dates data are missing. Is there a automatic purging happening ?
-
Print Receivables Transactions not sending print job to printerSummary: Print Receivables Transactions process creates output but it is not being printed. Content (please ensure you mask any confidential information): When we run th…RSongco 16 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
BIP Account query to get the rollup data in a a rowSummary: BIP Account query to get the rollup data in a a row Content (please ensure you mask any confidential information): Account 1 has rolled up to child 8, child 8 r…NarenInova 17 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Validate cross validation combination set in a BIP reportSummary: We have developed a BI Publisher report to validate the account combinations against the cross validation rules (CVR) using the PL/SQL API fnd_flex_ext.get_cvr_…
-
Deep link documentation for GL (and Financials)Summary: Where can we find the documentation for deep links for GL? Content (please ensure you mask any confidential information): Where is the detailed documentation fo…TyskJohan 205 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
General LedgerI' like to output the SEGMENT values (SEGMENT1~12) registered in GL that have an enabled flag of 'N', column by column. To achieve this with BIP, which table should I re…
-
GL Audit Trail Report not availableHi All, I am just trying to run the GL Audit Trail Report by below path, but report is not available. Steps to Search in BI Catalog: Go to Reports and Analytics > Browse…
-
how to fetch entered balancesSQL Query to identify Entered balances in Oracle Fusion tables.Suvodeep_Saha_98 11 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
Turkey E-ledger requirementSummary: Hello Team, Our customer requires Turkey E-Ledger report to be developed as part of Turkey Localization. Please check and let us know if we have any out of box …Narayanan M S-Oracle 29 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
SQL Query for Journal entries details and APInvoice table joinSummary: Need help on SQL query for the Journal entry details and Invoice details Join together. In the below screen shot we need highlighted information. I have written…
-
How do I add location and brand segments to a Cost Summary report for fixed assets in Oracle Fusion?Summary: I would like to customize a seeded report found in Oracle Fusion by adding brand and location segments by updating the data model. Content (required): Version (…
-
Is there a way to get the latest data from the GL_FRC_REPORTS_B tableHi, I need to retrieve the latest data from the GL_FRC_REPORTS_B table. When I queried the table, the results did not match the expected original data. Could anyone assi…Keerthana Sekar 5 views 1 comment 0 points Most recent by Keerthana Sekar General Ledger & Intercompany
-
SQL Behind the package JEFR_JELINES_RPT_PKGWe are trying to write the custom SQL for creating a custom report, in order to fetch the details in BIP report. In order to achieve the same, could someone please assis…Mohd Saqib 32 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany