BI Publisher
Discussion List
-
OTBI report to fetch all details of Direct and Indirect reports details based on Line Manager sessioSummary OTBI report to fetch all details of Direct and Indirect reports based on Line Manager session userContent Hi All, I am trying to fetch all the (direct+indirect) …User_2025-02-06-15-04-02-124 64 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to display the thousands separator point in the BI extraction tables for pay elements and goalsSummary How to display the thousands separator point in the BI extraction tables for pay elements and goalsContent Hi, We are experiencing an anomalous behavior. I enter…Alberto Barile 19 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Employee Headcount by Business Unit BI Publisher reportSummary Employee Headcount by Business Unit BI Publisher reportContent Hi Experts, I'm looking BI Publisher ( not OTBI since Headcount is not properly setup in our organ…User_2025-02-07-19-03-14-525 40 views 6 comments 0 points Most recent by Ninja Reporting and Analytics for HCM
-
Need to know KFF Deployed person nameContent Hi All, We have "Deploy Flexfield" option in cost Allocation Key Flexfiled. We need to know the person name who deployed the flex field. In "FND_KF_FLEXFIELDS_VL… -
BIP user based logicSummary filtering population based on running userContent Hi all. My salary and payroll report is a BIP one and currently i have 7~8 versions of the same data model with… -
Resignation Rejected ReportContent Hi Team, We are looking for some report by which we can fetch the data for all the Resignation status was Rejected. In our current environment, when the employee…Kiran Kancherla 28 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Checklist item and report on there StatusSummary Need a report for onboarding checklist (DoR) which the acknowledgementContent Team, We have onboarding checklist items and using BI publisher for some of them to…Santosh Mudide 54 views 4 comments 0 points Most recent by Santosh Mudide Reporting and Analytics for HCM -
Generate Workpattern code like NYYYYYNSummary Generate Workpattern code like NYYYYYNContent Hello I am trying to generate an understandable work pattern code like NYYYYYN for reporting. Any quick pointers ho…Murthy Kodavati 21 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
Ability to find out the Work Schedule based on ShiftSummary Ability to find out the Work Schedule based on ShiftContent Dear Team, Basic Requirement is to develop the custom BI report based on Shift Details to find out th…User_2025-01-31-16-34-04-599 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard is empty when selected option Printable PDF or Printable HTMLSummary Dashboard run empty when selected the option export entre dashboard or printable PDF or Printable HTMLContent Hello, I have a dashboard build out of BI Publisher…
-
Logo based on Business UnitContent Hi, I have requirement on the payslip report to have company logo printed based on Business Unit which is achievable but challenge is there are 37 business units…Mohammed Rafi 59 views 3 comments 4 points Most recent by User_2025-02-08-01-00-25-866 Reporting and Analytics for HCM -
Allow employees to access BI ReportContent Hello, I have a BI report that generates a benefits related letter. I would like to make this available to employees to access via self-service somehow. Does any…Susan Anderson 35 views 2 comments 2 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Report Job History page not renderingSummary Unable to use Report Job History page.Content When opening the page, it briefly displays search criteria fields and then loads as blank, white screen. Same issue…Deanna Tourigny 67 views 11 comments 0 points Most recent by User_2025-02-03-23-52-41-214 Reporting and Analytics for HCM -
Looking for Audit BIP report for Employee assignment/Relationship details and Personal detailsSummary Looking for Audit BIP report for Employee assignment/Relationship details and Personal detailsContent Can anyone used a BIP reports(OTBI report) to find out the …Prabhu Krishnamoorthy 53 views 2 comments 1 point Most recent by Prudence K Reporting and Analytics for HCM -
Audit report - assignment fieldsSummary Audit report of assignmentsContent A client is asking this request. Does anyone have an idea to the best approach. * A new report that shows all fields in the as…Daniel Shabra 52 views 2 comments 0 points Most recent by User_2025-02-05-16-39-03-485 Reporting and Analytics for HCM -
Customize OTBI Analysis Header FieldsSummary Need Help with customizing the OTBI analysis header field to a custom nameContent Hello Everyone, I am new to OTBI analysis and I need help with some customizati…GauravGupta39 49 views 2 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Session Timezone in BI PublisherSummary BI publisher not using the timezone from the Account screenContent I've found that the CURRENT_DATE in BI Publisher isn't applying the timezone entered on the us… -
No access to create BI Publisher reportSummary No access to create BI Publisher reportContent Hi all, is it possible to give users access to create/Modify only OTBI reports but only read-only access to BIP re…Prashant Kumar - 2103 43 views 4 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 43 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…Rajesh Ravikumar 21 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Need to know Tables to retrieve time card details like hours entered, time attribute detailsSummary Need to know Tables to retrieve time card details like hours entered, time attribute detailsContent I am trying to report time entries and other details like cor…User_2025-02-11-15-16-39-434 505 views 1 comment 0 points Most recent by User_UUX20 Reporting and Analytics for HCM
-
Can we create replica of changes only extract using BIP reportSummary Can we able to create a replica of changes only Extract using BIP Report. If Yes can you please guide me how we can proceed with this kind of requirements.Conten…Ashish Mangal 198 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …Dharmendra Jha 61 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 48 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …Prajna Hegde 33 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to read Context Segment DFF and associate it to employee record?Summary How to read Context Segment DFF and associate it to employee record?Content Hello, I have information stored in the assignment attribute 2 of the PER_ASG_DF DFF …Nicola Petri 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 75 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM