BI Publisher
Discussion List
-
How To get Cancelled Invoice Amount in AP Invoice in Oracle FusionIs there any ways to retrieve Cancelled AP Invoice Amount in Oracle Fusion Using SQL Script.EPNSLsupport 438 views 4 comments 0 points Most recent by EPNSLsupport Reporting and Analytics for ERP -
Can we default a parameter with dynamic value in ESS Job definition?Hi, We have a custom ESS Job defined for a BIP Report with a parameter Period Name and attached a custom LOV data source defined which lists the periods from gl_periods.…Rajendra Kona 438 views 2 comments 1 point Most recent by Rajendra Kona Reporting and Analytics for ERP
-
ZIP and PDF inquiries for Oracle BIPSummary: 1. We are trying to create bursting email which sends 1 zip with multiple pdf(separated by invoice). 2. In history we have a consolidated output which has 1 zip…
-
How to Display Date and Time as per User Local Settings in Excel TemplateSummary We need to display the Date and Time as per the User Regional Settings. We need to know how to use the XDODEFDATE and XDODEFTIME in Excel TemplateContent Our Req…Balachander G-Oracle 402 views 4 comments 1 point Most recent by Abhiengine Reporting and Analytics for ERP
-
How to escape double quote character in .csv file of BIP ReportSummary: We have enclosed few columns of the BIP report within double quotes and output is expected in a csv file. This will overcome the columns having comma getting sp…Rakesh Soma 632 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionWe are getting timeout error while Querying GMS_XCC_BUDGET_BALANCE_V results in timeout error in FusionAbhilash K - Deloitte USI 51 views 8 comments 0 points Most recent by Simon Hong Reporting and Analytics for ERP -
The Picture can't be displayed error in multi sheet excel templateI created an excel template which has multi tabs created dynamically. Logo in first tab displays fine while in rest of the tabs it displays error The Picture can't be di…Aakancha 33 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
BI Publisher - reference another group value from within a nested grouped areaSummary: BI Publisher Template: Reference a high level value from a lower level repeating group Content (required): I have a repeating group in an rtf template using BI …Robert of STAU 1.1K views 1 comment 0 points Most recent by Michael Angelo Lucena Reporting and Analytics for ERP
-
how to display clob data in oracle in readable formatSummary: My results are not as expected even i I followed the below link https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6C8C333C-FF56-4376-9914-C298DF0DCE83.htm…Rama Krishna Annam 42 views 6 comments 1 point Most recent by Viswanadh Reporting and Analytics for ERP
-
Is there any table to store the data model SQL query used while creating a reportSummary: Want to identify a particluar condition being incorporated in all the BIP data models ,once identified it can be replaced as per the requirement . Otherwise we …Hitesh Jasuja-Oracle 59 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Can provide READ ONLY option for report/ layout and data modelSummary: Can provide READ ONLY option for report/ layout and data model Can provide READ ONLY option for report/ layout and data model?Narendra Prasad Golla 32 views 2 comments 0 points Most recent by Narendra Prasad Golla Reporting and Analytics for ERP
-
SQL query tunningHi, I have developed a sql query to get the balance for a couple of months ( it may be up to 12 months) and it's taking more than 40 mins and ended up with timeout error…
-
Unpaid ReasonSummary Unpaid ReasonContent Which subject area and/or database table and column would store the "Unpaid Reason"? I am looking to create a report with this field. Thanks…Andrew_Schmitz 144 views 6 comments 2 points Most recent by __KumR__ Reporting and Analytics for ERP -
How does user level data security work in Fusion Financials BI PublisherSummary: Trying to confirm if I understand the correct way data security works for BIP reports in Fusion as its not working as expected Content (please ensure you mask a…
-
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…User_2025-02-07-23-45-47-870 486 views 7 comments 1 point Most recent by User_A19YQ Reporting and Analytics for ERP -
Slowness of report after upgrade to 23DSummary: A report which ran in less than a minute in 23c is taking 12 mins to complete for the same data post upgrade to 23D. We had 23D upgrade in all non-prod PODs and…Abhilash K - Deloitte USI 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
How to merge customer names with transactions in a grouped SQL query?Hello, I have this customer ABC having multiple transaction i want to merge the cells that have the same customer name and make it appear one time, i am using select fro…Omran Zeaiter 32 views 1 comment 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Burst to multiple destinationsSummary: Burst to multiple destinations Content (please ensure you mask any confidential information): Hello - We use Fusion BIP application for ERP. I wanted to know if…
-
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se…
-
Custom report for Invoice approval workflow detailsSummary: Custom report for Invoice approval workflow details Content (required): Hi All, We got a requirement to develop BI report to show AP Invoice approval details li…
-
Budgetary Control Purchase Order Life Cycle Custom ReportSummary Use this report to analyze a purchase order life cycle and its impact on budgetary control balances.Content The Budgetary Control Transaction Life Cycle report i…Anne Wong -Oracle 195 views 1 comment 5 points Most recent by Mr.Bilal Reporting and Analytics for ERP -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 71 views 3 comments 1 point Most recent by Renganathan V Reporting and Analytics for ERP
-
Not able to execute report from "Financial Reporting Center"Hi, I have developed a custom report and able to generate the data without any issue if i run from "Report And Analytics" but report execution is failed from "Financial …Madhu A 6 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
What are the Table names for fields "Other Communication Accounts" and "Order of Preference"Content (please ensure you mask any confidential information): What are the Table names for fields "Other Communication Accounts" and "Order of Preference". Need to fetc… -
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
Republish option not enabled in scheduled BIP reportsIn some of the scheduled BIP reports with excel template, the 'Republish' option is not enabled. Even after checking Save Data for Republishing, clicking on 'Republish' …Sharmava 57 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…Nidhi Chhajed 1.3K views 8 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP
-
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when …