BI Publisher
Discussion List
-
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… -
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 35 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 62 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 193 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 1 view 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 11 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 3 views 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 11 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 31 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.…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.1K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP
-
Disbursement Payment File Format - ChecksSummary: We are trying to add new business units for this file. The Supplier name is normally spaced out in the rtf but it returns normal once there is an output. Howeve…
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRANSFERS TO COST MANAGEMENT SCHEDULE RUNSSummary: Hi Content (required): Currently, my team is testing the 21D release update. The aforementioned feature (AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRA…Sheneli98 211 views 4 comments 0 points Most recent by Neha_Singh Payables, Payments & Cash Management
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 87 views 16 comments 0 points Most recent by Jayanthi Shetty Reporting and Analytics for HCM -
Is data contained in a report created/ scheduled in BI Publisher automatically encrypted ?We are looking to improve the way data is extracted from Oracle Fusion and delivered to internal customers. Using BI Publisher reporting, it is not clear or visible if t…
-
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…Angela Nietes 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add…
-
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…
-
Learning incident custom notification report is appearing blankSummary: We modified a custom report workflow notification but the notification appears blank in production. In backend the template shows all the changes The FYI notifi…
-
Where does the payment acknowledgement email come from and how to customize it?Summary: We recently set up a payment acknowledgment with the bank and have the payment file register with document detail email once the disbursement and acknowledgment…Nikki Reich 1 view 3 comments 0 points Most recent by lkratzberg Payables, Payments & Cash Management