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
-
Where to get the file size of Work Order AttachmentI have created this query to pull the attachments for Work Order, I need to get the file size for each attachment. Is the object_size the right column to use to know the… -
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf template
-
Cannot find GL_JE_LINE table when trying to create Data Model for BIP. "SELECT * FROM GL_JE_LINE"When I try to run this sql in a data model it says the record does not exist, but I'm positive it does. Any ideas why we can't select from it? SELECT * FROM GL_JE_LINE
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
can we restrict/hide viewing few columns based on rolesIn custom reports, i want to hide few columns based on the roles. I want to restrict the access of columns to few employees only. Is it possible to achieve?
-
Run a BIP report and get the output via REST APISummary: We are trying to run a BIP Report via REST API, but getting 404 not found error. /services/rest/v1/reports/{reportPath}/run Content (please ensure you mask any … -
Getting error while bursting BIP report output to sFTP serverSummary: Getting below error while bursting BIP report output to sFTP server- Below is my SFTP bursting query- *with hash_q as query* select distinct HASH "KEY", 'MicroS…
-
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…
-
Is it possible to edit and add column in Manage Invoice report on Fusion screen?Summary: Is it possible to edit and add column in Manage Invoice report on Fusion screen? User want to add one column in the output report from Manage Invoice. Content (…
-
Run large BIP reports using ScheduleReportWSSServiceSummary: In the following document Oracle advises using the ScheduleReportWSSService for executing BIP reports with substantial data volumes. Fusion Application BI Publi…
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …
-
Deep link for Journals to view Journal Entry ScreenSummary: Hi Team, Need some details about the Deep link for Journals to view the Journal. In BIP report on Journal Batch Name column , respective journals can be opened …
-
Extract Invoice attachment with Rest API Fusion ERP CloudSummary usingContent The following help page documents how to use the Get an attachment for an invoice Rest API. Running the codes gives me a similar response as per the…
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …
-
Is there a not equal operator for Query By Example?Summary: Is there a not equal to operator for query by example? Content (please ensure you mask any confidential information): We've had a few users request a not equal … -
Error for some user when opening Customer AccountHello, I am encountering an issue when accessing a customer account in Receivables. Steps performed: Navigate to Receivables > Billing > Manage Customers Search for the …
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?
-
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 …
-
SQL tables that store invoice and journal approval data like tasks & related rules etc.?Summary: What are the SQL tables with invoice and journal approval data like tasks and related rules like we have for procurement where we have the table POR_AMX_TASKS, …
-
Sample OTBI Report: Payables and ReceivablesSummary OTBI reports covering Oracle Fusion Receivables and PayablesContent This is a set of 13 sample reports showing various receivables and payables transaction detai…
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23… -
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
Which table has Journal Transaction details?Hi, Does anyone know where the details below can be found in the Oracle Fusion? This is inside of a Journal Transaction
-
Designing a BIP report that calculates the number of receipt notifications issued each dayHi , We Would like to explore if we can build a BIP report which calculates the number of receipt notifications issued per day. Can you please let us know if it is possi…
-
Budgetary Control Carry Forward Sample BIP ReportsSummary Sample reports to identify transactions that impact budget account balances, and also facilitate the identification of transactions and balances that need to be … -
Facing issue with FRS report after migrating to another instance.Facing issue with FRS report after migrating to another instance. Getting "Unknown Member Issue" even when the hierarchy and account exists
-
Can you help me with an example of how to use DFF in a query??I am building a query to extract invoice details as well as the line level Entity, Category and Actual month details as well from ap_invoice_lines_all table. Attribute3,…