BI Publisher
Discussion List
-
Need to know Tables to retrieve time card details like hours entered, time attribute detailsSummary Need to know Tables to retrieve time card details like hours entered, time attribute detailsContent I am trying to report time entries and other details like cor…User_2025-02-11-15-16-39-434 668 views 1 comment 0 points Most recent by User_UUX20 Reporting and Analytics for HCM -
AP- NACHA PPD/CCD ACH Balance fileContent The client's bank requires a balanced NACHA file that includes an offset debit with the bank account and transaction code 627. What is the best way to add this l…User_2025-02-06-22-16-28-372 145 views 2 comments 2 points Most recent by Divya Sidhaiyan Payables, Payments & Cash Management
-
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra…Dhruvjoshi23 67 views 11 comments 2 points Most recent by Dom Galano Reporting and Analytics for ERP -
How can i get DFF field in the Formula based Depreciation Methods?Summary How can i get DFF field in the Formula based Depreciation Methods?Content Hi Experts, I am trying to derive the depreciation rate based on the Descriptive Flexfi…User_2025-02-06-12-01-21-534 51 views 2 comments 0 points Most recent by Saipriya Vaidyanaathan-Oracle Assets
-
Can we create replica of changes only extract using BIP reportSummary Can we able to create a replica of changes only Extract using BIP Report. If Yes can you please guide me how we can proceed with this kind of requirements.Conten…Ashish Mangal 210 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
R13-SQL Supplier informationSummary R13-SQL Supplier informationContent Hello : I was wondering if you can share with me any SQL to get the Supplier information. I have the following one but it is …gabriel kinovisques-163562 46 views 3 comments 2 points Most recent by gabriel kinovisques-163562 Payables, Payments & Cash Management
-
Joining iby_ext_bank_accounts_ audit table with the person recordSummary Joining iby_ext_bank_accounts_ audit table with the person recordContent Hi All, I am trying to create the audit report for the Bank Account Changes and want to …Dharmendra Jha 58 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
How to remove Extra blank lines in Excel output from BI Publisher RTF templateSummary How to remove Extra blank lines in Excel output from BI Publisher RTF templateContent Hi Experts, How to remove Extra blank lines in Excel output from BI Publish…Bala Kasineedi 99 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
Influencing the SQL Optimizer in SaaS ERP ApplicationsSummary We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.Conte…
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Precedence of security roles for custom BIP reportsContent If we have 2 roles attached to the BIP report, one of them should have Read, Traverse access and another one should not have access what would be the precedence …Prajna Hegde 40 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to read Context Segment DFF and associate it to employee record?Summary How to read Context Segment DFF and associate it to employee record?Content Hello, I have information stored in the assignment attribute 2 of the PER_ASG_DF DFF …Nicola Petri 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict…Madhu Chalamalasetty 191 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 94 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…User_2025-01-30-20-59-13-989 63 views 2 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for ERP
-
Impact of creating a Customer specific custom folder in parallel to seeded Shared/Custom folder inSummary what are the impact of creating new folder parallel to seeded Shared/Custom folderContent Hi Team, Do you see any impact, if we create a new custom folder direct…Alok Suraj-Oracle 22 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…Warren Murray 63 views 3 comments 2 points Most recent by Warren Murray Reporting and Analytics for ERP
-
Query underlying UCM tableSummary Query underlying UCM tableContent Is there an available table or view that gives access to the UCM? I don't care about the actual attachment and the contents wit…
-
Parameterized Bi Report Within A Dashboard Is Not WorkingContent Hi Team, Greetings of the day!! I have created a dashboard with BI Report having one parameter. The report is working as expected with the same parameter but in …Divya Kollipara 40 views 4 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 32 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 Reporting and Analytics for ERP
-
report of all data access set access given to usersSummary Can we get a report of all data access set access given to users, along with current access and history of terminated accessContent Can we get a report of all da…User_C3J94 45 views 2 comments 1 point Most recent by User_C3J94 Payables, Payments & Cash Management
-
Course File Path ReportSummary Need to identify the file path of all SCORM and AICC courses in Taleo Learn.Content We are transitioning content and need to identify the file path for each of t…