Category 129
Discussion List
-
In OTBI unable to filter the trxs with 0 adjustments and with the status of approvedWhile creating an OTBI report, When we take the source criteria as Adjustment status we aren't able to filter out only the approved ones along with the transactions whic…Surbhi_1-Oracle 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
When clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp ChangedWhen clicking on Set Ownership of this Item under the Folder Properties , Report Time Stamp Changed Is this normal functionality? How can we revert this?PhillipJ 3 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Output when using a procedure callHello, I created a procedure call within OTBI. It is a complex PL/SQL that retrieve data from several tables. Each data pushed into a local table of records. All is fine…AA 21 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Line breaks in RTF template with Excel outputSummary: I have a report with two datasets. The first dataset is joined to the second dataset in the data model designer. The report used is an RTF template, and when ex…Ayala01 16 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
how to extract data from a PVO using BICCCI need to extract data from FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderExtractPVO to a file or at least to query this table. ( I need to do a count over a column to …
-
Need a table for Payment Document Category in Manage Bank account setupSummary: Hi Team, We need a table where the information of "Payment Document Category" meaning stored. There is a column PAYMENT_DOC_CATEGORY in CE_PAYMENT_DOCUMENTS but…
-
How to get Column headings to repeat across multiple pagesSummary: How to get Column headings to repeat across multiple pages Content (please ensure you mask any confidential information): Hello all - I am struggling to setup m…KDR 24 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting and Analytics for ERP
-
Expense Approval Report - how to show stops in between destinationSummary: Content (please ensure you mask any confidential information): Hi all, I have been trying to modify the seeded Expense Approval Report by adding any stops taken… -
Restricting BIP Data Model to signed in userSummary: Trying to use the data model to restrict the signed in user to only their information in projects. I'm trying to do this so that project managers when the open …
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
BIP Security - Need to restrict user from deleting the Folders from Shared FoldersSummary: Hello All We would like to restrict the users from deleting the folders from shared folders and user should be able to run and schedule the reports and data mod…ROHIT NAYAK_120 21 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to add Dashboard or OTBI analysis on Navigator or Springboard (Home page)This discussion provides step by step guidance on how to add OTBI analysis or Dashboard or any external webpage to application UI home page or on Navigator as new page e…CA Nirmal Choudhary 1.8K views 2 comments 4 points Most recent by MarkS Reporting and Analytics for ERP -
"General Ledger Journal and Subledger Transaction Mapping Report"HI Team, is it possible to get sql behind report "General Ledger Journal and Subledger Transaction Mapping Report" /shared/Financials/General Ledger/Account Analysis Gen…SushmaMeesala006 32 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Need a table or query to get Latest open period column in Manage Intercompany Period StatusSummary: Hi Support, We need a table for the column's "Latest open period" and "Open Transactions" under the setup Manage Intercompany Period Status. We have the table F…
-
BIP Bursting report failsSummary: Creating a report that will be emailed (bursting) to employees that have outstanding PCard charges that need to be added to a report for reconciliation. The rep…Kaz Myskiw 82 views 9 comments 0 points Most recent by Cosmin Foslea Reporting and Analytics for ERP
-
Exist a report that show all page composer in the ERP?Exist a report that show all page composer in the ERP?Cristian Gonzalez S 2 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
customizing payables dashboard/Invoices requiring my attentionSummary: How do I customize the build-in dashboards, eg. Payables Dashboard? Content (required): I have a requirement to customize this dashboard: The only thing that I …Anders W. Langholm 328 views 3 comments 0 points Most recent by NikitaLarson Reporting and Analytics for ERP -
how to see when a role was deleted from a user?Summary: how to see when a role was deleted from a user? Content (please ensure you mask any confidential information): how to see when a role was deleted from a user? a… -
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
DFF causes error in joint GL and SL subject area analysis in OTBIReposting this question using my corporate ID as I am still having the same issue. I created a joint subject area analysis for General Ledger Journals and Subledger Acco…Walter L Gess 42 views 5 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Is there any way to send UCM file to email/sftp though bursting ?Hi All, I would like to send the attachment of negotiation messages to others. I can get the document id of the attachment( non-pdf) in UCM, Is there any way to send the…
-
Blank pages in my BIP ReportSummary: Student Statements with 0 balances printing blank page Content (please ensure you mask any confidential information): I have developed a custom student statemen…
-
Receive Expected ShipmentsSummary: which table / tables store the data for this screen? Receive Expected Shipments Content (please ensure you mask any confidential information): 24b Version (incl…Daniel Martin-Oracle 1 view 1 comment 0 points Most recent by Daniel Martin-Oracle Reporting and Analytics for ERP
-
How to change newline characters in BIP reportI have created a BIP report using RTF template. When exporting the report to CSV, the newline character is line feed, but I want to make it carriage return and line feed…
-
Ad Hoc Smartview ERPWe recently set up a SmartView connection for Oracle Hyperion Financial Reporting, Fusion Edition so our folks can access different FRS reports from smartview. They also…
-
Chinese cannot show Bold when use rtf template to pdfHi All, I tried to customize a report's rtf template but I found the Chinese in the report cannot show bold while English show bold. I followed the disucss Added Font Ma…
-
Unable to run any custom FRS report after migrating the report from Test to ProdSummary: We have created almost 20 FRS reports in the TEST environment. After completion of the UAT, we are trying to migrate the report to PROD environment. After migra…
-
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 185 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include …