BI Publisher
Discussion List
-
how to get the organization and customer hierarchy data from tables in oracle fusion planningSummary: Hi Team, What all are the table to extract the organization and customer hierarchy data from tables/BI report in oracle supply chain planning cloud? Content (pl…Nitin Aavasarmol 5 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…
-
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 81 views 6 comments 0 points Most recent by Bayan Khalaf Reporting and Analytics for HCM -
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…vikram khengare 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 12 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 13 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
The XML which we have pulled for the Job History doesn't hold the Job statusThe XML which we have pulled for the Job History doesn't hold the Job status if it is success or failed the against individual employee if the job is success of failure …
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 262 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 79 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https… -
HDL - DeleteSummary We are trying to remove Matrix Managers via HDL; but DELETE removes all historyContent Hello! We are implementing Matrix Managers and I've been tasked with updat…Shawn McDonald 115 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 655 views 12 comments 1 point Most recent by User_FVSCP Reporting and Analytics for HCM
-
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…User_H77SF 10 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 1.3K views 4 comments 7 points Most recent by Kundan Kumar17 Reporting and Analytics for HCM
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 13 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM
-
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D…
-
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI…
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 357 views 5 comments 2 points Most recent by Toni B Reporting and Analytics for HCM -
Some Employee missing of the Reports on certain dateSummary: I want to explain the issue we encountered. On December 10, the HR team uploaded a change affecting all employees in a specific department, effective December 1…Lucas B Maciel 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Query Regarding Adding a Secured List Table to Oracle BI Data ModelSummary: Query Regarding Adding a Secured List Table to Oracle BI Data Model Content (please ensure you mask any confidential information): Hello, I am working on a BI d…
-
Is it possible to find deleted checklist details?Summary: Is it possible to find deleted checklist details? Content (required): Hi All, For one employee, one check list has been assigned and deleted by someone. I verif…Venkatesan 37 views 2 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Actual Termination Key Date?Client is saying The ActualTerminationKeyedDate is a column in the "per_periods_of_service" table. We don’t see from our side the termination_key_date from "per_periods_…Ronel M 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management -
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 183 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
Access to Reports and Analytics section - Roles and privileges requiredSummary: Hi All, We had the requirement to build a custom data role which will give the user the access to Reports and Analytics work area and role should provide access…
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 334 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 83 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 1.1K views 21 comments 1 point Most recent by Tom John Bontoyan Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 18 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM