Category 129
Discussion List
-
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
Flexfield Feature at BIP Model using where LexicalSummary: I want to make a report that similar to Budgetary Control Analysis. My current report, I define the segment1 as balancing segment, segment2 as natural account, … -
Deliver BIP report to sharepointSummary: Ability to deliver BIP report to sharepoint seems possible, but documentation is from 2007 and doesn't seem to line up with current sharepoint screens. Content …Alex Glose 82 views 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
Error when invoking ESSWebService submitRequest method from SoapUiHi, I'm trying to submit a request to run the job "ItalianSalesVatRegister" and I receive the following error: oracle.as.scheduler.RuntimeServiceAccessControlException: …
-
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…
-
BIP report output with 0 KB.Summary: We have a custom BIP report with a datamodel. The data could be seen when viewed in the data tab of the DM. When the report was ran in the BIP (using the schedu…Chetan Konda 88 views 14 comments 1 point Most recent by Chetan Konda Reporting and Analytics for ERP -
Varalakshmi 31 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Segment value Security tableSummary: Need a table that stores values stored in Segment Value Security (SVS) Rules. Content (required): Table fnd_object_instance_sets stores the value in FILTER colu…
-
Joining Subledger data with GL dataI need to build a query which joins subledger data table, xla_ae_lines to gl_je_lines. I am attempting this through gl_sl_link_id but the performance is awful, is there …
-
Italian AR E-Invoicing ProgressivoInvio NumberHi, As per Italian reporting requirement we are developing Italian AR E-Invoicing report with XML output. We have a tag called 'ProgressivoInvio', as per the customer re…
-
how to add unpaid reason under transaction tab for collections dashboardSummary: how to add unpaid reason under transaction tab for collections dashboardSwapnil Sapkal 22 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Performance impact while using standard viewsSummary: Is there any performance impact while using the standard views (in a BIP report) listed by Oracle. For eg. using standard view PJF_PROJECTS_ALL_VL, instead of t…
-
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…Erik Bjerkelund 76 views 2 comments 0 points Most recent by Erik Bjerkelund Reporting and Analytics for ERP
-
How to get the IP address of OTBI to add to a SFTP whitelistI am trying to get my OTBI environments IP address so I can whitelist it on a SFTP site. I found documentation on all the IP address, but I don't know which server I am …NicolaosDerr 97 views 2 comments 0 points Most recent by NicolaosDerr Reporting and Analytics for ERP
-
Unable to view the data in data model with lexical parameterSummary: Unable to view the data in data model with lexical parameter Content (please ensure you mask any confidential information): Hi, We are trying to create a BI rep…JithendraKCV 37 views 1 comment 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Generate blank BIP reportHi Team, We have a BIP report in Oracle fusion that has a bursting code. This works fine when there is data for report. However, if no data is returned by the underlying…Prabhjeet Kaur 338 views 5 comments 0 points Most recent by Cm Adil Ch Reporting and Analytics for ERP
-
How to join from Subledger Accounting (XLA) to transaction application entity code PJBACCOUNTINGSummary: Hi, How do we join to get transaction details in the subledger application from XLA_TRANSACTION_ENTITIES where SOURCE_APPLICATION_ID = '10036' (Project Accounti… -
How to extact segment 2 from code_Combination_description in my xml fileSummary: How to extact segment 2 from code_Combination_description in my xml file Content (please ensure you mask any confidential information): My xml stores the code c…
-
Using OR with IF statement in rtf template is not working as expectedSummary: Using OR with IF statement in rtf template is not working as expected Content (please ensure you mask any confidential information): I have a requirement for my…
-
Customization of 'Print Receivables Transactions' and 'Print Receivables Transactions: Invoices'Summary: Content (please ensure you mask any confidential information): Hi, This is regarding ESS Job 'Print Receivables Transactions' which in turn calls another ESS Jo…JithendraKCV 537 views 5 comments 0 points Most recent by JithendraKCV Reporting and Analytics for ERP
-
Output tab when scheduling a processHello On some standard reports, they don't have Output tab when scheduling the process but some do. Anyone know if we can set the Output tab to display or this is what i…Kamonwan Srasrisom 26 views 2 comments 1 point Most recent by Kamonwan Srasrisom Reporting and Analytics for ERP
-
How to go up from JELINE_ROW to CCID_S in my xml on my rtf templateSummary: Going up a level or two of my xml on my rtf template Content (please ensure you mask any confidential information): I have customised the Account Analysis rtf. …
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 985 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
FUSIONAPPSS_REQUEST_IDSummary: I'm trying to modify the ChartOfAccounts report in order to add new filters to the query, but as soon as I add the parameter :fusionapps_request__id the DM stop…Victor Bocardo Negrete 5 views 0 comments 0 points Started by Victor Bocardo Negrete BI Publisher Learning Center
-
CMK Message Processing RulesSummary: CMK Manage Message Processing Rules Description: We are working on Collaboration Messaging Framework process PO Inbound (EDI 850) to create sales order in Oracl…Amit Sutar 114 views 4 comments 0 points Most recent by Gowreenath Boina-Oracle Reporting and Analytics for ERP
-
Is there any functionality to have dynamic reporting parameters while scheduling FRS Reports.Summary: While we are scheduling FRS Reports, we need to add the ability to have dynamic reporting parameters for FRS reports. Recreating applicable schedules every mont…Abhishek khanduja 262 views 2 comments 3 points Most recent by Henry Pao Reporting and Analytics for ERP
-
Sql Query to get data security applied on Chart of AccountsHello, I need an sql query to get my user's data security on the chart of accounts values. Thanks,
-
How to archive entire catalog (Shared and Users)?Summary: With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T o…