BI Publisher
Discussion List
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 18 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
How dependent parameter works in OTBI Report, BI Report and DashboardSummary How dependent parameter works in OTBI Report, BI Report and DashboardContent Hi Experts, Can someone explain how the following thing works in OTBI Report, Dashbo… -
'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human CaSummary 'Create' Icon is missing from 'Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications'taskContent Hi Team…Rohit Kumar Singh 29 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 188 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
SQL - Job Table historySummary We want to pull all rows from the job code table and have the following SQL. The query pulls several rows for the same effective start date. Any suggestions? Tha…Mike Borghoff 46 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Please share SQL to return only employee person type whose termination approvals has been acceptedSummary Please share SQL to return only employee person type whose termination approvals has been acceptedContent Hi All, Please share SQL to return only employee person… -
Outer join queriesSummary Outer join within same subject areaContent Hi, I am using "Marketing - CRM Leads" SA to create report on leads. this return only those customer who have leads th…azodpe 28 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
SQL on Offering details in Learning moduleSummary SQL on Offering details in Learning moduleContent Hi Experts, I have a sql query to get course and offering details. But there is a difference between offering s… -
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 366 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Post report Completion event for External SystemsSummary Post report Completion event for External SystemsContent Hi, There is a scenario wherein client needs an event once the report is completed successfully, an even…Kaushal Gathani 19 views 2 comments 1 point Most recent by User_3EZDP Reporting and Analytics for ERP
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to filter BI Report PARAMETER for COA Segment Values based on the security rules defined …Vinay Gharge 34 views 0 comments 1 point Most recent by Vinay Gharge Reporting and Analytics for ERP -
Query to find amount and accounting date on AR ReceiptContent Hi Team, I thought AR_PAYMENT_SCHEDULES_ALL table holds accounting date , and amounts present on Receipt Page. However I could see few receipts who have values i…Nidhi Chhajed 2.5K views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Receivables & Collections
-
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
commonly used HCM tables in fusionContent Hi, Any body has commonly used HCM tables in fusion, Please let me know. Regards, ReddykrishnaReddykrishna Chidella-Oracle 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…GauravGupta39 22 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
NEW HIRE(FAST,PRESENT,FUTURE DATED EMPLOYEES) ANNOUNCEMENTSummary Developed BIP Report on ORACLE FUSION HCM we are getting data for current hire employees only, Unable to get future dated employeesContent Hi ALL, I have develop…
-
Is there a way to track which all analytics/Reports are run by users and via which device (Laptop VsContent Hi Everyone, Is there a way to track which all analytics/Reports are run by users and via which device (Laptop Vs Mobile phones) Please let me know if you have a…Reddykrishna Chidella-Oracle 43 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Create a report that shows the actual date when the assignment status changed with the Action ReasonSummary Actual date and reason when an assignment status changesContent Hi All, I hope someone is able to help me with a SQL that I am trying to build. I have several re…User_2025-02-04-08-51-08-912 273 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Payroll Pay Affecting changes reportSummary Payroll Pay Affecting changes reportContent Hello, I am in process of creating the Payroll Pay affecting changes report and wanted to know if any one has come ac…Dharmendra Jha 46 views 2 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM
-
Journal Issue - "No sequence version is enabled or defined for sequence **** XX GL Accounting SequencContent Hi Guys I would just like to inquire if anyone of you have encountered this kind of error for created journals? Please kindly refer below "No sequence version is…User_2025-02-11-12-30-38-982 340 views 1 comment 1 point Most recent by Kallol Sinha General Ledger & Intercompany
-
Denormalized view for workersContent Hello everyone! Do we have any inbuilt view in HCM which will provide a denormalized record per employee with basic fields like name, emplid, department, jobocde…Arathi Devi H 12 views 3 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
Required User Entity (HCM Extract) for StateSummary User Entity (HCM Extract) for US StateContent Hi All, Please provide user entity details in HCM extract for pulling the details of US state. Thanks -
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHESummary How to replace DATA_CACHE columns in 21B with XML_DATa_CACHEContent Hello, Can anyone help me replace DATA_CACHE columns in 21B with XML_DATa_CACHE, in BI report…Varkey George-Oracle 51 views 4 comments 0 points Most recent by VibhaSorte Reporting and Analytics for HCM
-
Oracle ERP > Procurement> Self Service Receipts tables to query for a reportSummary Self Service Receipts tables to query for a reportContent Hello Community, I am new to the topic, and I am trying to generate a report on Oracle Fusion ERP based…Robinson Antunez 49 views 3 comments 0 points Most recent by Robinson Antunez Reporting and Analytics for ERP
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 48 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM
-
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 1K views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
BIP Report Bursting for L1 and L2 ManagersSummary BIP Bursting Report for L1 and L2 ManagersContent Hi Team, I am using a single Data Model and 3 Templates(for 3 different Jobs ). I am using two columns to pull …Anjan Polimera 30 views 2 comments 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales