BI Publisher
Discussion List
-
Missing folder in BI Catalog under Custom/Human Capital Management - Reports and AnalyticsHi Team, One of the folder "Talent Management" is missing under /Shared/Custom/Human Capital Management/ and we could not replicate what happened to the folder and when?… -
Alignment issue in Absence Approval Seeded notificationSummary: Let me explain theissue clearly how the notification is been triggered in Responsive UI andRedwood in over mail and in bell notification.Responsive UI level the… -
What is the role or data access that allows to visualize the Subject Area.?Summary: What is the role or data access that allows to visualize the Subject Area. When I need to search, it is empty. Please your help Thanks Content (please ensure yo… -
SQL Query to Link Maintenance Work Order Asset to Fixed AssetDear all, Could anyone please share the SQL query to link the maintenance work order asset to the fixed asset? Thanks and best regards, George Mattar -
How to use ZX_REP_PAYABLES_EXTRACT.cf_taxable_amtformulaSummary: Hello Oracle Support, We are trying to use the oracle seeded package functions. ZX_REP_PAYABLES_EXTRACT.cf_taxable_amtformula. ZX_REP_PAYABLES_EXTRACT.cf_taxabl… -
Need to check the default parameter logic for the Supplier Balance Aging Report.Summary: Hi Oracle Community , I need to check the default parameter logic for the Supplier Balance Aging Report, When I submit the report with ledger, business unit and…User_J7ULB 41 views 3 comments 0 points Most recent by ERP.HCM1 Payables, Payments & Cash Management -
Standard VS Custom ReportsSummary: Hi Everyone, Content (please ensure you mask any confidential information): How to check if reports are standard reports vs custom report? I need a table that s…Srushti Dhote 33 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report on Auto-Provisioned RolesSummary: We are looking for a way to report on which of our security roles are auto-provisioned vs. manually provisioned. Does anyone know of a subject area that has thi…Karlie Backman 162 views 7 comments 1 point Most recent by Felix_fei Reporting and Analytics for HCM -
Custom bursting report failing sporadicallySummary: We have a scheduled process named Job Offer Notification that runs every 30 minutes to notify Compensation. While most runs complete successfully, we are notici… -
How to get all attribute in one nodeSummary: Hi Experts, I need your assistance. I'm currently working on XSL files to get values in the XML files. I want to show all the attributes separately in one node.… -
BIP - Change Content Type in Content Server Data SetHi, Is it possible to change the "Content Type" from a content server data set in a data model in order to read PDF / Docx content. Thanks! GuillaumeGuillaume SAVALL 11 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How to Generate a Dynamic template based on the assigned Business UnitSummary: Hi Experts, I am seeking assistance regarding a specific requirement from our client. The client has expressed a need to create a document that is customized ac… -
Job History of BIP Reports/Flow History of HCM ExtractsSummary: Hi, We have a few questions on the Job History of BIP Reports/Flow History of HCM Extracts; as I could not find any document for this information: 1.) How many …User_2025-02-11-23-20-16-609 101 views 4 comments 0 points Most recent by Akash Katiyar-Oracle HCM Extract -
BIP SFTP Bursting vs BIP SOAP API calloutSummary: Advantages of BIP API download option (for data reports) Vs BIP report sent to SFTP channel Content (please ensure you mask any confidential information): We us…Abdullah Munaz 51 views 2 comments 0 points Most recent by Akash Katiyar-Oracle Reporting and Analytics for ERP -
Query to get the Subledger Application name, Process category names and idsSummary: Can you help me with query to get the SLA name, Process category name and their IDs that can be passed to Create Accounting job? Content (please ensure you mask…Vishal_K 288 views 2 comments 0 points Most recent by Hitha Harikumar Subledger Accounting & Accounting Hub -
Report showing Employee Hierarchy in an OrganizationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ramesh Kumar.S-Oracle 2 views 0 comments 0 points Most recent by Ramesh Kumar.S-Oracle Reporting and Analytics for HCM -
was trying to fetch the date format as 01-Jan-2025 in bip getting an errorHey i have a requirement in the bip where the date format is 01-Jan-2025 and in the SQL of bip i have used the format like TO_CHAR(ele.EFFECTIVE_END_DATE,'DD-Mon-YYYY') …Kande Likhitha 45 views 4 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM -
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Query to get Item Class Change HistoryHi, Recently, some items in OC PLM had their class names changed, and I need to write a query to retrieve both the old item class name and the new item class name. I att…Ramsha Zameer 54 views 4 comments 0 points Most recent by Shamsul_Wzd Reporting and Analytics for SCM -
How to Customize Withholding Tax Letter (Payables and the one for Italy) and usage of je_it_wht_letSummary: We need to have a fully customized version of Withholding Tax Letter for Italy. We need it as fully customized because reqiorements want the parameters from Pay… -
Reverse the BIP Analytics Folder OwnershipHello IS there a way/process to reverse the folder ownership that was set to specific Folders. Say User A created the folder and User A was the Owner of the folder. Now,… -
Display Formatted Job Description Details on OTBI or BIP ReportSummary: Display Formatted Job Description Details on OTBI or BIP Report Content (required): We are trying to display Formatted Job Description Details onto an OTBI repo… -
What table stores reports that have hdl templates and hsdlSummary: I want to list all BIP reports that have HDL templates and list all HSDL templates. Is there a table backend that I can use or subject area that can pull this i… -
Table Names/ SQL Query to fetch the data for Other compensation from Manage OfferHello All, Someone please help on how to know the table for other compensation which can be found from MyClientGroups> Quick Actions> Manage Job Offer Please see below S…Joliver Caangay 121 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get the specialization linked with courses?Hi All, I am working on getting all courses details report and trying to get one of the column in my report Part of Specialization but i am unable to get the link betwee… -
Is there a way to filter the result of OTBI Report?Summary: I am creating Asset OTBI Report to capture the assets that registered with past dates since there is no standard report is available. I have created OTBI below …Karen Ito-Oracle 2 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets