BI Publisher
Discussion List
-
How to restrict All subject area Access from Line manager roleSummary: We wanted remove all subject area analysis from line manager role. We are able to remove some subject are by deleting the transaction analysis privileges . Rest…Aditya Jena 111 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to pass 10K records in IN clauseHi, I would like to pull journal information for 10K batches. I have 10K journal batches in the csv file and need to pull journal information(creation date, category, et… -
I'm new to E-text template, how can I learn and How can we develop in Bi reportsSummary: Hi Team, I'm new to E-text template,how can I learn and How can we develop in Bi reports. Any suggestions . Thanks, Ajay Content (required): Version (include th…AjayKumar Maddipati 41 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How long are the report jobs and outputs retained on the server?Summary: How long are the BIP Report Jobs and output files are retained on the server? Content (required): N/A Version (include the version you are using, if applicable)… -
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 12 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
how can start and learn oracle extracts in hcm ?Summary: Hi Team, Please help and Guide me on to learn Extracts. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): Code Snippe…
-
OTL Approval workflow data - Current manager for approval, Submitted by, SubmissionSummary: Does anyone have an SQL for OTL Approval workflow data - Current manager for approval, Submitted by, Submission? Content (required): I am looking to develop a B…Neena S 31 views 2 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…User_2025-02-07-07-19-13-925 143 views 3 comments 0 points Most recent by Pietro Papaioannu Payables, Payments & Cash Management -
Need to attached FF:Summary: Hi Team, We have a requirement in Oracle cloud recruitment where we need to attach FF for only US and Polad country. could someone help me to get this FF. Will …
-
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Create an analysis report to see the workflow for a specific Job RequisitionSummary: Create an analysis report to see all job requisition workflow Content (required): Does anyone know how to create an analysis to see all workflow for a specific …
-
Table that holds ESS Job Display nameSummary: Hi We are trying to create a bip to fetch ESS job details. we looked into ess tables for display name but looks like they store only short name. fusion_ora_ess.…Susmitha R 2.4K views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Parameter's label in two different languages.We have a requirement to display the parameter's label as per the language who logs in. The actual requirement is to display the label as per the users who logs in . If …
-
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
How to query return transaction id from AP invoice tables?Summary: How to query return transaction id from AP invoice tables? Content (required): We have the requirement to get return transaction id of debit memo. But the AP in…Lucy.liu 521 views 1 comment 0 points Most recent by Cesar Tepetla Corte Payables, Payments & Cash Management -
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 78 views 4 comments 0 points Most recent by David Pham-Oracle Reporting and Analytics for HCM -
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver…Abhilash K - Deloitte USI 31 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 946 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …
-
Table details for Setup: Payment process ProfileSummary: Table details for Setup: Payment process Profile Content (required): We need table details, which stores Default Payment Document for Payment Process Profile Cr…Nishanth B Jain 72 views 5 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
requirement to restrict the parameter display for BIP report.Summary: For an e.g for role ABC logged in user we want to display one parameter and the user with role XYZ we don't want to display the parameter. Is it possible to ach…Sayali Pawar-Oracle 41 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Is it feasible to restrict the folders using custom roles in reports and analyticsHi Team, I have the requirement that only a few sets of employees will be able to see some folders on the reports and analytics page. Ex: our requirement is only custom …Haritha 41 views 3 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 226 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for khajakistan (KZT)Summary: IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS is not working for only khajakistan (KZT) Example: select IBY_AMOUNT_IN_WORDS.GET_AMOUNT_IN_WORDS ('123.45','INR') from …SireeshaJaladi 434 views 9 comments 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Track IP AddressContent Hi All, Is there any way to track IP Address of the user who has made changes and accessing fusion system? Thanks, Visu
-
EEO - Recruiting ReportSummary: Hello, I am hoping our community can share an HCM BI Publisher report that lists all applicant data for requisitions that had a hire within the past year. It mu…
-
White paper to load an HDL through BIP reportSummary: Please let me know if there is a white paper indicating the configuration for creating an HDL file and further load it through HDL through a payroll flow. I am …
-
Is there a delivered report on percentage of candidates that turn down offers for specific positionsSummary: Job offer rejection rate for fiscal year. Content (required): I have a report request for % of candidates that turn down job offers for specific positions. If a…
-
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM