BI Publisher
Discussion List
-
Is it possible to display contents of CLOB column in OTBI analysis?Content Is it possible to display contents of CLOB column in OTBI analysis? I am adding a CLOB column to an OTBI analysis but it comes up with blank. When I query the sa…User_2025-02-11-06-57-37-559 173 views 7 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 22 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…Manoharan 536 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess…
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 215 views 5 comments 0 points Most recent by Angela Valcelli Reporting and Analytics for ERP
-
How does Group Notification Configuration works-Send One email containing all email addresseshttps://us.v-cdn.net/6034893/uploads/L3VF2N09KV4L/bpm-group-notification-configuration.docx Summary: We are trying to update the Notification Settings for the Invoice Ap…Baskara Sateesh-Oracle 23 views 0 comments 0 points Started by Baskara Sateesh-Oracle Payables, Payments & Cash Management
-
Feedback center manager email and BPM notification content mismatchHad an issue in Notifications content display - We have enabled and customized the template - /Shared Folders/Human Capital Management/Workflow Notifications/NoteSentToM…Challa Ramya-Oracle 11 views 0 comments 0 points Started by Challa Ramya-Oracle Reporting and Analytics for HCM
-
how can i get last date when customer was printed in final mode for a customer in oracle fusionHow can I get the last date when statement was printed in final mode for a customer in oracle fusion. Is that value stored in any table or is there any API that can be u…
-
PO PDF Template Conditional Regions by Purchasing CategorySummary: We are trying to update the PO PDF template so that if 3 specific purchasing categories are used on the Purchase Order it renders some different text on the tem…
-
Which field on the AR transaction stores PRESENTATION_TYPE for Online VAT Reporting for Spain XML?Summary: Hello, In some cases, the AEAT API rejects transactions due to missing data. We need to populate the child tags of in the XML output of the report SpainSIIForA… -
Unable to add a new field to oracle seeded report "Payable Trial Balance Report"Summary: We have a requirement to add a new field "Vendor_name_alt" to seeded report (Payable Trial Balance Report), after added new field and ran ess job it is throwing…SireeshaJaladi 51 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Adding additional column to get headcount for each month in OTBISummary: How to add additional column or calculated item to get the head count for every month? Content (required): I am using 'Workforce Trend Real time Subject Area' a…Raghavendra M 376 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query for Learning Assessment questionnaires with personal detailsSummary: Request for Expertise: BIP Report on Learner assesments Content (please ensure you mask any confidential information): Hi Team, Hope everyone doing well! I want…Prasanth Subbaiahh-Oracle 11 views 0 comments 0 points Started by Prasanth Subbaiahh-Oracle Learning
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Need to enable GL Date From and To as parameters in Account Analysis ReportSummary: Need to enable GL Date From and To as parameters in Account Analysis Report Content (please ensure you mask any confidential information): Account Analysis Repo…Deepa Lakshminarayanan 43 views 2 comments 0 points Most recent by Nathanieal General Ledger & Intercompany
-
Unable to send bcc in bursting.In the bursting query i have added parameter 8 for BCC mails. However, 'to' mails are going and the employees are receiving the mails. BCC is not being received. Can any…Reshma Eldho 21 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Tables for Worker Time Processing profiles in HCMSummary Tables for Worker Time Processing profiles in HCMContent Hi Team, I am looking for a query to find Worker time processing profiles(HCM Groups) based on assignmen…Harish Kumar Kovi 349 views 7 comments 1 point Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Print Receivables process for 'Paper' batch when there are no eligible transactions ends in ErrorSummary: As far as I know there isn't a way to change this but we are wondering if there is a way to update how Print Receivables works when the 'Paper' batch for Print …
-
Need Help on Source Table for Manage Common Options for Payables and Procurement:Summary: need to find table for Manage Common Options for Payables and Procurement. want value for default distributions -liability, prepayment Content (please ensure yo…Mayur Gangar 23 views 3 comments 0 points Most recent by Andres Celis-Oracle Reporting and Analytics for ERP
-
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en… -
USOnline Payslip Report CustomisationHi Team, We are looking for detailed steps for customising the USOnline Payslip report, with the output format in XML. Report output should be delivered to FTP. Please s…Swapnil Kashid 12 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
BIP report to get the ESS job error details based on process idSummary: Hi Experts Does anybody have a BIP report sql query to get the details of error ESS process encounters in fusion post running the ESS scheduled process . Please…shaikh123 85 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 6K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP
-
Learner Records Created via "Take Again" Button After Exam FailureSummary: We need a list of learners who clicked the "Take Again" button after failing an exam. We are only looking for records that were created because the learner clic…
-
How to create a report in OTBI of Manage Payment Process Requests informationSummary: The customer needs to have the information regarding the related invoices in a payment batch. Content (please ensure you mask any confidential information): I a…SERGIO BARRETO 81 views 3 comments 0 points Most recent by Basavaraj Navalagi Payables, Payments & Cash Management -
How can Canadian French characters be displayed correctly when using ANSI encoding?We have a requirement to send a demographic file to a Canadian RRSP vendor using ANSI encoding that supports ASCII characters. However, when we use encodings such as ASC…
-
Bip publisher output doesn't clear cache as old message isnt clearedSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BIP Report - Certification File Attachment - Assemble URL for downloading attachment from reportGreetings, During Auditing, our desire is to be able to quickly download any Certification attachments direct from the BI Report results. I'm trying to create SQL for a …Michael_Burgett 11 views 0 comments 0 points Started by Michael_Burgett Reporting and Analytics for HCM