-
Extract Data with HTML formatting
Hello Experts, I need your assistance regarding fetching data with HTML formatting in the OTBI Report. Currently, I'm working on the 'recruiting - recruiting real time' subject area. I'm attaching the XML and the screenshot of the HTML text. I added external and internal job posting details, and as per the requirement, I…
-
We have created few OTBI Infolets and enabled it through sandbox at Sales Infolets
Hi Experts, We have created few OTBI Infolets and enabled it through sandbox at Sales Infolets, but these sales infolets are not visible to other users. We need to enable it in a place where it is visible to all the users like landing pages or somewhere. Can anyone suggest where we can do that to make it visible to all the…
-
Restrict the view of a OTBI report only for a Role
We wanted to restrict the view of a OTBI report only for a role - Field Service Administrator. This role has the BI Consumer Role added to it already. But when we added this role in the OTBI report permissions, the user with this role is not able to see the data. Error received is attached below. How can we resolve this?…
-
How to change the default date format from MM-DD-YYY (American) to DD-MM-YYYY (European) in OTBI
The default date-format in OTBI is MM-DD-YYY. In Europe we use DD-MM-YYYY. Now we need to modify all date columns and change the format of the column. But if we could change the default date-format, then we do not need to change this. (Also strange that OTBI is not using the preferences that you do set on user level in the…
-
IPEDS reporting in Oracle Cloud HCM
The IPEDs report is a mandatory report for US higher education. Is this delivered in Oracle Cloud HCM? I see references to IPEDs in certain Oracle Cloud documentation but no samples of a delivered report.
-
Pivot Online template for BIP report- Column Heading setup
I created a BIP datamodel and tried to create pivot online template but i am unable to set BIP report Column Heading for Online Pivot template created. Pivot is working totally fine. Issue is For ex: I considered department to place as rows in pivot but I am unable to see the column heading /unable to set it up under…
-
Is it possible to create a report using OTBI; pulling this data table in the Object Group?
-
Can we zip the OTBI output file and email
Hi All, We have a requirement to zip the output CSV file of an OTBI analysis before emailing it. Is it achievable?
-
Disable or Hide Email option on the results page of an OTBI Report
When we click on the Email option that appears along with Export, Print, Copy on the Results page of an OTBI report, the raw data is dumped to the email address. This is not what the client would want. Can this be disabled or hidden?
-
Automatic Backup of All Custom BI Reports and Analyses
Fusion Applications BI - How To Take a Automatic Backup of All Custom BI Reports and Analyses Hello, We want to take backup of All Custom BI Reports and Analyses & custom folders on a regular basis to avoid getting deleted by mistake. Is there a way to automate periodic backup of custom reports/OTBI folders in fusion ERP…
-
Usage of PVOs GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALL
We are building a BICC extract to extract person and their assignment data, wanted to understand when should we use GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWAL
-
is it possible to copy all users' reports from their own folders to the Share folder?
Summary: Hi, Who can advise: is it possible to copy all users' reports from their own folders to the Share folder? For example, I have created a report and saved it in My folder. How admins can copy my report and put it in the common folder? Content (required): Version (include the version you are using, if applicable):…
-
How to create an RTF Template
Hi all I've tried to create a RTF template but I have a problem with the first step about the guide. I don't understand what it means " To obtain the sample XML file, submit a transaction after configuring all the required flexfield attributes and approvals enabled". What kind of transaction?
-
How to archive whole catalog (Shared and Users)?
With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T or when a user is making mistakes, we would like to have some backups to restore a previous version as it was possible in OBIEE. How can we do this backup? Is there…
-
Compare two fields from different Subject Areas in OTBI
I have written an OTBI analysis containing several fields however I am having an issue when I create a field with a Case statement to compare the below fields. Subject Area: Person Real Time: · "Person Address"."Region2" · "Person Legislative Information"."PER_PERSON_LEGISLATIVE_DFF_PAYROLL__TAX__STATE_" Subject Area:…
-
Calculating wrong values in Subtotals.
As I calculate the subtotals in the tabular report for which I work as a BI developer, the calculation is automatically producing incorrect results.
-
How to Fetch more than 1000 records with BIP or OTBI report
Summary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Parameter as Free Text field and provided values with comma separated. I am able to run the report with 1000 records/values and not more than that. At times, we…
-
Oracle BICC SOAP based extraction
We are trying to run a BICC extracts via SOAP API, Is it mandatory to have WSA-Addressing in header of the SOAP API payload? <wsa:Action>submitRequest</wsa:Action> <wsa:MessageID>1234567</wsa:MessageID> As per oracle documentation here , its not mentioned as mandatory . But without Action or messageID , we are not able to…
-
Assignment logic in data store: HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO?
We have an employee that has two assignments. The assignment fields that are populated in GlobalPersonPVO pertain to the 'old' assignment. I can't figure what the logic is to determine which assignment is used in GlobalPersonPVO since that data store has 1 record per employee.
-
BICC Extracts
Hi All, How do we identify whether the files generated by BICC on UCM are the files for Full or incremental extracts. The files generated have the same naming convention regardless of the type of extract and our customer wants to know if there is any better way of identifying the extract type (full/incremental) without…
-
24A - OTBI Data Exporting updates
Exactly what object types in OTBI are impacted by this 24A advanced notice. Does impact extend to csv or tab delimited files which are manually generated using rtf templates? Please direct us to additional detail around 24A CSV/tab delimited exporting changes. Specifically for the addition of apostrophes as an escape…
-
Reporting for the recruitment/hiring process
I need to build a report for the recruitment process that includes YTD counts for candidate slates, candidates on shortlist, interview slates and candidates interviewed broken by down professional and all positions. I haven't done much report development in recruiting and am not seeing any really helpful canned reports.…
-
Excel template of BI Publisher: specific requirement on Grouping of 1 Field
Hi, Attached are the samples from BIP as I cannot use ours due to security issues. But the Output requirement is mentioned exactly required marked in GREEN.
-
Newly Created Order Management Line and Header EFF not available in OTBI Subject Area
New Order Management Extensible Flexfields created with BI enabled flag checked. Flexfield deployed. ESS Job - Publish Extensible Flexfield Attributes successfully completed. But OTBI Subject area still does not show the context and segment created in Order Header or Order Line for selection. Is there any other setup or…
-
Listing of Email Correspondences
Is it possible to report on email correspondences? We are looking for a report either in OTBI or OBI which would list out all our email correspondences, status, recipients, last sent, etc.
-
System Notifications Listing
Is it possible to report on system notifications? We are looking for a report either out of OTBI or BI that will list all our system notifications, status, recipients, frequency, etc.
-
I want query for below columns, AR Invoice Integration Exception report using interface Tables only.
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
-
OTBI formula based on presentation variable prompt
Hi, I have tried to create report and in the fact amount using the following formula "CASE WHEN "Ledger"."Ledger Name" = @{COMPANYA} THEN 1 WHEN "Ledger"."Ledger Name" = @{COMPANYB} THEN 2 ELSE "Balances"."Ending Balance" END" And created presentation variable prompt ,my problem that above not captured the "Case" just…
-
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, Employee Number
-
OTBI formula to modify string
Hello, We have an analysis in OTBI from one subject area with strange behavior - in the column 'Employee' the values are in the format 'LastName, FirstName' (Doe,John), but when I use same column for filter, the values appear in format 'FirstName LastName'(John Doe) I am trying to use column functions to modify from the…
