BI Publisher
Discussion List
-
How to stop BI Workflow Notifications (Personal Information - Disability Info) in Fusion HCMSummary: A BI notification is triggered when an employee enters Disability Info (Navigation Person Details -> Disability Info). We can see there are a couple of seeded B… -
How to bursting a report with multiple data sets ?Hi all, I have a BIP report with multiple data sets to query different data to different excel sheets. I'd like to use bursting function on this report, but I found that…Weitao 901 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
BI Report to show all Employee/Manager HierarchySummary BI Report to show all Employee/Manager HierarchyContent Hi Community I am trying to build a report which shows all employees and their managers.. I need it to sh…Kunal Daya-175386 521 views 3 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
How to create an OTBI Report to display GL Parent/Child values ?Summary: How to create an OTBI Report to display GL Parent/Child values ? Content (please ensure you mask any confidential information): Hello I would like to have a Cha…Cesar Saveedra 301 views 2 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for ERP
-
Query behind 'Review Budgetary Control Transactions' the UI pageSummary: I am looking for the code behind the 'Review Budgetary Control Transactions' page as my requirement is to create BIP report with the same columns in the page. I…
-
organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesSummary organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesContent HI Team, report has to be developed in the column format parent_n…Hanuman Chennamsetty 3.3K views 3 comments 2 points Most recent by Shrikant Gupta Reporting and Analytics for HCM
-
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 89 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Can anyone help in sharing an idea for developing contra account report.Summary: For example, if in parameter, an account is selected, all relevant Debit and Credit which were generated against that account gets reported. Content (required):…Usman Ul Haq 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 563 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…Janardhan ACS-Oracle 51 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Hiding Schedule and Job from BIP report part of dashboardSummary: Hiding Schedule and Job from BIP report part of dashboard Content (please ensure you mask any confidential information): Hi, We've a BIP report part of a dashbo…Bhavna-Civeo 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Query to find Ownership type of candidate pool(Private, Shared, Global)Summary: I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, ther…Sujay Bhowmick 81 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Formatting issues in excel template for BIP report (formatted as number in data model but is text)Summary: So, we have a BIP report which details the amount for various pay elements, the element name is hard coded in sub select clauses so we can control the column or…
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 61 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
OPSS Audit Report BIP TablesSummary: What are the Tables used in the Oracle Platform Security Services (OPSS) Audit Reports? Need for a BIP Report Content (required): Hello everyone, I have a repor…Tom John Bontoyan 31 views 2 comments 1 point Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 2 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Syntax To Pass Dynamic Parameters in Custom LOVs for ESS Jobs parametersSummary: We have created an ESS job which has 2 parameters : Business Unit, Contract Number For the Business Unit Parameter we are using the standard LOV. But for Contra…KannanM 154 views 3 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
unable to see data in IEX_BANKRUPTCIES table any standard report available?Summary: Unable to see data in IEX_BANKRUPTCIES table , is there any specific job role to view the data in this table or is there any specify bankruptcy report available…
-
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the…
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 187 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th…User_2025-01-25-00-55-11-011 1.7K views 8 comments 1 point Most recent by GAVMAX Reporting and Analytics for ERP -
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 342 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
How to print tables side by side in BI publisherHi, I was trying to develop a rtf template to print the Invoice copy. As part of the requirement, I need to print tables side by side. I was able to add the tables side …AVN 162 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Report to extract Assessment Questionnaire of Learning sectionSummary Need to extract assessment questionnaire of an offering linked to a learnerContent Hi All, I am trying to extract the assessment questionnaire with the answers i…teresa.marciano 734 views 3 comments 1 point Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBISummary Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBI or BIP?Content Hi Experts, We are working on a requirement to…Harish Kumar Kovi 197 views 4 comments 0 points Most recent by 'Reekey Reporting and Analytics for HCM
-
Oracle BIP Report -> Timezone Issues (displays +5 hrs)Summary timezone offsetContent Hello, Can anyone please help me? I have a learning activity with a start time of 08:00 am and with timezone of EST. When it is included i…SantoshKumarBhairi 134 views 8 comments 1 point Most recent by Cristelle Dahak Reporting and Analytics for HCM