Sample Reports
Discussion List
-
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 695 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis… -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 566 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Presentation variable in Column Filter possible?Summary: Hello all, Not sure if this is possible - I would like to use a variable inside a column filter, for example for YTD Actual I have filtered on scenario Actual H…Ian.Gooderham 24 views 7 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Drill down query for GL->XLA->AR(Receipt Category)Drill down query for GL->XLA->AR(Receipt Category). I have a custom report where I have to pick the details from GL_JE_Lines tables, and RA_CUSTOMER_TRX_ALL, AR_CASH_REC…
-
How to print page number only in last page in rtf templateHow to print page number only in last page in rtf templateLakshmiVanarasi 22 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
Need the tables that stores AR Receipts: Receipt Type, Status and Refundable deposit statusHi Experts, I need the table names that stores Receipt Type, Status and Refundable deposit status in Manage Receipts UI in oracle fusion. I used, AR_CASH_RECEIPTS_ALL AR…Krishan_Palihakkara 131 views 1 comment 0 points Most recent by Krishan_Palihakkara Reporting and Analytics for ERP
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Learning courses linked to any of the communityHi Team, Anyone developed the report to link the courses under the topic community? If so, please share. Thanks,
-
How to use the or in if clause together in RTF correctly?In RTF template How to use OR in the IF condition ?MayuriMMote 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Hcm tables/query which stores CA meal and rest break detailsHi Team, We have client requirement to create report for following details. Time Code(s) = Rest Time Violation and Meal Time Violation Time Card Work Date Attestation Qu…
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the … -
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 141 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
We looking employees Names in arabic language like LANGUAGE = 'AR'Summary: Hi Team, We looking employees Names in arabic language. for department name we used Transalation table HR_ALL_ORGANIZATION_UNITS_TL ,,and dept_arabic.LANGUAGE =…AjayKumar Maddipati 173 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
SQL needed to find parent department in department tree for any given department nameSummary: SQL needed to find parent department in department tree for any given department name Content (required): Hi All, Please share SQL to find parent department in …C.R.Balaji 3.3K views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Learning Management - Activity Completion DateSummary: Hi - I am trying to build an OTBI report that would show all activities in a course at the employee level and whether or not they have completed that activity o…
-
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
How to duplicate a page in the dashboard?Summary: Hello, how to duplicate a page in the dashboard? I want to copy a page in existing dashboard so I could have the same layout. Thanks! Content (please ensure you…
-
Query to find BIP report schedule detailsSummary: Query to find BIP report schedule details Content (required): Hi Team, We have requirement to fetch the schedule details of a BIP report like schedule start dat…Vasanthakumar Ravi 2.7K views 8 comments 1 point Most recent by Dev V Reporting and Analytics for HCM -
PER_ROLES_DN_VL table showing Duty Roles N or Null valuesHi Team, Greetings! We have encountered an issue while querying the PER_ROLES_DN_VL table for values in the DUTY_ROLE field. The table is only showing 'N' or NULL values…Bhuvaneswari Konduri-Oracle 65 views 0 comments 0 points Started by Bhuvaneswari Konduri-Oracle Reporting and Analytics for HCM
-
PDH Item Structure Structure Component audit database tablesSummary: I have a request to develop a custom audit report for PDH Item Structure and Structure Component. I'm looking for the database tables where I can sql data and c…Carlos Benassi 12 views 2 comments 0 points Most recent by Carlos Benassi Reporting and Analytics for SCM -
Seeded report listingSummary: Hello Experts Can someone help me with the listing of PPM (PFM + PEM) seeded reports ?Navya Krishna Yarlagadda 41 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management -
sql query to get person payment amount typeSummary: sql query to get person payment amount type Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Rahul K-Oracle 32 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Conditionally display columns in an BIP etext rtf template.Summary: Example out of 50 columns, first 30 and last 10 columns will show up always and 10 columns in the middle will show up only on a certain condition. Note: The req…Sunil Pradhan 132 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.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…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 12 views 1 comment 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM