BI Publisher
Discussion List
-
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval… -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…
-
PER_EXTRACT_UTILITY performance in reportingSummary: Hi experts, quick question, is PER_EXTRACT_UTILITY faster than querying the actual table in BIP? e.g. we can use get_decoded_lookup to get the Meaning of the lo…
-
Customizing Separate Remittance Advice Subject with dynamic valueSummary: Customizing Separate Remittance Advice Subject Content (please ensure you mask any confidential information): Hi Team we should customize the subject with PAYEE…Luca Nobili PWC 288 views 7 comments 2 points Most recent by Kara Hart Payables, Payments & Cash Management
-
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 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 79 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 46 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 20 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 93 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 729 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 856 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 13 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 82 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.