BI Publisher
Discussion List
-
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 4 views 4 comments 0 points Most recent by Nikki Reich Payables, Payments & Cash Management -
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary: Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting ru… -
Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is ZeroSummary :- Unable to skip resending the Bursting Notifications to HR/Team for Positions whose incumbent is Zero , and notification was already sent in previous bursting … -
Question marks appearing in custom eText outputSummary: Custom eText payment format in BI Publisher has question marks inserted into output. Content (please ensure you mask any confidential information): I have creat… -
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 77 views 1 comment 0 points Most recent by Deepsji Payroll and Global Payroll Interface (GPI) -
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 5 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 0 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 854 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 154 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…