BI Publisher
Discussion List
-
BI Publisher - pulling Candidate Source Medium and SourceSummary: We have a BI publisher report that we want to use to report on Candidates who are specifcally coming from these two Source Mediums: Referral and "Candidate adde…Evelina Hobson 31 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Need to change default from email address"bipublisher-report@oracle.com" to customer email addressesSummary: Hi Experts, We are trying to burst the BI outputs and needed to change the default from email address "bipublisher-report@oracle.com" to other. Let's say for le…Rama123-Oracle 546 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Need query to get the list of all roles for a given roleSummary: Navigation: Tools > SecurityConsole > Roles If I query a role name, I want display all the roles associated with it. I want to build a query for the same. Pleas…Niranjan_DTCC 41 views 4 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
HCM Extract reference root data group attribute in child nodeSummary: I have a custom extract to pull payroll balance for employees. It has 2 data groups. The first data group has balance values and child data group has employee d…
-
How to create consolidated AR invoices based on Order Types or Invoice rules in oracle fusionSummary: Do we have details available on what are the options available to consolidate Oracle AR Invoice in Fusion ? Business doesn't want use Bills Forward billing feat…
-
SQL query for absence disbursementSummary: Hi Experts, I need to fetch the absence disbursement value for a plan (screenshot attached) using a SQL query. Can some one please help with a sample SQL for th…Pinky Mukherjee 101 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM -
BIP Report - How to calculate exact AgeSummary: Hi All, Can anyone please confirm the query to calculate the exact Age in BIP report. I tried multiple functions like Datediff & Months_between but, they are no…Sagar Perala 121 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Can we pass SYSDATE in Share report link URL of reportWe need to pick sysdate instead of static date in report Link. eg: https://fa-****-saasfaprod1.fa.ocs.oraclecloud.com:443/xmlpserver/Custom/XXXX/Reports and Analytics/Co…Sourabh Patial 61 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…sultank 21 views 1 comment 0 points Most recent by Jun Ye-Support-Oracle Reporting and Analytics for HCM
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 31 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP
-
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …Janardhana Kondaveeti 243 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?Anj M. 111 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Do we have unplanned depreciation report in Fusion Fixed assets ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PL Karthick Ramanathan 21 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get…
-
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 722 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …Prakash Shetty 11 views 2 comments 0 points Most recent by Prakash Shetty Reporting and Analytics for SCM
-
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? ThanksNaidu.R-Oracle 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management -
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Most recent by Mustafa Abu Dayeh Reporting and Analytics for HCM
-
Table Name for Approver's Data of BPM Worklist along with History of Approver'sSummary: Issue : Table Name for Approver's Data of BPM Worklist along with History of Approver's for a Person whose Task are Completed Now We want Table Name's for Appro…Roy Aniket 63 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Payables, Payments & Cash Management
-
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM
-
Not able to find join between budget tables and GL_BALANCESSummary: We have a requirement to build a custom report where most of the columns are from the control budget screen under budgetary control. We are fetching budget colu… -
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 31 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM
-
join GL_BALANCES and XCC budget tablesSummary: How to join XCC_ tables with GL_Balances Content (please ensure you mask any confidential information): Hi, We have requirement of building a custom report wher…SauarbhAgrawal 427 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle Budgetary Control
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 131 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 35 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration