BI Publisher
Discussion List
-
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti… -
Talent Score - deep link in BIPSummary: Does anyone know if you can deep link from BIP to the Talent Score screen? I think it is here: My Team > Career and Performance path, page titled “Goals and Per…Andrew_Schmitz 11 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM -
Links with BI Publisher when using With ClauseSummary: Data sets using the With Clause lose the ability to create links between datasets Content (required): I'm trying to leverage the powerful WITH clause in a bi pu… -
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 149 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Need help to build the sql logicSummary: Hi Team, I am working on a requirement for position incumbent. Here my code will get each positon with vacant positon details. And for each position one record …Mohan Murali 51 views 3 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.9K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Override AP Transaction not captured by Budgetary control ModuleSummary: Hi All, Please note that actually when I'm proceeding with Override of a transaction in AP module same is not being capture in the Budgetary Module. For example… -
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Learning Initiative associated with a courseHello everyone, we would need to know if a course has an initiative attached to it and possibly the number of that initiative. However, among the documentation we could …User_2025-02-07-06-30-13-200 11 views 1 comment 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Can Last_update_date be taken as the date when invoice hold was released in AP_HOLDS_ALL?Which table and column will give the details of the invoice hold release date and invoice released by name ? Release 22BKanikaGupta 72 views 1 comment 0 points Most recent by Hari Sanka-Oracle Payables, Payments & Cash Management
-
Is there any way to get the sub category for module identify column in HRC_TXN_HEADER tableWe could see lot of transactions for Manage Employment (Under Module Identify field --> Table HRC_TXN_HEADER). We are trying to segregate the transactions. We are trying…Kiran Kollamsetti 11 views 0 comments 0 points Started by Kiran Kollamsetti Reporting and Analytics for ERP
-
FTE and Salary - Compensation Salary Details Real Time Subject areaSummary: The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row Content (required): I'm digging into an erro…Rob F 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to download OTBI and BIP reports before the refresh of the instance ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):DJ Kumar 41 views 4 comments 0 points Most recent by Deshin Pillay-Oracle Reporting and Analytics for ERP
-
BI Publisher Style Templates vs Online Layout BuilderSummary: How to deliver a consistent look and feel in BI Publisher reports Content: I'm trying to improve my skills with writing BI Publisher reports and learn about Sty…
-
BIP Email Bursting - Best PracticesSummary: Content (required): Hello, We've received a requirement from customer to implement automatic custom notifications to employees. More in depth: HRs post job requ… -
Is there any way to identify which roles have security profiles?Summary: Is there any way to identify which roles have a View All Document Types and View All People person security profile, and who these are assigned to? Content (req…Abhimanyu Kumar27 51 views 3 comments 0 points Most recent by Rachel Martorelli-Oracle Reporting and Analytics for HCM
-
How to get FULL_NAME from PER_PERSON_NAMES_F_V if user row is not on PER_USERS?Summary: We have a very simple section of report code that uses the LAST_UPDATED_BY field on FA_TRANSACTION_HEADERS table ("FTH" in the code below) to get a user's full …Brad Kirschner 511 views 3 comments 0 points Most recent by Brad Kirschner Reporting and Analytics for HCM
-
HCM &Power BISummary Possible that Oracle HCM cant feed automatically to a Dashboard using PowerBIContent Hello, I am just wondering is there any posibility that Power BI can be refr…User_2025-01-29-22-24-40-400 76 views 10 comments 1 point Most recent by Mansur Khalil Reporting and Analytics for HCM
-
Accounts Payable Trial Balance Report - no detailsSummary: Why do I only see a summarized amount, when running Accounts Payable Trial Balance Report? How do I get details per supplier? Content (required): Version (inclu…Bo Tøpgaard 91 views 2 comments 1 point Most recent by Bo Tøpgaard Payables, Payments & Cash Management
-
Gender Pay Gap ReportSummary Has a Gender Pay Gap report been release for HCMContent I am trying to find the equivalent Gender Pay gap report that existing in EBS. Is there one? If not what …User_2025-01-23-23-03-09-078 177 views 15 comments 4 points Most recent by TarunAggarwal Reporting and Analytics for HCM
-
AZA: Consecutive Absence ReportSummary: Hi team, We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater tha…Ahmed AZA 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP report Excel output is formatting large numbers as General/scientificSummary: We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42…Brad Kirschner 851 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Unallocated AORI've got sql to extract those who have an AOR allocated to them but im looking to do a cleanse on active AOR where a colleague isn't allocated. Does anybody have any tho…