BI Publisher
Discussion List
-
We have Multipul records in UI for each employee but we need only latest one that is top one?Summary: HI Team, We have Multipul records in UI for each employee but we need only latest one that is top one in below screen short? Could you please help me on . Thank…AjayKumar Maddipati 41 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi… -
Unable to use deep link to navigate to view journal page through OTBI.We want to use Deep links in our OTBI report for journals. By using that deep link we should be able to navigate to view journal page in the application. However we have…KanikaGupta 606 views 1 comment 1 point Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…Akbar Ahmed 92 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Can custom PL SQL TABLE type in Fusion DB be createdSummary: Need custom PL SQL TABLE type in Fusion DB to use in BI report with Data Set Type as Procedural Call Content (required): In Fusion BI Report some complex valida…
-
attachment in bursting not addingSummary: requirement is to add attachment using data model for custom report, in bursting section we have added email bursting and adding attachment but we are receiving…Rehber Hussain 102 views 5 comments 0 points Most recent by Rehber Hussain Reporting and Analytics for HCM
-
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 347 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 41 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 104 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. 198 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 513 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 855 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 746 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…