BI Publisher
Discussion List
-
How can I pull in all ledgers within one report regarding 'Subledger Period Close Exceptions Report'We have 20 + ledgers and have to run a report for each due to 'Ledger' as a required field. Does anyone have any workarounds if Oracle has not created another BIP report… -
Can we duplicate "Create Customer Statements" ess jobSummary: Hi, Can someone please help me in undrestanding if we can duplicate Create Customer Statements ess job. If yes, how do i call other child ess jobs after duplica…
-
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Procure To Pay real time Subject Area issuesSummary: Need help to triage Procure To Pay real time Subject Area issues Content (please ensure you mask any confidential information): I am currently validating the da…
-
If Position or Department attributes getting changes how to extract all the employees assignedSummary: If Position or Department attributes getting changes how to extract all the employees assigned to that position/department in fusion hcm Content (please ensure …Samapti 21 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…Pritha 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
BI/OTBI Report to identify list of all users who have access to a specific employeeSummary: We have a requirement to fetch all users who have access to view/modify employment data for a given user. We explored options and we can see such information is…Vinayak Hegde 21 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
SQL query to Backend table for Filtered List under Learning ManagementSummary: Hi Team, We need a back-end table or SQL query to get Filtered Lists in Learning Management module. Navigation: My Client Groups → Show More → click Filtered Li…
-
From which tables can I get the Workflow details of transactions archived in transaction console.Summary: Tables to get the Workflow task details of transactions archived in the transaction console. Content (please ensure you mask any confidential information): Vers…JSAHOO1988 24 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Customization of create accounting execution reportSummary: Customize create accounting execution report to use email bursting and steps to link it with standard create accounting ESS Job Requirement: User expecting the …Vidyashree M B 66 views 3 comments 0 points Most recent by Mohammad Hussein Subledger Accounting & Accounting Hub
-
Query to fetch data entered by employee in an ICP requestI am looking to build a query on the ICP request raised by an employee. This should include submitted and approved transactions. However, there are certain fields for wh…SHRUTI PRIYA 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 3.7K views 15 comments 11 points Most recent by Sachin Bhadange Reporting & Analytics for Sales
-
Enable Report in Administrator DashboardSummary: Hi Experts, How can we enable the below reports things in our client instances on Administrator Dashboard ? The above dashboard is available in Oracle instances…
-
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 5.1K views 8 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
How to get the total work hours in rtfSummary: I have a client who does not enter the hours in OTL. but under payslip they want no of hours(Bi weekly payroll - 80 hrs for 2 week). now I need to customise the…
-
xls template compatibilty errorSummary: Hi Team, I am currently using an Excel template in the Microsoft Excel 97-2003 format, which has been working well in production. However, I need to implement a…
-
BIP ESS Job ErrorSummary: create ESS Job For BIP Report ,Go error when run Schedule Process Content (required): Version (include the version you are using, if applicable): Code Snippet (…
-
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 32 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
A Functional Guide for customizing Disbursement Payment File Format in Oracle Cloud ERPHi All, Please find below detailed steps on how an Oracle Finance Functional Consultant should approach the customization of any payment file (Disbursement Payment File)…CA Nirmal Choudhary 530 views 6 comments 5 points Most recent by MiguelMaldonado Payables, Payments & Cash Management -
Conditional Signature Printing in Disbursement Payment File Formats Based on Fusion InstanceSummary: In the Oracle Fusion ERP seeded report “Disbursement Payment File Formats”, I need to conditionally print a signature in the check template based on the Fusion …Basavaraj Navalagi 11 views 0 comments 0 points Started by Basavaraj Navalagi Payables, Payments & Cash Management -
Customization of seeded "Supplier Balance Aging Report"Summary:Hi, I am looking for customization of seeded Supplier Balance Aging Report in Oracle fusion application where I want to add currency as a parameter to run the re…Shraddhha Namde 201 views 12 comments 0 points Most recent by Smruthi M Reporting and Analytics for ERP
-
Account Analysis Report - How to Pass Account Filter (P_FLEX_FIELD_RANGE_FILTER_ID)Summary: We are working with the Account Analysis Report in Oracle Fusion (ESS Job). When we apply an Account filter (Natural Account segment) in the report submission U…sailesh_cloudare 25 views 2 comments 0 points Most recent by User_5PFSB General Ledger & Intercompany -
Recommended OTBI and BI Publisher Reports for Financial ReconciliationI’m exploring OTBI and BI Publisher in Oracle ERP Cloud and would like to build useful reports for reconciliation between Payables, Receivables, and GL. Could someone re…
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
User_2025-02-05-14-11-28-072 5.1K views 33 comments 1 point Most recent by suellen Reporting and Analytics for HCM -
BIP Schedule Data Parameters for the Previous MonthSummary: BIP Schedule Data Parameters for the Previous Month Content (please ensure you mask any confidential information): I am looking to use date parameters on a BIP …
-
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
How to gather data of update interest tab from all employees?Summary: We need to create a report which shows all the data user has entered in Update interest page. Basically we want to gather employee interest so that recruiter ca…Vaidehi Desai 21 views 2 comments 0 points Most recent by Vaidehi Desai Reporting and Analytics for HCM
-
Etext Templates do not process an XML tag prefixed with underscoreSummary: XML Fields with underscore prefix are ignored in EText template e.g GB Statutory Deductions /PAYE/ Pay as you earn/ _TAX_CODE, _TAX_DISPLAY, _ISSUE_DATE etc Con… -
Oracle AI Apps: Intelligent Account Combination DefaultingSummary: Hi Oracle Team, https://us.v-cdn.net/6034893/uploads/2NO1N9TY10A9/iacd-supplemental-setup-guide.pdf When i going to enable this feature 'Oracle AI Apps: Intelli…Mina Sabry 158 views 13 comments 0 points Most recent by Sudip Dutta Payables, Payments & Cash Management