BI Publisher
Discussion List
-
Getting data from a Data Model to test it (Ad Hoc)Content After the direct SQL query was removed, I am now forced to create a report for my data model when I want to see the data in any other format than XML or more tha…MaartenDIF 60 views 6 comments 1 point Most recent by User_2025-02-06-06-17-13-684 Reporting and Analytics for ERP -
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access… -
Where can we get Percent Complete in Contracts Associated ProjectsContent Hello all, From where can I get the highlighted field . This is from which table? I checked contract lines tables there Percent Complete is coming NULL. Please s…Lucky Sharma 29 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 Reporting and Analytics for ERP -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti…Koteswararao Yenikepalli 55 views 1 comment 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX tableNageshwaran1 94 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
BIP report deployment by using web service with object permissionContent Hi, Experts. I would like to deploy BIP report and data model by BIP web services from Test instance to Production instance. Each Object has specific permissions…shun nakamura 127 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g…Koteswararao Yenikepalli 72 views 3 comments 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP
-
Session user for bursting BIP reportSummary Session user for bursting BIP reportContent How can i burst BIP report to the session user ( the user that run the BIP report ) ? what parameter i should add aft…Shlomo Elnekave 51 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP -
Unable to view audit data in _ tablesSummary Unable to view audit data in _ tablesContent Hi All I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract … -
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudNageshwaran1 20 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Add note text of an invoice in OTBI/BIPSummary Add note text of an invoice in OTBI/BIPContent Hello, My need is the following : create a report which will show the comments of invoice which are rejected This …Antoine.Kaiber 96 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Otbi report on Asset BookSummary Otbi report on Asset BookContent I need to create a report that shows the change in asset life. Which field names do I need to add to reflect the asset life befo…
-
Need to extract all OTBI/BI reports in custom folderSummary Can we use sql to extract OTBI/BI reports metadata?
-
How to idenitfy attached expense at line levelSummary Need to find query for attached expense at line levelContent Hi, I am trying to create a table which shows the expense line and it's attachment. Currently I have…
-
Querying CST_COSTED_ONHAND_DAILY brings nothing.Summary CST_COSTED_ONHAND_DAILY is empty.Content I do retrieve data from other CST tables but querying CST_COSTED_ONHAND_DAILY brings nothing. Any suggestion? Thanks! Ve…User_2025-02-07-06-48-26-537 46 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Best strategy for weighed FIFO item cost.Content Hi. In Oracle EBS we had FIFO layers that each one was being consumed. The item cost at a time was the weighted average of the value of the unit value of the lay…User_2025-02-07-06-48-26-537 40 views 0 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP
-
User Logon IP AddressSummary User Logon IP AddressContent Hi Experts Is there any table where Oracle stores the IP Address of an user logon ? We are looking to putting some controls on the I…Murthy Kodavati 62 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
GL Journal Workflow notification template customizationSummary GL Journal Workflow notification template customizationContent In latest release oracle allows editing the workflow notification template. We are trying to custo…saravana maneeian subhramaniun 30 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle Reporting and Analytics for ERP
-
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …Murthy Kodavati 27 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Logo in OTBI AnalysisSummary Getting error when uploading images into OTBI analysis from local driveContent Hi All, I am getting below error when uploading logo image into an OTBI analysis u…Vinod Kumar Mohanraj 285 views 7 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Add Period Date to Parameter Default ValueSummary How to add current 'MMM-yy' in Parameter Default ValueContent Hi, I would like to set my default value for my Parameter as current 'MMM-YY', so in today's instan…
-
Can a BI report be scheduled to email an excel attachement using Schedule Report JobSummary Email an excel attachement of BI report OutputContent Can a BI report be scheduled to email an excel attachment using Schedule Report Job? When scheduling via th…User_2025-02-06-00-15-19-515 58 views 6 comments 1 point Most recent by User_2025-02-06-00-15-19-515 Reporting and Analytics for ERP
-
Page Entry For OTBI DashboardsSummary How to Create page Entry for OTBI DashboardsContent Hi There, We have a requirement where in we want to have the page entry created for our dashboards. We dont w…Sahil Makhiza 60 views 2 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
Need ERP R12 tables in FusionSummary Just want to know the ERP r12 tables in fusionContent Hi, Can any one help below listed ERP R12 tables in Oracle Fusion. jai_om_wsh_lines_all jai_om_wsh_line_tax…Nageshwaran1 98 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Avoid carriage return character at the end of each line in etext outputSummary Avoid carriage return character at the end of each line in etext outputContent Hi, We have a requirement to remove CRLF at the end of each line in extext output.…ashishgupta0212 27 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How can I either hide or remove columns easily in a data model?Summary data model bi publisher reportContent I have a data model that I have copied this over. I am trying to remove and/or hide some of the columns, and then move some…User_2025-02-08-08-55-02-564 142 views 8 comments 0 points Most recent by User_2025-02-08-08-55-02-564 Reporting and Analytics for ERP
-
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…