Category 129
Discussion List
-
BIP Based ESS Jobs Completed with Errors Post Environment RefreshSummary: BIP Based ESS Jobs (Seeded and Custom)are completing with errors immediately after submission following the recent Environment Refresh (Self Service) . Unable t… -
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 44 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 44 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 12 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 229 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 52 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 80 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 26 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 12 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 12 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…
-
There is a need to show GL Account and Description in 2 separate columns in FRS ReportThere is a need to show GL Account and Description in 2 separate columns in FRS Report Is there any way to split Account into Account and Description column in FRS reportLakshmiVanarasi 12 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to execute BIP report and get a PDF file by calling SOAP web service ?Summary: How to execute BIP report and get a PDF file by calling SOAP web service ? Content (please ensure you mask any confidential information): BIP reports were run u…
-
Grouping in FRS based on parameters passedCompany Cost Center 1111 11111 2222 22222 3333 33333 If user selects the above combination in the parameters in an FRS report, the data should be fetched for the sum of …PrerakKhandelwal 41 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany