Report Output
Discussion List
-
Missing/incomplete Data produced in the Oracle fusion BI publisher reports XML FormatWe have developed a custom BI Publisher report in the Oracle Fusion Cloud instance. The report is expected in the xml format. We have an issue here. i.e., the report com… -
RTFtemplate sorting data is there any limitWe want to sort the data in alphabetical order for “Payment Process request status report”. This is the seeded report provided by oracle when PPR is ran. Seeded report i…SivaRamaKrishna-Oracle 20 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
can we add columns with name spaces while creating an eText format of the BI publisher report?We have requirements to create and extract CSV files for another system as integration. The requirement was to have column names with space (e.g. First Name). We have do…
-
rtf template payment "due date"Hi, I want to modify an XML template (rtf format) to payment batches formatting. I get now the invoice due date SUBSTR(to_char(to_date(to_date(PaymentDueDate,'YYYYY-MM-D…Iker Garcia Martin 1 view 0 comments 0 points Started by Iker Garcia Martin BI Publisher Learning Center
-
BI Publisher not working in MS Word, and how can I fix it?I downloaded BI Publisher to work on an RTF template, but every time I try to open MS Word, it crashes and becomes unresponsive. The issue resolves only when I remove th…Omran Zeaiter 174 views 7 comments 1 point Most recent by Chris Pomager-27736 BI Publisher Learning Center
-
What is the support version of Excel in Oracle Fusion BI Report?Is it only support Excel 97-2003? Does it support .xlsx format, please?
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
How ESS Job Parameters are mapped to BIP Data ModelI would like to know how ESS Job Parameters are mapped to the BIP Data Model? I have a BIP Data Model with some mandatory and optional parameters. I would like to use a …
-
How can I give managers easy access to BI and OTBI reports that are already written?We have a number of BI reports and OTBI analyses already created that would be useful to our managers. However, it is a daunting task for managers to navigate into the r… -
which tables stores interview evaluation feedbackHi Team, May I know which tables stores interview evaluation feedback ? If possible can I get a snippet of SQL code ? Regards, Harish
-
What values should be provided to lexical parameters for seeded BIP data model?I am working on the SQL query for Oracle Seeded Data Model - Transactions Print Data Model for Invoice Print Template report, where it shows some lexical parameters and …Kratika Sharma 75 views 4 comments 0 points Most recent by Dhinakaran G BI Publisher Learning Center
-
Global Level Function By Expression does not show anythingHello, I'm trying to use the below Global Level Function expression in a RTF but even though it shows in the XML outpout it doesn't in the Table view not RTF. Do you hav…Guillaume SAVALL 1 view 1 comment 0 points Most recent by Eshwar Kappala BI Publisher Learning Center
-
Do we have backup table for ESS request historyThe ESS request history table has data of last 90 days. Would like to know if there is any backup table which stores the entire request history information.Mounika Samayamantri 1 view 1 comment 0 points Most recent by Vijaya Sekhar A-Oracle BI Publisher Learning Center
-
How to call a service logistics PVO from an SQL query from BI Publisher and BI AdministrationHow to call a service logistics PVO from an SQL query from BI Publisher . We are trying to use the PVO- oracle.apps.scm.serviceLogistics.billing.publicView.DebriefLinesP…P.S.Nikhitha Muduliar 27 views 1 comment 0 points Most recent by Shrikant Nene-Oracle BI Publisher Learning Center
-
Why does the query in the dataset take an extended time to process?I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the…
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
Learning DashboardDoes anyone have a template for Learning Dashboards in OTBI? -
BIP Letter Templates and ImagesHi all, I've created a simple data model that allows an end user to run a self service report where they input the employee number and it generates a semi complete lette…
-
Time Stamp Date and Time in BIP report NameHi, I am Scheduling BIP report for everyday. I wanted to Timestamp the Date and time in the output file name. For Example : The Schedule process is run on 15th June 2022…Shashank Verma-Oracle 1.3K views 6 comments 0 points Most recent by Shashank Verma-Oracle BI Publisher Learning Center -
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…Cindy Mavioga Malaga 3 views 1 comment 0 points Most recent by Cindy Mavioga Malaga BI Publisher Learning Center
-
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 …
-
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…
-
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…
-
AR Aging Report Issues in BI PublisherHi everyone, I'm hoping to get some help with an AR Aging Report built in BI Publisher. I inherited this report from someone else, and I'm facing two issues: Missing Cus…
-
Initial cap/upper case in BIP report RTFSeeded report column value is like 'ANNUAL' .I want to display the value as 'Annual' which is in Init cap format without having to modify the seeded XML. How to do that …
-
Oracle Fusion Application MT Timezone is not reflecting sometimes in OTBI ReportsHi Everyone, I have set the timezone in oracle fusion application as UTC-07:00 Denver - Mountain Time (MT) and now when I am creating an OTBI analysis and using Now() fu…Himansh Agarwal 21 views 0 comments 0 points Started by Himansh Agarwal BI Publisher Learning Center
-
Use .XLS template with Excel MacroIs it possible to utilize a BIP .xls template that has a macro embedded into it? If so, are there any examples that can be shared with me? I am not sure how to apply for…
-
How to find the sum total of an element for all the groups in rtf template?Hi, I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template. The scenario is there are …
-
BIP report Group data need to be show in message bodyI want to send a report to each manager with the employee details. Employee details should show in message body instead of attachement. Please let me know, how to do tha…
-
HCM Extract attribute back end QueryHi All, We need your help in finding out the Actual query being used in the back end of Attribute in HCM Extract. We built a HCM Extract with data group using the user e…