BI Publisher
Discussion List
-
How to Extract the whole Transactional Data of Finance and ProcurementSummary: Want to extract the transactional data of Finance and Procurement which can be easily accessible and viewed via Excel. Content (please ensure you mask any confi… -
Overlaps with updating GL tables and BIP executionSummary: Overlaps with updating GL tables and BIP execution Content (please ensure you mask any confidential information): I am developing a BIP that outputs balances fr… -
Account Analysis Report - The report columns are shuffled in CSV format outputIn Standard Account Analysis Report - The report columns are not in a proper order in CSV format output. for every different parameter the some columns are shuffled. Ple…Thanigainathan R 4 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Error 500--Internal Server ErrorSummary: Error 500--Internal Server Error From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.5.1 500 Internal Server Error The server encountered an unexpected co…
-
Customization of Bank Statement ISO Processing Report (CE_ISO20022_2) CLOB FileSummary: Content (please ensure you mask any confidential information): We would like to customize the seeded bank statement template to include an additional attribute …
-
New record character in eText Template does not workI am creating a BIP report using etext template and filled in the format setup table in the template like the image below. (New record character: Carriage return) But wh…
-
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 1 view 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 1 view 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…
-
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 11 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 41 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 31 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 1 view 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 11 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 25 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 223 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