BI Publisher
Discussion List
-
Tables to find leave approval detailsSummary: Tables to find leave approval details Content (required): Hi All, We got a report requirement to show leave details with who approved the leave. From which tabl… -
Checkbox value not getting fetched in backendSummary: Content (required): A checkbox dff has been created in such a way that if it is checked then Yes value from the value set will be picked and if not checked then…Pranjal Mohla 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …AjayKumar Maddipati 33 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 21 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
Sending fails when encrypted PDF is being sentHello, I've to send a PDF file format with pgp encryption to SFTP server. I already uploaded the pgp key in BIP. When testing the file's sending, I am getting an error m…
-
Goal Task detailsHi, Which Table or subject area contains goal task details? Regards, NivyaNivya Mathire 33 views 5 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Data issue- OTBI AnalysisSummary: We have an OTBI analysis to capture benefit details and I noticed that it's providing information for one legal entity although are three legal entities added i…Ayesha Iroshani 42 views 13 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Oracle BI analysis - Relative deep links in interaction actionsSummary: Relative deep links in interaction actions Content (required): We are trying to add relative deep links to a big number of performance counter tiles. How can we…
-
BI Publisher RTF template with Excel output merging rowsSummary: I have a HCM Extract which outputs as Excel via an RTF template. However on the output it is merging 3 rows for each row of data (see below screenshot). Does an…
-
Custom SQL reports don't return data in another language anymoreSummary: Four users with the same security roles and Area of responsibility ran a report. 2 English-speaking users saw data, while the 2 French-speaking users no longer …
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require…
-
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont…User_2025-01-25-00-37-41-739 69 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Why does the audit table PER_PEOPLE_EXTRA_INFO_F_ return no value?Hi all, I need to audit the PEI_INFORMATION1 field of the PER_PEOPLE_EXTRA_INFO_F_ table. I configured everything as stated in this document (https://support.oracle.com/…VincenzoCoppola 108 views 6 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 278 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
RTF Template with Excel Template AlignmentWhat would be the best way to get the good alignment when using RTF and output is Excel. We have more number of columns ...Example see the date of birth. The same way it…
-
Embed BIP report in the Application UI pagesSummary Embed BIP report in the Application UI pagesContent Hi, OTBI Report can be embedded in the UI using page composer. But can we achieve the same for BIP report? I …Manoj.Gupta 587 views 10 comments 8 points Most recent by Sai Revanth-Oracle Reporting and Analytics for HCM -
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 314 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 105 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
How to restrict All subject area Access from Line manager roleSummary: We wanted remove all subject area analysis from line manager role. We are able to remove some subject are by deleting the transaction analysis privileges . Rest…Aditya Jena 112 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th…AjayKumar Maddipati 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 11 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM