BI Publisher
Discussion List
-
HCM Profile-> Set Preference-> LanguagesI want table to get data from Profile-> Set Preference-> Languages. and want joins to create relation between profile and language. profile-> Set Preference-> Languages …Rajdeep_Chavda 3 views 0 comments 0 points Started by Rajdeep_Chavda Reporting and Analytics for HCM -
HDL Error Updating ActivityAttemptActualEffort for Completed RecordHello, we are trying to update ActivityAttemptActualEffort via HDL using LearningRecordActivityAttemptV3 for a learning record already in Completed status. The HDL file … -
How can we migrate FRS reports in MYFOLDERSummary: How can we migrate FRS reports in MYFOLDER from one user to Shared folders by other user? As user 1 does not have access to paste the FRS reports to Shared Fold…SwapnilSurange1 44 views 6 comments 0 points Most recent by SwapnilSurange1 Reporting and Analytics for ERP -
How to use attachment tab in datamodelHi Experts, How can I attach FAQ document to the bursting query? I could see a attachment tab next to busting query. Can anyone share sample query to get document from c…Nivya Mathire 1 view 1 comment 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
Looking for SQL to Retrieve BI Report Job History and Deleted Job History in Oracle FusionHi everyone, I have a requirement to retrieve BI Report job history using SQL in Oracle Fusion. I also need to identify or retrieve deleted/removed BI report job history…Kanishka DIas 19 views 3 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
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… -
BIP Bursting LimitHi all, Hopefully a very quick one. Is there a limit at all to how many emails can be bursted out of BIP? I can't seem to find any documentation online so wanted to ask … -
How does the ar_bpa_print_requests table get populated?Summary: We are getting timeout issue when trying to print an invoice using the Print Receivable Program. However, this issue only happens if the delivery method of an I…marc.joed.de.guzman 90 views 3 comments 0 points Most recent by Nagarjuna Nudurupati Receivables & Collections -
BICC Extract Failures with "Error occurs while calling remote service ADFService11G" after 26CUpdateSummary: We have been experiencing intermittent failures with several BICC extracts following the Oracle Fusion Cloud Applications 26C update. The failures started appea… -
I want to group the date year wis in results file which excelFor one of my extractions in report code I am extracting date with code : Trunc(creation_date) CREATION_DATE and in excel layout I hv made the creadtion_date cell custom… -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 726 views 8 comments 0 points Most recent by Vijay Rajalbandi R Reporting and Analytics for ERP -
Bursting invoice print to print individual invoicesSummary: Generating individual output from Print Receivable transactions program Content (please ensure you mask any confidential information): Hi, When we use the seede… -
Table to get special purpose field of input valueHello, I'd like to know if anyone has an idea on where I can find the field of ''Special Purpose' and its value, whether it's a table or a query would be very helpful. I…Mayar Mohamed 2 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
createException: Security violation... permission: 16578Summary: I created a report but a few users receive this error message, why? Content (please ensure you mask any confidential information): Version (include the version …Stefano_Mazzocca 853 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
OTBI ANALYSIS PIVOT TABLE SUM TOTAL ON EACH ROW FOR SPECIFIC COLUMNSWe wish to identify how to create the columns in blue and green. I need to know what needs to be created on the Criteria (I assume a custom formula for each summary colu…Dkowall-Virtua 11 views 0 comments 0 points Started by Dkowall-Virtua Reporting and Analytics for ERP -
ESS-01035 Unable to determine a logical application name for new request running new jobset in UII am defining a jobset for the first time, to work in financials for Advanced Collections. I have identified how to create the jobset under Manage Enterprise Scheduler J…Susan Hathaway 81 views 4 comments 0 points Most recent by Susan Hathaway Reporting and Analytics for ERP -
Folder permission in OTBI "Resetting?" - "Enterprise Scheduler Job Application Identity for HCM"Summary: Good Day, We have a number of Custom Folders within Shared Folders - Custom where for some reason the "Accounts" "Permission" on specific user on each folder ke…Clifford Trett 568 views 1 comment 0 points Most recent by Lydia Jayasingh Reporting and Analytics for HCM -
How to get a data secured Job Requisition report in ORC?Summary: We need an Oracle Recruiting Job Requisition report with Job Offer status/progressing information if the Requisition started the offer process, which will publi…Meme 0101 152 views 4 comments 0 points Most recent by Shashi Kant Kumar Reporting and Analytics for HCM -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26CSummary: Hi, Can anyone please share R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet in 26C release Thanks, Content (please ensure you … -
Oracle Learning 26D Redwood Features for Learning AdministratorsSummary: Hi Everyone, As per the Oracle 26D documentation, I noticed that there are certain Redwood features for Learning Administrators that appear to be mandatory. Cou… -
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide. -
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette…Harish Vummidi 110 views 7 comments 1 point Most recent by Raj Battiwala Reporting and Analytics for HCM -
Can we customise the asset approval notificationSummary: Content (please ensure you mask any confidential information): Hi, We have a requirement of customising the Asset approval notification for below transactions: … -
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 594 views 7 comments 0 points Most recent by Kamalnath V Reporting and Analytics for HCM -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit… -
Can we use same post completion certificate template for all Learning Item TypeSummary: Can we use same post completion certificate template for all Learning Item Type Course Specialization/Learning Path Self Paced Learning. Events Content (please … -
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… -
How to get the details of action items which are denied?Summary: Need details of the action items which are denied along with their denied date Content (please ensure you mask any confidential information): We have a requirem…anirbanchatterj7 15 views 0 comments 0 points Started by anirbanchatterj7 Reporting and Analytics for HCM -
Customizing the standard Negotiation Award Decision Notification doesn't work after upgradeSummary: I customized the standard Negotiation Award Decision Notification by: Adding new columns to the data model and using them in the layout. Adding new sections and…Nermin Khaled-Oracle 39 views 1 comment 0 points Most recent by FusionSrini Reporting and Analytics for ERP