BI Publisher
Discussion List
-
What is the Table name to fetch Comments & Attachment posted in Allocated TaskSummary I want to know the table name which stores the comments & attachments which are added by the Approver while marking a allocated task as completeContent I want to…VinodKumar 675 views 6 comments 0 points Most recent by Stephan Steup - ITUP Reporting and Analytics for HCM -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…RamkumarKadhiravan 71 views 8 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio…Abhilash K - Deloitte USI 23 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
The user request exceeded the maximum query governing execution timeSummary: The user request exceeded the maximum query governing execution time Content (required): Hi Team, Greetings! We get error on OTBI report as 'The user request ex…Parag Hiremath 135 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
I see only few terminated PPRs in the iby_pay_service_requests tableSummary: When I check in the application, there are around 15 terminated PPRs available. But when I query , I see only 7 in iby_pay_service_requests table Content (requi…Lakshmi Bandlamudi 41 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 322 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …Guillaume SAVALL 31 views 2 comments 1 point Most recent by Guillaume SAVALL Reporting and Analytics for ERP
-
Conversion RatesSummary: Conversion Rates Content (required): We have "MY IFRS Primary" Primary ledger ledger currency for this Primary ledger is "MYR" as we are creating a custom repor… -
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
Is there a plan to lengthen the BIP audit log data of 90-day retention period to, say, 180 daysSummary: We would like to ask if Oracle Product Team has planned to lengthen the 90-day retention period for BIP audit log data. Content (required): Audit Log Version (i…
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…Sharmava 271 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Is there any table/way to find the tables used (data set details) in BIP reportSummary: Is there any table/way to find the tables used (data set details) in BIP report Content (required): Hi Team, Greetings! Is there any table/way to find the table…Parag Hiremath 932 views 16 comments 0 points Most recent by HarshithDarla Reporting and Analytics for HCM
-
Looking for a Workflow transactional Report where Self Approval is enabled.Hi Team, I'm Looking for a Workflow transactional Report where Self Approval is enabled. Either the report should let me know about on which workflow rule self approval …
-
Expense Approval Notification Template not picking the Locale templateSummary: We have a requirement to show Expense approval notification template both in English and French based on the Preferences set at the user level. Expense approval…
-
Print Receivables Transactions request to run by transaction and/or customerSummary:Hi we had an issue recently where someone ran the above request and did not narrow their request by transaction number or customer. The result was that thousands…
-
BI Publisher reports now timing out (previously working)Summary: I have two BIP reports that were created several years ago that are now timing out. They began failing around the beginning of September 2023. Content (required…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co…sailesh_cloudare 471 views 1 comment 2 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…kalyan gade 101 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Manage General Ledger Lookup Values - Seeded Export and ImportSummary: Manage General Ledger Lookup Values - Seeded Export and Import is not generating expected output. Need to design a custom report to generate output file similar…Rajeswari B 126 views 2 comments 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
query to get current logged in user_id in BI publisher reportSummary query to get current logged in user_id in BI publisher reportContent Hi Experts, how to get current logged in user_id in BI publisher report. Thanks, PradvinPradvin Prabhakar 5.4K views 7 comments 2 points Most recent by MastekLtd Reporting and Analytics for HCM
-
User with employee role can access the BIP report.Currently we are observing that user with employee role can access the BIP report from report and analytics. Employee role is providing the privileges to user to access …Anusha Raghav Naik 31 views 1 comment 0 points Most recent by Karun Jain-Oracle Payables, Payments & Cash Management -
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
How to fetch learning community access group details?Hi everyone, I have a requirement to fetch the learning community access group details like, Community Access Group Name, Community Access Group Learner Count and Commun…Prashanth Sangram-Oracle 13 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
What HCM table can I use to get the future Line Manager?Summary: I'm checking if I can use the BIP Bursting feature to send details which includes tasks to the worker's future LM once the transfer is approved. The client want…
-
How to get access group details from Learning Page.Summary: Hi All, I'm trying to fetch Access group details along with the below query. In which table can we find that and how to join with Learning tables? Code Snippet …
-
Which tables store the Weekly Working Hours data?Summary: Which tables store the Weekly Working Hours data? Version (include the version you are using, if applicable): 23BLuke.Findex 69 views 4 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Oracle BI Tables for compensation plan columnsSummary: Content (required): Hello experts, do you know which Oracle HCM BI Tables store compensation plan user-defined columns (custom numeric and text column); Compone…Valerio Curzi 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM