Category 81
Discussion List
-
Number field not displaying correctly on RTFSummary: I have a RTF created with the BI Publisher Add-in and is sent as a PDF email notification through a bursted BIP report. There is a number field on the RTF, that… -
How to Encrypt and Send BIP report output from oracle HCM cloudSummary: There is a need to Encrypt a BIP report output to 3rd party through SFTP. Please let us know the possibility and how to accomplish it ? Does BIP provide any def…
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…Osama_Mo 2.9K views 10 comments 1 point Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM
-
BIP report to extract all JR approval flow stepsSummary: BIP report to extract all JR approval flow steps Content (please ensure you mask any confidential information): Hello experts, my customer requirement is to ext…
-
Extract future task assignment in transaction approval flowHello experts, I know that we have the ability to query current and past approvers for an approval transaction (hrc_txn_data / fa_fusion_soainfra.WFTASK), but is there a…
-
PER_PERSON_SECURED_LIST_V showing own recordsSummary: Hi, We have some reports created with PER_PERSON_SECURED_LIST_V one employee is from a country A with AoR from country B, on person management the employee cant…Lucas B Maciel 20 views 3 comments 0 points Most recent by Nidhi Prasad2 Reporting and Analytics for HCM -
Error changing ReportsWhen trying to change the report from the custom folder, the following error appears:Matheus Vitorelli 16 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Employee Connection - Colour bar represents assignment typeSummary: My Organization chart page displays yellow bar for contingent workers and blue bar for employee assignments type. I do not see this colour bar feature on connec…ArunSolanki18 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I display user chosen from and to dates in OTBI?Is there way to show the dates a user has selected in the output of the report? Date run can be shown in the title, but I want the user to enter a from and to date and t…
-
In which table has the information of Mail Stop in Legal Reporting Unit AddressesSummary: Hi, In which table has the information of "Mail Stop" in Legal Reporting Unit Addresses under the setup Manage Legal Reporting Unit. We checked in below tables …
-
Pivot table is not working in OTBI report with 2 subject areas, columns are not working properlySummary: Pivot table is not working in OTBI report with 2 subject areas, columns are not working properly as per the pivot table layout. Created a report with subject ar…Elavarasan S 19 views 5 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Where can I find HCM Extract user entity to database lineage mapping?Where can I find HCM Extract user entity to database lineage mapping?
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 126 views 13 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
What is the OTBI Subject Area to get data from PER_LOCATION_LEG_F tableSummary: Which Subject Areas should i use to get the details from PER_LOCATION_LEG_F table. Should we need to any process to add those fields to the Subject Areas ? Cont…Jagdish Varadraj 7 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
V3 seniority date multiple seniority date in OTBI IssueSummary: We just upgraded from V1 to V3 seniority dates and tried to update existing OTBI reports with the new dates. Have no issue replacing if the report is pulling ju…
-
Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_FSummary: Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F Content (please ensure you mask any confidential information): I am extracting data fro…
-
My Team Activity Center Org HierarchySummary: Redwood. 25A. Test Pod. When logged in as a Line Manager and accessing My Team Activity Center, the manager will click on the Org Hierarchy. When moving up the …
-
Calculation Card Component - Provincial Tax CardSummary: Column / Table where the Location held on the Provincial Tax Card is stored. Content (required): Hello experts, We've been trying to report on the Calculation C…
-
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?…
-
Standard VS Custom ReportsSummary: Hi Everyone, Content (please ensure you mask any confidential information): How to check if reports are standard reports vs custom report? I need a table that s…Srushti Dhote 39 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 168 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM
-
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…Vincent T 28 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Custom bursting report failing sporadicallySummary: We have a scheduled process named Job Offer Notification that runs every 30 minutes to notify Compensation. While most runs complete successfully, we are notici… -
How to get all attribute in one nodeSummary: Hi Experts, I need your assistance. I'm currently working on XSL files to get values in the XML files. I want to show all the attributes separately in one node.…
-
Candidate Marital status and extra information reportSummary: Candidate Marital status and extra information report Content (required): Candidate Marital status and extra information report Version (include the version you… -
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac…
-
SQL query to get the candidate's education detailsSummary: Hi All, I am facing an issue to get the candidate's education data using the SQL query: SELECT U.* FROM IRC_CAND_PROFILE_USAGES_M R, IRC_PROFILE_EDUCATION_ITEMS…Shikha Agarwal 1.6K views 9 comments 0 points Most recent by UdayrajSingh Reporting and Analytics for HCM -
Capturing the Learning outcome from the Learning Record Real Time subject area- OTBISummary: Content (required): hi there, we have as learning outcome a custom certificate. The certificate has a name, issued by field and issued date. I wonder if this ca…Bobby Jourdan 38 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Goal library extractionHi to all, do you know if there is a possibility to extract all the goals entered by the HR on the Goal Library? Is there an OTBI area? Thanks in advance, Best Regards, …
-
Request for Guidance on Managing DEI Attributes in OTBI Analysis Following Executive Order 14151In response to the Executive Order 14151, "Ending Radical and Wasteful Government DEI Programs and Preferencing," signed on January 20, 2025, our Compliance team is work…SwatiSharma 17 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM