BI Publisher
Discussion List
-
How to find assignee value for an invoice in a query?Summary: I'm unable the table and field to get this specific assignee for an invoice Content (please ensure you mask any confidential information): Version (include the …Naushad Khodabocus 21 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Does anyone use JP Morgan Chase Check Printing services?We are exploring having JP Morgan print our checks and so need to setup a payment file that will be sent to JPMC. We envision utilizing the POSPAY file generation proces…Richard Nagle 271 views 4 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
Deeplink for RA Transaction Attachment directlySummary: Per one integration flow, we uploaded an attachment with a specific naming convention to RA CUSTOMER TRX. I am looking for a deep link or any URL that can downl…sailesh_cloudare 52 views 5 comments 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 92 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
SQL instruction to join data from 2 or more BI tablesSummary: Content (please ensure you mask any confidential information): Hello experts, which instruction when building queries in data models allows me to join two or mo…Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Get GL Balances from CONSOL ledger restricting sourceWe would like to get the GL Balances of the entries posted directly into the CONSOL ledger and are not transferred from the Primary ledgers. We can see that the source i…Arun Vasanthakumar 11 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Connections BIP report - how to remove HTML tags?Summary: Hello, I've created a BIP report for Connections. Could you please advise how to remove HTML tags? Please find SQL query attached. Kind regards, Marta Content (… -
How to remove the duplicates in rtf templateSummary: Currently using the three Data sets in the report First DS will contain the employee details,legal employer name ,Dept id and element amount Second DS contains …
-
Hot to fetch bursting delivery notification detailsSummary: Looking for a query or table which would fetch bursting delivery notification details. Content (please ensure you mask any confidential information): We have a …Priyanka_Ghosh 162 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Add parameters to BIP report URLHello, Is it possible to add parameters to a BIP report URL? My report BIP URL: https://***/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=****%2FF…
-
How to capture employee working as a manager in Employee details oracle BIP reportSummary: What is the table and column to capture working as a manager column, to write a employee details BIP report. Content (please ensure you mask any confidential in…
-
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Learning BIP Report Table LogicSummary: Hello, The current BIP Report we have in our org is based on the Learning Assignments Table (WLF_ALL_ASSIGNMENTS_V). However, we had an issue that a person was …
-
Issue with bursting queryHi, Facing some issue with custom email notification for overdue learning in the learning module. Have developed a SQL query with bursting but employees are receiving mu…
-
xmlpserver: RTF Template for quick action Change AssignmentWe were able to locate RTF templates for Person Management changes on the xmlpserver, but we were unable to locate quick actions like Change Assignment RTF templates. Th…Ashok Kumar Sharma 11 views 4 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Workflow Notification TranslationsSummary: Workflow Notification Translations Content (please ensure you mask any confidential information): Hi , When we customize seeded notification and make copy of it…
-
Transmit invoices with portal upload as preferred delivery methodSummary: I have setup customer site profile preferred delivery method to "portal upload". We have some client invoices that need to be uploaded into a client portal in a…Raj Mohanraju FRNT 211 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Enabling BPFM Notification and Template customisation for Goal ManagementHi Team, 1)Can we include BPFM in Goal FYI notifications? 2) How to bring supervisory in Goal FYI notifications rules in "THEN" Condition and which rule is triggering no…
-
Table details for ESS Job Display NameSummary: Hi, Can you please suggest which table holds the ESS Job Display Name? I have tried few tables like: request_history_view, ess_request_property but not able to …
-
Issues in syncronization of Columns in OTBI analysisSummary: Hello, I was trying to make a simple analysis with one subject area for which I added my Business Unit column and then added my Bank Account name in another. Th…
-
Custom File Naming for ESS Job Downloads in Oracle FusionSummary: Request for Custom File Naming for ESS Job Downloads in Oracle Fusion Content (please ensure you mask any confidential information): We have created ESS (Enterp…Tauseef-Oracle 131 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Does ADFdi, SmartView and VB Extension for excel supported with Google SheetSummary: Our client is only using Google products and not having MS office products. In this case does ADFdi, SmartView and VB Extension for excel supported with Google …
-
Requisition Approval E-Mail Report Template changes is not getting reflected in output file.Summary: I have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the la…Palukuri 409 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to use RTF templates if Client is having Google Docs and sheets instead of MS Office productSummary: Our client is using Google products only like Google Sheets and Google docs and not having MS office products such as MS word or excel. How do we edit the RTFs …
-
How to resize Rows and Columns in OTBI reports?How do I set column or cell dimensions to have a consistent format for my report?
-
Tracking Data Model Usage and associated queriesSummary: How is called the table or view (Oracle fusion) which tracks the information about the queries (data models) run by a user? The goal is to determine which table…Christian Flegler 11 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D…Dineshkumar.A-Oracle 1 view 1 comment 1 point Most recent by KISHAN BUSSA Reporting and Analytics for ERP