BI Publisher
Discussion List
-
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 21 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 734 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 21 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 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 421 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 131 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 22 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 15 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 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 12 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 481 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 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 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 442 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…Milan_Mohanty 21 views 2 comments 0 points Most recent by Milan_Mohanty 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'…