Category 129
Discussion List
- 
             Encrypt File Bursted Via EmailSummary: Hi, Is there a way we can encrypt file bursted via email? File type is Excel Regards, Kay Encrypt File Bursted Via EmailSummary: Hi, Is there a way we can encrypt file bursted via email? File type is Excel Regards, Kay
- 
             Drill down to ERP pages through Infolets as standard onesSummary: Hi, We want to create objectives that are actionable that is, as the standard ones from Oracle. For example, create an infolet that shows the number of invoices…Emma Fayos García 21 views 2 comments 1 point Most recent by Emma Fayos García Reporting and Analytics for ERP Drill down to ERP pages through Infolets as standard onesSummary: Hi, We want to create objectives that are actionable that is, as the standard ones from Oracle. For example, create an infolet that shows the number of invoices…Emma Fayos García 21 views 2 comments 1 point Most recent by Emma Fayos García Reporting and Analytics for ERP
- 
             Run SOAP web service from bi publisher.Summary: Hi, please I would like help with the following: I try to setup a connection as web service: I define the datamodel to use this connection: Looks good! it seems…Juan Jesus 41 views 5 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP Run SOAP web service from bi publisher.Summary: Hi, please I would like help with the following: I try to setup a connection as web service: I define the datamodel to use this connection: Looks good! it seems…Juan Jesus 41 views 5 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
- 
             showing a historical assignment as latest for some employeesSummary: We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for… showing a historical assignment as latest for some employeesSummary: We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for…
- 
             Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 21 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…Kalyani-Oracle 21 views 3 comments 0 points Most recent by Kalyani-Oracle Reporting and Analytics for ERP
- 
             OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…Dona Das-Oracle 32 views 5 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP OTBI IssueHi There is an existing OTBI report which attached below. Now the customer requirement is to add the below condition. But on adding this, the count is reducing. Please s…Dona Das-Oracle 32 views 5 comments 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
- 
             How to add Reports and Analytics menu to Order Management Dashboard pageSummary: We have a requirement to add Reports and Analytics drop down menu with access to all reports on Order Management Home Page. Content (please ensure you mask any …Nagarjuna Nudurupati 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP How to add Reports and Analytics menu to Order Management Dashboard pageSummary: We have a requirement to add Reports and Analytics drop down menu with access to all reports on Order Management Home Page. Content (please ensure you mask any …Nagarjuna Nudurupati 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
- 
             Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your thoughts. Content (please ensure you mask any confidential i…Lucky Sharma 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP
- 
             Standard Memo Line Report - Revenue CodingSummary: I have a customer requirement to be able to export a list of all standard memo lines and their associated Revenue coding, required fields highlighted in .JPG. C… Standard Memo Line Report - Revenue CodingSummary: I have a customer requirement to be able to export a list of all standard memo lines and their associated Revenue coding, required fields highlighted in .JPG. C…
- 
             oracle fusion ESS job request limits per hour.Summary: We have a requirement to run a report through ESS in Oracle SaaS application, expecting 1500 requests per hour. is oracle supports these volume? is there a way …Santhosh Mothepati 231 views 2 comments 1 point Most recent by Gerardo Carrillo Applications Security oracle fusion ESS job request limits per hour.Summary: We have a requirement to run a report through ESS in Oracle SaaS application, expecting 1500 requests per hour. is oracle supports these volume? is there a way …Santhosh Mothepati 231 views 2 comments 1 point Most recent by Gerardo Carrillo Applications Security
- 
             Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO… Where can I find the Payment Number for Payables on OTBISummary: I'm trying to pull together a report listing payments made to suppliers and need to include the the Payment Reference Number (i.e. the cheque, payable order (PO…
- 
             IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?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…Manoj Vasa 26 views 2 comments 0 points Most recent by Kadiri Prathusha Reporting and Analytics for ERP IN OTBI How to display the data as per user preferred time zone and dynamically add GMT /- ?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…Manoj Vasa 26 views 2 comments 0 points Most recent by Kadiri Prathusha Reporting and Analytics for ERP
- 
             I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 21 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 21 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP
- 
             Add "Cost Element Type" in OTBI Report "Costing - Period Inventory Valuarion Real Time" subject areaHi, I've created a report in OTBI to detail the On Hand valuation information. We are using the new subjet area "Costing - Period Inventory Valuation Real Time". We need…Sebastián Bach 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP Add "Cost Element Type" in OTBI Report "Costing - Period Inventory Valuarion Real Time" subject areaHi, I've created a report in OTBI to detail the On Hand valuation information. We are using the new subjet area "Costing - Period Inventory Valuation Real Time". We need…Sebastián Bach 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
- 
             How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte… How to read a tab delimited data using querySummary: I have a text file which have data separated by tab. I need to split that into multiple columns. How i can write a query to achieve this. any idea please. Conte…
- 
             Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 21 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP Sql query issueHi All, We have a sql query. Now we have a requirement to add a condition so that employees with AEI_ATTRIBUTE4 from PER_ASSIGNMENT_EXTRA_INFO_M table is NULL, should sh…Dona Das-Oracle 21 views 3 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for ERP
- 
             How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external… How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
- 
             How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure … How to create drill down charts in Oracle BI Publisher (BIP) Reports?Summary: How to create an interactive or drill down charts in BIP reports, where clicking on a chart updates the data in other charts and tables? Content (please ensure …
- 
             In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 12 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP In which Subject Area can I found the end date of an account.Hello, I am trying to bring the value of the End date of a GL account in an OTBI report . This value can be inputted in Manage chart of accounts value set values feature…Vlad CONSTANTIN 12 views 2 comments 0 points Most recent by Vlad CONSTANTIN Reporting and Analytics for ERP
- 
             "Check Digits" on a Supplier Bank Account Record in BIP SQL TABLE locationHi Guys Does anyone know please which BIP table contains the field "Check Digits" for a supplier bank account? I need to get the checkdigits field for a supplier bank ac… "Check Digits" on a Supplier Bank Account Record in BIP SQL TABLE locationHi Guys Does anyone know please which BIP table contains the field "Check Digits" for a supplier bank account? I need to get the checkdigits field for a supplier bank ac…
- 
             Populating xcc_balances table - requesting more informationSummary: Hello, Our BI report which shows the budget amounts for our accounts is missing a certain account for specific periods. It looks like the period names are missi… Populating xcc_balances table - requesting more informationSummary: Hello, Our BI report which shows the budget amounts for our accounts is missing a certain account for specific periods. It looks like the period names are missi…
- 
             How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 11 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP How to query the emirate in Customer Account Site addressHello, We are currently creating a Customer report, and we need to retrieve the Emirate under the Customer Account site address. From which table and what field can this…Kristelle 11 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
- 
             Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 21 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP Is is possible to create an audit report that has all FRS BIP and OTBI reports?Summary: Is there a way to get details of report along with the last run date individually (individual report for each areas) for reports & analysis - in OTBI and a Fina…Soare Oldrich Alexandru-Oracle 21 views 4 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
- 
             Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 311 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…Bo Tøpgaard 311 views 6 comments 0 points Most recent by Neha D-Oracle Reporting and Analytics for ERP
- 
             Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties…
- 
             XLAFSNAPRPT job nameHi, I need to find the job name (ex: for XLAFSNAPRPT, job name is Create Accounting). Is there any table that store this information or it is only MetaData (xml) ? Thank…M. Tonghioiu 82 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP XLAFSNAPRPT job nameHi, I need to find the job name (ex: for XLAFSNAPRPT, job name is Create Accounting). Is there any table that store this information or it is only MetaData (xml) ? Thank…M. Tonghioiu 82 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
- 
             Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S… Backend tables or SQL query to know "Manage Enterprise Scheduler Job Definitions"Summary: Hi Team, We are unable to find the tables or SQL query to get the data under the task "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, S…
- 
             Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid…Tina Valtchev 11 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP Is it possible to store both US and Local Legal Entity Identifiers in Oracle?Summary: Our business team would like to know if it's possible to store multiple registration numbers for an Entity in Oracle. Content (please ensure you mask any confid…Tina Valtchev 11 views 1 comment 0 points Most recent by Julien_Dubouis Reporting and Analytics for ERP
- 
             Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 32 views 4 comments 1 point Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP Set BIP folder/report permissions by RoleSummary: I'm trying to set the permissions on a folder in Reports & Analytics based on Application Role. The specific role I want to use doesn't appear in the list of va…Lisa D 32 views 4 comments 1 point Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP
- 
             Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 12 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 12 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP