OTBI
Discussion List
-
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…Stephanie Golly-Oracle 556 views 4 comments 4 points Most recent by M.Stafford Reporting and Analytics for ERP -
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…Vikas V. Kamat 21 views 2 comments 1 point Most recent by CA Nirmal Choudhary Reporting and Analytics for ERP -
Oracle fusion hcm OTBI Subject area for person extra infoSummary: I am looking for subject area in oracle fusion HCM that store person extra information. (i.e. Region (PEI_INFORMATION1), Capability (PEI_INFORMATION2), Service …Anup Karmankar 354 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
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…Koteswararao Yenikepalli 1.1K views 8 comments 1 point Most recent by Ranju kumari Reporting and Analytics for ERP -
The specified criteria didn't result in any data - For Purchase Requisitions and PO Details ReportsSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 101 views 3 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for SCM -
Data Security Policy is not working for the custom role which has Purchase Analysis role addedSummary: We have created a custom role by copying it BI Consumer Role, We have also added the Purchase Analysis role under this custom role so that users can access the …Shabbir M Tahasildar 82 views 5 comments 0 points Most recent by Shabbir M Tahasildar Reporting and Analytics for HCM
-
Plan period start date in absenceSummary: Hi Team, I am trying to get absence accrual detail in OTBI report. Please let me know how to get these details with plan period start date. Thanks Content (plea…Anup Karmankar 22 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM
-
XMLPSERVERIn the XMLPServer section, can OTBI reports be seen, or are only BI reports visible?Emanuele De Marchi 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Report on Denied Absences (OTBI)Summary: I am trying to create a report on Absences which are in "Denied" Approval Status using the Workforce Management - Absence Real Time SA. The Approval Status fiel…Gary Miller-39965 101 views 10 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI template?Hi Guys In OTBI for “General Ledger - Journals Real Time” I can see 2 fields for a Journal Header I can potentially leverage: Journal Header "Additional Information (Nam…
-
How to Join 'Inventory - Inventory Transactions Real Time' & 'Shipping Real Time' subject areaSummary: Hi Gurus, We are trying to build a report which show the Inventory Transcations with the 'Waybill Number' & 'Tracking Number' field. So is there a way to join t…Amrish_Amradkar 41 views 2 comments 0 points Most recent by Yann Consolin-Oracle Reporting and Analytics for SCM
-
Remove Manager role from Worker self-evaluation Performance TaskSummary: Hello, I need help to check if my case statement below is correct. I encountered errors several times so I'm not sure what is the problem with this. I want to i…
-
Can you Delete Analysis previously used in Learn to assign CoursesSummary: Can you Delete Analysis previously used in Learn to assign Courses Content (please ensure you mask any confidential information): Hello We have a number of Anal…
-
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…
-
allow ordering from unassigned sites on Blanket Purchase Agreements is not available in OTBIhttps://us.v-cdn.net/6034893/uploads/FH62H9CNBAYX/allow-ordering-from-unassigned-sites.pdf We utilize the "allow ordering from unassigned sites" control on Blanket Purch…
-
What is the role of the Manager in Self-Evaluation?Summary: Hello, I'm currently working on Performance Task Status Report for my organization. I've changed the Role to Task Assignee. In the Worker Self-Evaluation, there…
-
SQL for fetching Item, Item Class, Attribute and Attribute Group etc.Summary: SQL for fetching Item, Item Class, Attribute and Attribute Group etc. Content (required): SQL for fetching Item, Item Class, Attribute and Attribute Group etc. …Goopikrishnan Jayaraman-Oracle 2.3K views 2 comments 0 points Most recent by Ramaraj M Product Master Data Management -
OTBI Report for EthnicitySummary OTBI Report for EthnicityContent Hello, CASE WHEN COUNT("Worker"."Employee Ethnicity Code" BY "Worker"."Person Number")>1 THEN 'Two or More Races' WHEN "Worker".…Shanna Oppenheim 643 views 79 comments 2 points Most recent by Juliet Eaton Reporting and Analytics for HCM -
Accounts Receivable RollForward ReportSummary: Is there a delivered AR Rollforward report in Fusion OTBI? Content (please ensure you mask any confidential information): Version (include the version you are u…
-
Unable to pull salary amount into OTBISummary: Hi, I am currently building an OTBI report and I am unable to pull the Salary Amount into the report. The report is crossing multiple subject areas and I have i…Sylvia Wong 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting for Questionnaire DataSummary: We have multiple Observation Checklists and Learner Evaluations within various learning items in Oracle Learn, but I'm not seeing where we can pull the data fro…
-
Why can't I see DFF configured in Trading Community Model in OTBI Receivables subject area?Summary: DFF has been setup in Manage Trading Community Organization Descriptive Flexfield under the application Trading Community Model, and Module is Trading Community…Jennifer-Leung 22 views 1 comment 0 points Most recent by Marius Neagu - Oracle Support-Oracle Receivables & Collections