Category 385
Discussion List
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCES? Content (required): Version (include th… Equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity QA_CSI_ITEM_INSTANCES? Content (required): Version (include th…
- 
             Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…Jessamyn Donovan 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…Jessamyn Donovan 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 39 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 39 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…Gurujothi D 458 views 4 comments 3 points Most recent by Hugo Martínez Reporting and Analytics for SCM Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…Gurujothi D 458 views 4 comments 3 points Most recent by Hugo Martínez Reporting and Analytics for SCM
- 
             Transaction table limitation in performance goalsHi Team, Please find my concern below: There is a limitation on transaction table "fa_fusion_soainfra.wftask" to store data only up to latest 3 months. I want to know if… Transaction table limitation in performance goalsHi Team, Please find my concern below: There is a limitation on transaction table "fa_fusion_soainfra.wftask" to store data only up to latest 3 months. I want to know if…
- 
             when are the update for FAW?Summary: When are the updates for FAW Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…Kathleen 11 views 1 comment 0 points Most recent by Kathleen Reporting & Analytics for Fusion Service when are the update for FAW?Summary: When are the updates for FAW Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Sni…Kathleen 11 views 1 comment 0 points Most recent by Kathleen Reporting & Analytics for Fusion Service
- 
             Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…Sateesh Kumar 51 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…Sateesh Kumar 51 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service
- 
             how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables how to link Absences table with work force scheduling table in oracle fusionI am looking for a query which list employee work schedule including leaves. Any suggestion on how to join absences module with work force module tables
- 
             Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi… Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
- 
             New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a… New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a…
- 
             Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca… Customize Career Development Report not workingGreetings team! The customize feature in BI Publisher for the 'Career Development Report', that is available in the Oracle HCM Cloud application in Person Spotlight > Ca…
- 
             Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 33 views 1 comment 0 points Most recent by DMW_HILLSCOUNTY Payables, Payments & Cash Management Is any currently using NACHA File Format with more than one addenda record?I am trying to implement a NACHA CTX Format for my eText bank file using the US NACHA CCDP template. I have tried other templates as well. The closest I have come is to …Keith Doucet 33 views 1 comment 0 points Most recent by DMW_HILLSCOUNTY Payables, Payments & Cash Management
- 
             PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 14 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 14 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM
- 
             Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …Sudeepto 96 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM Customising Sales Order Acknowledgement ReportTrying to customize Sales Order Acknowledgement Report, I have added new fields in the Data model but when I have added the new fields in Template using BI Publisher as …Sudeepto 96 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
- 
             1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…Darwin HP 72 views 4 comments 1 point Most recent by Darwin HP Reporting & Analytics for Fusion Service 1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…Darwin HP 72 views 4 comments 1 point Most recent by Darwin HP Reporting & Analytics for Fusion Service
- 
             Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…Kameron Withak 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…Kameron Withak 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
- 
             sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Rahul K-Oracle 21 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Rahul K-Oracle 21 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
- 
             I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 32 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 32 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
- 
             what is the option to get BIP and OTBI report usage details from Oracle Fusion Reports and AnalyticsWe have lots of custom reports (BIP and OTBI) piled up since years and want to cleaned up un-used reports. We are looking for any audit/usage report which will provide d…Narasimha Raju 23 views 2 comments 0 points Most recent by Narasimha Raju Reporting & Analytics for Fusion Service what is the option to get BIP and OTBI report usage details from Oracle Fusion Reports and AnalyticsWe have lots of custom reports (BIP and OTBI) piled up since years and want to cleaned up un-used reports. We are looking for any audit/usage report which will provide d…Narasimha Raju 23 views 2 comments 0 points Most recent by Narasimha Raju Reporting & Analytics for Fusion Service
- 
             Hide Reject Button only in Performance Goal Approval Workflow Email NotificationsHi, We need to populate only Approve and Request info buttons in workflow email and remove Reject button. Thanks, Chetanpuja suryanarayana 32 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management Hide Reject Button only in Performance Goal Approval Workflow Email NotificationsHi, We need to populate only Approve and Request info buttons in workflow email and remove Reject button. Thanks, Chetanpuja suryanarayana 32 views 1 comment 0 points Most recent by InaNotra-Oracle Performance Management
- 
             Actually our dev leads asking for read only access to BI report on Prod instanceActually our dev leads asking for read only access to BI report on Production instance and we need to restrict them to query our salary , compensation, Performance relat…poornima_kole 61 views 3 comments 0 points Most recent by Vasu V Reporting & Analytics for Fusion Service Actually our dev leads asking for read only access to BI report on Prod instanceActually our dev leads asking for read only access to BI report on Production instance and we need to restrict them to query our salary , compensation, Performance relat…poornima_kole 61 views 3 comments 0 points Most recent by Vasu V Reporting & Analytics for Fusion Service
- 
             Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…Sudara 195 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service Bold letters are not showing in PDF OutputHi , We are facing an issue while generating PDF outputs for BI Publisher (BIP) reports. When the PDF output is generated using the RTF template, the bold letters in the…Sudara 195 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
- 
             We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections We need a query to retrieve the AR remittance batch approver's name and approval date.Hi All, We need to retrieve the batch approver name and approval date for a remittance batch. Is there an existing table, column, or query that can provide these details…nehayadav86 11 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
- 
             Need to trigger Custom ESS job rather than standard ESS job for sending Dunning LettersIn the Collections menu, under the customer profile, there is an option called "Strategies." Within this, there is a "Tasks" section with options like "Soft Reminder" an… Need to trigger Custom ESS job rather than standard ESS job for sending Dunning LettersIn the Collections menu, under the customer profile, there is an option called "Strategies." Within this, there is a "Tasks" section with options like "Soft Reminder" an…
- 
             Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification…Katharina_Seidenfuß 13 views 0 comments 0 points Started by Katharina_Seidenfuß Reporting and Analytics for HCM Report - send notifications to usersHi together, We have following requirement from our customer: They want to have one report, where they can check (based on security level through AOR) which notification…Katharina_Seidenfuß 13 views 0 comments 0 points Started by Katharina_Seidenfuß Reporting and Analytics for HCM
- 
             Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 51 views 2 comments 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service Issues in creating hyperlink and passing dynamic input parameter from BI Publisher RTF templateDear Team, Pls provide me the list of steps to pass dynamic input parameter in BIP report, We are trying to achieve hyper link as a drill down report, hence we need your…Sabyasachi Mishra 51 views 2 comments 0 points Most recent by Sabyasachi Mishra Reporting & Analytics for Fusion Service
- 
             How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which… How I can fetch licence details, which stored against employee’s job profile?if employee has multiple assignments, and I want to get licence detail of assignment then how I can fetch by using sql. I wrote the sql query to fetch all licences which…
- 
             Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …Ksimmy200 21 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service Are there APIs for Fusion Data Intelligence?Summary: The most frequently asked question that I face from customers is 'How do I get my data out of ADW, as I already have a data warehousing strategy?' While during …Ksimmy200 21 views 1 comment 0 points Most recent by Will Paddock -Support-Oracle Reporting & Analytics for Fusion Service