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
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from … -
How can I Archive multiple BI Publisher Data Models & Reports into one .xdo (catalog) file?Summary: How to archive multiple BIP reports in OTBI? Content (required): I believe it should be possible to archive multiple data models and reports into one .xdo file … -
Add Report to Manage Invoice Screen and have it be dynamicSummary: We are looking to add a report to the Manage Invoices screen and have the results of the report be specific to the invoice we are on. Content (required): We hav…
-
Why are SOAP webservices reading sample data of a BI report with Excel layout?Summary: SOAP services - reading data from a BI report, with Excel data: date fields are taken from the sample data (report excel layout) and not from the report output … -
Dynamic page orientation change from portrait to landscape in a single RTF templateSummary: Dynamic page orientation change from portrait to landscape in a single RTF template Content (required): Requirement is to change the Page orientation conditiona…
-
Looking for a master list for all the auditable objects in Oracle ERP cloud?Summary:We need an extract on the all the auditable objects, is there a way to get an extract to see what are currently audited and what is not. So the extract will show… -
Report is taking 17 minutes for 1M record using burstingSummary: Report is taking 17 minutes for 1M record using bursting Content (required): Hi Expert, We have build a report to extract ledger balance and the report is havin…
-
How to get the last instance of BIP report where delivery status = S & use it in FSCM Data sourceSummary: How to get the last instance of a BIP report where delivery status was successfull for a particular parameter and use that detail in Data Source Applicationdb_F…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…
-
We need to enable Audit Trail for Oracle Financials and Procurement.Summary: We need to enable Audit Trail for Oracle Financials and Procurement. Need to know what are the seeded Audit Trail report that system generate for the ERP Financ…
-
Select All columns from multiple tablesHi All, How to select all columns from multiple tables in the BI Data model. select a.*, b.* from table1 a,table2 b I cannot execute above sql statement when both the ta…
-
Print Receipt Traveler Report erroring outSummary: We have got a requirement to customize Standard report "Receipt Traveler Report". I have customized the standard report in custom folder. I'm unable to run the …
-
Printer Related queries raised by CustomerSummary: This print server will be configured in Oracle SaaS fusion to print the labels and invoices from BI and ESS jobs Content (required): - Does Oracle monitor the e…
-
What are the differences between Enterprise Set and Common Set?Summary: What are the differences between Enterprise Set and Common Set? Content (required): What are the differences between Enterprise Set and Common Set? Version (inc…
-
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
RWS vs SmartviewSummary: Hi All, Can anyone provide insight on when should we use RWS and when to use Smartview. Dimensions are same in both methods. Please help me with pros and cons o…
-
Moved: Is there an accounted equivalent to AMOUNT_DUE_ORIGINAL field of AR_PAYMENT_SCHEDULES_ALL ta…This discussion has been moved. -
Track setup change report/analysis in OTBISummary: Track setup change report/analysis in OTBI Content (required): I'm looking for a report or to create an analysis in OTBI to track setup change. Who and When Sco… -
Invoice Line level Subject Area in FAW OACSummary: Hello, We need to create a Invoice line level report in FAW OAC, but do not find ant relevant Subject area in ERP Financials. Content (required): the Prebuilt A…
-
What table(s) contain 'Invoice Method' and 'Revenue Method'?Hi, I'm trying to find what tables/views contain the following fields for: 'Invoice Method' - Cash basis, cost reimbursement, event-based, milestone, proportional perfor…
-
Ledger Currency are null on some payments in Analysis Payables Payments - Disbursement Real TimeSummary: Ledger Currency are null on some payments in Analysis report using the Payables Payments - Disbursement Real Time subject area. Content (required): Is there a w…
-
Parameters used to run the BIP report is not reflected in the HistorySummary: We have other reports where in the parameters are shown on the history. We don't know what's the difference with this specific report why it doesn't show the pa…
-
How to change member display in SmartView FunctionEven if I changed "Member Name Display" in Options>Member Options> General> Member Name Display, there are no changes in "Member Selection". Member Selections shows each… -
Job Set ParameterSummary: I have seeded ESS Job and I want to make a ESS Job set that assign value to the seeded ESS Job. Is there a way I can achive that? Content (required): There is a…
-
How to change the "subject line" or "from address" details for Accounting Automation emailsSummary: Content (required): We have enabled GL accounting automation process in all our PODs. The issue we are facing is, all the emails from all the PODs are coming wi…
-
Assign custom role to OTBI reportHi, I have to assign custom role to custom OTBI report and I was trying to assign a role to OTBI report but custom roles are not showing in the LOV. Any suggestions?
-
Need the know table and field name for enterprise contract page to prepare BI reportSummary: I need to prepare BI report on Enterprise Sell contract as per client requirement. Please let me know the how to identify the behind table name on Billing and F…
-
AR Aging for PBCS IntegrationSummary: We need to integrate customer Aging data from Oracle fusion to Oracle PBCS . We have customer as a dimension in PBCS. When I tried to customize "Collections Agi…
-
How the performance will be affected if multiple user run a BIP report at the same time?Summary: How the performance will be affected if multiple user run a BIP report at the same time? Content (required): If multiple users run the same BIP report at the sa…
-
Does the END_DATE field in PER_USERS table get populated when the user is made inactive?Summary: Does the END_DATE field in PER_USERS table get populated when the user is made inactive? Searched this filed and no values populated Content (required): Making …