You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

General Transactional Reporting (OTBI)

Discussion List

  • Kristen Magno
    Cell Splitting based on special character
    Summary Split a field into two columns based on characterContent Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns inst…
    Kristen Magno 21 views 2 comments Most recent by Kim Welker
  • Lin Tiedemann
    Concatenate non text fields
    Summary Function Concat does not support non-text types.Content Is there a way to concatenate non-text fields? I would like to concatenate Req id and Candidate id to cre…
    Accepted answer
    Lin Tiedemann 41 views 4 comments Most recent by Reena Trangri
  • Kim Welker
    Return Candidate Name only for Specific CSW Selection steps/statuses
    Summary How to modify my SQL statement to remove redundanciesContent Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pas…
    Kim Welker 32 views 11 comments Most recent by Rahul Thomas
  • krishiveth
    data Model Report
    Content Hi, How to create Promotion data model report based on promotion employees regards, nivaetha
    krishiveth 28 views 0 comments Started by krishiveth
  • User_6T5YF
    Help with my SQL Code
    Summary Help with my SQL CodeContent I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like …
    Accepted answer
    User_6T5YF 56 views 1 comment Most recent by User_6T5YF
  • Jason Schwartz
    Audit Related: Last Logon Session
    Summary Last LogOn Session: Looking for a audit related report that shows last time accessing OracleContent I am able to query HCM related tables (such as per_users) to …
    Jason Schwartz 51 views 1 comment Most recent by Jason Schwartz
  • Mor Amsalem
    Users information in report
    Summary I need to create (or use one that exists) that will give me basic information on the usersContent Hi, I need to create (or use one that exists) that will give me…
    Mor Amsalem 28 views 2 comments Most recent by Mor Amsalem
  • Mor Amsalem
    Currency in reports
    Summary When the users login with diffrante currency then $ the amount is correcet but the currency code is still $Content In user preferences you can define witch curre…
    Mor Amsalem 27 views 0 comments Started by Mor Amsalem
  • Andy French
    Email prompt does not allow for quotation mark
    Summary Email prompt does not allow for quotation markContent We have a report built in Performance that pulls in a manager's full reporting hierarchy (both direct and i…
    Andy French 13 views 3 comments Most recent by Andy French
  • Evan Jenkins
    Conditional Formatting on Column Sub-Total
    Content Hello, I've built a sickness report that counts the number of instances of sickness and number of days sickness over a time period. I've figured out how to add a…
    Evan Jenkins 29 views 1 comment Most recent by Caroline Gladwin-Oracle
  • Kim Welker
    Field Level Security and Folder Permissions
    Summary We want all user types to share one folder, but have user type permissions that can restrict certain confidential fieldsContent Hi - We are trying to find the be…
    Kim Welker 36 views 1 comment Most recent by Azfar Hussain-31614
  • Ellen Manthei
    Issue with Percentage in Pivot Table
    Summary Issue with Summarizing Percentages in Pivot TablesContent I have a calculation for the fill rate based upon hired vs target. This is working fine in the details,…
    Ellen Manthei 39 views 0 comments Started by Ellen Manthei
  • Maria Lieberman
    Sorting alphabetically on name
    Summary Sorting alphabetically on nameContent Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special letter…
    Maria Lieberman 23 views 5 comments Most recent by Rachel Martorelli-Oracle
  • Neil Peacock
    Agent Limitations
    Summary Encountering limitations on the exports from agentsContent I am currently encountering an issue where exporting data through an agent is cutting off at 25,000 ro…
    Accepted answer
    Neil Peacock 41 views 3 comments Most recent by Chris Dabel
  • Aaron Leggett
    SQL IS NULL error
    Content Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…
    Aaron Leggett 32 views 3 comments Most recent by Neil Peacock
  • User_EQ8R5
    Format prompt selections
    Summary Add specific formatting to prompted selectionsContent Is there a way to format the selections that show for prompts? For instance i need to have a prompt that fo…
    Accepted answer
    User_EQ8R5 28 views 4 comments Most recent by User_EQ8R5
  • Wendy Ware
    Using Subject Area for Report: "Unable to retrieve metadata from data model"
    Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …
    Accepted answer
    Wendy Ware 41 views 2 comments Most recent by Wendy Ware
  • Peter Kirwan
    Stats
    Summary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…
    Peter Kirwan 24 views 1 comment Most recent by Chris Dabel
  • Aaron Leggett
    How to stop employees viewing reports in 'Custom'?
    Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…
    Accepted answer
    Aaron Leggett 42 views 2 comments Most recent by Aaron Leggett
  • Alex Andreadis-21319
    SQL editor for Oracle BI
    Summary What tools are people using to edit SQL in Oracle BI?Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model …
    Alex Andreadis-21319 74 views 3 comments Most recent by Neil Peacock
  • Andy French
    Link to Dashboard
    Summary Looking to provide a direct link to our Recruiting Dashboard for users not logged inContent I'm trying to create a link to our Recruiting Dashboard to be include…
    Accepted answer
    Andy French 71 views 2 comments Most recent by Andy French
  • Peter Kirwan
    Terminated Line Manager
    Summary Report on where an employee's Line Manager is TerminatedContent does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues i…
    Peter Kirwan 29 views 2 comments Most recent by Peter Kirwan
  • Erin Caby-47393
    Duplicates appearing - need true data
    Summary I have one field that is pulling different dates - need true dataContent Hi Group, I'm having an issue getting a single date to pull in correctly in OBI. The fie…
    Accepted answer
    Erin Caby-47393 21 views 3 comments Most recent by Reena Trangri
  • Kellie Lacabanne
    Pushing Shortcut to Custom Folders to Users "My Reports"
    Content If we have a custom folder with many reports, I know that as a user, I can create a shortcut and have that in My Reports. Is there a way for an Admin to push the…
    Kellie Lacabanne 19 views 1 comment Most recent by JF Carpentier-23261
  • Andy French
    Pivot Table/Table Horizontal Layout
    Summary Adjusting the layout of a pivot table or table from vertical to horizontalContent I need to change the layout of a sectioned Table from vertical to horizontal. I…
    Andy French 70 views 1 comment Most recent by JF Carpentier-23261
  • AshishHCM
    Need Help in Creating a OTBI Analysis from Simple Logical SQL
    Summary I am trying to create a Logical SQL which tries to identify all Person Records who have National Identifiers having more than one occurenceContent I have attache…
    AshishHCM 58 views 1 comment Most recent by Merrick Hartslief
  • User_I6AXL
    Limit of Number Of pages On rtf file?
    Summary I can affiche only 1500 pages on pdf output with rtf templateContent Hello, Is there a limit of number of pages when working with rtf template . I can visualize …
    User_I6AXL 24 views 0 comments Started by User_I6AXL
  • Shannon_Johnson
    Candidate ID Prompt
    Summary Adding required candidate ID prompt with text box entryContent Trying to add a prompt for candidate ID. I want users to be able to copy/paste or type into a text…
    Shannon_Johnson 21 views 7 comments Most recent by Suvankar Dasgupta
  • Vishal Goyal-17421
    Using HR VP Data Visualization Content Packs
    Summary How can i use the Data Visualization Content PacksContent I have downloaded the HR+VP.zip file which has HR+VP.dva file. How can I import this into my cloud inst…
    Vishal Goyal-17421 66 views 0 comments Started by Vishal Goyal-17421
  • MarkS
    Sorting In a Pivot Table OBI
    Summary How to sort on a measure within Pivot TableContent I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I c…
    MarkS 22 views 2 comments Most recent by MarkS