BI Publisher
Discussion List
-
Global and Local Learning Specialist not able to see correct data in Learning History BI ReportSummary: We are currently implementing the Learning Module, which involves distinct HR roles with different levels of access: 1. Global Learning Specialist: Has View All… -
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 99 views 2 comments 0 points Most recent by Balamurugan.N-Oracle Payroll and Global Payroll Interface (GPI) -
Duplicate of Print Receivables Transactions Report fails to reach parameter selectionSummary: I have created a duplicate of the Print Receivables Transactions Report to be able to add an additional parameter to the report. Upon duplication the process sh…
-
which duty roles would give access to BI Publisher Report which queries these tablesHello All, We want to give access to a custom role to a BI Publisher Report that queries these tables: per_periods_of_service ppos , per_assignment_secured_list_v paam ,… -
How to enable password for P60 Document with date of birthSummary: We are trying to password protect the Oracle P60 document with employee's Date of Birth. The XML doesn't have the Date of Birth tag. Can we modify the seeded Da…
-
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 34 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 234 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 113 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 84 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 370 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 334 views 7 comments 2 points Most recent by Kara Hart 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 61 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 3 views 1 comment 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 127 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 881 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 979 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 188 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 615 views 1 comment 0 points Most recent by Lydia Jayasingh Reporting and Analytics for HCM