BI Publisher
Discussion List
-
Does any one works DOR functionality to custom HCM Extracts to store Output form to Person DOR ?Hi All, We have a requirement to Store the Generated output form in Person Document Records for Terminated Employees using custom HCM Extract. we want to upload automati… -
24C - Reporting-Only Taxes and Calculation Formulas in WithholdingSummary: Hi Experts, On the 24C feature for 'Reporting-Only Taxes and Calculation Formulas in Withholding', is there a seeded report that will show WHT created from this…Crystal Joy.Paule 11 views 4 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global
-
jg_zz_vat_rep_status join with transactions tableI need to join the tables jg_zz_vat_rep_status or jg_zz_vat_rep_entities with AR transactions tables. the query is: select CASE when count(DEFAULT_SET_CODE) > 0 then 'NO…ACNROMA2023 11 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 302 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 464 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Line manager dashboard through My Team > My DashboardSummary: We found the line manager Dashboard that was available through My Team > My Dashboard is no longer accessible for line managers. The function (tile) is no linge…
-
Excel template missing row header infoSummary: I have converted an Excel template to display in rows rather than columns. I have updated the Name Manager and the results display as expected however the param…Viviane Beaudoin 1 view 1 comment 0 points Most recent by Viviane Beaudoin Reporting and Analytics for HCM -
Position Incumbent History reportContent Hi, Can someone help me with Position Incumbent History report ? We wanted to know how long the position was vacant at any point of time after creation and who a…Nivya Mathire 149 views 13 comments 1 point Most recent by Ian Figueroa Schulte-Oracle Reporting and Analytics for HCM -
Run report that will show users that have run BIP or OTBI reports over timeframeSummary: Good afternoon. Any suggestions around how to produce an audit report (we don't have auditing enabled) to produce a list of users that have run Human Capital Mg…Rich R 11 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Financial Tax Register Excel templateNeed a BIP Excel template for the "normal" FTR (similar to the one available for the distributions level report with accounts).
-
Whenever bursting job ran where can we find the details whom all the trigger is sentHi , We have letters like tenure/grade change we need the detail to whom the trigger is sent. Where will the details stored. Can i get the tables. Please help Regards, S…
-
CMP_ASG_SALARY_V we need these fields zone_name,ZONE_TYPE_NAME,ZONE_TYPE_ID,ZONE_ID related querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surya Prakash Chetla 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we customize the standard report with Internal tables provided by oracle? I found them empty.Summary: CCC-Internal tables provided by oracle do not have the data and unable to verify our customizations Content (please ensure you mask any confidential information…
-
SCROM ReportSummary: Has anyone had any success with creating a SCORM report in OTBI or BI? Would really appreciate help with this. We are trying to create a report to take out the …Teja Arepalle 31 views 2 comments 0 points Most recent by Teja Arepalle Reporting and Analytics for HCM
-
Customer invoice to get attached to invoice page after e-invoicingSummary: Invoice Print should be attached on invoice work area. There should be some schedule process which we can run and invoice print gets saved on the billing work a…Jeetesh Singh 1 view 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Join Condition in BIPSummary: Hi Team, Recently, we have created a report to take out the questions and answers of the learner in a new content but when we are trying to join WLF_SCORM_INTER…
-
Custom folder structureSummary: My client wants to change the Custom folder structure. My client does not want path to be Shared Folders > Custom > Human Capital Management. My client wants to…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.3K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
How to report on days in state/phase through BIPSummary: We would need to create a datamodel showing when a submission entered a certain phase/state to calculate the times in phase/state. You can see similar informati…
-
we need a sample payment file for rtgs payment methodwe are implementing payments for customer and they want a payment file which has rtgs payment method so we need a sample payment file for rtgs payment method Thanks, Sai…Sai Divya Kolachana 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
General Ledger Report - Cash BasisSummary: Hi Team, I would like to extract or build a custom report for General Ledger in oracle fusion with the below columns data. Required columns are: GL Date Transac…Sesha Sailini 12 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Static IP for sftp connectionSummary: Do you know if Oracle can use a specific IP address to transfer data to the SFTP server? We have configured a connection to the sftp server via OTBI/BI Publishe…Daniel Sobotka 31 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
BPM Notification audit informationHi Team We have a requirement to get the audit log for BPM notifications. If anybody worked on similar requirement, please share the solution/document. Thanks Umang SainiSaini 21 views 3 comments 0 points Most recent by Parag Hiremath Payables, Payments & Cash Management
-
New fields not showing any data in rtf template for document of recordsHello, I have one Document of record which is working fine but requirement is to add 3 new columns in that , For example Notice period/Hours and contract so i added all … -
Not able to fetch Recommended Courses in the Both OTBI & BI ReportsSummary: Hi Everyone, We have created reports in the BI and OTBI to fetch all the assigned courses of Required, recommended, and Voluntary. However, we are not able to s… -
Exclude Data Models in BI Search ResultsWe don't want end users to see data models in BI. We have followed the typical approach of saving data models in a Data Models folder where the permissions on the folder… -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 104 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 952 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Need assistance on Bursting report for Visa and Passport expirationSummary: Hi, Our requirement: The alert should trigger Worker and AOR on Worker passport expires. The Notification should be sent before 30days. Currently Alert composer…RamkumarKadhiravan 1 view 0 comments 0 points Started by RamkumarKadhiravan Reporting and Analytics for HCM -
Ho do i add PO number to the 'Receivables Aging by General Ledger Account Report'Summary: Need to Add PO Number detail in 'Receivables Aging by General Ledger Account Report'. For that we are trying to customize the same for that but as the main quer…Kasi Eswari 21 views 1 comment 0 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections