BI Publisher
Discussion List
-
PVO for tax line distributions of an invoice to load data to FAWSummary: we have a requirement to showcase tax line distributions if an invoice in a FAW report. These data is not coming to FAW from ERP through delivered pipelines. Wa…Balachandra reddy 31 views 1 comment 0 points Most recent by Daniela Petria-Oracle Reporting and Analytics for ERP -
Need help from substr and instr function used in etext templateSummary: Hello Team, I need help from substr and instr function used in etext template. For Ex; NAME (11001-Benefits Services) in etext template, i used substr(NAME, 7, …JanardhanaKondaveeti 223 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Get Data from OTBI to PowerBIIs there a way to get data from OTBI to integrate to PowerBI?Anj M. 111 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Do we have unplanned depreciation report in Fusion Fixed assets ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PL Karthick Ramanathan 22 views 3 comments 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
BI Publisher for word is stuckSummary: BI Publisher for word is stuck Content (please ensure you mask any confidential information): Hi, BIP for MS Word has stopped working and the application is get…
-
How to get specific value from XML_DATA_CACHE columnSummary: How to get specific value from XML_DATA_CACHE column in FUSION.HRC_TXN_HEADER table ? Content (please ensure you mask any confidential information): Version (in…Shlomo Elnekave 670 views 4 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for HCM -
how to pass the parameter Item/Change notice to our DM based BIP reportSummary: We have a Report on which we want to pass the Item number/Change Number to the BIP Report, However the report is not passing the parameter which we are passing …Prakash Shetty 11 views 2 comments 0 points Most recent by Prakash Shetty Reporting and Analytics for SCM
-
Need to find table to get all Bank account related informationTeam, i need to fletch all the data related to bank account , can you please suggest which table suits ? ThanksNaidu.R-Oracle 22 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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 Most recent 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 42 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 415 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 134 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 4 views 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 41 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 468 views 0 comments 0 points Most recent 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 12 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 51 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 432 views 2 comments 0 points Most recent by Sean Rogers Payables, Payments & Cash Management