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
-
Positive Pay Template ConfigurationSummary I'm looking for detailed instructions for how to break down and configure a positive pay template.Content By and large I'm looking for a guide for setting up a P… -
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 48 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271 -
How to create an ESS job using PerlJobTypeSummary We want to create a scheduled process to change the default buyer of an ItemContent Hello guys, We're trying to create a ESS Job / Concurrent to change a default… -
Attend The Premier Oracle Technology Conference—ODTUG Kscope20Summary Your ODTUG Kscope20 conference pass includes access to over 300+ technical sessions, all-day symposiums, lunch and learn panels with Oracle experts, and hands-on…User_2025-02-05-00-37-00-120 29 views 0 comments 0 points Most recent by User_2025-02-05-00-37-00-120
-
Customized Trial Balance ReportSummary Users are unable to run Customized Trial Balance Report from Scheduled ProcessesContent We have customized the layout of the standard Trial Balance Report and ar… -
BIP PO rtf Template archive querySummary Displaying the Line Level Notes to Supplier in the PO Template in BIPContent Hi, I have a requirement to display "Notes to Supplier" field on to PO rtf Template …User_2025-02-05-10-39-37-202 38 views 8 comments 1 point Most recent by User_2025-02-05-10-39-37-202
-
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.
-
report accounts payable with cut-off dateSummary A report of accounts payable with cut-off date is requiredContent Does anyone know if in OCF version 19D there is a report of accounts payable with cut-off date …
-
XML output using RTFContent Hi, As the data model is ready I would like to have report output in XML as shown in screenshot what is the best possible way to develop the report. Attached scr… -
Reports ListSummary get the list off all reports under CatalogContent Hello all, I am not sure this is the right section to ask this question, but I will give it a try: Does anyone …
-
Cash Flow StatementSummary Availablity of out-of-box Cash Flow StatementContent In 19D version, is there any out-of-box report (BI or FRS) available for generating Cash Flow Statement? Sam…
-
GL Valueset DFF's are not available in OTBI subject areasSummary GL Valueset DFF's are not available in OTBI subject areasContent I confirmed the context and segments are BI enabled then ran the processes: Create Rules XML Fil…User_2025-02-06-00-15-19-515 52 views 3 comments 2 points Most recent by User_2025-02-06-00-15-19-515
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, Nishanth -
How to Pass parameter from ess job to BI Publisher reportSummary How to Pass parameter from ess job to BI Publisher reportContent Hi, I created BI Publisher report with the following parameters: P_BUSINESS_UNIT P_CUSTOMER_NAME… -
Adding LOV in ESS Bi Publisher ReportSummary Adding LOV SourceContent Someone can help in Adding LOV of BiPublisher Report in Custom Enterprise Scheduler Job with LOV Source
-
OTBI bar graph formatting for gradient not workingContent I've created a dashboard and saved the supporting analyses and prompts in My Folders. When I copied it to a shared custom folder, no one in my company could view… -
Smartview reports include disabled CCID data or not?Summary Our Smartview reports were out of balance after removing the check mark on "Enabled" in "Manage Account Combinations" for some CCIDs back in 2016.Content In 2016…
-
BIP extract needs to be split into multiple files for a specific range.Summary Is it possible to split BIP extract file into multiple files for a specific range.Content Hi All, I need to extract Projects and related task information from Or…
-
How to Publish New DashboardContent Hi i have new dashboard in BI and i need to publish after finish and i stuck in below error Destination same as source: /shared/Custom/_portal see in attached Th… -
Oracle Operational reports - CSV exportSummary Oracle Operational reports - CSV exportContent All, We are reviewing the OOTB cloud ERP operational reports (BI Publisher) with client and what they really like …
-
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.
-
Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionSummary Can we still use API - APPS.iby_fd_extract_ext_pub to add custom XML tag? in Oracle Cloud FusionContent Can we still use API - APPS.iby_fd_extract_ext_pub to add…
-
Can we invoke a ess job uisng action link on BI DashboardSummary We are creating go to reports dashboard and we need to create a link on a dashboard that invokes account analysis reportContent Is it possible to create action l…
-
Custom ESS Job Parameters Display Issues on Submission FormSummary Custom ESS Job Parameters with Custom LOVs do not display correctly on ESS Job Submission ScreenContent I have created a custom ESS job from a Bi Publisher repor…
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…
-
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
line feed when displaying getclob() using data model in oracle cloudSummary line feed when displaying getclob() using data model in oracle cloudContent select sysdate, rtrim(xmlagg(xmlelement(e,id,',').extract('//text()') order by id).Ge…
-
Quarterly Patching - TestingSummary Quarterly Patching - TestingContent Hi I was just wondering what other customers do around the quarterly patching for financials? We tend to read the notes for a…
-
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …
-
otbi reports - how do i find out you last modified report?Summary otbi reports - how do i find out you last modified report?Content otbi reports - how do i find out you last modified report? i only see owner and that is person …