BI Publisher
Discussion List
-
Costing of PositionContent Hi All, I am trying to get the Costing of position in SQL query. Does any have the SQL which can give the costing details of position. Thanks,Misbahul Khair-266763 474 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Journey report - display 'Saved as Draft' status in the reportHello, Related to Journey, I want to create a report that shows the task's progress status for each performer. In case of the performer saves the task as "Saved as Draft…Liran 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Ability to run “Print Receivables Transactions” program based on “real” from/to print dateSummary: Usecase: We usually re-printed some transactions when our customers request a copy of the initial printed transactions with a label saying that it is the exact …
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to use an SQL query to select records of elements whose value was changed by CORRECT?Hello everyone, How to retrieve with an SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS ta…Alex_Balanovsky 81 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
How to establish a connection from Oracle Cloud to Local printer to print chequesHow to establish a connection from Oracle Cloud to Local printer to print cheques Hi all, We are trying to establish a connection between Oracle Cloud and a local printe…Daniel Ackland 91 views 5 comments 0 points Most recent by Joseph Terry Payables, Payments & Cash Management
-
Query to get payment description from payable payment pageSummary: Hi everyone, I am building up a query for extracting all payable payment informations. I cannot find the payment description that I am able to see on the web pa…GNCC33 101 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
debugging an errorSummary: debugging an error Content (please ensure you mask any confidential information): Hello everyone, I am getting this error when running a report in PROD but not …
-
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 32 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 11 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 871 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 11 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 54 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 …
-
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…