Category 67
Discussion List
-
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 32 views 0 comments 0 points Started by Himansh Agarwal BI Publisher Learning Center
-
Bi Reporting Error #221When attempting to open our organisation structure report we are being hit with an error as shown in the screenshot attached. This error is occurring when initially tryi…
-
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…
-
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 …Kratika Sharma 1.2K views 0 comments 0 points Started by Kratika Sharma BI Publisher Learning Center
-
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…
-
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…
-
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…
-
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…
-
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 PublisherRitika.ray-Oracle 21 views 7 comments 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
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…
-
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. …
-
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…vikram khengare 698 views 1 comment 0 points Most recent by MandeepGupta BI Publisher Learning Center
-
Can Learning Initatives triggred through BIP reportshi Can Learning Initiatives triggered through BIP reports, if yes how the same can be configuredabhilashblackbox 2 views 0 comments 0 points Started by abhilashblackbox BI Publisher Learning Center
-
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…abhilashblackbox 12 views 1 comment 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
Need help with checkbox wingding.ttf font fileHi All, we have a requirement to insert check box in a report. based provided "DocID: How to Add a Checkbox in a BI Publisher Report ( Doc ID 2692589.1 )" For the checkb…
-
Email Bursting not workingI have the below Email bursting definition configured. The Schedule job completes successfully, however I never actually receive an email from it, even though there was …KDR 905 views 6 comments 0 points Most recent by Sreekanth Chennabathini BI Publisher Learning Center
-
How to solve java error in the excel template while working on BI reportHi, I am getting this error while trying to get the excel template for my BI report "javaw -Xmx256M -jar "C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Templ…nehayadav86 113 views 5 comments 0 points Most recent by Swapnil Kashid BI Publisher Learning Center
-
Adding a parameter to custom data model of a seeded reportWe need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gives an er…
-
How to add column in a seeded BI report with existing package, ESS jobs, before/after event triggerHi, I am trying to add two columns in a "Payables Payment Register" seeded report but i am getting errors like and I would need to add column "PAYMENT_INSTRUCTION_ID"fro…
-
How to read AUDIT_CHANGE_BIT_MAP_Hello Guys I am in need to read data from tabel: FND_VS_VALUES_B_ Because i need to understand which field has been changed in the Value set I've activated the audit and…
-
BIP Can you encrypt a file using PGP Encryption with AES-256 CipherHello, I set up a Data Model and report layout to extract data in an xml file. My next step is to encrypt the file using PGP with the AES-256 cipher. I'm able to set up …Mospherey Yu-Oracle 201 views 5 comments 0 points Most recent by PG_of_NSG-Oracle BI Publisher Learning Center
-
RTF values not summing upI have been trying to calculate the sum of values group by specific element and person number in the RTF template, but unfortunately, I have been unable to achieve the d…Michael Angelo Lucena 121 views 0 comments 0 points Started by Michael Angelo Lucena BI Publisher Learning Center
-
Error when run BI Publisher Report from cURL(REST API)According to Oracle documentation (https://docs.oracle.com/middleware/12213/bip/BIPAP/op-v1-reports-%7BreportPath%7D-run-post.html), i installed cURL in my desktop. To t…
-
BI Publisher Word Plug-In ErrorI have the Word Plug-in that has previously worked without issue, however it is now kicking back an error when I attempt to preview my data. Steps taken: Opened rtf temp…
-
Is there any way to invoke a soap service from a BIP report passing parameters dynamically?Hi experts, The idea is to invoke a soap service let say pressing a button on the BIP report layout and pass report parameters as part of a payload. Is it possible someh…Volodymyr Faranosov 11 views 4 comments 1 point Most recent by MandeepGupta BI Publisher Learning Center