BI Publisher
Discussion List
-
Seniority date blank on front end but populated in PER_SENIORITY_DATES_F TableSummary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add i…Seema Kalantri 35 views 3 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM -
How to get the Name equivalents of RECRUITING_LOC_HIERARCHY_ID and RECRUITING_ORG_HIERARCHY_ID?I'm trying to get the Recruiting Type, Recruiting Location Hierarchy and Recruiting Organization Hierarchy from the Areas of Responsibility - Scope section, but I only h… -
How to distinguish the output file basing on the scheduling dateSummary: How to distinguish the output file basing on the scheduling date Content (please ensure you mask any confidential information): Hi, we created a BI report; the …
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep_Chavda 14 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
Query or table to get the employee work schedule as of the leave start dateSummary: Hi Every one, Do any one have any query to get the employee work schedule as of the Leave Start date . The requirement is when employee applied the leave, I nee…Charan Kollipara 947 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Error while loading LearningRecord.dat fileHi Team, While loading the below HDL, I'm getting the following error:…Saurav R-Oracle 14 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 53 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 51 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 45 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 …Milan_Mohanty 25 views 1 comment 0 points Most recent by David --Oracle 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.7K 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 14 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 …
-
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 32 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM