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
-
RTF Template with multiple sheetsSummary: RTF Template must push out results in Excel with mutiple sheets Content (please ensure you mask any confidential information): I have put in place a rtf templat… -
Need the mapping of Job Application Names EarHcmEss and FscmSummary Need the mapping of Job Application Names EarHcmEss and FscmContent We have a requirement to create a custom report of the ESS Job Execution details. We want to … -
BIP Bursting - Zip Multiple text/csv files and burst to Content serverSummary: Hi All, We have a requirement to push zip files (multiple text/zip files) to UCM. This has to be accomplished in Oracle ERP Cloud SAAS tools. Please let me know…
-
Table : ap_inv_aprvl_hist_all field "response" possible values meaning?Hi Guys I could not find anything on the web, I would be interested to know what some of the values in the "response" field in table ap_inv_aprvl_hist_all mean please an…
-
can BICC join multiple tablesSummary: Hi, Can BICC join multiple tables to populate data. i.e. From XLA table, I would like to link it to RA_CUSTOMER_TRX_ALL? Content (please ensure you mask any con…
-
Intermittent Error with Custom OTBI ReportSummary: We are experiencing issues with one of our custom OTBI reports, which had been functioning perfectly until recently. Users have reported that the report intermi…
-
What is Oracle Fusion alternative for rowset and columnset used with FSG reports in Oracle EBS?Summary: In Oracle EBS, FSG Reports maintenance was quite simple. We used to maintain rowset and column sets. We can combine any rowset and columnset to form a FSG repor…
-
how to derive last day of month in OIC mapper to pass as parameterSummary: Hi All, Could someone please help me in deriving Last day of month based on system date? Content (please ensure you mask any confidential information): I have I…
-
Pick slip running for too long after bursting customizationSummary: We have customized print pick slip report to burst to email.However , its running for too long post changes. Any suggestions? Content (please ensure you mask an…
-
Help finding FND_ATTACHED_DOCUMENT table in ApBicc PVO in FDI?I need some help to find out if a PVO exists that is accessible in FDI that contains the FND_ATTACHED_DOCUMENTS table - namely I'm after a column called "URL Attachments…
-
How to pass multiple values in one parameter in OIC mapper?Summary: Pass multiple values into a parameter with delimiter in OIC mapper to invoke OTBI Content (please ensure you mask any confidential information): Hi All, I have …
-
add 2 columns in ExcelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Issue with Sheet Naming in BIP Report Excel TemplateHi All, We are developing a report using excel layout and enabled Scalable Mode = True under Report Properties. When the number of records exceeds 65531 the records are …
-
OTBI Report filter for first and last date of current monthSummary: Hi Team, I am scheduling an OTBI report. We have accounting date between parameter in report. I am adding filter to OTBI report and want system to take first an…
-
Posted query in inappropriate groupPosted query in inappropriate group -
Create Advanced Financial Controls Report with Deep Link to AP InvoiceSummary This video shows how to create an AFC report in OTBI with a deep link to drill to an AP Invoice. The documents referenced describe the various deep links that ca… -
Unable to get the data of glcoding for unapplied prepayments in otbi reportwe have created prepayment application register OTBI report, and we are getting the glcoding for applied prepayments but requirement to all data for unapplied and applie…
-
How to see the list of ESS Jobs scheduledHello All, we had a requirement to get the list of ess jobs scheduled and what frequency they have been and what is the current status of that ESS Job. for BIP Report we… -
What is the difference between Apply of the filter and Refresh of the report outputSummary: We have built a report within a Subject Area, for which we have created a Dashboard. In this Dashboard, there is a section for the Prompt and a section displayi… -
Duplicated Job Definition not creating privilegeSummary: I am duplicating a delivered job definition and updating it to the custom report created. Based on documentation, it should create a privilege in order to grant…
-
Adding comments to FRS reportsSummary Add comments to specific cells in an FRS reportContent Hi All, Hopefully someone out there can help me with this, as its driving me slowly mad. We are currently … -
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…
-
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
Enable hierarchy for catalogSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…
-
How to disable logon using username and password in Oracle ERP, EPM and OCICan someone please provide the insights on the below query We need help to understand options around security, namely:- Can we disable the ability to log on using a user…
-
To restrict access so that only pending workers can use the username and password.Hi All, Can someone provide insights on how to implement restricted access so that only pending workers can use the username and password login while everyone else uses …
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur…