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
-
Need help on getting correct YTD_DEPRN (YTD Depreciation) and DEPRN_RESERVE (Depreciation Reserve)Summary: Can someone pls provide inputs on where can we find correct base table and column for YTD Depreciation and Depreciation Reserve for a specific Asset and Book wi… -
How to find SQL query or logic behind the value set attached to the ESS job?Summary: Is there a way to figure out how the Asset book list of values are populated when running Create Mass Addition program? As per below screenshot, List of value s…
-
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…
-
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…
-
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 … -
-
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… -
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 …
-
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 create deep links with parameters for supplier qualification moduleSummary: As a business requirement, we should create custom Overview page in supplier qualification module. we built a analysis on the new page and when we click on resu…
-
Multiple Email domain to send seeded Out of the Box Reports in different ModulesSummary: We have a requirement for specific Oracle-generated emails to be associated with distinct domains that represent different divisions within our organization. Th…
-
How to configure the notification for Journal Request ProcessOracle OneERP --> General --> Journal. A notification e-mail is currently automatically sent to journal requestors' individual e-mail addresses. Can we change the config…
-
Manage Audit Policies - Using this for India financial regsSummary: India authorities have introduced financial regulations around system auditing and we all looking to understand how other people have achieved meeting this requ… -
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…
-
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… -
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…
-
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…
-
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… -
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…
-
Schedule running of 'Workflow Transactions Listing'Summary: Can we schedule the running of the report 'Workflow Transactions Listing' and send an email to all the approvers included on the result of the run? Content (req…
-
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…
-
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, … -
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…
-
Moved: Member Selection is not showing correct value in Smart View ReportThis discussion has been moved. -
Scheduled Jobs ErrorSummary: Hi Team, We have few scheduled jobs which will run on daily basis. Recently few system automated jobs and manual scheduled jobs ended in error without any log f…
-
Need Information on Parameters for AP_TRIAL_BAL_REPORT_PKG.BEFORE_REPORTWe are using a customized version of the Payables Trial Balance Report to pull one specific account via custom parameter on the data model. We would like to add another …
-
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…