-
I want query for below columns, for AR Invoice Integration Exception report using interface Tables
Columns are ACCOUNT_CLASS, Distribution_Account, description, Invoice_Number, Distribution_Amount, Payment_Term, Currency, GL_DATE, Error_Reason, Ship_To_customer_Name, Bill_To_customer_Name, Bill_To_Site_Name, Ship_To_Site_Name, Oracle Division Number
-
How to invoke a BIP report with parameters from Oracle cloud ERP
Hi Experts, To invoke custom BIP report with parameters from orcale cloud ERP , i have follow below steps. Enable sandbox choose page composer tool page composer -> Structure -> Edit -> Add HTML content…
-
How can we send Fusion Report to SharePoint
Facing issue while sending Fusion Report to SharePoint, need process
-
Happy holidays!
The Oracle Analytics community has grown so much this year! Thank you for all your work, ideas, and innovation, and we hope you enjoy these holiday wishes from your dedicated OA team :).
-
BPM Workflow logs
Hi, During development of workflows/approvals using BPM, how can we attain logs for any errors etc.? Also, what roles/privs should be assigned to view such logs? Thanks Y
-
How to use And condition in Conditional formatting in Taleo OBI ?
Hello Guys, We are trying to combine two conditions like if job board = 'xyz' and number of days the job is posted to to 'xyz' job board is >=7, then display the cell or the entire row in red colour. But in Taleo OBI, we cannot use AND condition for conditional formatting. Can you please suggest the workaround for this…
-
Time Card Status
Hi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying to add the BEFORE CHANGE and AFTER CHANGE status. However, I cannot find any table which has the columns I need. I am currently using the tables…
-
Defaulting attributes like server, security group while scheduling a report
We are trying to schedule a report and want to default the server and security groups when we add a destination and submit the job.
-
How to get the information about User Creation Date
Hi, We are using the following weblogic version: WebLogic Server Version: 10.3.5.0 I would like to see more information about User Creation Date, Modified Date, Disabled etc. I am at this screen I drilled down on particular user and eventually at this screen. Tried with More Info too, haven't got any info there. Kindly do…
-
Getting "This resource must only be accessed over HTTPS. It was incorrectly accessed using HTTP"
We have http server for our dev / test environments. Both schemas are on same servers with different port numbers. Recently we have created few REST APIs. We get expected result from DEV environment. On test environment, if roles and privilege are not applied it works. I mean I can successfully use API. But once applied,…
-
What controls the 'Delete' & 'Rename' Abilities in the BI Catalog Task section for a custom folder.
Hello All, What controls the 'Delete' & 'Rename' show in picture? We have a specific folder that we wish to lock these down, but the user also has BI Admin role. I included current permissions to the folder in question. Thanks, Karl
-
EBIS - XML BI Puiblisher : how to pass avalue into the template （ｎｏｔ ｆｒｏｍ ｄａｔａ ｓｏｕｒｃｅ）
Hi All, I have a PＯ ｔｅｍｐｌａｔｅ ｄｅｖｅｌｐｅｄ ｂｙ ｏｔｈｅｒ ｄｅｖｅｌｏｐｅｒ． Ｔｈｅｒｅ ａｒｅ ｓｏｍｅ ａｔｔｒｉｂｕｔｅｓ ｗｈｉｃｈ ｄｏｅｓ ｎｏｔ ｅｘｉｓｔ ｉｎ ｔｈｅ ｄａｔａ ｓｏｕｒｃｅ （ｔｈｅ ｘｓｄ／ｘｍｌ ｆｉｌｅ） Ｔｈｅ ｖａｌｕｅｓ ｆｏｒ ｔｈｏｓｅ ａｔｔｒｉｂｕｔｅｓ ａｒｅ ｒｅｔｕｒｎｅｄ ｂｙ ｓｏｍｅ ＤＢfunction. How can be the values pass into the ｔｅｍｐｌａｔｅand how can the DB triggered by the template (or XMLＰｕｂｌｉｓｈｅｒ）…
-
In Oracle Fusion- BIP Report Job succeeds but Files not found on FTP Server
We have scheduled a BI publisher report by using the schedule option on the BIP report to place file on the FTP server. When we run the job it is getting ran successfully without any error, but the file is not placed on the FTP server. We have done this for few list of reports. Few of the reports output is placed on the…
-
How do I determine a person record is merged in Oracle HCM Fusion
We have a series of outbound demographic files to third parties and we are paying thousands in additional licensing due to "merged" person records being included. For example, John Smith is onboarded twice. HR merges the two records into one and I need to be able to exclude the merged record from the outbound demographic…
-
How to capture Previous year balances based on the period parameter.
Hi Experts, We have a requirement where we need to capture below mentioned information based on the period parameter from "Fixed Assets - Asset Transaction Real Time", "Fixed Assets - Asset Depreciation Real Time", "Fixed Assets - Asset Balances Real Time". * Previous Year Current Cost as of 31/12 previous Year. E.g. if…
-
Finished upgrading ATGLITE.ATGLITE with status: FAILURE.
Hi Team, We have doing the OBIA 11.1.1.10.1 installation on AIX machine. While doing updating the schema, faced the issue. Finished upgrading ATGLITE.ATGLITE with status: FAILURE. also let me know is there any steps I have missed while doing installation on AIX machine, i.e any specific bug patch for AIX machine. Versions…
-
OBIA 11.1.1.10.2.0 Configuration failed at 2% deploying applications presentation server
Hello All, DB:- oracle 12.1.0.2 I was trying to install and configure OBIA 11.1.1.10.2.0 in windows, all patches and other got succeeded. When I came to configure BIapps "ConfigApp.bat". It got failed at 2%. Here in log , it is showing invalid username/password, however I could connect to oracle by using same password,…
-
Cannot startup Informatica Repository Service
Hello Peers, Greetings! I am unable to bring up our repository service. I have tried every possible way, using some help online ( for example: http://www.cool-bi.com/Infa/InfaDomainPWD.php) but in vain. I have attached logs from three files: catalina.out, node.log, exceptions.log files for your reference. Can you please…
-
Attaching a static PDF document in a Bursting BI Report.
Hi Team, Can You suggest how to add a static pdf to a bi report. we are bursting a bi report in which we are delivering a mail to the candidate in an html format. now the requirement is to add a static pdf attachment to the email along with the email body. Can it be possible to do it. Note: - Email Body consists of…
-
Oracle Analytics - Creating an analyses to display all rows with same values in certain fields
Hi all, first time poster here so hope I'm in the right place! I'm using OACS to develop a report/analysis to list any duplicated invoices in the system. The initial idea is to potentially use a Group By clause to group rows by the following fields: Invoice Number, Invoice Date, Invoice Amount and do a count of rows where…
-
How to insert image as hyperlink which acts as go back button in OAC
Hi I have a scenario where we have multiple dashboards in OAC dv and created a homepage/landing page having links of the dashboard using BI. When the user navigates from the homepage to the respective dashboard, and now wants to go back to the homepage, the functionality couldnt be achieved directly. So I made a workaround…
-
OBIA 11.1.1.10.3 Install - Error while creating domaine 64015: Invalid property
Hi team, I am installing OBIA 11.1.1.10.3 - PS3 and i am facing an error during the configuration of biapps, especially during the creation of the ODI domain Source documentation :…
-
report print server integration problem with Oracle Apex 22.1
please note: i already asked it in Apex forum on 31-Dec-2022 and received first reply on 08-Jan-2022 after 2 my own replies just to "reminder". @Timo Hahn give me this BI Publisher related forum link. OS: Win 10 Pro, DB: 21cXE, Apex 22.1, ORDS 22.3, Tomcat 9, MS Word 2016, BI Publisher Desktop 10g as main admin of Oracle…
-
OBIA 12c: Errors during data store imports
Hi - We have done a fresh install of 11.1.1.10.3. We are attempting to import our customizations from OBIA 11.1.1.10.1, as per https://blogs.oracle.com/biapps/obia-12c:-odi-customizations-migration-utility. This is for the 'ODI12c Data Stores Migration Utility'. The export seemed to work fine and generated the necessary…
-
In OTBI report I'm trying to pull Organization hierarchy level1 and organization hierarchy level2,
I'm getting multiple rows like both active and inactive, so how to pull top most one which is active...
-
How to get the count of rows in any given data store in BICC ?
We're extracting the fusion data to ATP using BICC extracts and OIC. Recently there was an incident where the data replication program failed and notification was missed. Hence the customer is looking for a solution to look for the count of row in any datastore in fusion and count of rows in matching ATP table to validate…
-
OTBI Subject Area for Fixed Assets Lease information
Hi In which OTBI subject area can i find information about leases ( lease number, lessor, lease terms, etc. ). Thanks Andrzej
-
BI Publisher Excel With XPATH
What's the syntax (if any) for navigating to a node / using XPATH in an Excel template (xls). If you select an element from the GUI and look at the hidden tab, it does something like this <?MYFIELD?> however it doesn't like <?/Record/FIeld?> or <?./Record/Field?> or <?./Record/Field[1]?> Similar syntax in an RTF template…
-
Which Fusion OTBI subject area contains data pertaining to Team Member Workbench Journeys?
I am looking to generate an analysis that generates completion data specific to certain users and/or Journey assignments. The assignments mentioned are the Journeys located within the Team Member Workbench. I have attempted to search through the Workforce Learning - Learning Management Real Time & the Workforce Learning -…
-
BI Publisher Formatting issues
Hello, Once I save a file as RTF and upload it into BI publisher, the PDF formatting is completely wrong. It changes the margins of paragraphs, and completely blanks out some pages. Has anyone experienced this and what was the solution? Thanks!
