BI Publisher
Discussion List
-
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… -
Build BI Pub for Representatives Details InformationHi Everyone, We are currently building a BI Publisher report to retrieve detailed information about Representatives. The report and SQL query work as expected in our Tes…Andriampeno Odilon 8 views 0 comments 0 points Started by Andriampeno Odilon Reporting and Analytics for HCM -
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 212 views 4 comments 0 points Most recent by User_NAIBF Reporting and Analytics for HCM
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…MaheshRayudu7 94 views 3 comments 0 points Most recent by Zohaib-Oracle Reporting and Analytics for HCM
-
What is the retention period for BIP reports & ESS Jobs in Oracle fusion applicationSummary: We wish to know the retention period of BIP reports & ESS Jobs in Oracle fusion application. Also needed any Oracle documentation that helps in understanding th…Shabharish.Pasupula 64 views 3 comments 0 points Most recent by Shabharish.Pasupula Reporting and Analytics for ERP
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud …Brendon Charles-24581 317 views 5 comments 2 points Most recent by DebashishDeka Reporting and Analytics for HCM -
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 305 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 10 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…
-
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 50 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 6 views 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 55 views 3 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
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 104 views 3 comments 0 points Most recent by Nagarjuna Nudurupati Receivables & Collections
-
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 790 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…
-
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 905 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 18 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 93 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 591 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 151 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…