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
-
What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to extract data from BICC to oacsSummary: What is PVO for 'FUN_USER_ROLE_DATA_ASGNMNTS' table to pull data from BICC to OACS Content (please ensure you mask any confidential information): Version (inclu… -
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…
-
Can we Use .XLS template with Excel Macro enabledHi Team, Is it possible to utilize a BIP .xls template that has a macro embedded into it? Our User requirement is to have a Macro in excel template a user can run on the…
-
How to embed BIP Reports in Job Requestion UI pageNeed to add the BIP Report in Job Requestion UI page. Based on the selected Requisition the embedded BIP Report should populate the candidate's details in UI. Kindly let…
-
Customize Soft, Medium, Hard and Final DunningSummary: Need steps to customize the dunning letter templates, including name of the template. Steps need to prefix additional characters to template name. Navigation an…
-
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 …
-
Flexfield Feature at BIP Model using where LexicalSummary: I want to make a report that similar to Budgetary Control Analysis. My current report, I define the segment1 as balancing segment, segment2 as natural account, …
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
How to group rows based on one column and then find the sum for each group?Hi, I am working on a rtf template where it is required to group the records based on the tax code value. Now I want to show the sum of amount for each tax code in diffe…
-
Unable to preview attachment without download the attachment in ReportHi All, Unable to preview the attachment without download the attachment Below steps are we following:- step1:- we have made one custom report step2:- we have added the …
-
OTBI folder permission segregationHello, I am working for a client that has multiple subsidiaries ( in UK, IN France, in USA etc) and all of these subsidiaries have distinct folders with distinct OTBI re…
-
How we can print checks as first page on check stock and overflow pages on second printer in FusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BI Publisher - Obtain YTD / accumulated balances via SQLGreetings, We are trying to pull custom balance totals via a SQL query in BI publisher. So far, we have been able to obtain individual run results but cannot pull the to…
-
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 …
-
What are the subject areas to fetch question and answers in OTBI?In BI report we get the following fields from the following tables: QuestionnaireParticipantPEO.qstnr_participant_id AS Q_QSTNR_PARTICIPANT_ID, QuestionnaireParticipantP…
-
Using OR with IF statement in rtf template is not working as expectedSummary: Using OR with IF statement in rtf template is not working as expected Content (please ensure you mask any confidential information): I have a requirement for my…
-
FUSIONAPPSS_REQUEST_IDSummary: I'm trying to modify the ChartOfAccounts report in order to add new filters to the query, but as soon as I add the parameter :fusionapps_request__id the DM stop…
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…
-
Can we able to send data from Oracle cloud to GCP directlyGot a requirment to send file from Oracle to GCP. Can we able to send the file directly? Need suggestions. Thanks, Keerthana.
-
query for receivables receiptsI wrote the query of receipts, but I need the receipt date, I think it's in the table AR_CASH_RECEIPT_ALL but I don't know how to join with the others. Can anyone help m…
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…
-
ZIP and PDF inquiries for Oracle BIPSummary: 1. We are trying to create bursting email which sends 1 zip with multiple pdf(separated by invoice). 2. In history we have a consolidated output which has 1 zip…
-
Option to download multiple file from content serverSummary: Using BI Publisher report, I have extracted multiple files to content server , Whats the way to download all files from content server Content (please ensure yo… -
how to select correction record from data?Hello everyone How to select by SQL query records of elements whose value was changed not by UPDATE but by CORRECT, is it in the HRC_EVT_OBJ_CHANGE_COMPONENTS table? or …
-
BIP reports usageSummary: Is that possible to run a BIP report that show all BIP reports that have been running in our POD? We know we can see the scheduled reports in ESS table but we a… -
Custom Package creation in fusionHi Team, Can anyone explain how to create custom PLSQL packages in Fusion Database Schema? When creating BI Reports for Oracle Fusion SaaS, there is an option to create …
-
how to add prompt of Start Accounting date and end accounting date in FRS reportHi, I am looking out for ways to pass a period range Prompt in FRS report based on which my columns will dynamically be fetched. However i can't seem to find the ways to…
-
Custom UCM datasource To Retrieve The Text Attachments for PDFHi. I used this document: How to create Custom UCM datasource To Retrieve The Text Attachments for PDF ? ( Doc ID 2643214.1 ). I was able to follow all of the steps and … -
Is It possible to get out put In JSON Format for BIP Reportscurrently we do not see JSON Format In BIP Reports out put format section, Please help!