To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Why do I get an SQL timeout limit error now, after the 23C upgrade?Summary: SQL timeout value limit error Content (required): Hi, We have a custom BI report, with an explicit SQL timeout value limit specified in the datamodel properties… -
Can we create custom table in Oracle Fusion without PAAS license?Summary: Is there any way to create custom table and store the data in Oracle Fusion Order Management or any other supply chain application without PAAS license? Client … -
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d… -
Sorting in eText templateSummary: We have a requirement to sort data based on a tag from XML using eText template Content (required): In eText we can sort based on tags but here we have to sort …
-
Make every report output display date in PST timezone instead of UTC in Oracle FusionSummary: Hi Team , is there a way that you are aware of in oracle cloud that we can make the report to run in California timezone instead of default UTC timezone of clou…
-
Is there a way to display the full content of a Text Attachment on a Purchase Order/PO PDF report?Summary: Full Text Attachment content is not being displayed on PO or PO PDF print report. Content (required): The table and column which stores the PO text attachments …
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…
-
Populate DFF value in Journal Screen based on another field in JournalSummary: Define a DFF at the journal line level and default the parent level COA segment value in this DFF based on the child level COA segment in the journal line COA.…
-
Find all emails sent by OracleSummary: Find all emails sent by Oracle Content (required): Hi, An email should've been sent to a user once he did the reception in Oracle but it seems he didn't receive… -
How long are the ESS Jobs history and output files are retained on the server?Summary: How long are the ESS Jobs history and output files are retained on the server? Content (required): ESS Job History along with Log files and Output Files Version… -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…
-
How to build an Custom AP trial Balance report without having to use ap_trial_balances tableSummary: 1. We are trying to build a custom AP trial balance table which we will be sending to ARCS returning the output in a csv format, but without using the ap_trial_…
-
Is there a report which can track the provisioned/deprovisioned and deleted roles for a user?We are unable to find any report that helps us track the audit history of a user account regarding when the roles were/are assigned and when the roles were/are removed f…
-
RWS vs SmartviewSummary: Hi All, Can anyone provide insight on when should we use RWS and when to use Smartview. Dimensions are same in both methods. Please help me with pros and cons o…
-
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
List of BIP Reports FTP/ESS JobsSummary: List of BIP Reports with FTP/ESS Jobs Is there any query or report that provides a list of all BI Reports which include FTP/Bursting enabled or registered as an…
-
Can we submit a BIP Report as Job from UI using a linkSummary Can we create a link or button in ERP which submit a BIP Report as Job uplon click/press ? Content (required): Version (include the version you are using, if app… -
Need the Backend Table Details for Oracle SubscriptionSummary: I want to build a report to get what module/functions are used for my organization/company. Content (required): need the query if any one have handy. Attached i…
-
Can custom PL SQL TABLE type in Fusion DB be createdSummary: Need custom PL SQL TABLE type in Fusion DB to use in BI report with Data Set Type as Procedural Call Content (required): In Fusion BI Report some complex valida…
-
Access BU in BIP based on UI RolesSummary: I have a client who has requested a specific functionality for displaying Business Unit (BU) names in the Business Intelligence Publisher (BIP) List of Values (…
-
Using Oracle Database Cloud Schema Service to access Oracle Fusion DatabaseSummary: Using Oracle Database Cloud Schema Service to access Oracle Fusion Database Content (required): in MOS article 1910762.1 it states "If the SaaS / Fusion service…
-
How to put current financial year filter to date columnSummary: hi we are developing an Otbi report to find out the revenue recognition amount for the current financial period, can any one suggest us, how to put the filter o…
-
Oracle Fusion ESS - Scheduled Processes - Schedule Monthly By Date - ClarificationSummary: While Scheduling an ESS Job in Oracle Fusion: If we want to run the process once a month every month on a particular day, for example, 29th or 30th of every mon…
-
BICC - Customization migrationSummary: BICC - Customization migration Content (required): I want to migrate one custom offering from one environment to another environment. BICC is giving an option t… -
Sales Order Lifecycle ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…
-
How to replicate values from a calculated column to all table rows in an OTBI analysis?Summary: I have a table that shows columns related to Innovation Management Proposal's instances like Proposal name, profit, proposal type, proposal squad, proposal trib… -
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
Oracle Fusion Cloud - Fields/recordsSummary: Hi, I am new to using Oracle Fusion Cloud and coming from Peoplesoft. Is there any kind of view or extension on a page in Fusion where I can find field names an…
-
Smart view - OBIEE - ExcelSummary: When working with multible excel workbooks and connected to OBIEE in one of them, when shifting to another workbook the OBIEE extension tab always open. Content…
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…