BI Publisher
Discussion List
-
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 29 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 7 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 20 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…GaneshSKulkarni 9 views 0 comments 0 points Started by GaneshSKulkarni Reporting and Analytics for HCM
-
Reporting/Managing on Goal Plan EligibilitySummary Can goal plan eligibility be managed like Performance documents can?Content I've been searching the forums but haven't found a clear answer. I have a lot of ques… -
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 13 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 29 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 25 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna…
-
Virus Scanner Not Reachable - Unable to Archive Files in My Folders / Shared FoldersSummary: Content (please ensure you mask any confidential information): Hi, We are encountering an issue when trying to archive files in My Folders and Shared Folders. E…Sankalp Shukla 1.2K views 9 comments 1 point Most recent by Sangeetha17-Oracle Reporting and Analytics for HCM -
If Position or Department attributes getting changes how to extract all the employees assignedSummary: If Position or Department attributes getting changes how to extract all the employees assigned to that position/department in fusion hcm Content (please ensure …
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 21 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…Rama Krishna_Annam 17 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
Tables for Worker Time Processing profiles in HCMSummary Tables for Worker Time Processing profiles in HCMContent Hi Team, I am looking for a query to find Worker time processing profiles(HCM Groups) based on assignmen…Harish Kumar Kovi 284 views 5 comments 1 point Most recent by Nilesh R Goyal Reporting and Analytics for HCM
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…Abhishek Jois 41 views 6 comments 0 points Most recent by Gaurav Bhardwaj Reporting and Analytics for HCM
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 1.8K views 26 comments 1 point Most recent by User_U58AH Reporting and Analytics for HCM -
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 4 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
if else condition in rtf template is not workingi tried using these conditions in rtf but its not workingminati_behera-Oracle 766 views 4 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
Query to pull error details of failed terminations from transaction consoleSummary: Query to pull error details of failed terminations from transaction console Content (required): We need a query to pull error details of failed terminations fro…
-
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…
-
Transaction Console -> Error Description and Error Resolution (hrc_txn_error)Summary: I have a requirement to get the data related to the transaction console when the transaction fails I need to get the error description and error resolution as d…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…
-
Tables lock or obsolete statisticsSummary: Hello experts! It's possibile to verify if it's present a lock on a table o the statistics are obsolete? We have a BI query of a scheduled job that times out ra…Gian Luca Triglia 1 view 1 comment 0 points Most recent by Alexandru-Catalin Serban-Oracle Fusion Applications Administration
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi…