BI Publisher
Discussion List
-
OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Summary OTBI Agents and BI publisher scheduling us there a Report displaying the active scheduling ?Content Hello , We would like to have a list of the existing active a…Revital Mefano 42 views 12 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
MT940 Bank Statement ImportContent Team, We have been trying to setup MT940 Bank Statement import to our company, however we have faced with multiple issues in the process and haven't been success…Rihan Jameel 290 views 5 comments 2 points Most recent by Rihan Jameel Payables, Payments & Cash Management -
BI Report - Need to display Date Time in User TimeZone in excel template - But always displaying UTCSummary Trying to display Report Run Time in User TimeZone, but unable to do itContent The requirement is to display the Date and Time in user Timezone. I came across fe…Rajesh Ravikumar 41 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
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 693 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 47 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 105 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 195 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP