BI Publisher
Discussion List
-
Can i restrict edit access to BI reports to those who creates itSummary: Hi Team, We have a requirement to restrict edit access to BI reports that a certain user has created it. i.e , The one who creates can only be allowed to edit i… -
Oracle Analytics Publisher Desktop Silent Install FailSummary: I have a requirement to install Oracle Analytics Publisher Desktop to client's machines via a silent install. When trying to perform this install with the synta…Johnny'sDaddy 101 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to check Memory Used Information for ReportSummary: We would do an enhancement for reducing the 'Memory Used' and 'Memory Read' for one BI report. However, we do not khow how to get 'Memory Used' and 'Memory Read…Abby Chen522 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
How to undo LTR Direction that impact Data Model and Reporting BI AnalyticSummary: Hi everyone, I'm seeking help. Has anyone ever used the 'Force LTR Direction' option in an RFT template? I clicked it by mistake and can't undo it Content (plea…Dinar 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Line breaks in RTF template with Excel outputSummary: I have a report with two datasets. The first dataset is joined to the second dataset in the data model designer. The report used is an RTF template, and when ex…Ayala01 51 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 21 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM -
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 71 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM -
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 342 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM -
How to create balance calculation date for the reportSummary: Hi , I am working on one requirement , where i need to add balance calculation date parameter to one of the existing report . User is expecting if they give fut…Vishnupriya 22 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Query to find fusion user details with their rolesI need to create a BI report which retrieves user information like user_id,username , email of the users along with their role information like role_id,role_common_name,…Rithu123 2.2K views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 138 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
Bursting Query errors outSummary: Report generated output in XML, but the bursting query errors out Content (please ensure you mask any confidential information): Waiting Time: 0.5 seconds Data …SukumarKondaveti 71 views 7 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
SUPPLIER BALANCE AGING REPORT Showing invoices in Unallocated AmountSummary: Needs to understand the current logic of this "Supplier Balance Aging Report Content (please ensure you mask any confidential information): The accounting event… -
Is there any work around to get audit detail of External application identifier using BIPSummary: As we don't have audit table for External application Identifier (PER_EXT_APP_IDENTIFIERS) Is there any work around to get audit detail of External application …ManjunathaKD 32 views 7 comments 0 points Most recent by Ganesh Aithandal Muralidhar Reporting and Analytics for HCM -
Need fetch past date absence plan balanceSummary: Need to fetch past absence balance Content (please ensure you mask any confidential information): My requirement is to perform inbound integration via OIC from … -
Need a table for Payment Document Category in Manage Bank account setupSummary: Hi Team, We need a table where the information of "Payment Document Category" meaning stored. There is a column PAYMENT_DOC_CATEGORY in CE_PAYMENT_DOCUMENTS but… -
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a… -
BI Report for Job Requisition Approval FlowSummary: BI Report for Job Requisition Approval Flow containing full approval flow related data. Content (please ensure you mask any confidential information): Hi expert… -
How to get Column headings to repeat across multiple pagesSummary: How to get Column headings to repeat across multiple pages Content (please ensure you mask any confidential information): Hello all - I am struggling to setup m…KDR 71 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP -
Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Summary Is "EDI Location Code" available for Reporting in Customer Real Time Subject Area?Content Is "EDI Location Code" available for Reporting in Customer Real Time Su… -
Error: SQL query time exceeds the limit(500 sec). Stopped processingSummary Error: SQL query time exceeds the limit(500 sec). Stopped processingContent Hi All, Error: SQL query time exceeds the limit(500 sec). Stopped processing. I am un…Devendra Thota-220620 2.3K views 8 comments 4 points Most recent by Shyam Patel Reporting and Analytics for SCM -
Generate SAFT Data ExtractHi, We got some of the requirement for SAFT data extract report. For that we need to customize the SAFT extract. But we observed this report is of JAVA job type and we n… -
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… -
Expense Approval Report - how to show stops in between destinationSummary: Content (please ensure you mask any confidential information): Hi all, I have been trying to modify the seeded Expense Approval Report by adding any stops taken… -
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 1 view 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Report for specified pay period that shows time card hours paid and costsSummary: I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real ti…Giselle Valdovinos 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Third-Party Control Account Balances Report - Include Zero Amount BalancesHello, In the Third-Party Control Account Balances Report there is a parameter with name "Include Zero Amount Balances", you can select either Yes or No in this paramete… -
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM