BI Publisher
Discussion List
-
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… -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
Sql query for employment term numberSummary Does someone have a query for the employment term number?Content Hi, I'm really need an sql query for that shows the person number, person f.name, person l.name,…Yaniv 755 views 12 comments 1 point Most recent by Naryman Ismail-Oracle Reporting and Analytics for HCM
-
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
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 23 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 5 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 9 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 5 views 0 comments 1 point Started by Ajay Kumar Kotha Payables, Payments & Cash Management
-
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 248 views 4 comments 0 points Most recent by User_A4SYN Reporting and Analytics for HCM
-
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 193 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…
-
Can you send me a sample of email notification for payment approval workflowWe are not yet using the payment approval workflow. I only want is to see the format or template and details when we received the notification for approval.GRACE SORIANO 1 view 1 comment 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
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…
-
Report/Tables to extract User Role change History for every role assigned/revoked on a userSummary: Hi Experts, We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that …Abhinay Singh-Oracle 451 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
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…
-
Implement Badging in Oracle Learning Cloud and Integrate with talent profileSummary: We are looking to implement badges in Oracle Learning Cloud Content (required): Hi All, Our client is looking for implementing Badging functionality in Oracle L…
-
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 20 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 101 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 21 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 665 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 361 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…