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
-
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…
-
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…
-
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…
-
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…
-
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…
-
Need Oracle BI accountHi Team, We have registered as a Oracle Partner. We need Oracle BI reports account for creating and accessing data in it. Please provide us access to the account. Thanks…
-
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.
-
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 …
-
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…
-
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…
-
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…
-
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 …
-
How to create from and to date parameter without default and mandatory fileHow to create from and to date parameter without default and mandatory file in BI Publisher
-
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…
-
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!
-
Oracle BI PublisherI'm trying to create a DM and extract in Oracle BI publisher to pull some payment data from the cloud and build a report for our users to run to identify payments made. …
-
BI report Webservice Data ModelWe are using web service Private Data source in Data Model, to call Oracle Integration cloud Web service. Please confirm will this feature be deprecated in future or wil…
-
In Blanket Agreement, how to get name of level one approver in partial approved stateIn oracle fusion we have implemented two level of approval for blanket agreements. When the level one approver has approved the agreement and it is pending for approval … -
sub total label in interactive layout BI PublisherHi Team, Facing issues in displaying Subtotal label dynamically based on some report column as there is no such option available in Interactive layout of BI Publisher an…
-
Document delivery failed while sending email using BIP report burstingHi Team, We are getting below error while sending email using BIP report bursting. Document delivery failed [INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]Exception happen…
-
Can Learning Initatives triggred through BIP reportshi Can Learning Initiatives triggered through BIP reports, if yes how the same can be configured
-
Current Date in OTBI for Enterprise Hire dateHi Need to know the exact query to add up in Enterprise hire date filter , date should be current date , we tried with the below options CURRENT DATE 'CURRENT DATE' CURR…
-
How to prevent report output going to outside organization via email outputSummary: User has option to run report as schedule reports for all BI reports. How do we ensure that outside email when user enter is not allowed? We also want to ensure…
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…