BI Publisher
Discussion List
-
Project field is blank for below querySummary: WITH hours_data AS ( SELECT prr.payroll_assignment_id, prr.run_result_id, TRUNC(prr.ora_part_key) AS trx_date, SUM(TO_NUMBER(prrv.result_value)) AS hours FROM p…Rajeswari Thanubuddi 1 view 0 comments 0 points Started by Rajeswari Thanubuddi Reporting and Analytics for ERP -
Report Name Change ImpactsSummary: We have some reports in OTBI & BI which have a prefix of a Company and the name is changed - just a letter - XYZ to XY1 - so can anyone advice on the below Do w…Sailajad 11 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How Payables gets the Remittance Email for Customer Refunds?Summary: How Payables gets the Remittance Email for Customer Refunds? Content (required): We are creating CM in AR and issuing refunds in payables. We need to send remit…
-
Is there a scheduled process (or other way) that we can update a payment type change to flow throughOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): MTB Description (Required): Is there …Ajay Kumar Kotha 3 views 0 comments 1 point Started by Ajay Kumar Kotha Payables, Payments & Cash Management
-
Oracle BI Report > Parameter based on LOV having string limitationsSummary Oracle BI Report Parameter dissappeared due to long string value on listContent Hello Community and experts, I am building a BI report based on a SQL query, and …Robinson Antunez 194 views 10 comments 0 points Most recent by Rosita Santosuosso Reporting and Analytics for ERP
-
GL-HUB-AP report takes too long to runWe have a report which pulls GL, Hub and AP data by journal line level, it takes a long time to run since it is going back into Hub, which has +1mn transactions per day …James Coles 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
HDL upload marking Learner Assignment as 'Bypass Completed"Summary HDL upload marking Learning Record Assignment as 'Bypass Completed"Content Hi Experts, We have used the HDL upload functionality for few Learning Records history…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
Dynamic Header generation in RTFSummary: Is there a way to create an RTF or Excel template that allows us to dynamically populate the header? Content: The requirement is to fetch pre‑screening question…
-
UI bug: "All" vs "Tout" in BI Publisher Multi-Select Shuttle componentHi, We have a BI Publisher parameter with Multiple Selection and Can Select All enabled. The search dialog (shuttle component) behaves differently based on the user's se…
-
How to reconcile the subledger journals between primary and secondary ledgersHi There Recently we are trying to develop a report to reconcile the journals between primary and secondary ledger. The clients are now using the subledger conversion le…Alex.s.li-Oracle 103 views 2 comments 0 points Most recent by ManasaP Subledger Accounting & Accounting Hub
-
How to default logged in user to BI report parameter?Summary: Default logged in user to BI report parameter Content (please ensure you mask any confidential information): Hi, We have a custom BI report, that has a paramete… -
Report is taking some time to reflect changed dataSummary: We are noticing that reports in Oracle Fusion HCM are taking considerable time to reflect updated data. For example, when changes are made in the application or…PranjalM 36 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives … -
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…Praveen Chandra-Oracle 668 views 5 comments 5 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM
-
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 376 views 6 comments 0 points Most recent by Neha Thakre 2023 Reporting and Analytics for HCM -
Lack of Documentation for ORA_ACTIVE Code in Learning Notifications (26A Update)Summary: Hi All, We’ve recently observed a change in Oracle Learning notifications as part of the 26A update. Specifically, the ORA_ACTIVE code has now been introduced w…
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…Sreeram V 6.3K views 11 comments 0 points Most recent by Nazir Hossain Reporting and Analytics for HCM
-
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
Swiss QR-Bill on customer invoicesSummary: Oracle EBS R12.1.3 We need to print Swiss QR code on invoices sending to customer as Swiss QR Bill requirements. I did not find any solution in Oracle for this.…
-
Required table for "Direct Apply" section under the task "Recruiting Category Enablement"Summary: Hi Team, We are unable to find the table for the field "Direct Apply" under the setup task Recruiting Category Enablement. The main table are IRC_TP_PARTNERS, I…Opkey PA 2 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Can anyone suggest me how can I pull Requisition Hierarchy in Report in fusion HCMSummary: I want to capture all approver in the report. Can anyone suggest me how can I move. Content (please ensure you mask any confidential information): Version (incl…Rohit_Verma 11 views 1 comment 1 point Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
-
Need Table details for Subledger Journal Batch Description in 25DSummary: Subledger journal batch description is showing in UI (review subledger journals page) as 'Payments'. We have checked xla_ae_headers, lines, events and transacti…AbdulBasith 53 views 3 comments 0 points Most recent by Sundara Meenakshi Subledger Accounting & Accounting Hub
-
Funds Capture Batch Acknowledgments FormatsSummary Unable to find the Format to customize or to review the structure of the file formatContent Hi, we are not able to find any format listed for "Inbound" formats u…
-
How to find the difference between two date attributes in eText templateSummary: We need to find out the difference between two dates and add 1 to the result in eText template. Content (required): We need to find out the difference between t…Meenakshi K 1.2K views 8 comments 0 points Most recent by Chiranjeevi Boya Reporting and Analytics for HCM
-
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…User_2025-02-07-07-19-13-925 156 views 5 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
SQL to get the list of all tax codes definedSummary: Hi, Can anyone please share the SQL to get the list of all tax codes defined. Or are you aware if there is any standard reports which is available that can prov…
-
Standard Purchase Order Report sub template logicSummary: Hi Team, Theres a subtemplate being called in PO template rest of contents in rtf template has english content with fields no language specfic condition. but w…