Posts

P2P Cycle SQL Script in Oracle Fusion

-
   --P2P Cycle SQL Script Functional Flow 1 ) Purchase Requisition Business user identifies need Creates PR in system Budget gets validated 2 ) PR Approval Manager reviews and approves Budget check happens Approval routing complete 3 ) Purchase Order Creation Approved PR converts to PO Supplier gets selected Terms & conditions set 4 ) PO Approval Amount-based routing Multi-level approval workflow Final authorization received 5 ) Goods/Service Receipt Warehouse receives items Quantity verified Quality inspection done 6 ) Invoice Receipt Supplier sends invoice Manual or EDI entry Initial validation runs 7 ) 3-Way Match PO vs Receipt vs Invoice Quantity must match Price tolerance checked 8 ) Invoice Approval Holds resolved Final invoice approval Exceptions handled 9 ) Payment Processing Payment terms applied Payment run created Bank file generated 10 ) GL Accounting Technical Flow SELECT  -- 1. Requisition Data (PR)     prh.requisition_number,     p...
Post a Comment
Read more

Active Employee Roster Query

-
   Active Employee Roster Query SELECT      -- Person Identifiers     papf.person_number,     ppnf.full_name,     ppnf.first_name,     ppnf.last_name,     -- Employment Details     paam.assignment_number,     paam.assignment_status_type,     ppos.date_start                AS hire_date,     ppos.actual_termination_date,     -- Job,Department Details     pjft.name                      AS job_name,     houtl.name                     AS department_name,     -- Assignment Metadata     paam.effective_start_date      AS assignment_start_date,     paam.effective_end_date        AS assignment_end_date FROM      per_all_people_f...
Post a Comment
Read more

VAT Report in Oracle Fusion

-
Image
 SELECT      gl.name AS ledger_name,     zx.trx_number AS transaction_number,     zx.trx_date AS transaction_date,     zx.tax_regime_code,     zx.tax_rate_code,     zx.line_amt AS taxable_amount,     zx.tax_amt AS vat_amount FROM      ZX_LINES zx,     GL_LEDGERS gl WHERE 1=1     AND zx.ledger_id = gl.ledger_id     AND zx.trx_date >= TO_DATE('2026-01-01', 'YYYY-MM-DD')     AND ROWNUM < 50
Post a Comment
Read more

Absence Management

-
Image
     Absence Management It helps to manage employee Absence Details, meaning leave management. After the implementation of GHR, Absence Management is required. Human Resources Role is required to manage Absence Management application. Navigation: My Client Group à Absences Time Periods Repeating Time Periods Define the boundaries for when accruals are calculated, when balances reset, and when leave can be taken.     Creating Absence Plans means Leave Plans. Ex: Vocation leaves, pending leave, sick leave, ….etc Get approval from the manager and get leave Auto approval Schedule the leaves Leave balance will be calculated and posted to (General Ledger:GL) First Time Periods will be defined, and then the Eligibility profile will be defined Eligibility Then we will have a Fast Formula and Rates Rate definition: When we want to change the values dynamically. Absence Reason: What is the reason for applying for leave ...
Post a Comment
Read more

HSDL vs HDL

-
  What are the differences between HDL and HSLD in Oracle HCM Cloud? HSDL Vs   HDL HCM Spread Data Loader   HCM Data Loader We need to install the ADFdi Plug-on Excel   No need to install ADFdi Plug-in User Friendly   It is not user-friendly A normal consultant can fill in the data in Excel <50,000 records   Technical expertise is required to prepare the DAT file >50,000 records If we load more than  50,000 records then we may encounter problems like: Excel stopped working Session Time-out   We can load unlimited records. We will prepare .DAT file We will just fill the data in the Excel sheet If any errors occur, we can fix it in the same Excel sheet.   We have to check the error logs and then we n...
Post a Comment
Read more

Mastering Parameters in Oracle Fusion BI Publisher

-
Mastering Parameters in Oracle Fusion BI Publisher: Mandatory, Optional, and "All" Logic When building Data Models in Oracle Fusion, how you handle parameters determines the user experience and report performance. Here is the definitive syntax guide: 1. Mandatory Parameters Use this when a value must be provided for the report to run. Syntax: AND column =:parameter Example: AND Person_Number = :p_Person_Number 2. Optional Parameters (The "All" Logic) Use this to allow users to leave a field blank or select "All" to see all records. Syntax (Recommended):  AND (:parameter IS NULL OR column = :parameter) Example: AND (:p_Person_Number IS NULL OR Person_Number = :p_Person_Number) Note: Using NVL is common but can be slower on large datasets as it may bypass indexes. 3. Multi-Select Parameters Use this when the user can select multiple values from a list. Syntax: AND (column IN (:parameter) OR 'All' IN (:parameter)) Example: AND (Person_Number IN (:p_Pe...
Post a Comment
Read more

Oracle Fusion BIP: Customizing Seeded Reports the Right Way

-
 Oracle Fusion BIP: Customizing Seeded Reports the Right Way When a client asks to see only specific columns in a Standard/Seeded BIP Report, you have two main paths.  Choosing the right one depends on whether you want to change the View  or  the Engine. Option 1: Create a Custom Layout (Recommended) This is the "cleanest" approach. You keep the standard logic but change the visual output The Move: Create a new Layout (RTF/Excel/Online) using only the required columns from the existing Seeded Data Model. Why it wins: It’s low maintenance. Since you’re still using the seeded Data Model, you benefit from any logic updates Oracle pushes during quarterly patches. Best for: When the data is already there, you just want it to look tidier. Option 2: Customize the Data Model This is a deeper "under the hood" change. The Move: Copy the seeded Data Model to the Custom folder, edit the SQL script to remove unwanted columns, and link it to a new report/layout. Why it w...
Post a Comment
Read more