BI Publisher
Discussion List
-
ISO 2022 Payment formatsSummary ISO 2022 Payment formatsContent Hello everyone, I am trying to understand how ISO 2022 payments work. How do we create those payment formats. If anybody has any …Lucky Sharma 58 views 6 comments 0 points Most recent by Lucky Sharma Payables, Payments & Cash Management -
Audit trial for events on some modulesfor audit purposes , can we get a log if a person export data from module, or if a user query about data ? (like the search in the person managment for employee's data)Mustafa Abu Dayeh 1 view 0 comments 0 points Started by Mustafa Abu Dayeh Reporting and Analytics for HCM -
Table Name for Approver's Data of BPM Worklist along with History of Approver'sSummary: Issue : Table Name for Approver's Data of BPM Worklist along with History of Approver's for a Person whose Task are Completed Now We want Table Name's for Appro…Roy Aniket 61 views 1 comment 0 points Most recent by Rama Mohan - Support-Oracle Payables, Payments & Cash Management -
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM -
Not able to find join between budget tables and GL_BALANCESSummary: We have a requirement to build a custom report where most of the columns are from the control budget screen under budgetary control. We are fetching budget colu… -
BIP Data Model - How do I join multiple Data Sets created from OTBI AnalysisSummary: BIP Data Model - How do I join multiple Data Sets created from OTBI Analysis Content (please ensure you mask any confidential information): After creating 5 dat…Mike.Myers.CDIPRODUCTS.COM 31 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for SCM -
join GL_BALANCES and XCC budget tablesSummary: How to join XCC_ tables with GL_Balances Content (please ensure you mask any confidential information): Hi, We have requirement of building a custom report wher…SauarbhAgrawal 383 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle Budgetary Control -
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 132 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Custom BI Reports and tables performance issue in fusionSummary: Hi Team we are recently facing performnace issue on PAY_PAYMT_SEARCH_RESULTS_VL view and it is resolved automatically after one week. Could you please provide d…Venkatesh Emani-Oracle 31 views 2 comments 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
HRC_TXN_CONSOLE_ENTRY table is not fetching the effective_start_date updated during approval processHRC_TXN_CONSOLE_ENTRY table is not fetching the effective_start_date updated during approval process by HR , instead it has the effective_start_date entered in when and …Kavya Sreenivasulu 21 views 2 comments 0 points Most recent by Kavya Sreenivasulu Reporting and Analytics for HCM -
How to build EDI format and enable for AR Transaction Invoices deliverySummary: Hi Team, What are the standard EDI formats available for AR Transaction Invoice Delivery ? How to enable EDI delivery option for AR Transaction? Content (please…Aru Chauhan 1 view 1 comment 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Receivables & Collections -
Financial Tax Register seeded report ESS job not retrieving data based on Reporting Ledger ParameterSummary: We are trying to run Financial Tax Register seeded report through ESS job. Parameters passed for ESS Job : Reporting Level : Ledger Reporting Context : Ireland …Yasasree Boosireddy-Oracle 42 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global -
How to retrieve Custom Child Object and Custom Field in BI PublisherSummary: Hi, Would like to check how do I retrieve Custom Child Object and Custom Fields in BI Publisher? For example, under the SCM»Innovation Management»Proposal - I h…Poh Chie 11 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Yearly Tax summary (Italy)Summary: Yearly Tax summary Content (please ensure you mask any confidential information): Hi everyone, the VAT summary report can only be extracted by fiscal period (1 …Antonia_Fasoli 11 views 2 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle Tax & Global -
BI Publisher - Object_version_number column in gl_je_headers tableDear All, After creating a journal manually, the object_version_number in gl_je_headers is set directly to the value 3. Can anyone tell me what the purpose of this colum…George Mattar 11 views 1 comment 0 points Most recent by Uddipta Bhaumik-Oracle General Ledger & Intercompany -
Performance document questionnaire with answers for worker and manager queryI am trying to build a query for Performance document questionnaire with answers for worker and manager query but its not giving correct answers. When I add the tables f…Deepeeka Nath 424 views 0 comments 0 points Started by Deepeeka Nath Reporting and Analytics for HCM -
Error when we schedule a notificationSummary: Error when we schedule a notification Content (please ensure you mask any confidential information): We schedule a report (once a day). The Data Model and the r…Barile Alberto 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Fixed asset Subledger report - providing the location information of an assetSummary: We are in a need of a Fixed asset Subledger report - providing the location information of an asset and tying to a general ledger for a given period - is there …Dhruvjoshi23 54 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
SUPPLIER BALANCE AGING - SQL QUERY NEEDEDSummary: We have a customer requirment to customize the supplier balance aging to increase the aging buckets than the standard one. So we want the sql query for the unpa…Yara Ibrahim-Oracle 421 views 2 comments 0 points Most recent by Sean Rogers Payables, Payments & Cash Management -
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMYSummary: How to get the meaning of the MODULE_NAME( PER, WLF etc) from FND_APPL_TAXONOMY Tried with FND_LOOKUP_VALUES.Meaning does not return any vaue Can anybody Please…MilanMohanty 21 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Can we have multiple RTF templates as links instead of tabs in BIP report?Instead of having as tabs in case of multiple templates, we would like to have them as links in single view/screen, in one page. Attached the usual format, which we don'… -
Report to show all employees who have not been paid in last 3 weeksSummary: Need a report to see the employee, assignment, last paid date and benefit termination date for the employees who have not been paid in last 3 weeks. Content (pl…Priyabrata Prusty 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
Excel Report Errorummary: Hi experts, we are trying to upload a ready excel file as a Report, but we continue to receive the following error message when trying to view it. We have alread…Marlon Castillo Maliglig 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to display XML tables in BI PublisherSummary: How to display XML tables in Word's BI Publisher add-in Content (please ensure you mask any confidential information): Hello. In my project, I am using Word's R…Keita Furuya 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
What role is required to Grant only Reports and Analytics Catalog in Oracle Cloud ?Summary: We have a requirement from Business. Business wants to Run only the OTBI Reports from Cloud. So, What role is required to Grant only Reports and Analytics Catal… -
How to know what are the data accesses and priviliges needed to view a table from a BI reportSummary: I would like to know how I can relate permissions, data access, and privileges necessary to view a table. For example, I would like to know what permissions are…