Category 129
Discussion List
-
Does OTBI Scheduler return report in non-English?Summary: When we run OTBI in UI, it returns a report with all the colums in Japanese as we set the language preference to Japanese. However, when OTBI scheduler runs, th…CHIZURU SHIGA 21 views 4 comments 0 points Most recent by CHIZURU SHIGA Reporting and Analytics for ERP -
General Ledger - Balance Real Time OTBI Report IssueSummary: We have used below columns in the report, it is not giving the data with below combination. "Natural Account Segment"."Natural Account Segment Code" "Natural Ac…FirozahamedSK 46 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
What happens if a report is scheduled by a user and, the user is inactivated in futureSummary: What happens if a report is scheduled by a user and later once the schedule is active, the user is inactivated. Also, how can a new user take control of the sch…Abhilash K - Deloitte USI 41 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
unable to get all the column values in Excel output in BIP reportSummary: Hi, When I run the BIP 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 col…Satish123 64 views 10 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Where can we see warnings after FBDI import of customersSummary: Where can we see warnings after FBDI import of customers Content (required): Where can we see warnings after FBDI import of customers. I cannot find them in the…Lucky Sharma 350 views 10 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP -
23D Table ImpactedHello Team, Can anyone tell me the List of Table that is getting depreciated or new table being introduced in 23D release of Oracle Cloud ERP. Thanks, Sandeep Shaw
-
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 13 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 24 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 22 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 105 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 15 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 82 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 48 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 58 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 145 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 125 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 77 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 31 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 256 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 79 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 18 views 1 comment 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need to know the logic behind the seeded report parameters of Payables Trial Balance ReportSummary: Just wanted to know the logic behind seeded 'Payables Trial Balance Report' parameters which are mentioned below 1.Include Bills Payable 2.Negative Balances Onl…SireeshaJaladi 87 views 3 comments 0 points Most recent by SireeshaJaladi 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 13 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 -------…