BI Publisher
Discussion List
-
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 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 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 12 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 483 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 445 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 22 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 24 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…
-
PER_EXT_PAY_EMPLOYEES_V2_UE won't retrieve INACTIVE person information regarding salary informationSummary: Hello, Customer Connect! I had developed an HCM Extract that fetch employee data such as some person/assignment information(person_name, assignment number, lega… -
Update Seeded oracle certificate template in LearningSummary: Update Seeded oracle certificate template in Learning Content (please ensure you mask any confidential information): Update Seeded Oracle certificate template i…
-
How to handle the data which has a new line in it in LOV/BI Reports.Summary:User has mistakenly entered new line in a column, where data type CLOB is text, for that the LOV value is populated in 2 line and the report parameter is not han…Sura Yashaswini 11 views 3 comments 0 points Most recent by Sura Yashaswini Reporting and Analytics for HCM
-
Which column from REVISIONS table needs to be mapped to Document ID of Content server dataset?My goal is to read contents of file in UCM and append it to PO PDF. Currently, I am using DID column from REVISIONS table and mapping it to Document ID of Content server…
-
is there a way to send auto- generated email notifications to the users about unsubmitted claimsSummary: is there a way to send auto- generated email notifications to the users about unsubmitted claims within a specified timeframe like 3 days or 1 week..etc. Exampl… -
Periodic Payroll Activity Report bursting Based on LocationSummary: Hi I have a requirement to split Periodic Payroll Activity report based on location. I tried bursting option by creating a copy of globalreport data model and c…
-
Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML FileSummary: Different Bank Branch Number and Bank Alternate Branch Name in a single ISO20022 XML File Content (please ensure you mask any confidential information): We are …Christian Roxas 21 views 2 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management
-
Unable to convert date in specific formatSummary: We are fetching termination date from xml table which is fetched in string format. We need to convert date in format 'DD-MON-YYYY' which is not happening. Data …Arpit Dhalawat 12 views 2 comments 0 points Most recent by Arpit Dhalawat Reporting and Analytics for HCM
-
How to report on Directly Assigned detail in AOR TemplateSummary: I'm looking to report on the Directly Assigned detail in an AOR Template Content (please ensure you mask any confidential information): I've looked in all the A…
-
How can I access the candidate profile source via BI publisher?Summary: I need to access the source fields on the candidate profile. I have so far identified that I can access the application source via the IRC_SOURCE_TRACKING table…