BI Publisher
Discussion List
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 33 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Hi All can anyone help me to print these columns item and description in my transaction report.Summary: Please help me to print these columns in my transaction detail report please provide sql or tables where i can find these columns data. These are present under …
-
Any OTBI Report/table to get Multiperiod Accounting Transactions AHCSDo we have any tables or oracle Reports BI or OTBI to get the list of Multiperiod transactions posted and future transactions other than table XLA_MPA_DISTRIBUTIONS.Chetan007 1 view 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 31 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
The extract chunking task does not generate the default XML(at least parameter data) file.Hi Team, We observed that when there is no data to chunk, the extract chunking task completes successfully after 25C; however, it does not generate the default XML file …
-
BI Publisher Run report Rest API Call Unsuccessful.Summary Trying to access the Run Report Rest API for BI Publisher but without success.Content Hi there, I'm trying to run a POST request against the RunReport task withi…User_2025-02-05-10-38-08-223 180 views 6 comments 0 points Most recent by Babu Chalamalasetti Reporting and Analytics for ERP -
Trying to add new custom font in BIP getting errorSummary: I am Trying to add new custom font in BIP getting below error. Path : Admisnstartion→Runtime Configuration→Font Mapping When i click on Font mapping then gettin…Basavaraj Navalagi 71 views 6 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Looking for a way to limit/disable the use of the refresh button on the BIPublisher rep executionMy client has a report that runs based on a date range. However, after running the report, when they immediately click the Refresh button, it triggers the data extractio…Oscar Chahestian-Oracle 1 view 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting & Analytics for Sales
-
We need show Invoice Distribution COA Account segment values on AP CheckSummary: We need to show Invoice Distribution COA Account segment values on AP Check in Fusion Cloud Accounts Payable. These fields are not available in XML. I cannot ad…Ibrahim Konak 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to viiew Package - gl_flexfields_pkg.get_description_sqlHi, I was able to fetch the description based on the package /* select gl_flexfields_pkg.get_description_sql(23,23,7) from dual*/. However; I would like to see the entir…
-
segregation of dutiesIs there a report for segregation of duties for Finance?
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 31 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to Add Custom Email Body Text for Separate Remittance Advice Email (with PDF) in OracleHi All, In Oracle Fusion Payables, I need to send a Separate Remittance Advice by email with a PDF attachment and have a specific message appear in the email body. The m…Mukesh Sirigiri 181 views 3 comments 0 points Most recent by Mukesh Sirigiri Payables, Payments & Cash Management
-
unable to query the rejected transaction details from the approval related tablesSummary: We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fusion_soa…
-
Is there any base table for privilege master along with table to map privilege table with roles?Summary: Hello experts, We are trying to create a BIP query to map the user to role and role to privilege. Previously we were using the "ASE" tables for this purpose, bu…
-
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…Rama Krishna_Annam 11 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
Possibility to track via BI Publisher, the course start date and end date for each accessSummary: Possibility to track via BI Publisher, the course start date and end date for each access Content (please ensure you mask any confidential information): Hi, we …
-
How to use 'Ignore Participant' under the THEN option in the BPM Rules for Invoice Approvals?Summary: We are trying to use 'Ignore Participant' asunder the THEN option for one of the AP Invoice routing rules in the BPM but getting an error ' RUL-05730 : type "LI…AkashAgarwal 1.6K views 4 comments 0 points Most recent by RenganathanVenkatesan Payables, Payments & Cash Management
-
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
HCM Extract and BI Publisher - GC overhead limit exceededTeam, We have a HCM Extract which is invoking the BI Publisher to generate PDF output. But we are getting an error and HCM Extract is not generating any PDF output. Erro…
-
Add an Email Body to Separate Remittance Advice Emails with attached PDF by using BI ?Summary: Since there's still no Email Body feature available when using Separate Remittance Advice Emails with attached PDF -but- is it maybe possible to add an Email Bo…Marcus S. 48 views 3 comments 0 points Most recent by Sankalp Gupta Payables, Payments & Cash Management -
Query to Derive Budget information for a purchase orderSummary: Looking for a query to derive Budget information(below highlighted columns) for a purchase order from the below screen,i.e Budget Account ,Budget Period and con…Ripendra Kumar-Oracle 721 views 3 comments 0 points Most recent by Mirza_Adeel Reporting and Analytics for SCM
-
BI Report access issueSummary: Hi, One of the users is unable to access the BI report. When he tries to access it, he getting the error shown below. But, he is able to access the report from …DHILNA P 2 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
if else condition in rtf template is not workingi tried using these conditions in rtf but its not workingminati_behera-Oracle 801 views 4 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM
-
The report displays two completion statuses for some learners, while the course shows only one.Summary: The report displays two completion statuses for some learners, while the course shows only one. Does anyone have the same issue and what is the resolution for t…
-
SLA - Request For Table-Column Details for Subledger Journal Reversal LinkageSummary: SLA - Request For Table-Column Details for Subledger Journal Reversal Linkage Content (please ensure you mask any confidential information): Version (include th…Sridhar Gupta Yerram-Oracle 1 view 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Subledger Accounting & Accounting Hub
-
po number join with budget tableDear , I have a PO number that has failed, and I need to check the available funds for it in the budget table. I need to join this PO number with the table shown in the …