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
-
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC… -
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… -
Moved: Drill Down OTBI is not working correctly using Custom Column.This discussion has been moved. -
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…
-
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…
-
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
Moved: SQL - GL Balances for IntercompanyThis discussion has been moved. -
Error : ORA-01861: literal does not match format stringThis is my query : WITH details AS ( SELECT ppl.person_number, ppl.person_id , pet.base_element_name, pee.effective_start_date start_date, TO_DATE(peev.screen_entry_valu…
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio… -
ERP Scheduled Job behaviour while downtime as part of maintenance/patching activitySummary: Hi Team, Could you please suggest on the behaviour of scheduled custom or seeded ess jobs in erp, during system downtime as part of maintenance/patching activit…
-
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r… -
Approval rule on business creationSummary: Approval rule on business Unit creation not working Content (required): I want to apply approval rule when Business Unit is created/updated, and I used the task…
-
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…
-
How to add new Column in seeded Subject area Receivables - Transactions Real TimeSummary: I need to add column as Ready for XML (select READY_FOR_XML_DELIVERY_FLAG from RA_CUSTOMER_TRX_ALL ) Content (required): Version (include the version you are us…
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content… -
Administrator license consumptionSummary: Content (required): We have a user "****.ADMIN" who has these 4 admin roles: -Employee -IT security Manager -Application Implementation consultant -Application … -
Dynamic Logo in FRS reportsSummary Dynamic Logo in FRS reportsContent Hi All, Can we have company logo derived dynamically in FRS reports ? Thanks Version 19C -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
Report on Invoice coding approval flowContent Hi, Is there any seeded OTBI report for invoice coding approval flow. If not can you please help with the SQL query to view using BI publisher Thanks -
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…
-
Does exist a Job to update data in OTBI ?Summary: Does exist a Job to update data in OTBI ? Content (required): Dear All, we need to know if exist a Job to update data in OTBI. Thanks, Elisa Version (include th… -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
customizing payables dashboard/Invoices requiring my attentionSummary: How do I customize the build-in dashboards, eg. Payables Dashboard? Content (required): I have a requirement to customize this dashboard: The only thing that I … -
Fusion - using BI soap service ExternalReportWSSService to run reportThe soap service xmlpserver/services/ExternalReportWSSService is used to call the BI report. Getting an error PublicReportService::generateReport failed: user: abc@abc.c…
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…
-
Can custom PL SQL TABLE type in Fusion DB be createdSummary: Need custom PL SQL TABLE type in Fusion DB to use in BI report with Data Set Type as Procedural Call Content (required): In Fusion BI Report some complex valida…
-
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re…
-
Data Encryption from Oracle BI publisher print to On-Prem Print ServerBased on the documentation provided on Oracle site - (Doc ID 1964157.1) , we opened up ports 443, 631 to allow printers located across state be able to print. We want to…
-
how to create a non-sso bi userSummary: how can I create a non-sso bi user Content (required): n/a Version (include the version you are using, if applicable):23A Code Snippet (add any code snippets th…
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …