BI Publisher
Discussion List
-
Duplicated Job Definition not creating privilegeSummary: I am duplicating a delivered job definition and updating it to the custom report created. Based on documentation, it should create a privilege in order to grant… -
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
How can some Audit details be reported in Oracle Cloud HCM?Hi, I need some application security details that the client requires. For Example; User Login and logout Roles assigned to the user and their changes Password change in… -
Collection Note table?Summary: Collection Note table?! Content (please ensure you mask any confidential information): I am trying to find the table that stores the data for notes related to t…Robert of STAU 328 views 6 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
What are the calculations or processes inside &L_DEPRN_SUMMARY of Asset Register Report?Hello, We are investigating an unexpected behavior which cause an issue and some discrepancies in our reporting. We need to know what is the content of the lexical, &L_D…
-
SQL - GL Balances for IntercompanySummary: Can anyone help, I understand with subledger queries I can filter to accounting_class_code = 'INTER', is there any equivalent means of getting ONLY intercompany…Robert of STAU 41 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
What is SrcDescriptiveFlexField?We are using the standard Oracle data model TransactionDocumentExtractDm to review Payment files for XML and standard remittance template building but are not sure what …Cam Mistry 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
DELETE Data into HCM Fusion using parameterized BI Publisher ReportSummary: We want to delete time cards via parameter through flow pattern. QUERY: SELECT HTRG.TM REC GRP ID TIMERECORDGROUPID, substr(replace (HTRG.START_TIME, '-','/'), … -
How can i caculate in BI Publisher rtf templete the number of days between report day and Due date?Summary: Hello! Trying to create a report of Open Receivables Transaction. So i have the column of Due Date () and i'm running the report with parameter of As of Date ( …Yftach Paschur-Oracle 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections -
Oracle BI Publisher Errors with "Replacing Invalid junk char with inverted question mark"So, I am developing a BI Publisher report in Fusion Financials with an etext template to generate output in a flat file csv format. I have done this 30+ times at least a…Robert of STAU 43 views 3 comments 1 point Most recent by User_PZBRW Reporting and Analytics for ERP
-
I need to restrict record in the BIP report query using Lookup valueThere is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item num…Shahid Qureshi 21 views 5 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…User_2025-03-07-21-11-01-091 278 views 9 comments 2 points Most recent by Vasu Ramarathinam Reporting and Analytics for ERP
-
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 43 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is there a report that can fetch a list of all created Expense Policies?Summary: We need to be able to pull a report that can fetch us the list of expense policies in our system, that is required by our audit team. I tried looking in OTBI, b…
-
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ…
-
ADFDI Upload Error - Remote Server Returned an error (500). Internal Server Error.Summary: We are not able to import journals using ADFDI spreadsheet. Whenever the user creates a I/C transaction in spreadsheet and click save and submit button, then he…
-
invoice approval report with signatures of all approversHi, Business requirement is to create a payable invoice pdf template with signatures of all approvers. Currently we are having signatures on PO pdf output but only of la…Rahim Azam Butt 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How can I export list of delivered reports for fusion HCM?Summary: Where can I find list of core delivered reports for fusion HCM modules. Content (please ensure you mask any confidential information): Version (include the vers…
-
RTF template to enable the checkbox option in generated emailSummary: I have a requirement like need to send mail to Manager asking to wheather contract extension is planned or not with No and Yes checkbox. ? Content (please ensur… -
BIP Bursting output with CSV fileSummary: BIP Bursting output with CSV file Content (please ensure you mask any confidential information): I am trying to burst a CSV file to an FTP server and I am havin…
-
Automatic Report Printing PaymentsDear All, I have successfully customized two BI reports using my own data model and RTF template—one for cash payments and the other for check payments. I need to config…George Mattar 1 view 1 comment 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management
-
Fast Formula doesn't return expected valueSummary: Content (please ensure you mask any confidential information): Hello, we built the following FF where we should retrieve value from two different value sets. If…Valerio Curzi 21 views 3 comments 0 points Most recent by A_R-Oracle Reporting and Analytics for HCM -
trigger a Oracle HCM Cloud BIP report based on an onlineSummary: There is a requirement in our project that once a certain transaction is submitted in the system (Newly created candidates' security verification custom field o…
-
Reporting Strategy/ApproachSummary: We have a client who is moving from a legacy application to Oracle Fusion ERP. What I'd like to get some expert advice if how the reporting was handled in a gre…
-
concatenate data elements with line break in BI excel templateSummary: It is concatenating with supp_name,supp_name2,supp_name3 columns separated by ',' . In my case comma "," also displaying for null cases. Hence i am trying to d…
-
Getting the data in un-structured formate in excel file while extracting the dataSummary: Hi Team, We are trying to export the data for IBY_SYS_PMT_PROFILES_VL in excel format and we are getting in un-structured formate. Means some rows data are not …
-
What is the SQL Query to fetch Asset Cost Center Code and Asset Cost Natural Account?Summary: SQL Query to fetch Depreciation method, Asset Cost Center Code, Asset Cost Natural Account and Depreciation Expense Account Content (please ensure you mask any …Uma Scherer 535 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP