BI Publisher
Discussion List
-
What web service for BIPublisher to use to download output of scheduled report (ScheduleService)Summary: We use the SOAP web service interface "/xmlpserver/services/v2/ScheduleService". Using Operation "scheduleReport" it is possible to launch an execution of a BI …Renato Baietta 60 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
Need a sample SQL for HDL Summary ReportSummary: I'm trying to create a HDL summary report, where I wanted to fetch the Submission Time, Finish Time and Elapsed Time which I'm unable to find the exact table. P…Sujeeth Chinta 31 views 4 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Retrieve Person addressesSummary: Do we have any package function to retrieve the person addresses? Please share. Content (please ensure you mask any confidential information): Version (include …MilanMohanty 21 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
per_person_secured_list_v view problemSummary: per_person_secured_list_v view is ignoring past events Content (please ensure you mask any confidential information): Hi, we have an admin user and she should h…Stefano_Mazzocca 91 views 2 comments 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
How to add custom Parameter to PayslipSummary: Need to be able to print Payslip by Departments for specific Departments following a Pay Run Content (required): We have over 60 departments and some department…
-
SQL Query to get Value Set ListSummary SQL Query to get Value Set ListContent Hi Team, Could you share me any BI/SQL query to fetch the all list of Value sets using in HCM Instance like Dependent, Ind…User_2025-01-29-00-33-34-534 3.6K views 4 comments 0 points Most recent by Swarna Mahadevan Reporting and Analytics for HCM -
Analysis report for course completion of specific courseWe are a new Oracle customer and so new to creating Analysis criteria and want to create a report that shows the course completion status of a particular course. We have…
-
Recruiting OTBI Performance issueSummary: Hi Expert, I need your assistance. I'm trying to combine two subject areas 'Recruiting - Recruiting Real Time' and 'Recruiting - Recruiting Event Real Time' and…
-
Learning BI Report query for questionaries with based Employee DetailsHi Everyone Currently, I am creating a BI report for Oracle Learning Cloud where it should have, Learning Related Fields Employee Basic Info ( Name, Person Number, DOB, … -
Filter command field greyed outSummary: Need inputs to enter value in the Filter Command in the FTP delivery option Content (please ensure you mask any confidential information): In the FTP delivery o…Visu 11 views 3 comments 1 point Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Overtime period field on payroll relationshipSummary: What table(s) can I find the Overtime Period field on the payroll relationship. I am being pointed to HWM_RP_TM_PERIODS_TL but this table does not seem to have …
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Employee / Employer Pension Contribution Report for a specific durationSummary Employee / Employer Pension Contribution Report for a specific durationContent Hi, May I check if anyone has any OTBI / BIP report for Employee / Employer Pensio… -
I need a query to get the attached images from HR document record and print it in RTF templateSummary: I need a query to get the attached images from HR document record and print it in RTF template Content (please ensure you mask any confidential information): Ve…Farah Alajou 32 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Table name/Report for Structure (Navigation Configuration)Summary : We require a report or table name that contains the configuration for the 'Navigation Structure.' This information will be necessary to ensure consistency in t…Bhupesh 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Customize CAMT.053 TemplateSummary: Hi All, We are looking to customize camt.053 template, and referring below document, but the instructions are not clear, do we have any better reference to cust…
-
-
How to use the Maximum Price field if NULL or Blank for Learning Request ApprovalSummary: We have configured this condition "(Learning Item.result.Maximum Price == null)" from Learning Request Approval rule but it is not working. Our requirement with…
-
How to map out Repeat/Recurrence in BIPSummary: Where can I find the table that could be used to pull out Repeat/Recurrence found in Scheduling Details in Offering Activity in HCM UI? -Where to find the field…
-
Extract output file name concat with the extract parametersSummary: Hi All, I am working on a HCM extract where requirement is to generate the output file name which contains the interface name concats with the parameter as ment… -
Hi Guys query is returning DATA_DS, please help me where i went wrong int he query.Summary: My Query: select per.person_number, per_name.FULL_NAME PER_ABSENCE_ENTRY_ID , abs.absence_type_id, apae.APPROVAL_STATUS_CD,abs.name absence_type,to_char(apae.st…
-
Do we have usage reports for Document of Records categoriesSummary: Are there any reports that summarises number of documents loaded against document categories. Content (please ensure you mask any confidential information): Ver…Chandan Patel 31 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
IBAN with BIPSummary: Hi experts, we need to create a report with the Employee's Personal Payment method Details like IBAN and bank account info. Does anyone know how can I create si…Oriana L. 61 views 3 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM
-
Need to fetch Score/Actual Scorein the BI ReportSummary: Need to add Score/Actual Score to the existing BI report which is coming from Manage Activities page. Can anyone please help me with table names or SQL to fetch…
-
BI table name to fetch Module from Manage common lookup screenContent Hi Experts, I have a requirement to fetch module from manage common lookup screen. Please help with relevant BI query. Thanks SandipSandip Karmakar 232 views 8 comments 0 points Most recent by User_2FZC5 Reporting and Analytics for HCM -
Tables used in "User Password Changes Audit Report"Hi team, would like to know the tables used in the User Password Changes Audit Report program and do we have any standard report for user account name changes in oracle …chandrakanth makam-Oracle 31 views 2 comments 0 points Most recent by Thomas De Leeuw Reporting and Analytics for HCM
-
Query to fetch high performers termination countSummary: Fetch the count of high performers termination Content (please ensure you mask any confidential information): We have a requirement to fetch high performers ter…Hitha Harikumar 21 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Linking courses using an Analysis CriteriaWe are a new Oracle customer and so new to creating Analysis criteria and we want to use this functionality to create an audience for some compliance refresher training …
-
SQL query to fetch all postal codes and their corresposding county, city and state in US legislationHi All, I need an sql query to fetch all the postal codes and their corresposding county, city and state in US legislation. Please help Thanks. SowmyaSowmyaSk18 182 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM