Category 129
Discussion List
-
Unable to get excel outputSummary: Hi, When I run the report to get the output in CSV, HTML etc. its fetching all the column values but when I run it to get the output in Excel format few columns…Satish123 16 views 2 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Include a row when column null in out of the box analysisI would like to use an analysis in OTBI but include the data when a column has a null value. What happens now is when I add the column and that column is null, the resul… -
OTBI - Can we have one line per transaction with tax amount?Summary: We are looking to have only 1 line per transaction and when I add tax amount it splits the report to multiple lines per transaction. Is there a way around this?…Rahul Kumar Gupta.-Oracle 25 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Can Oracle ERP Cloud BIP pulling data from external database to build report?Summary: Can Oracle ERP Cloud BIP pulling data from external database to build report? Content (required): Version (include the version you are using, if applicable): Co…User_2025-02-10-23-40-15-146 26 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to extract data from an xmltype columnSummary: How to extract data from an xmltype column that is in the table ZX_CONDITIONS Content (please ensure you mask any confidential information): I am trying to put …
-
Security feature for AR invoice print options available in view image button of transactionsSummary: Is any security feature for AR invoice print options available in the view image button of transactions Content (required): Users are saving(save as pdf method)…Siva Gollapalle 112 views 5 comments 0 points Most recent by Nikki K Reporting and Analytics for ERP
-
How to query committed cost of projects?Using Oracle ERP/ FSCM, there is a requirement to add data related to "Project Committed Cost" to our data warehouse. We mostly use the PVOs to import data in DW, What a…SHAHRAM SALAMI 22 views 1 comment 0 points Most recent by Gershatprg Reporting and Analytics for ERP
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 84 views 2 comments 1 point Most recent by CathyK Reporting and Analytics for ERP -
Requisition Approval E-Mail Report Template changes is not getting reflected in output fileI have customized the seeded report named "Requisition Approval E-Mail Report" but the changes is not getting reflected in the notification. It is taking the last update…Deepa Kumari 55 views 3 comments 0 points Most recent by Deepa Kumari Reporting and Analytics for ERP
-
create a net column on an analysis by subtracting two columnsSummary: I am trying to create a net column on an analysis using by subtracting two columns that are included on it. The Analysis is using the GL and AP subject areas. T…Tashi Temple-Wood 60 views 6 comments 0 points Most recent by Tashi Temple-Wood Reporting and Analytics for ERP
-
Remove ability for users to edit FRS reportsSummary: Users have the ability to view and edit FRS reports through the "Launch Financial Reporting Web Studio". Content (required): We would like to know how we can re…Joe B 154 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 134 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
How to select multiple members in one of the dimension? FRS reportsTeam - how can I select multiple values of one of the dimension in FRS report(s)?User_2025-03-28-20-51-35-346 86 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
ERP Cloud - Export Table Using Saved QuerySummary: is there functionality in ERP Cloud similar to OTM Cloud Export Table using query? Content (required): OTM has ability to run custom SQL query and extract resul…Roman Havrylyak 36 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 278 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Why is the PVO for project team members not appearing anymore in Oracle 23... versions?Hi, We noticed that the following PVO, used to extract data for project team members: FscmTopModelAM.PjfProjectDefinitionAM.ProjectTeamMemberPVO , does not appear anymor… -
API to update SSH Key every 90 days in Oracle BI Admin and Manage Transmission ConfigurationSummary: Content (required): Is there any API to update SSH Key every 90 days in Oracle BI Admin and Manage Transmission Configuration Version (include the version you a…
-
Apply Format Currency in RTF within a calculation TagSummary: Hello, Is there a way to apply a format currency () for this tag in an RTF template: Thanks Content (please ensure you mask any confidential information): Vers…Guillaume SAVALL 90 views 0 comments 0 points Started by Guillaume SAVALL Reporting and Analytics for ERP
-
PGP Encryption for RunReport SOAP Web ServiceSummary: Is there a way to encrypt the Report output when the report is extracted using the following SOAP API: Service WSDL URL: https://servername/xmlpserver/services/…Shubham Malik 19 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Feasibility check to customize Disbursement PPP File to generate xml output with attribute values.Summary: Requirement is to customize Disbursement Payment File for a bank to generate an xml output to display attribute values from CE_BANK_ACCOUNTS, IBY_EXT_BANK_ACCOU…Chowdari Malapati Monika 16 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
BIP Cloud - Deployment role missingSummary: BIP Cloud - Deployment role missing Content (required): Please note this idea is related to deployment of BIP reports on "BIP Cloud" Problem Description -------…
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
what is EDI location in Banks, Branches and Accounts FBDI TemplateSummary: What is EDI Location in Banks, Branches and Accounts Template also guide me on how to update Bank code, Branch number etc., for existing bank accounts. Content …
-
Concatenating Values in a Database with 'for each' with a delimiterDear all, Is there a way to retrieve data using a 'for each' loop and insert a string between the values? For example: I have the following values in a database table: c…George Mattar 28 views 5 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…Service Desk Claremont 29 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Cannot connect to URL in FRS ReportSummary: Hello, When trying to edit my FRS report or even adding a member, like Aug-23 in the Accounting Period, the system gives me a white screen with an error of 'htt…
-
Why to use FRS or Narrative reports when we have OBTI and BIP toolsHello Oracle Gurus, When we have reporting tools such as OTBI and BIP, why is there a specific need to use Narrative reporting tool or FRS tool?
-
How to sort data in etext template using a hard coded fieldSummary: We have a requirement to sort data using a record type element. this element is custom and is the first column of the level and not present in the xml file. Ple…Abhilash K - Deloitte USI 74 views 3 comments 0 points Most recent by Arun Raj Reporting and Analytics for ERP