BI Publisher
Discussion List
-
How to Embed BIP report with parameter onto person search screen in Oracle HCM cloudSummary: Embeded BIP report with person number parameter using page composer onto Employment Info screen into oracle HCM cloud. How do I pass searched person number to r…Eknath 691 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Field for Action Keyed Date?Summary: What is the field in Oracle BIP Reporting for the date an Action is keyed? Content (required): Hello, What is the field that shows when an action is keyed in th…
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …ShailenS 101 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
how to viewing oracle saas BIP report history based on job id parameterHi Team, When we select the Schedule and submit the BIP report (after entering the job name) from catalog section , Currently the History the Report has Job name , owner…User_2025-07-18-07-26-59-885 346 views 4 comments 0 points Most recent by User_2025-07-18-07-26-59-885 Reporting and Analytics for ERP
-
Secure Reporting on Person Special Category DataSummary: In 23B we see there is a new feature to secure reporting on Ethnicity, below is the detail. We also require this capability for other sensitive categories such … -
Is there any subject area to get the Module to which each object belongs toSummary: What is the equivalent Subject Area for this table - adf_extensible_table_usage Content (required): 'adf_extensible_table_usage' has a column - 'Application_nam…Venkateswari 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 51 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Report Sharing: Contracts Conversion Reconciliation ReportSummary A Custom BIP Report for Contracts Conversion Reconciliation / Audit PurposeContent Business Use Case: While importing Enterprise contracts especially multiple it… -
Deleted QuestionDeleted questionSurbhiPapreja 42 views 2 comments 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to generate UETR value in Swift ISO 20022Summary: We are working on the implementing the new SWIFT ISO 20022. We see in the documentation that the UETR is mandatory. But the sample template provided by Oracle d…Karishma Mungara-Oracle 1K views 3 comments 1 point Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…User_2025-02-05-22-44-35-842 103 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 71 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Insufficient Privileges fa_fusion_soainfra.wftaskmetadataSummary Insufficient Privileges for running fa_fusion_soainfra.wftaskmetadataContent Hi All, Trying to run a query given on Fusion Global HR: Approvals Delegated To Othe…Meet Bhavsar. 195 views 4 comments 2 points Most recent by Ashok Sriniva-Oracle Reporting and Analytics for HCM -
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
Table gl_je_batches not up to date in BIP?Hi Guys I have an issue today when accessing table gl_je_batches via BIP, I am not seeing the very latest batches in there which I know have been created because I can s…
-
Identify customer from ar_statement_deliverySummary: How to identify the customer from the ar_statement_delivery table Content (required): I have written a sql in order to identify the customer_name, account_numbe…
-
Query for unearned revenue in oracle fusion from RA_CUST_TRX_LINE_GL_DIST_ALL tableSummary: we have Oracle fusion cloud services and we need to develop a report for unearned revenue how Can I identify the unearned revenue from RA_CUST_TRX_LINE_GL_DIST_…Shameer Muhammed P M 512 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 859 views 3 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
How to prevent payment amount replication on Payment Details Report-multiple invoices incl in pymtSummary: Payment Details Report is duplicating Payment Amount when more than 1 invoice was included in payment. Is there a way to prevent this from happening? Or add a c…
-
Need a sample SQL Data model using DFF and EFF Flex FieldsSummary Need a sample SQL Data model using DFF and EFF Flex FieldsContent We have several EFF and DFF fields were created in Oracle HCM. Can someone share a sample data …Prabhu Krishnamoorthy 764 views 5 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Connect to HCM Database through MiddlewareSummary: Just curious if I can connect to the HCM database through anything other than the cloud url Content (required): Hello, I am creating an integration using middle…
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available…
-
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is …
-
Creating Asset Cost Summary Report in OTBISummary: Creating Asset Cost Summary Report in OTBI Content (required): I created "Asset Cost Summary Report" in OTBI, however, I am not getting back the balances as the…
-
Standard Oracle depreciation report.Summary: Hi All, Thank you in advance for your help and time. I am just wondering if there is a standard Depreciation report that we can use in the Asset module (Oracle …
-
DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBISummary DRILL DOWN TO EXPENSE REPORTS AND EXPENSE ITEMS FROM OTBIContent Do we have a deep link which we will use in OTBI Report, this is new feature in 20C https://www.…
-
Fetch large volume of data in BI publisher reportSummary Fetch large volume of data in BI publisher reportContent HI We have a requirement to extract data for GL code combinations using BI publisher and burst the outpu…ashishgupta0212 718 views 10 comments 2 points Most recent by Alok K Gupta Reporting and Analytics for ERP