Sample Reports
Discussion List
-
Hello, I need help with SQL query joining 3 subject areasSummary: Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performan… -
Is it possible to add Approve and Reject buttons in payment process request tabSummary: Is it possible to add Approve and Reject buttons in payment process request tab in payables dashboard Content (please ensure you mask any confidential informati…Venkatesan 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Does anyone have the Payables invoice register report as oracle SQL QUERY.I want to create a BI report that is the same as the payable invoice register (the one seeded in Schedule process ) , due to filtering option (i can't filter by invoice …Omran Zeaiter 31 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…Chris Mansfield 64 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can you share Expense Reports OTBI including Approver information ?Summary: Can you share Expense Reports OTBI including Approver information ? Thank you Content (please ensure you mask any confidential information): Version (include th…
-
Procurement BU missing in Top 10 Spend by CategorySummary: Procurement BU missing in Top 10 Spend by Category Content (please ensure you mask any confidential information): Hi Experts, Would like to reach out to you on …
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 561 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center -
Dunning Letter Format in Peppel 3.0 FormatHi, We have new requirement for our client need to send Dunning Letters in Peppel 3.0 Format. Can you please let us know do we have Oracle standard functionality dunning…Koteshwar Tippani 103 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tablesSummary: AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS are interiam tables. Content (please ensure you mask any confidential information): We are looking actual ba…
-
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo…
-
Client requesting data to be not split into multiple sheets in excel or rtf templateSummary: Our client is requesting that the output does not be split into different sheets if the count of records are more than 65K in Excel and 1M in RTF while generati…Abhilash K - Deloitte USI 1 view 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center -
Is there an excel template based report delivered by Oracle in FusionHas Oracle created any report with excel template inside Fusion Applications?Abhilash K - Deloitte USI 3 views 0 comments 0 points Started by Abhilash K - Deloitte USI BI Publisher Learning Center
-
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
Custom BIP Report Dynamic Column IssuesSummary: The requirement is to print the output in below format: For each period, there should be a row and corresponding value in dynamically generated column. Ex.- For…
-
How to link PL and RL rows when parent_je_header_id is not populatedSummary: How to link PL and RL rows when parent_je_header_id is not populated Content (required): I need to write a query that will bring primary ledger details along wi…Jaeyshree Kumaran Kalpana 131 views 2 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Has anyone successfully implemented secure list views? Do you recommend them?Summary: I’m eager to learn of other users' experience in implementing Secure List Views, particularly from anyone who has implemented them to any significant scale. The… -
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…Sasidhar_Araja 84 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections