To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Learning Center
Discussion List
-
Pivot balance rolling basis calculated using rtf template in BI reportHi, I hope this email finds you well. I facing some issue from balance logics in rtf layout, Also, balance is equal to (On-hand + current commit – demand qty) on a rolli… -
disable custom BIP report parameter once it's been selectedSummary: Content (please ensure you mask any confidential information): I have a custom BIP report it has parameter (list of value), say Invoice Number from AP table the…
-
Is there a system variable to display running environment like DEV/UAT/PROD in BI report?Without customizing the data model is there a way to identify the running environment in the rtf template.
-
Will PAAS & SAAS instances time zones be always in Sync?Will PAAS & SAAS instances time zones be always in Sync as we are fetching SAAS data(BIP Reports) from PAAS based on date parameters passed from PAAS. We need to ensure …
-
Do all view tables hold data constantly or is there a process to get the information to showHello, I'm using the view FND_BPM_TASK_HISTORY_VL to see the history of tasks and approvals for transactions. This is to create a report to show the approval workflow fo…
-
Can I SFTP the documents stored in documents of record through BI Publisher BurstingSummary: Can I SFTP the documents stored in documents of record through BI Publisher Bursting FTP? This is PDF attachments. Kindly assist. Content (please ensure you mas…
-
Invalid session ID or session expired error on custom BIP reportwe have a custom report which runs in fusion. the report used to run for almost 2hrs in past. but with increase in data now, the report is running for close to 2hr 30min…
-
I have requirement on HCM where i need sql for employer rejection reasonHCM Report: I want to extract query for WithdrawalReason and EmployerRejectionReason
-
Translation of Performance Document Reports RTF Templates to other languagesHi Team, Kindly suggest a best approach or is it feasible on how we can translate an English language Performance Document Worker Ratings Report RTF template & Performan…
-
Functionality of 'Every' Value in Weekely Frequency Report BI Agent Scheduler ?In BI Agent Scheduler, we have Frequency = Weekely and 'Every' = … Weeks so here what is meaning/functionality of 'Every' value. So suppose if we put Weekely Frequency a…
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
Control data through EL expressionSummary: We have a custom report which is dsplaying the calibrated rating of the employees in the performance documents page under Me > Career and Performance > Performa… -
How to schedule ESS job report with period parameterI have a report that runs on period parameter requirement is this report is to be scheduled and while getting scheduled it should consider the date of schedule as period…
-
What values should be provided to lexical parameters for seeded data model for Asset Register ReportWhat values should be provided to lexical parameters for seeded BIP data model for Asset Register Report - *&L_INVOICES *&L_SOB_INV *&d_category_segs *&d_asset_key_segs … -
How to extract only employee's current grade step using BI publisher?How to extract only the last grade using BI publisher? I tried to filter on EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE and ASSIGNMENT_SEQUENCE, but it is the same recor…
-
How to remove extra line before the contents for column note_txt.Summary: Hi Team, I am working on AR aging report in which we have developed query to extract collector notes. We are referring note_txt column from zmm_notes table. But…
-
can we use the regexp_replace function in a xsl bi publisher template?I'm trying to use the regexp_replace function in my xsl template to replace special characters and I receive an error. Is the regexp_replace supported by the xsl templat…
-
How to remove decimal value in BAR CHART - RTF Template - BIP Report?Decimal value is displayed in the Bar chart of RTF Template - BI Report. How to remove decimal values in the chart?
-
Has anyone ever had a problem with if@inline in rtf?Has anyone ever had a problem with if@inline in rtf which perhaps solves the problem of no longer going to line but no longer reading the :string-length> 0?
-
Is There an way to Default BI report Text parameter to logged in user person id like in Date typeIs There an way to Default BI report parameter to logged in user person id like we default System data in Date type parameter {$SYSDATE()$}. We have a Text parameter whi…
-
How to find redline change data in the OBI tablesHi Experts/Team, Is there any OBI table that stores if any attribute is redlined on a change order, redline information i'm looking for a specific attribute is redlined …
-
How can I run Review Distributions Report?Hi, I can find Review Distributions Report in Shared Folders > Supply Chain Management > Cost Management > Cost Accounting but cannot run it. There is no such ESS job. B…
-
Parameers of the job are not visible after creating Job setsSummary: Content (please ensure you mask any confidential information): I created 5 jobs under one Job set. After defining all the jobs in serial mode in Job sets page, …
-
Is there a way to index a DFF Attribute?Summary: Our solution calls for use of DFF attributes to capture data from boundary applications that should be used as parameters and filtering in BIP/OTBI reports and …
-
Can anyone suggest some tips to optimize SQL queries for slow running BI reportsSummary: Can anyone suggest some tips to optimize SQL queries for slow running BI reports. Please share your knowledge or experience here. Content (please ensure you mas… -
Issue with .xlsx formatWhen scheduling a report and then the report is sent to the manager, manager cannot receive it because report cannot be sent. Could it be that .xlsx option is not suppor… -
Insufficient BIP privileges to run queries that fetch logs for an issue in Fusion Recruiting CloudWhen the queries that fetch Recruitment Content Library Notification Details and Email Message Content and Delivery Status details are run on BIP in order to collect log…
-
How to pivot to display questions horizontally as the heading using answers instead of measureI wish to create a table of questions as the horizontal headings (dynamic from data) and the users as the vertical with the answers in the data section. Pivoting appears… -
How to display a 2nd signature based on Check AmountHi, we have a requirement to print a second signature on a check when the check amount exceeds a threshold e.g., $25,000. We have created our RTF template with one stati…
-
install BIPublisherDesktop64i installed BIPublisherDesktop64 , but still not appear in Microsoft world ... Please need to install it and appear in the World