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
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co… -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme… -
Report for BPM Workflow RulesSummary: Is there a mechanism to pull out list of BPM rules as an extract or report. Also the workflow Rules Report covers some of the workflows but not all. Content (re…
-
Audit Tables in Oracle CloudSummary: Audit Content (required): We are working on Audit Report. User is not happy with the output provided by the Audit Report functionality in Oracle and we want to …
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
How to use INSTRING function to retrieve string Position in OTBI Formulae column?Summary: How to use INSTRING function to retrieve string Position in OTBI Formulae column? Thanks, Immanuel
-
How to default System Date using Sandbox?Summary: We have one requirement that we need to default the system date in the Supply Request Form Content (required): We have one requirement that we need to default t…
-
OTBI User sessions not shown in Manage sessionsSummary: Other user's OTBI sessions don't seem to be always passed through and visible in Admin>Manage sessions, even when using report with prefix set to: SET VARIABLE … -
-
Child account not reflecting under Parent account in Smart ViewSummary Child account not reflecting under Parent account in Smart ViewContent After creating a new account, when refreshing Smartview report I noticed Its not reflectin…
-
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
Distributed Amount for direct report - cannot find field in analysisHello, This is the module compensation. Navigation --> Compensation>Act as proxy manager>Manage Budgets I am not able to retrieve the 48142.80 for the 11 direct reports …
-
Need clarification on movement of Fusion SaaS to new OCI environmentsSummary: Need clarification on movement of Fusion SaaS to new OCI environments, is it migrated from Fusion My Services to OCI Gen 2 ? Content (required): Version (includ…
-
Filter function in case statement in otbi columnIn my otbi analysis, I tried to add this formula in my column CASE WHEN "Compensation - Workforce Compensation Budgets Real Time"."Workforce Budget"."Published Worksheet…
-
Importing Budget in Oracle Cloud for only reporting purpose.Summary: Our requirement is to import budget from external source (EPM). Either through integration or manual upload. We don't want to apply any Budgetary Control for th…
-
Fusion to Datawarehouse mapping for reportingSummary: We are currently using Snowflake as out data warehouse product. We generate quite a few different reports from the data located there and this move to Oracle Fu…
-
How to find a Privilege or a Role which would give access to particular task in OracleSummary: Content (required): How to find a Privilege or a Role which would give access to particular task in Oracle? For example, we want to give Chart of Accounts Struc…
-
Support for Legal Entity Time Zone in ERP Cloud FinancialsSummary Request for documentation about how and for which transactions Legal Entity Time Zone in ERP Cloud FinancialsContent Our understanding is that in ERP Cloud the t…
-
How to hide parameters in csv output and change data formatHi All, I'd like to create a report which output type is csv. After the output file was generated, I found the parameters of report are included in the output file and o…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…
-
Adding page break to etext templateSummary: We have an etext template that we need to have a page break to. It appears that we can do this with xml, but we currently don't have any XML in our template. Is… -
Source Table for Manage Common Options for Payables and Procurement:Summary: Need Help on Source Table for Manage Common Options for Payables and Procurement: Pls see below screenshot of the screen.. Content (required): Given the Busines…
-
How to create a role with limited access (by module) to Reports and AnalyticsSummary: When you give a user access to the BI catalogue as a 'BI Consumer' then the person has access to data from all modules in play. We want to limit certain users t… -
How to initialize session based on username in Oracle cloud BIP reportsSummary: How to initialize session based on username in Oracle cloud BIP reports. If a Service user is running a report and has to initialize the report based on a parti…
-
Need to Convert PDF from word and merging more than one PDF documentsHi, we are planning to use BI Publisher of Oracle analytics cloud to print customer invoice out of a custom tool being developed in VBCS. we have a requirement where the…
-
Suppress Rows - Zero not working in SmartviewSummary: I am trying to Suppress rows that have HSGETVALUE formulas in them for account member in Smartview report. When the account value is zero, the rows should be su…
-
How to preserve the single space character in the report?Summary: In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the re… -
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Information regarding UCM storageHi Team, I have below given doubts regarding UCM as we are using UCM as storage while extracting file from BICC. 1) Is there any storage limitation with UCM ? Does it ev…