Reporting and Analytics
Discussion List
- 
             ZX_REP_TRX_DETAIL_T not giving any dataSummary: I need accounting information for the transactions. zx_lines is not helping since it does not have history data. Tried using ZX_REP_TRX_DETAIL_T, but its not gi…Sharmava 591 views 1 comment 0 points Most recent by Gopal Reddy-Oracle Reporting & Analytics for Fusion Service ZX_REP_TRX_DETAIL_T not giving any dataSummary: I need accounting information for the transactions. zx_lines is not helping since it does not have history data. Tried using ZX_REP_TRX_DETAIL_T, but its not gi…Sharmava 591 views 1 comment 0 points Most recent by Gopal Reddy-Oracle Reporting & Analytics for Fusion Service
- 
             Will a version of SQL Developer that can connect to a SaaS instance be released?Summary: We see other products that are being marketed to allow users to query the tables in the SaaS database. Just wondering if a version of SQL Developer might be dev…C_Blocklin 31 views 2 comments 1 point Most recent by SukantaBarari-Oracle Reporting & Analytics for Fusion Service Will a version of SQL Developer that can connect to a SaaS instance be released?Summary: We see other products that are being marketed to allow users to query the tables in the SaaS database. Just wondering if a version of SQL Developer might be dev…C_Blocklin 31 views 2 comments 1 point Most recent by SukantaBarari-Oracle Reporting & Analytics for Fusion Service
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_URGENCIES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_URGENCIES_VL? Content (required): Version (include… Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_URGENCIES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_URGENCIES_VL? Content (required): Version (include…
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENTS_AUDIT_BSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENTS_AUDIT_B? Content (required): Version (include the… Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENTS_AUDIT_BSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENTS_AUDIT_B? Content (required): Version (include the…
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity JTF_ESCALATION_TASK_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity JTF_ESCALATION_TASK_V? Content (required): Version (include th… Equivalent Oracle Cloud table/view for the EBS 11i entity JTF_ESCALATION_TASK_VSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity JTF_ESCALATION_TASK_V? Content (required): Version (include th…
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_BILLING_TYPE_CATEGORIESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_BILLING_TYPE_CATEGORIES? Content (required): Version (inclu… Equivalent Oracle Cloud table/view for the EBS 11i entity CS_BILLING_TYPE_CATEGORIESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_BILLING_TYPE_CATEGORIES? Content (required): Version (inclu…
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CSD_REPAIR_TYPES_TLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSD_REPAIR_TYPES_TL? Content (required): Version (include the … Equivalent Oracle Cloud table/view for the EBS 11i entity CSD_REPAIR_TYPES_TLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSD_REPAIR_TYPES_TL? Content (required): Version (include the …
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_HZ_SR_CONTACT_POINTSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_HZ_SR_CONTACT_POINTS? Content (required): Version (include … Equivalent Oracle Cloud table/view for the EBS 11i entity CS_HZ_SR_CONTACT_POINTSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_HZ_SR_CONTACT_POINTS? Content (required): Version (include …
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_STATUSES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_STATUSES_VL? Content (required): Version (include … Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_STATUSES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_STATUSES_VL? Content (required): Version (include …
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_SEVERITIES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_SEVERITIES_VL? Content (required): Version (includ… Equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_SEVERITIES_VLSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CS_INCIDENT_SEVERITIES_VL? Content (required): Version (includ…
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_LOOKUPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_LOOKUPS? Content (required): Version (include the version … Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_LOOKUPSSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_LOOKUPS? Content (required): Version (include the version …
- 
             Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTANCE_STATUSESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTANCE_STATUSES? Content (required): Version (include th… Equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTANCE_STATUSESSummary: Could you please help us to provide the equivalent Oracle Cloud table/view for the EBS 11i entity CSI_INSTANCE_STATUSES? Content (required): Version (include th…
- 
             Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 51 views 3 comments 0 points Most recent by Nikatfusion Reporting & Analytics for Fusion Service Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 51 views 3 comments 0 points Most recent by Nikatfusion Reporting & Analytics for Fusion Service
- 
             Oracle Fusion: Is there any relationship/link between Security Job Roles and FND ApplicationsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Gireesha Pinnagoda 41 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle Reporting & Analytics for Fusion Service Oracle Fusion: Is there any relationship/link between Security Job Roles and FND ApplicationsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Gireesha Pinnagoda 41 views 3 comments 0 points Most recent by Baidehi Nanda–Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to link "Corporate card transaction reversal" invoice lines from expenses to Company AccountSummary: I am attempting to create a BI report using SQL Query to report on the miscellaneous invoice lines, which are system generated from credit card expense reports … How to link "Corporate card transaction reversal" invoice lines from expenses to Company AccountSummary: I am attempting to create a BI report using SQL Query to report on the miscellaneous invoice lines, which are system generated from credit card expense reports …
- 
             Is it possible to add a Payment Date Parameter for Payables Withholding Tax Report.Summary: Adding Payment Date Parameter for Payables Withholding Tax Report. Can you please advise and provide the steps. Content (required): We are trying to add Payment…VagdeviAkella 41 views 1 comment 0 points Most recent by VagdeviAkella Reporting & Analytics for Fusion Service Is it possible to add a Payment Date Parameter for Payables Withholding Tax Report.Summary: Adding Payment Date Parameter for Payables Withholding Tax Report. Can you please advise and provide the steps. Content (required): We are trying to add Payment…VagdeviAkella 41 views 1 comment 0 points Most recent by VagdeviAkella Reporting & Analytics for Fusion Service
- 
             How to create reports related to tables that are only in PaaSSummary: Hi, We want to know if there is a way to create reports in SaaS that retrieve information related to tables that are only in PaaS. I have created a custom table…Iker Garcia Martin 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service How to create reports related to tables that are only in PaaSSummary: Hi, We want to know if there is a way to create reports in SaaS that retrieve information related to tables that are only in PaaS. I have created a custom table…Iker Garcia Martin 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
- 
             Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m… Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m…
- 
             BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…maroti.n.pawde 111 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service BIP report output file encoding is changing in different ERPC environment, why this is happening?Summary: We developed a BIP report and for that BIP report client requirement is to send data in particular format and it should be in UTF-16LE encoding . file is in .tx…maroti.n.pawde 111 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
- 
             View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service
- 
             What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…Suri Natarajan-Oracle 72 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service What is the limitation for how large of an XML string Oracle/BIP can handle?Summary: **This post was created as part of a How to Service Request (SR) Release: 23A Content (required): Customer is getting data from external source using web servic…Suri Natarajan-Oracle 72 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service
- 
             Adding static hyperlink to BIP RTF TemplateSummary: I need to add a basic static hyperlink to a BIP rtf template to open a OTBI analysis. I cannot get the hyperlink or even basic text to display once I upload the…Jarrett 241 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service Adding static hyperlink to BIP RTF TemplateSummary: I need to add a basic static hyperlink to a BIP rtf template to open a OTBI analysis. I cannot get the hyperlink or even basic text to display once I upload the…Jarrett 241 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
- 
             Payload is required for the SOAP web service - BIP scheduled job historySummary: We require the payloads of BIP scheduled job history SOAP web service. Please find the following web service details and share the appropriate payloads to get t…Lakshmana Rao Bandaru-Oracle 163 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle Reporting & Analytics for Fusion Service Payload is required for the SOAP web service - BIP scheduled job historySummary: We require the payloads of BIP scheduled job history SOAP web service. Please find the following web service details and share the appropriate payloads to get t…Lakshmana Rao Bandaru-Oracle 163 views 4 comments 0 points Most recent by Lakshmana Rao Bandaru-Oracle Reporting & Analytics for Fusion Service
- 
             How to pass date to ESS Job for Oracle BI reportSummary: We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page t…Hardik Gupta 1.2K views 1 comment 0 points Most recent by Hima Bindu Patil -Oracle Reporting & Analytics for Fusion Service How to pass date to ESS Job for Oracle BI reportSummary: We have created a report that takes start and end date as mandatory parameters in the format (MM-dd-yyyy). When we run this report from Analytics Catalog page t…Hardik Gupta 1.2K views 1 comment 0 points Most recent by Hima Bindu Patil -Oracle Reporting & Analytics for Fusion Service
- 
             i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service i have this two rows in the result column from union of two subject area i need to divide those rowsSummary: i need to divide the result from subject area 1 (defect as in the screenshot ) above the result of subject area two (total as in screenshot ) Content (required)…Ab_AM 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting & Analytics for Fusion Service
- 
             Multiple Values for BIP Report Parameter from LOVSummary: How to select multiple values from a LOV for a BIP report parameter Content (required): Version (include the version you are using, if applicable): Code Snippet…Robert A 114 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting & Analytics for Fusion Service Multiple Values for BIP Report Parameter from LOVSummary: How to select multiple values from a LOV for a BIP report parameter Content (required): Version (include the version you are using, if applicable): Code Snippet…Robert A 114 views 1 comment 0 points Most recent by Bharath Raghupathi-Oracle Reporting & Analytics for Fusion Service
- 
             remove rows with 0 value from reportSummary: Remove rows with 0 value from report or remove weekend dates/Saturday and Sunday days only. Content (required): reports Version (include the version you are usi…Marissa Gonzales 21 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting & Analytics for Fusion Service remove rows with 0 value from reportSummary: Remove rows with 0 value from report or remove weekend dates/Saturday and Sunday days only. Content (required): reports Version (include the version you are usi…Marissa Gonzales 21 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting & Analytics for Fusion Service
- 
             How can we identify the reports that are using a Custom Subject Area?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: There is a way to find the reports that are using a Custom Subject…Ionel Spaloghe-Support-Oracle 21 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Fusion Service How can we identify the reports that are using a Custom Subject Area?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: There is a way to find the reports that are using a Custom Subject…Ionel Spaloghe-Support-Oracle 21 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Fusion Service
- 
             How do I display the lookup code in a OTBI analysis?Summary How to display a custom fiel lookup code in a OTBI analysis?Content Hi, A client wants a OTBI report with columns that contain the lookup code of some account's …XUM TECHNOLOGIES 529 views 4 comments 1 point Most recent by Roxana Oprean Reporting & Analytics for Fusion Service How do I display the lookup code in a OTBI analysis?Summary How to display a custom fiel lookup code in a OTBI analysis?Content Hi, A client wants a OTBI report with columns that contain the lookup code of some account's …XUM TECHNOLOGIES 529 views 4 comments 1 point Most recent by Roxana Oprean Reporting & Analytics for Fusion Service
- 
             BICC PVO is extracting same delta extract every time irrelevant to Last Extract DateSummary: BICC PVO is extracting the same delta extract every time irrelevant to the Last Extract Date. Below are the two PVO for which we are encountering this issue: 1.…Vivek Gautam 72 views 2 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting & Analytics for Fusion Service BICC PVO is extracting same delta extract every time irrelevant to Last Extract DateSummary: BICC PVO is extracting the same delta extract every time irrelevant to the Last Extract Date. Below are the two PVO for which we are encountering this issue: 1.…Vivek Gautam 72 views 2 comments 1 point Most recent by Sahithi Kolasani-Oracle Reporting & Analytics for Fusion Service