BI Publisher
Discussion List
-
unable to open Oracle seeded reportSummary: I do not see option to open the report. Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable… -
Issues in Prepayment Handling in Custom AP Aging Report (As-of-Date Logic – Oracle Fusion)Summary: Incorrect remaining amount calculation in custom AP Aging Report due to improper handling of multiple prepayment applications (Invoice-Level and Line-Level), in…
-
Permission for standard folderSummary: Hello, I'd like to know if we can set permission for Human Capital Management under shared folder(the standard folder) to specific users. I managed to do that i…Mayar Mohamed 5 views 2 comments 0 points Most recent by Mayar Mohamed Reporting and Analytics for ERP
-
Report notifies manager when time reported by employee is less than 4.5 hoursSummary: I need to build a report that will have coloumns Emp name, number, manager name, department, and calendar days in recent time card on which date employee report…Vamsi Krishna G 6 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to fetch a comma separated string into separate columns in Oracle fusionSummary: We have a column name - "Approvers" from table - "FA_FUSION_SOAINFRA.WFTASK". When we have multiple approvers for a transaction and those will appear in the "Ap…
-
How to enable deep link in payment approval notificationSummary: How to enable deep link in payment approval notification? Content (please ensure you mask any confidential information): Hi all, We got a requirement to show in…Venkatesan 43 views 3 comments 0 points Most recent by Stesha Sasidaran Payables, Payments & Cash Management
-
I need to review the Invoice Header.Account Coding StatusSummary: Hi Oracle, I need to review the Invoice Header.Account Coding Status when it is not marked as “Complete.” Could you please confirm the exact value that should b…Javier Zakzuk 13 views 1 comment 0 points Most recent by Purvi -Oracle Payables, Payments & Cash Management -
Customize Receivables Aging by General Ledger Account ReportSummary: Hi, We want to customize the "Receivables Aging by General Ledger Account Report" for a specific GL Account. We know how to customize/ extend a seeded ESS BIP r…Gireesha Pinnagoda 225 views 6 comments 0 points Most recent by User_3XIID Receivables & Collections
-
Default person name using SQL query for DFFHi Team, We have a requirement to default the person name on DFF filed using SQL query. By default the DFF value should be the person name who is logged in currently. We…Suresh Manchukonda 31 views 2 comments 0 points Most recent by User_59TDH Reporting and Analytics for ERP
-
Need query to get the list of all users for a given roleSummary: Need query to get the list of all users for a given role Could you pleaes provide me the query to get list of all users for a given role. attached the screen sh…User_7A1QO 878 views 3 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
"View History" section doesn't work when update bank account number through Personal Payment MethodsSummary: Hi, We are developing a BI Publisher report to monitor changes in various system attributes, including the Bank Account Number. Enabling auditing was a necessar…
-
Invoice Approval Notification: Task details aren't available for this task. (FUN-720809)Summary: Our Invoice approvals are based on mail & one user has been getting "Task details aren't available for this task. (FUN-720809)" & notification is empty without …Sujatha Kumari 17 views 4 comments 0 points Most recent by Sujatha Kumari Payables, Payments & Cash Management
-
Dynamic Hyperlink/deeplink that is more user friendlySummary: I am looking to insert a dynamic hyperlink/deeplink that is more user friendly. The current URL at the bottom of the email is very long and not user friendly at…Consultant Ian 18 views 4 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
Query to capture daily balances from gl_daily_balances_v / gl_daily_balances tableSummary: We need to capture the daily opening balance, credit balance, debit balance, and closing balance for both functional and entered currencies. Although ADB is cur…Praveen Gollu-Oracle 8 views 1 comment 0 points Most recent by Gaurav Kumar-100036 General Ledger & Intercompany
-
HCM Position HierarchySummary: Hi Team, We have a requirement to develop a new report as like "HCM Position Hierarchy" standard report, so please share code file or file path and report name …
-
How to schedule BIP report in application composer ?Summary: I would like to use the application composer to schedule a BIP report I have defined the (https://****/xmlpserver/services/ScheduleReportWSSService?WSDL ) webse…
-
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 3 views 1 comment 0 points Most recent by SankarBalu Reporting and Analytics for ERP
-
Can we add Custom P_LANGUAGE Parameter for template translations in fusionSummary: Hi Team, Can we add customer language parameter to select templates and translations based on xliff loaded using language paramter in Oracle BIP. Its working wi…
-
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…User_F89L9 443 views 10 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6.3K views 6 comments 2 points Most recent by SankarBalu Payables, Payments & Cash Management
-
How to generate subtotals in rtf templateSummary: Requirement to show subtotals at the top of each source Content (please ensure you mask any confidential information): I have developed a template that looks li…
-
Why does the Oracle ISO20022SEPAV7_0 not convert characters that are not allowed by SEPA?Summary: Why does the Oracle ISO20022SEPAV7_0 seeded payment format not convert characters that are not allowed by SEPA? -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.3K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP
-
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …AntonyD 8 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
SQL to get the ESS job run details with Parameter ValuesSummary: We have a requirement to analyse the performance issues for some of Project application ESS jobs for our client. TO this end, I would like to see get an extract…Rakesh Viswam-Oracle 48 views 6 comments 0 points Most recent by Rakesh Viswam-Oracle Reporting and Analytics for ERP
-
Link to Linkedin CourseHi, we need to send the Oracle Course Catalog to an external system, for Linkedin Courses we want that users of external system will access direclty to Linkedin wihout p… -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 527 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
How to convert column into HTML format in BIP datamodelSummary: OTBI column output: Here how same column appears in SQL Datamodel in BIP So, could you kindly help on how we can convert this Comment column to be displayed as …