-
Retrieve only managers with at least one report having a specific legal entity
Hello experts, we would like to create an OTBI report with a list of managers (only managers name and person number). In particular we would like to retrieve only managers having within their team at least one member/report with the Italian Legal Entity. Do you know if this is feasible? If yes, could you please share us…
-
Getting this error in OTBI: ACI0A5LN
One of our users, when trying to access a report in OTBI get the following error when they click to view report Any idea how can I resolve this?
-
Seniority Dates v3 causing issue
We are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Person Seniority Real Time" subject area (e.g., Bargaining Unit), we notice an issue: Fields like Assignment ID and Assignment Start Date correctly reflect the latest…
-
i am working on OTBI report Payables Invoices - Transaction real time Subject area
i am working on OTBI report Payables Invoices - Transaction real time Subject area . where i am pulling the details of Account Debit and Account Credit , accounting date ,Supplier name .i want to pull the details of only the active supplier . how to do that in Payables Invoice -Transaction real time subject area .
-
How to fetch Sales Engineer column from OTBI in oracle fusion using subject areas
Hi, We have a requirement to fetch the sales engineer column from Leads page using OTBI Subject areas. But we are unable to fetch the sales engineer column using subject areas. Kindly provide the subject areas which stores data for leads sales engineer. Thankyou,
-
Dunning History report showing letters sent based on Invoice
Hi All, Do we have any seeded report or real time area where we can find history of dunning letters sent or at what stage dunning letters are based on Invoice. I have queried table "IEX_DUNNINGS" table but don't see any column related to Transaction. Any suggestions or help much appreciated. Regards, Bhanu
-
OTBI - How to create Drill Down with custom data model reports
Hi everyone, I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to another (Cost in each Project). These reports are related via a foreign key (Project ID). Is there a recommended approach or best practice for implementing…
-
What is the difference between Archiving and Downloading BI objects?
What is the difference between .catalog and .xdmz/.xdoz BI objects, the archive and download options thru OTBI (/analytics) and Oracle Analytics Publisher (/xmlpserver)? I understand the .xdmz/.xdoz objects can be unzipped and read thru xml format, what about the .catalog format? Both are recommended alternatives for…
-
How do I change YTD to FYTD in a measure column?
In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I update this to return sums for the FY (Jul 01 - Jun 30)?
-
Item Description error from Dashboard Prompt
currently working on Purchase history dashboard , using subject area- Procurement -Purchasing real time , when we are searching with item description (long item description) it is turning in error for normal item description it is running without any error , is their any specific character limit set for dashboard prompt…
-
How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?
Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, or if there are any alternative solutions.
-
Update “Contact Us” Section Contact Details in Journeys Checklist Template
Hi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currently, we can only control whether this section is hidden or displayed. However, we would like to update it to display different contact details instead. Where…
-
PVO for BICC SYNC - columns - TXN_XFACE_CTRL_ID and USER_BATCH_NAME Table PJC_EXP_ITEMS_ALL
looking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. Please help.
-
Need to restrict the User password updating field in one of the custom reports.
We have one custom report for the User Access where in the report only roles added and deleting information needs to be shown along with the updating date. But along with this when we reset password for that also it is showing. how can we restrict this kind of requirement. Anyone worked or knowledge on this requesting you…
-
BICC : Reset Last Extract Date at PVO Level
Summary To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings level Content Currently there are two ways change the Last Extract Date filter within BICCC outside of the built in incremental Logic BICCC has. 1. Reset to Full Extract : You can do this at the PVO…
-
Some AP invoices are missing in the OTBI Payables Report
Hi Team We have created OTBI report in Payables. In that report we have given three parameters 1) Accounting period 2) Supplier 3) Business Unit. If we download the report using any of these parameters, the report is showing all the AP invoices. But when we run the consolidated report for all BU, all Supplier and all the…
-
While creating a credit memo in oracle fusion in credit transactions i am facing the below error.
You can't overapply this transaction. (AR-855287) The transaction type assigned to the transaction doesn't allow overapplication. You can only apply a credit or receipt amount up to, but not over, the outstanding balance on the transaction.
-
Need backend query to fetch audit details of Job profile
Hi, We have enabled audit for jobs and trying to fetch the job profile details through BIP Report who, when and what are the changes that are made but somehow we couldn't be able to fetch the details. Can you please confirm if there is any way to fetch these details. Any inputs or suggestions is appreciated. Thank you,…
-
Using report parameter to call different excel template in different layout
Hi, We have an requirement from our client. They have more than 10 RTF different template for a report. When the user run the report, user have an option to choose which RTF template to run the report. I just thinking I can use the report parameter (e.g. p_layout_name). Then call the report with the correct template. But I…
-
Is there a way to find all data models using a specific field?
I asked Oracle this question years ago (and the answer was no), but I wanted to check again with this group to see if anyone found a way to accomplish it. We need to find all reports in which the National Identifier is being selected in the data model.
-
OTBI analysis - problem with left outer join
Hi, I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submitted their reported hours or not. Do you also have documentation regarding OTBI joins? select t1.t ,ifnull(t2.c,upper('wo')) as m from ( select all…
-
OTBI - SHOW ONLY SUBTOTAL
Hello and good day! Dearest Oracle community friends, Is there a way to show only the subtotal in OTBI? Hope to hear in the community with solution on this. Thanks and best regards. Regie
-
What subject area or field to display the corrected amount for Service POs in OTBI
We are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the amount received on a Service PO. That is working as expected. If we correct the Receipt Amount on one of these service POs, we are not seeing the Corrected Receipt…
-
How to remove extra spaces from file generated from BIP report
I have tried unchecking , still generating these characters in the front for each row.
-
Unable to view VETS4212/EEO1 Output in OTBI
Hello experts, We have setup VETS4212/EEO1 reporting in our Dev environment according to the documentation provided: EEO-1 Establishment Electronic Report VETS-4212 Establishment Electronic Report We are able to run and access the reports via My Client Groups > Payroll > Submit a Flow However, we are not able to…
-
Subject Area: Payroll - Personal Payment Details Real Time
Hello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Country: New Zealand I can obtain data for: Bank Code Target Bank Branch Number Target Bank Account number Thanks
-
Field Location Help (License/Cert - Item Code )
Summary: I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to Licenses/Certifications, but unable to find this field. The Item Code can be found under: Talent>Item Catalogs>Licenses And Certifications. Am I looking…
-
OTBI Redwood Receiving Comments
-
How to query fusion tables in SQL developer
Summary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_CANDIDATES table) in SQL developer . Is this possible? Content (required): Version (include the version you are using, if applicable): Code Snippet (add any…
-
View Reports and Analysis
There used to be a link under the Oracle Cloud Help Center where you could download an MS Excel spreadsheet which contained a listing of all the standard delivered reports with Fusion (sample attached). Has the link moved since it is no longer available under a Reporting and Analysis sub-category on the Cloud Help Center.…
