BI Publisher
Discussion List
-
After 20C OAC DataSync from ERP Cloud fetching 0 recordsSummary We are observing in Data Sync the PVO's are getting 0 records while fetching data from ERP cloudContent We are seeing this currently in all instance where the Da…Kammarapalli Venkatesh-Oracle 45 views 2 comments 1 point Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for ERP -
20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsSummary 20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsContent All, 20c- BI Publisher Data Models No Longer Support P…Amarnath 298 views 6 comments 0 points Most recent by User_2025-02-05-17-23-19-130 Reporting and Analytics for ERP
-
Dynamic List of Values for ESS JobSummary Dynamic List of Values for ESS JobContent Hi, How to create a 'Dynamic List of Values for ESS Job' , I cant use the lookup and table type valueset is not working…Soumya Prakash Parhi 140 views 12 comments 3 points Most recent by RaviThejaDarbha Reporting and Analytics for ERP -
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin…
-
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 49 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP -
Report on selected bank accountSummary I need to report on the selected/default bank account where a colleague may have more than one in the systemContent Hello, I need to report on the selected/defau…User_2025-01-28-05-32-59-092 52 views 5 comments 1 point Most recent by Gopikrishna Nerella Reporting and Analytics for ERP
-
Table which captures the User-Defined Fiscal Classification CodesSummary I am looking for the back end table which captures the Manage Transaction-Based Fiscal Classifications Task DetailsContent Setup and Maintaince > Search Manage T…SandeepPaspunuri 194 views 1 comment 1 point Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
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 61 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 32 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 54 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 77 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 282 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…