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
-
Using rest api in fusion BI publisher data modelSummary: Is there any way to use rest api fusion BI publisher data model, I need to consume external data source and create a report in oracle fusion Content (required):… -
Asset cost and reserve detail ReportSummary: I am currently working on a custom report where I need to include asset cost, reserve details, and a summary report. However, I am unsure about how to obtain th…
-
How to find last logon date of users in Fusion Applications?Summary How to find last logon date of users in Fusion Applications?Content Hello people You know how to inform me please, in which table can I retrieve a list with the …
-
BIP Joining GL with PJF_PROJECTS_ALL_BI'm trying to join PJF_PROJECTS_ALL_B with this query so that I can add segment1 from the table to this GL report. Does anyone have any insight for easiest way to achiev…
-
Requirement to get user environment languageThere is one requirement to get user environment language. Tried to logged in cloud with German language to get the expected output. However, when I run the following qu…
-
Custom Job Set not showing for one userSummary: We have created job sets in a lower environment and the users that need to access it are able to with the exception of our Director of Projects. She is still no…
-
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report… -
How to restrict User From Submitting Create Accounting for a Certain SubledgerSummary: How to restrict User From Submitting Create Accounting for a Certain Subledger Content (please ensure you mask any confidential information): Hi All, We have a …
-
Table to get the field of Condiion under Manage Chart of Accounts MappingsSummary: We need a table and column where the Condition field information stored for the setup "Manage Chart of Accounts Mappings". Attached the screenshot with highlite…
-
how add user variable to report header #2Summary: I need to add user variables into a report header. Is there any way to do this? What is shown below doesn't work. -
how add user variable to report headerIs there any way to put a user variable into the header of a report?
-
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same …
-
What is and when should the "Synchronize Transaction Workflow Status" process be run?Summary Listed in Scheduled Processes is "Synchronize Transaction Workflow Status" with description "This process ensures that the workflow status is updated correctly i… -
How to Fix Height of table In An RTF TemplateSummary: Hi Team ,Can anyone tell me how to Fix Height of table In An RTF Template. Example: If table has 1 or 10 invoice the height of table should be same. I have chec…
-
How to send an ESS job output on email?Summary: Need to send an ESS job output (ex: .pdf) on email, to certain people Content (required): Needed functionality: send ESS job output on email. Tried from: Schedu… -
Remaining Life of an Asset in Fixed AssetsContent What is the query to calculate the remaining life of an asset year and months wise in oracle fixed assets.?
-
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…
-
How to schedule FRS reports in Fusion FinancialsSummary: I need to run an FRS report in Fusion Financials using scheduling. In EPM the process would be to create a batch and then add the batch to the schedule. In Fusi…
-
Scheduling "report" based on column with user emailSummary: I developed an SQL report on OTBI and an EXCEL output should be delivered to corresponding users. There is a column containing email address of the user and use…
-
Newsfeed vs Banner vs PanelSummary Default Home Page Layout OptionsContent Is there a recommended option for Default Home Page Layout? Are there benefits of going with one over the other? Looking … -
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…
-
How to fetch only current/latest updated eff data from EGO_ITEM_EFF_B table?Hi, We need to extract current item eff data. We are using EGO_ITEM_EFF_B for fetching the same. But this table is fetching all the values updated for effs till date. Bu…
-
OTBI Report for General Ledger - Journals Real Time Not Displaying Correct AmountsSummary: Entered Credit & Debit Amounts and Accounted Credit & Debit Amounts are not displayed correctly in the OTBI Analysis using the General Ledger - Journals Real-Ti… -
List of Special character which cannot be loaded through FBDI file.Summary: We have around 50 Inbound integration from various sources for GL, AP, AR, PO, Receipts. We have observed that if special characters are present in the file lik…
-
Can you run a process and have the report/file generated from the process sent to a set folder?Hi Everyone, Is it possible to have a process run adhoc or scheduled and when the process finishes the report output is sent to a file/folder location? For example, if o…
-
View OTBI Report using BI Consumer RoleHi. I created some OTBI reports and was able to view them. I am now testing view only access with the OTBI reports using a user that only has the BI Consumer Role. It se…
-
How to run Audit Type Reports by EPM Automate or by RestAPI for EDMCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BI Report Calling service isssueSummary: Hi Team We are calling BI report using SOAP service but getting below error. CASDK-0033: Received a SOAP fault while invoking endpoint target: This indicates a …
-
FLA to GL tables join to display vendor detailsHi, For an account analysis BIP report, I want to link the FLA table and GL tables to display the vendor details. But I am not able to join Can you assist? Thanks and Re…
-
Browser is getting automatically refreshing when scheduling ESS job set in Oracle cloud ERPSummary: Hi All, I hope everyone is going well!. I need some help in resolving the ESS job set related problem. I have created the ESS job set with 10 Ess jobs inside of…