BI Publisher
Discussion List
-
Error while loading LearningRecord.dat fileHi Team, While loading the below HDL, I'm getting the following error:…Saurav R-Oracle 13 views 3 comments 0 points Most recent by Keerthi Masireddy-Support-Oracle Learning -
Is there a way to get new and old value for an object in OTBI without logical SQL?is there a subject area that inherently stores old and new values of objects like department lAloka Bhattacharya 51 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
Observation Checklist Link not found in Oracle TablesHow is the observation checklist link/URL being created or generated to use for notification? Can it be found in Oracle tables? Where could the link be stored? Is there …
-
How can I identify Items which have common Structure with another item in different org?Summary: Goal is the extract list of item with with common structure. We have gone through the two subject areas below elated to Item Structure but did not find any comm…
-
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 58 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 92 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 31 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