BI Publisher
Discussion List
-
New FRS report is not visible for the user in the Financial Reporting CenterSummary: New FRS reports is not visible for the user in the Financial Reporting Center Content (please ensure you mask any confidential information): New FRS reports are…Chittibabu Dudala 4 views 2 comments 0 points Most recent by Chittibabu Dudala General Ledger & Intercompany -
How to track email delivery status for the emails (invoice, dunning) sent to customers?Summary: Oracle Fusion Accounts Receivable (AR) sends high volumes of customer emails daily, such as Invoices, Customer Statements, and Dunning Letters. However, there i…
-
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 33 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 -
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 6 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 7 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 41 views 3 comments 0 points Most recent by Stesha Sasidaran 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 13 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 4 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 445 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?