BI Publisher
Discussion List
-
OBJECT_ID stores the Period of Service ID instead of the Assignment ID for PER_ALL_ASSIGNMENTS_M ?Usually, for transactions related to the Assignment page: •Object Name → PER_ALL_ASSIGNMENTS_M • Object ID → Employee Assignment ID However, in one particular case invol…Ashish_Goyal_MPC 71 views 8 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
SQL Query to extract all details related to data roles and security profiles designedSummary: Need an SQL query for creating a data model and subsequent BIP report, to extract the details of all the data roles and also the security profiles like Person, …Gurvinder Singh Gill 259 views 4 comments 2 points Most recent by mgoswami Reporting and Analytics for ERP
-
AGIS tables PVO's doesnot existsSummary: Hi Team, The below AGIS tables PVO's does not exists in BICC. Can you please advice to me. FUN_BAL_INTER_RULES FUN_BAL_INTER_ACCOUNTS_ADDL Thanks Content (pleas…Siva Kumar Bondalapati 15 views 0 comments 0 points Started by Siva Kumar Bondalapati Reporting and Analytics for ERP
-
Is there a scheduled process (or other way) that we can update a payment type change to flow throughOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): MTB Description (Required): Is there …Ajay Kumar Kotha 15 views 3 comments 1 point Most recent by Ajay Kumar Kotha Payables, Payments & Cash Management
-
Regarding Extract DBI of work-schedule asisgnment when assigned at Enterprise levelSummary: Hi Folks, When I assigned work schedule at assignment level then I got the value in HCM extract of WS and the Pattern as well but if i remove the assnment level…
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 1 view 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
How to remove View Invoice Button in Payable Invoice Approval Notification Based on User PrivilegeSummary: Hi Team, I have a requirement to dynamically show : View Invoice button - based on the user privilege. Is it possible to write a logic to display the button dyn…Sridhar Gupta Yerram-Oracle 12 views 3 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 3 comments 0 points Most recent by Sidhartha Wadhwa Reporting and Analytics for HCM
-
Hi Experts, I have a requirement in Oracle Fusion ExpensesRequirement: I need to display an informational note dynamically on the page only when the below conditions are met: Vehicle Category = Cars and Vans Vehicle Type = Elec…
-
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
This is the HDL I have loaded and getting errorSummary: Getting issue while loading this HDL for Withdrawing learning assignments.…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.4K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP
-
Disbursement Payment File Format - ChecksSummary: We are trying to add new business units for this file. The Supplier name is normally spaced out in the rtf but it returns normal once there is an output. Howeve…
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRANSFERS TO COST MANAGEMENT SCHEDULE RUNSSummary: Hi Content (required): Currently, my team is testing the 21D release update. The aforementioned feature (AUTOMATICALLY INCREMENT THE DATE PARAMETER FOR COST TRA…Sheneli98 227 views 4 comments 0 points Most recent by Neha_Singh Payables, Payments & Cash Management
-
Is data contained in a report created/ scheduled in BI Publisher automatically encrypted ?We are looking to improve the way data is extracted from Oracle Fusion and delivered to internal customers. Using BI Publisher reporting, it is not clear or visible if t…
-
Scheduled agent is failedHi Experts, I’m hoping someone can assist me here. We have several agents scheduled that were running successfully. However, one of the scheduled agents has suddenly sto…Angela Nietes 60 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Does anyone know how to prevent BI Folder being accidently moved?Summary: Any strategy to prevent the BI folder structure from being accidently manipulated. When a folder is accidently moved, the reports that use a BI Publisher data m…
-
value set values exportSummary: Hi Team, We have defined a Asset key flexfield and would be loading 100 values on a daily basis, we would want to have a report to view the value set values add…
-
Report to fetch a list of all active configured approvalsSummary: Hello, Wanted to check if there is a way to build a report (sql query or OTBI) to fetch a list of all active approval rules in the system. Note: Approvals rules…DebayanB 285 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
HSDL template failing for certain usersHi, We are experiencing performance issues with HCM Spreadsheet Data Loader (HSDL). Users are able to generate/download the spreadsheet from Oracle Fusion HCM successful…
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 433 views 6 comments 0 points Most recent by LaurentDup Reporting and Analytics for ERP
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 1.1K views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …Gül Öner 27 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
26B - Some learning assignments missing Actions issue will be fixed in patch?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor… -
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher … -
Printable Expense Report Receipt Required CheckboxSummary: I am modifying the seeded Printable Expense Report and noticed that the Receipt Required Column always return as null (checkbox). Upon validation from excel usi…