Reporting and Analytics
Discussion List
-
24B OTBI Reported Time Cards Real Time : Reported Timecard Details : Timecard Messages is blankAs per the 24B Feature, "SUPPORT VALIDATION MESSAGES IN TIME AND LABOR SUBJECT AREAS". I have a timecard that throws the error message via a time entry rule. But in the … -
SQL query for Balance sheet and income statementWe have a requirement to get Ending balances and Average balance for Balance sheet using BIP, has anyone worked on this?Priyankaprks 205 views 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany -
Insufficient BIP privileges to run queries that fetch logs for an issue in Fusion Recruiting CloudWhen the queries that fetch Recruitment Content Library Notification Details and Email Message Content and Delivery Status details are run on BIP in order to collect log…Rohan Kulkarni-Oracle 2 views 0 comments 0 points Started by Rohan Kulkarni-Oracle BI Publisher Learning Center -
How to get backdated Leave balance Data in OTBIWe have a requirement to get the Leave Balance of a particular Absence Plan on a particular date in OTBI, when we configure this , when we check it for backdate we still… -
Report Approval Path PRWe have requirement to make report about all approval path (person) from requester until approver for transaction PR or PO. Is there any table or data set that used to c…fani2904 31 views 3 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Do we have a report that shows the total of foreign currency balances for the accountsSummary: Do we have a report that shows the total of foreign currency balances for the accounts in a particular ledger Content (please ensure you mask any confidential i… -
Enterprise Contracts OTBI Fields - Couldn't find the notes on a contract field in the subject areaHi All, Is it possible to include the notes on a contract as a reportable field when creating an analysis? It is currently not an option. Can anyone please guide me on w… -
Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user.Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user. This is generated from custom report, and it is showing Pending Bene… -
What is Automatic Invoices percentage in Procure to Pay Dashboard?Hello, What triggers or affects the Automatic Invoices percentage in the Procure To Pay dashboard?Yousef 21 views 2 comments 0 points Most recent by John Housari-Oracle Payables, Payments & Cash Management -
SQL Query to get AP invoices stuck in initiated status in oracle fusion Cloud ERPHi All, I need a sql query to get all invoices in Initiated status that are not assigned to any user or security role for approval. Can anyone please guide me where I ca…Sneha_S 613 views 1 comment 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Summary: Can we restrict the users to submit the ESS job/ Job set in SAAS applicationSummary: Content: We would like to restrict the users to submit the ESS job/ Job set in SAAS application. I tried with action item with reference to oracle Note: 2251561…surya reddy 51 views 7 comments 0 points Most recent by MandeepGupta Fusion Applications Administration -
Best practices for moving data from Oracle DM Cloud to a GCP data lakeHello Everyone, I'm Umesh, and we're currently implementing Oracle Demand Management Cloud. I'm looking for recommendations on the best practices for moving data from Or…Umesh GC 21 views 1 comment 0 points Most recent by Prateek_16-Oracle Supply Chain Planning and Collaboration -
"view image" in oracle fusion receivables works for few transaction and shows blank pop for othersI have created a custom template for a BU and added it to the main seeded template in bill presentment for the "view image" feature in oracle fusion receivables manage t…Sneha_S 756 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Is it possible to trigger existing report in Oracle button page using Sandbox?We would like to trigger a report and run it as Scheduled Process when clicking existing Oracle Fusion button (Manage Invoice Preview button to be specific). Is it possi…Eden Valparaiso 71 views 1 comment 0 points Most recent by Gpe_AL-Oracle Reporting and Analytics for ERP -
Last activity date w/ owner of last activity by accounts reportWe have a number of reports on our OTBI Dashboards that looks at last activity by account by a few different categories. Recently we've felt that bringing in the name of… -
FAW report of all custom reportsIn fusion analytics warehouse can we get a report which gives details of all custom reports created including report fields, filters etcPhalke, Gayatri 11 views 1 comment 0 points Most recent by Sudarsan Royam-Support-Oracle Warehouse Management -
What are the subject areas to fetch question and answers in OTBI?In BI report we get the following fields from the following tables: QuestionnaireParticipantPEO.qstnr_participant_id AS Q_QSTNR_PARTICIPANT_ID, QuestionnaireParticipantP… -
Custom ESS job creating unwanted extra filesESS job is created for BIP report, and it is scheduled for every one hour. And it is creating unwanted extra files and sending them into content server (UCM). How to res…Rajeswari 51 views 4 comments 0 points Most recent by MandeepGupta Fusion Applications Administration -
David Sak 21 views 3 comments 0 points Most recent by RaduALBEI-Oracle Fusion Applications Administration -
Few Roles missing when I pull the 'ALL ROLES' Report in ERP Fusion?Summary: Some of the Roles are missing when I pull the 'ALL ROLES' Report in ERP Fusion. Just wondering what would be the reason? some examples are below... Content (ple…Jaya Syamala 26 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration