BI Publisher
Discussion List
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).Manoharan 251 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Exception: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violationSummary: Failure: Due to oracle.xdo.server.ReportException: oracle.xdo.servlet.CreateException: java.lang.SecurityException: Security violation Content (please ensure yo…Parag Hiremath 791 views 10 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
Query to find details of Scheduled Processes ESS jobs?Summary: Hi Team, we have requirement to fetch all ESS jobs from Scheduled Processes UI. while i am checking the backend tables unable to fetch the name of scheduled pro…Vishnu_Jai 3.6K views 4 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
what are the PVO's available for Legal Entity which can be used in Finance Module ESS JobHi, Could you please provide a list of PVO which can be used for Legal Entity in Finance Module ESS Job. Thanks, LakshmiLakshmiSahithi 1 view 1 comment 0 points Most recent by Mahesh Adivishnu-Oracle Receivables & Collections
-
Oracle Learning Cloud Bulk Processingwe need to have details about the ESS Oracle Learning Cloud Bulk Processing, which has been running in production. Is it possible to get these details via query? Do you …
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 41 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to get the organization and customer hierarchy data from tables in oracle fusion planningSummary: Hi Team, What all are the table to extract the organization and customer hierarchy data from tables/BI report in oracle supply chain planning cloud? Content (pl…Nitin Aavasarmol 313 views 1 comment 0 points Most recent by gclampitt Supply Chain Planning and Collaboration
-
how to fetch entered balancesSQL Query to identify Entered balances in Oracle Fusion tables.Suvodeep_Saha_98 13 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany
-
how can i get the data security info from tables with sql.Summary: i need to use this security infos to restrict the parameters a user can use when submiting a BIP report Content (please ensure you mask any confidential informa…chang.liu 31 views 3 comments 0 points Most recent by chang.liu Payables, Payments & Cash Management
-
disable_date not populated in HR_ALL_ORGANIZATION_UNITS_X after inventory org is disabledHi Team, We have disabled the inventory org and we are checking below condition but org.disable_date is not populated. Can you please help how we can populate org.disabl…vikram khengare 11 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Need to add new parameter to Seeded ESS Job "Print Receivables Transactions"Hi Team, We have a requirement to add new parameter (Intercompany Invoice Template) for seeded ESS job Print Receivables Transactions. there is already template paramete…LakshmiSahithi 31 views 1 comment 2 points Most recent by Sairam Surampalli-Support-Oracle Receivables & Collections
-
Supplier bank country field in OTBI reportSummary: Supplier bank country field not found in "Supplier-Supplier Real Time" OTBI Subject area Content (please ensure you mask any confidential information): Version …Sharmava 41 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Supplier Management
-
Can we hide or disable the Hourly/Minute frequency while schedule BIP Reports?Summary: Can we hide or disable the Hourly/Minute frequency while schedule BIP Reports? We have identified users that have used the scheduling option to have reports run…
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 153 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we create a distribution list in Oracle fusion Bi publisher?I need to share a custom report with multiple users through the following steps: Schedule → Output → Destination Does anyone have any idea about configuring a distributi…
-
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 421 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 91 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 871 views 12 comments 1 point Most recent by User_FVSCP Reporting and Analytics for HCM
-
Incorrect Payables Invoice Approval Email TemplateHello, We're encountering a strange issue where (very rarely) a Payables invoice sent for approval triggers an email notification using a template that doesn't exist in …Willson Mach 31 views 4 comments 0 points Most recent by SanjayBasera Payables, Payments & Cash Management
-
query to get employees with missing bank accountswe want all new employees who didnt enter their bank account details
-
How to link AP Invoice directly to GL Module as it is not hitting subledgerSummary: Hi Team, How to link AP Invoice directly to GL Module as it is not hitting subledger Content (please ensure you mask any confidential information): Version (inc…Aditi Agrawal2650 31 views 3 comments 0 points Most recent by JimCC Subledger Accounting & Accounting Hub