BI Publisher
Discussion List
-
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …Anup Karmankar 22 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 153 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP
-
How to join ra_customer_trx_all (AR Header Table) with projects tables to get the project NumberSummary: We are Trying to get the 'Project number' field in the 'Manage Transactions' Header Screen inside 'Billable' in Receivables. We are unable to find direct join t…
-
We need a tables or Query to get Opt-in Features for Financial in oracle fusionSummary: Hi Team, Could you please provide us the Query or Tables to get Opt-in Features for Financial in oracle fusion. We could find the below table, but these are not…
-
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 698 views 8 comments 0 points Most recent by PiyasaMandal1 Payables, Payments & Cash Management
-
4-Bucket parameter is not showing for Receivables Aging by General Ledger Account ReportSummary: 4-Bucket parameter is not showing for Receivables Aging by General Ledger Account Report Content (please ensure you mask any confidential information): Run Repo… -
How to replace invalid XML character (fffe)Summary: Due to invalid characters in Purchase Requisition header description (mostly likely due to requestor copied and pasted content containing this invalid control c…
-
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
Download Attachment File from Oracle REST API (HCM/SCM) without MiddlewareI was able to successfully retrieve the download URL from Oracle Fusion REST API within BI Publisher (Data Model only), and the link works correctly. However, when downl…
-
Need Guidance/References: Reporting Post-Approval Timecard Edits in OTLSummary: Hello Everyone, We have a requirement to build an OTL BI report that captures post approval timecard edits. Specifically, when an employee updates a timecard af…tejaswi kilaru 4 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Standard oracle functionality is not working when one custom button added in the Edit Journal Page.Summary: I have created one custom button in the Edit journal page name 'Validate' for a business requirement in my project. That custom button itself is working as expe…Arkaprabha Pal 12 views 1 comment 1 point Most recent by Gaurav Kumar-100036 Reporting and Analytics for ERP
-
New assignment alertSummary: We are using Seeded Alert for New assignment, whereas for Event its showing "Null" can some one help? Content (please ensure you mask any confidential informati…
-
BIP report layout hyperlink works with hard-coded parameter, but not with dynamic field valueSummary: I am trying to create a drill-through from one BIP report to another. The source report is a report created with the Layout Editor, and the layout file ends in …Sherie Ross 24 views 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 2 views 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 13 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 196 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 2 views 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 38 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM