BI Publisher
Discussion List
-
Fixed value in Value set querySummary Fixed value in Value set queryContent we have defined the value set and validation type is Table we have written condition to pick email ID from PER_EMAIL_ADDRES…Sandeep Nihalani 60 views 2 comments 2 points Most recent by Sandeep Nihalani Reporting and Analytics for ERP -
BIP Schedule Skip or Resume after Oracle DowntimeSummary BIP Schedule Skip or Resume after Oracle DowntimeContent Hello, Whenever Oracle SaaS is down due to patching or release upgrades, does it pause all the BIP Sched…Vinay Gharge 40 views 0 comments 2 points Most recent by Vinay Gharge Reporting and Analytics for ERP -
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…Hannah Dorman 31 views 5 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
BI Standard report not fetching all course information While Report builder report doesSummary I have to fetch users completed the courseContent I have to fetch users completed the course along with category mapped to course. I tried exorting data from BI … -
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying … -
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 648 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 208 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 59 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 91 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 192 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