BI Publisher
Discussion List
-
How to add Intermediary Bank account field for Customized ISO20022 Payment FormatSummary: Hello, We need a customized ISO20022 Payment format with the intermediary bank account fields. I followed the doc ID How To Add Intermediary Bank Fields for Cus…Mariam Lefranc 124 views 5 comments 0 points Most recent by Gautham Pradan Ramu Payables, Payments & Cash Management -
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…Vinayak Hegde 32 views 3 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM -
Audit - On Folder Permissions ChangesWe have a requirement on Auditing folder Permissions Changes details on "Reports and Analytics --> Catalog --> Shared folder --> Changes on any of the custom folder perm…Ramachandran Mani 33 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 65 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM -
BI Publisher Scheduled Report Not Reflecting Updated Recipient List in Oracle FusionSummary: We are facing an issue with an existing scheduled BI Publisher report in Oracle Fusion. After updating the recipient email list in the schedule, the changes are…Gurivi Reddy-Oracle 14 views 2 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
CAMT053 Bank statement load failing with CE-660228 Despite custom JPM FormatSummary: We are trying to load JPMorgan chase CAMT053.001.02 bank statement files into oracle fusion CM using the Load and import bank statement ESS process. The file co…Prashant Prashant 33 views 1 comment 0 points Most recent by Sanket Darokar Payables, Payments & Cash Management
-
per_national_identifiers security?Does the table per_national_identifiers have AOR security? I see quite different row counts depending on whether I run a count (*) from pni when logged in as a country H…Stephen Jones 15 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
SQL to Find AP invoices assigned for approval to wf groups where those role currently has no usersWe have a requirement to fetch the invoices assigned for approval to wf groups(roles) which has no active users, if anyone has any sql or BIP report could you please hel…Naveen_CCC 12 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Can we exclude minimum amount receipts from AR Aging report (like -0.01)Our customer don't want receipts which has amount less than $1 in their AR aging report (attached ss for the same), can we exclude those receipts from this report?Jayshree Chavan 3 views 4 comments 0 points Most recent by Jayshree Chavan Receivables & Collections -
Suggestion Needed: Removal of special characters at the XSL template level for Payment OutboundsHi Oracle Cloud Community, I hope this message finds you well. We are working on a project where our client requires payment outbound files generated in oracle cloud whi…Subhranil Maitra 64 views 3 comments 1 point Most recent by User_6GELQ Payables, Payments & Cash Management
-
Which privilege to access per_assignment_secured_list_vHello, I am struggling with the per_assignment_secured_list_v secured view in BI Publisher, as I can't seem to pinpoint the exact duty role that gives the "Report assign…Sara Suleiman 79 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…
-
How to track email deliveries of Print Receivables ESS Job?Summary: We are trying to track the delivery of invoices to the customers which are sent via email but we are unable to get any delivery failure notification in case cus…
-
Charge Wise Total Report Producing Incorrect DataI am investigating a custom Oracle Fusion SCM query that calculates landed cost charges by charge name. The query returns correct charge totals for most receipts, but fo…
-
Phone Numbers are not showing up in BI Publisher ReportSummary: Phone Numbers are not showing up in BI Publisher Report Content (please ensure you mask any confidential information): I created a custom BI Publisher report to…
-
The absence report should calculates absence durations based solely on working days.We have created a report name "Absence Balance Details Report" , which has below columns : EMPLOYEE NUMBER EMPLOYEE NAME LEGISLATION CODE LEGAL EMPLOYER NAME ASSIGNMENT …User_6VOPA 31 views 4 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 58 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …Gurvinder Singh Gill 183 views 4 comments 2 points Most recent by mgoswami Reporting and Analytics for ERP
-
AGIS tables PVO's doesnot existsSummary: Hi Team, The below AGIS tables PVO's does not exists in BICC. Can you please advice to me. FUN_BAL_INTER_RULES FUN_BAL_INTER_ACCOUNTS_ADDL Thanks Content (pleas…Siva Kumar Bondalapati 2 views 0 comments 0 points Started by Siva Kumar Bondalapati Reporting and Analytics for ERP
-
Is there a scheduled process (or other way) that we can update a payment type change to flow throughOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): MTB Description (Required): Is there …Ajay Kumar Kotha 15 views 3 comments 1 point Most recent by Ajay Kumar Kotha Payables, Payments & Cash Management
-
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level…
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 1 view 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
How to remove View Invoice Button in Payable Invoice Approval Notification Based on User PrivilegeSummary: Hi Team, I have a requirement to dynamically show : View Invoice button - based on the user privilege. Is it possible to write a logic to display the button dyn…Sridhar Gupta Yerram-Oracle 12 views 3 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 33 views 3 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include … -
Hi Experts, I have a requirement in Oracle Fusion ExpensesRequirement: I need to display an informational note dynamically on the page only when the below conditions are met: Vehicle Category = Cars and Vans Vehicle Type = Elec…
-
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
This is the HDL I have loaded and getting errorSummary: Getting issue while loading this HDL for Withdrawing learning assignments.…