BI Publisher
Discussion List
-
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 477 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 121 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 32 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 11 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 64 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 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add a custom report in the custom application createdSummary: we created a custom application under ¨About Me¨ for employees but we are not able to add a custom report to display there. any idea on how to add the content i…
-
Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL table?Summary: We need a field that captures the accounted amount equivalent of the AMOUNT_DUE_ORIGINAL field from AR_PAYMENT_SCHEDULES_ALL table. Content (required): Hello, W…Kristelle 121 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Distributed Amount for direct report - cannot find field in analysisHello, This is the module compensation. Navigation --> Compensation>Act as proxy manager>Manage Budgets I am not able to retrieve the 48142.80 for the 11 direct reports …
-
Filter function in case statement in otbi columnIn my otbi analysis, I tried to add this formula in my column CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet…
-
BIP email's font appear diffrent within gmail than outlookSummary: Customized email's fonts appears diffrent Content (required): I'm designing a BIP template with the kind of rtf format. I'm designing one of the journeys OOB re…Peleg Puzaylov-Oracle 21 views 5 comments 0 points Most recent by Peleg Puzaylov-Oracle Reporting and Analytics for HCM
-
can we create one certificate for course and specialization with same DM?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
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 222 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to hide parameters in csv output and change data formatHi All, I'd like to create a report which output type is csv. After the output file was generated, I found the parameters of report are included in the output file and o… -
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 21 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Why bursting from BI Publisher sends emails to 1 domain and not the other?Summary: Why bursting from BI Publisher sends emails to one domain and not the other? Content (required): I created a BI Publisher report having bursting object on it. I…Stefano_Mazzocca 51 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Source Table for Manage Common Options for Payables and Procurement:Summary: Need Help on Source Table for Manage Common Options for Payables and Procurement: Pls see below screenshot of the screen.. Content (required): Given the Busines…JSalarza 345 views 1 comment 0 points Most recent by Danieleeeeee-Oracle Reporting and Analytics for ERP
-
How to query email of a user account which is not linked to any person record?How to query email of a user account which is not linked to any person record? In this case person id can be null in per_users table and we can't join it with per_email_…Ankit_Bhadja 1K views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM