BI Publisher
Discussion List
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require… -
Filter that will capture future date assignmentsSummary I created a report that is capturing Action Type: Terminate Work Relationship.I need to filter the report to only show scheduled terminations for a specific mont…User_2025-01-25-00-37-41-739 69 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
People review meeting How to identify the Metting submitted by HR or manager, Whic table we can see?Summary: i have created one people review meeting. i have added 2 employees' population and 2 reviewers' manager. i have logged in as 1 manager and submitted the meeting…challa praveen 21 views 0 comments 0 points Started by challa praveen Reporting and Analytics for HCM
-
Capture the Course and Offering StatusSummary: I need to capture course status and offering status. I have a requirement where I need to capture course status and offering status of the relevant course. Cont…Sanduni Pathirathne 11 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Need a query which show all pending transactionSummary: Hi Everyone, I need a query in which we can show all pending, stuck transactions along with the person's name and approvers' information. Like, the document pro…
-
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 61 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Include project details AP Payment CheckSummary: In 'Disbursement Payment File Formats' oracle Seeded XML file I did not see AP invoice project details, if invoice is mapped to any project details. How to map …Narendra Prasad Golla 21 views 1 comment 0 points Most recent by Narendra Prasad Golla Payables, Payments & Cash Management
-
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 363 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
Still we implemented Query level RTF templates, how can we implement in RTF level changesSummary: HI Team, Still we implemented Query level RTF templates, how can we implement in RTF level changes as per requirements . Any on help me on to learn RTF level . …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Join subject areas Human Capital Management and RecruitingSummary: How can I join the two subject areas below? Human Capital Management - Transaction Administration Real Time AND Recruiting - Recruiting Real-time Content (requi…
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 291 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
RTF Template with Excel Template AlignmentWhat would be the best way to get the good alignment when using RTF and output is Excel. We have more number of columns ...Example see the date of birth. The same way it…
-
Find and Replace PROD path reference in extractsSummary: Find and Replace PROD path reference in extracts Content (required): Hi Team, Greetings! We have multiple extracts with reference to Production path on SFTP or …
-
Enable Audit Log/System PerformanceHello All, We are interested to enable the Audit log files in Production and we want to know that what is the impact on system performance audit log is enabled once. We…Linga Murthy 41 views 1 comment 0 points Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP
-
Embed BIP report in the Application UI pagesSummary Embed BIP report in the Application UI pagesContent Hi, OTBI Report can be embedded in the UI using page composer. But can we achieve the same for BIP report? I …Manoj.Gupta 603 views 10 comments 8 points Most recent by Sai Revanth-Oracle Reporting and Analytics for HCM -
Master data historySummary: Looking for an Audit query, which shows old and new values of master data. Content Hi I am looking for a query to track changes in Master data (Position, Locati…
-
EXM Table that includes the TokenSummary: Does anyone know of an EXM table that includes the Token? Content (required): The bank I am working with sent some rows where the Card Holder Details are comple… -
Error Message from RTF Template - Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001Content Hi Please can someone assist witht the below error: Report Errors with oracle.xdo11g.xqxp.XQException: FORG0001 This error is recvieved when running custom templ…User_2025-01-30-20-23-15-920 415 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 357 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Added new delivery options at Element Result Report but output is not available once we runSummary: Added new delivery options at Element Result Report but output is not available once we execute Run Element Result Register flow Content (required): Added new d…
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 111 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
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…