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
-
Burst to multiple email addresses stored in a parameterSummary: Burst to multiple email addresses stored in a parameter Content (please ensure you mask any confidential information): I would like to have Bursting to multiple… -
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …
-
Retired Assets in previous years should be part of Asset Register ReportSummary: Hello, one of our user raised concern regarding Asset Register Report that "all the assets that were retired last year still appear on the report. They do have …
-
Report Output data getting spit in two rows in excel file due to line breakageSummary: We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields. When exportin…
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…
-
ERP Period Close White Paper with Runbook Considerations (Doc ID 2506148.1)Summary Updated documentation availableContent Hi, Please note that we have posted an updated Period End document (21C) onto MOS 2506148.1 today. Also, based on customer…
-
Customization of Standard Trial Balance Reportwe have a requirement to create custom trial balance report using customize option from the standard Trial Balance report. The same time we want to keep both the reports…
-
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any…
-
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…
-
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi… -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin… -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…
-
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
Data Security not being applied to OTBIWe have a report created using the Subject Area- Expenses - Expense Transactions Real Time. As per Oracle documentation, this subject area access requires, Expense Trans…
-
How to identify a requisition lines if negotiated flag is checkedSummary: Content (please ensure you mask any confidential information): We have some requisition where users checked 'Negotiated' which they shouldn't. This has created … -
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Is there any base table for privilege master along with table to map privilege table with roles?Summary: Hello experts, We are trying to create a BIP query to map the user to role and role to privilege. Previously we were using the "ASE" tables for this purpose, bu…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb…
-
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab… -
convert period to a number and use in formulaI need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to c… -
Redwood Time Card Change History Errors "We couldn't find any audited data for this time card"Summary: Log in as user to HCM Me > Existing Time Card or My Client Groups > Time Management Search for and Modify an existing time card Change the hours, select a chang…
-
OTBI Analysis: How to format Person Number as 6 digits with leading zeros?Summary: Hi experts, I have a business need that requires me to extract data from an OTBI analysis and format all Person Numbers as 6 digits with leading zeros when need…
-
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…