BI Publisher
Discussion List
-
BIP - List of Employees under the Area Of Responsibility of HRSummary: Hello, Does anyone know how to get the list of employees under the Area of Responsibility of HR via BIP Report? Could you please share a query or do you have do…Hazel De Castro 141 views 13 comments 0 points Most recent by User_2025-02-12-21-24-25-654 Reporting and Analytics for HCM -
SQL Query for Supervisor/Employee Hierarchy with Both Direct and Indirect ReportsContent I have a task to create a BI Publisher report and attach additional data from different tables based on the bottom level employees. I am wondering if anyone has …Brian Todd-Oracle 982 views 2 comments 0 points Most recent by Suhitha K-Oracle Reporting and Analytics for HCM
-
Fusion UI Customization TablesSummary: Fusion UI Customization Tables Content (required): Hi All, From which table we can get fusion page customization details like, who did the customization and the…
-
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…Aloka Bhattacharya 55 views 6 comments 0 points Most recent by Shampi Reporting and Analytics for HCM -
Custom notification with HTMLSummary: Content (required): Hello everybody, we are customizing a custom notification containing an attachment inside it. In particular, we have inserted and created ev…
-
I am needing SQL for SalaryIdSummary: I am looking for an sql that includes SalaryId for trouble shooting an error I have in data flowing into FAW. I have the SalaryId in the error in FAW but can't …Sharon Ferguson 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
BI Reporting function that creates link to attachmentsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Oracle Consulting Description (Requir…Claudio Marini-Oracle 31 views 0 comments 3 points Started by Claudio Marini-Oracle Reporting and Analytics for HCM
-
Future Dated HiresSummary I need a report from the OBI that will give me a list of employees that have been boarded in Fusion, but haven't started yet.Content I've attempted to load the t…User_2025-01-23-22-36-14-742 155 views 11 comments 0 points Most recent by Matty S Reporting and Analytics for HCM -
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 543 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Need to move Profit and loss FRS report from one instance to anotherSummary: Content (required): I have created a FRS report of profit and loss statement and I need to move it to another instance. Any suggestions on how to do this Versio…AeeTee 85 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Regarding Alternate Fusion Application function for XLA_CONDITIONS_PKG.DISPLAY_CONDITIONSummary: Hi Team, We are migrating a few reports from EBS to Fusion and we have found that the XLA_CONDITIONS_PKG.DISPLAY_CONDITION function is not available in the Fusi…Ankit GML 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Can we include a pivot table in a OTBI report.Summary: I have a report and wondering if a Pivot table can be added so if we run this report or schedule it, it would include that pivot table? Content (required): Vers…Rajib_Samanta 51 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
How to create an OTBI Report to display POs by running for GL Parent/Child Department valuesSummary: How to create an OTBI Report to display POs by running for GL Parent/Child Department values Content (required): How to create an OTBI Report to display POs by …Abhilash K - Deloitte USI 21 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Reset the sequence in etext template when I have only one level where data residesExperts, I have to generate a sequence that resets after printing details for every person. The Cost_ID tag makes sure every record that is needed is fetched on the repo…Aloka Bhattacharya 61 views 2 comments 0 points Most recent by R Ravichandran Reporting and Analytics for HCM
-
Customizing the Payables Workflow Transactions Listing seeded reportSummary: Business needed few more column for the seeded report, But we do not have access to Data model.Suggestions needed in order to get this done. Content (required):…NarenInova 91 views 4 comments 0 points Most recent by Raunak Kumar Singh Payables, Payments & Cash Management
-
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 112 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Competencies custom ReportSummary: new to the oracle HCM system and i need to create a report listing all competencies for a job / position by staff assigned to these titles. Content (required): …
-
Created Eff for Extra internal info in candidate application details section in a requisition,Summary: I have created a eff under person extra info it is BI enabled . Content (required): I have run the ESS Job Import Oracle Fusion data extension for transaction B…Rajib_Samanta 201 views 4 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
Is the performance goal section possible to pull in OTBI?Summary: I was able to pull the overall summary rating and rating from the competency section which is the behavior office (refer to the screenshot) however, I cannot fi…Christian Suarez 31 views 3 comments 0 points Most recent by Christian Suarez Reporting and Analytics for HCM -
OAC vs OTBI best for reporting ?Summary Soliciting comments and feedback as to when OTBI is best for reporting vs. Oracle Analytics CloudContent Hello Forum: I'm looking for feedback when OTBI might be… -
Expense mileage reportDear ALL is there any report by oracle for the expense where it give a warning for the mileage when it will reach a limit so the report will give the name of each user h…