BI Publisher
Discussion List
-
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 42 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 31 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 61 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM -
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 51 views 1 comment 0 points Most recent by Sanket Darokar Payables, Payments & Cash Management
-
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 11 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? -
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 71 views 3 comments 1 point Most recent by User_6GELQ Payables, Payments & Cash Management
-
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 32 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 61 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 206 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 13 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
-
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
-
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 22 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM