Category 129
Discussion List
-
How to display sysdate in an excel template. I am using an HCM Extract.Summary: I want to display the sysdate in one of the columns of an excel output. I am using an excel template. Content (please ensure you mask any confidential informati… -
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction -
Facing issue with FRS report after migrating to another instance.Facing issue with FRS report after migrating to another instance. Getting "Unknown Member Issue" even when the hierarchy and account existsLakshmiVanarasi 31 views 10 comments 0 points Most recent by LakshmiVanarasi Reporting and Analytics for ERP -
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…Jahnavi Konduru 26 views 2 comments 0 points Most recent by Jahnavi Konduru Reporting and Analytics for ERP -
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 41 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
Extract XML or output from ESS jobSummary: Is there a way to extract XML or output from ESS job through SOAP webservice, or REST to outside of Oracle fusion Content (please ensure you mask any confidenti…Sunil Pradhan 61 views 4 comments 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Oracle Help desk tables and Queries to develop a reportHi All, I need to develop a custom BI or OTBI report related to the columns below. Please guide me on this Assigned To Assigned to: Email Category Name Channel Name Crea… -
Table to find instance name/Environment NameHi Team, Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD. I have already checked the ASK_DEPLOYED_DOMAINS table…Swapnil Kashid 347 views 6 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
actual vs budget bi publisher based on COASummary: Hi, is there a BIP report where we can extract initial budget and adjusted amount for chart of accounts 1-3. Content (please ensure you mask any confidential in… -
There is requirement on BIP for learningSummary: when the learner course is due date past 7 days email notification should go to manager 's manager. How can we write BIP report to generate notification Content… -
Please provide join logic for tables within the pvo SubledgerJournalDistributionPVOSummary: As part of our project we are extracting data from the underlying tables inside PVO. Could you please provide the join logic across the below set of tables GL_L… -
What does the following code in an RTF table cell actually do (if@cell:position()...)?Summary: Hi, I wondering if someone can explain to me what the following code might do. I found it in an BIP RTF report within a table cell. The code was introduced besi…Frank.Steinjan 53 views 8 comments 1 point Most recent by Frank.Steinjan Reporting and Analytics for ERP -
OTBI - Read Only ModeSummary: I have a service account that is set to Read Only Mode within Fusion, however when navigating into OTBI the account is no longer in read only mode and can edit,… -
Query to get the final approver of AP InvoiceSummary: Hello, We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report. Current report is…Sushmitha G 93 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
How to format date column in Excel Template without adding another columnSummary: I am able to format date column in excel by adding another column and using =DATEVALUE function as suggested in below link, but I want to format date in current…Meer Muzafar Ali 21 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP -
Why BU is a mandatory parameter in ESS job of Uninvoiced Receipts Accrual ReportWe have a business requirement to run Uninvoiced Receipts Accrual Report for all the BUs. But using the ESS job we can select only one BU at a time. Tried to execute or …DebasmitaDas123 11 views 3 comments 0 points Most recent by DebasmitaDas123 Reporting and Analytics for ERP -
Bursting Email attachment with a constant attachment.Summary: Is there is any possible way to add an extra constant attachment (pdf) to send an email bursting along with report attachment? If it is Possible please help me …Goutam5555 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
OTBI - Export timeout based on user role?Summary: My manager and I are exporting the same OTBI analysis (excel format). While my export will automatically time out after 10 minutes, hers can export for hours un… -
Subject area in OTBI corresponding to XLE_REGISTRATIONS tableSummary: I need to find the subject area in OTBI in which the information about SIREN / SIRET numbers are stored. These data correspond to REGISTRATION_NUMBER column fro…Evgeniya Repnina 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …Kobby Adu 101 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
how display member name alias on a formI am having trouble displaying the member name and the alias side by side in the rows of this form. What is shown below is the alias. The member names are the actual acc…
-
Can we schedule a BI Report run and place the generated file in an SFTP location?Summary: Can we schedule a BI Report run and place the generated file in an SFTP location? How can we do this? -
How to call an Integration in OIC from ESS Job in Oracle Fusion SaaSSummary: How to call an Integration in OIC from ESS Job in Oracle Fusion SaaS Content (required): I have an Integration in OIC and I want it to be triggered by submittin… -
How to display number into decimal number in Oracle cloud sqlHi Team, Need to know about the function to convert integer into decimal like 185 it should display 185.00 -
Report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projectsHello, We have a required to build a BIP report on inception to date activity on the Revenue aspect/Invoice aspect Development SOW projects. We need to fetch the financi… -
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders… -
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Is there any method to output a certain number of lines without destroying BIP Excel template layoutSummary Is there any setting/method to output a certain number of lines without destroying the BIP Excel template layout? Content Hi, We are conducting feasibility verif… -
query to get a tax registration number for legal entitySummary: query to get the tax registration number for legal entity Content (please ensure you mask any confidential information): I want to create a SQL to retrieve a ta…