BI Publisher
Discussion List
-
Is there a way to add field in Edit distribution feature on the BPM notificationIs it possible to pull the accounting date field into the BPM notification and make it editable when using the edit distributions feature on an invoice notificationAkanksha Bhardwaj 31 views 6 comments 0 points Most recent by Mohit8799 Payables, Payments & Cash Management -
Extracting Learning data from Oracle EBSSummary: Extracting Learning data from Oracle EBS Content (please ensure you mask any confidential information): Hi Team, Greetings! This question is about extracting Le… -
how to join xcc_budget_accounts to projects,tasks and expenditure typesSummary: i want to know the joins between xcc_budget_accounts and project tables. i have tried to join segment_value1 with project number from pjf_projects_all_b which i… -
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 11 views 2 comments 0 points Most recent by Javier Zakzuk Payables, Payments & Cash Management -
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…Pranat Damani 1 view 0 comments 0 points Most recent by Pranat Damani Reporting and Analytics for ERP
-
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 1 view 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…
-
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…
-
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 311 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 41 views 2 comments 0 points Most recent by User_59TDH Reporting and Analytics for ERP
-
"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…
-
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 11 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 1 view 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 1 view 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 551 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.4K 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 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
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 539 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 …
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 43 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need a query to fetch the status of Manage Negotiations pageContent Hello, Can someone please tell me a table to fetch the status of the negotiation on the Manage Negotiations page. Please find the attached image with the require…Sushan Peiris 2.5K views 9 comments 4 points Most recent by PranjulG Reporting and Analytics for SCM -
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 51 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP