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
-
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… -
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…
-
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…
-
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…
-
Excel template with summary and Detail and Detail sheet should split in to multi sheet, need helpSummary: Excel template with summary and Detail and Detail sheet should split in to multi sheet, need help Content (required): Excel template with summary and Detail ( D… -
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…
-
In OTBI GL- Balances Real Time subject area 1 segment is missing from the Subject AreaSummary: Since second balancing segment label doesn't have the BI Object Name, we have created the custom label and given BI Object Name to add the Fund segment along wi… -
what role is required for data model in oracle biSummary: what role is required for data model in oracle bi Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code sni…
-
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n… -
Fusion SaaS BIP to OIC SFTP serverWe have a requirement to transfer a Fusion SaaS BIP report to OIC SFTP server within the same region. Is it the correct understanding that this traffic won't go over int…
-
Unable to Import Lookup TableSummary: Getting error while trying to import lookup type code when having context segment and associated DFF. We have context attribute named as context segment which a…
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
Limitations on number of Invoice lines that can be printed / generatedSummary: Business has a requirement to print Aggregated Invoice via ESS Scheduled Process/ Reports Business wanted to know if there would be a technical limitation on th…
-
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… -
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…
-
Ability to audit the native login enablement.Summary: We would like to understand if there is an option to Audit the native login being enabled/disabled in Cloud ERP. Content (required): Navigation: Tools > Securit… -
Attaching BI Report to OTBI DashboardSummary: Hello, I want to attach a BI report to OTBI Dashboard and connect it with dashboard's prompt. Question 1: Can I attach and view a report made from FSCM Tables (…