Home/Oracle Fusion ERP
  1. Asked: November 21, 2025In:

    How to find the last refresh date for the TEST environment (P2T) in Fusion ERP

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    You can use the following query to get the last refresh date of the clone in oracle fusion. select * from ask_deployed_provision_configs; the last_update_date column in this table gives the completion date of last refresh date.

    You can use the following query to get the last refresh date of the clone in oracle fusion.

    select * from ask_deployed_provision_configs;

    the last_update_date column in this table gives the completion date of last refresh date.

    See less
  2. Asked: August 4, 2025In:

    Is There Any Depreciation Projection Report Available in Oracle Fusion?

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    The Depreciation Projection feature available in Oracle EBS Assets is not present in Oracle Fusion. Instead, you can use the 'What-If Depreciation Analysis' to perform similar evaluations. Please see also the description in the Help Portal: Here Use what-if analysis to forecast depreciation for grouRead more

    The Depreciation Projection feature available in Oracle EBS Assets is not present in Oracle Fusion. Instead, you can use the ‘What-If Depreciation Analysis’ to perform similar evaluations.

    Please see also the description in the Help Portal: Here

    Use what-if analysis to forecast depreciation for groups of assets in different scenarios. The information you enter is for analysis purposes only and does not affect your Oracle Fusion Assets data. You can run what-if analysis on assets defined in Assets or on hypothetical assets that are not yet defined in Assets. Depreciation projections are only estimates of actual depreciation expense. For every asset you specify, Assets computes depreciation data for the specified number of periods. The results of an analysis will not overwrite the results of previous analyses.

    You can forecast depreciation for either:

    Existing assets: When you run what-if depreciation analysis for existing assets, the application automatically launches the Prepare What-if Depreciation Analysis process.

    Hypothetical assets: When you run what-if depreciation analysis for hypothetical assets, the application automatically launches the Prepare Hypothetical Depreciation Analysis process.

    Reference: Doc ID 2026500.1

    See less
  3. Asked: May 28, 2025In:

    What is the difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in Oracle Fusion

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    The PER_ALL_ASSIGNMENTS_M is the core table for assignment-related data in the Oracle HCM Cloud. The PER_ALL_ASSIGNMENTS_F view is essentially a filtered version of this table, defined as: SELECT * FROM per_all_assignments_m paam WHERE effective_latest_change = 'Y'; This means: If you're looking toRead more

    The PER_ALL_ASSIGNMENTS_M is the core table for assignment-related data in the Oracle HCM Cloud.

    The PER_ALL_ASSIGNMENTS_F view is essentially a filtered version of this table, defined as:

    SELECT *
FROM per_all_assignments_m paam
WHERE effective_latest_change = 'Y';

    This means:

    If you’re looking to retrieve all assignment records, regardless of their current status, you should query the PER_ALL_ASSIGNMENTS_M table directly.
    If you’re only interested in the most recent effective changes to assignments, then the PER_ALL_ASSIGNMENTS_F view is the appropriate choice, as it returns only the latest effective rows.

    Source: Doc ID 2096539.1

    See less
  4. Asked: May 18, 2025In:

    Query to Get Oracle Fusion Users and their Attached Roles

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    Here's a sample SQL query that you can use to retrieve a list of users and their attached roles in Oracle Fusion: /* For Oraask.com */ SELECT pu.user_id ,pu.username ,ppnf.full_name ,prdt.role_id ,prdt.role_name ,prd.role_common_name ,prdt.description ,TO_CHAR (pur.start_date, 'DD-MON-YYYY') role_stRead more

    Here’s a sample SQL query that you can use to retrieve a list of users and their attached roles in Oracle Fusion:

    /* For Oraask.com */
SELECT pu.user_id
,pu.username
,ppnf.full_name
,prdt.role_id
,prdt.role_name
,prd.role_common_name
,prdt.description
,TO_CHAR (pur.start_date, 'DD-MON-YYYY') role_start_date
,TO_CHAR (pur.end_date, 'DD-MON-YYYY') role_end_date
,prd.abstract_role
,prd.job_role
,prd.data_role
,prd.duty_role
,prd.active_flag
FROM per_user_roles pur
,per_users pu
,per_roles_dn_tl prdt
,per_roles_dn prd
,per_person_names_f ppnf
WHERE 1 = 1
AND pu.user_id = pur.user_id
AND prdt.role_id = pur.role_id
AND prdt.language = USERENV ('lang')
AND prdt.role_id = prd.role_id
AND NVL (pu.suspended, 'N') = 'N'
AND ppnf.person_id = pu.person_id
AND ppnf.name_type = 'GLOBAL'
AND pu.active_flag = 'Y'
AND NVL (pu.start_date, SYSDATE) <= SYSDATE
AND NVL (pu.end_date, SYSDATE) >= SYSDATE
AND pu.username = :p_username
ORDER BY pu.username, prdt.role_name

    You can adjust the query based on your specific requirements. If you need further customization or have any questions, let me know!

    See less
  5. Asked: April 27, 2025In:

    What is the Impact if we change the username in Oracle Fusion

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant

    Changing usernames can have several significant impacts: Pending Approval Transactions: Users will lose all pending approval transactions from their worklist and will be unable to approve them. Approval History: The history of approval transactions will be lost. Delegation and Vacation Rules: TheseRead more

    Changing usernames can have several significant impacts:

    • Pending Approval Transactions: Users will lose all pending approval transactions from their worklist and will be unable to approve them.
    • Approval History: The history of approval transactions will be lost.
    • Delegation and Vacation Rules: These rules will also be lost.
    • Scheduled Processes: All scheduled processes submitted under the old username will remain associated with the old username. These may fail, so it’s advisable to cancel the old schedules and reschedule them with the new user IDs.
    • Favorites: All items saved in favorites will be lost.
    • WHO columns: For existing transactions, the “created by” and “last updated by” fields will retain the old username. For new transactions, these fields will reflect the updated username.

    Note: The recommended approach is to deactivate the old username and create a new one.

    See less
  6. Asked: March 21, 2025In:

    How to use AND , OR in IF() function of " add element by expression" in data model

    Hassan AbdElrahman
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    You can use && for AND, || for OR. examples: IF (P_ORG_ID==1 && P_CUSTOMER_ID==2, 'yes','no') IF (P_ORG_ID==1 || P_CUSTOMER_ID==2, 'yes','no')

    You can use && for AND, || for OR.

    examples:

    
IF (P_ORG_ID==1 && P_CUSTOMER_ID==2, 'yes','no')

IF (P_ORG_ID==1 || P_CUSTOMER_ID==2, 'yes','no')
    See less
  7. Asked: July 24, 2024In:

    Query to Get Business Units in Oracle Fusion

    Saly
    Saly Explorer

    Find below a query to get business unit information's like (Name, Effective Date, Is it enabled for HR, etc..) /* - Query to get Business Units informations in oracle Fusion - Prepared by: Hassan for Oraask.com */ SELECT haotl.NAME BU_NAME, hao.LOCATION_ID LOCATION_ID, haotl.BUSINESS_GROUP_ID BUSINERead more

    Find below a query to get business unit information’s like (Name, Effective Date, Is it enabled for HR, etc..)

    /* - Query to get Business Units informations in oracle Fusion
   - Prepared by: Hassan for Oraask.com
 */

SELECT
haotl.NAME BU_NAME,
hao.LOCATION_ID LOCATION_ID,
haotl.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,
haotl.EFFECTIVE_START_DATE DATE_FROM,
haotl.EFFECTIVE_END_DATE DATE_TO,
hoi.ORG_INFORMATION1 MANAGER_ID,
hoi.ORG_INFORMATION2 LEGAL_ENTITY_ID,
hoi.ORG_INFORMATION3 PRIMARY_LEDGER_ID,
hoi.ORG_INFORMATION4 DEFAULT_SET_ID,
haotl.NAME SHORT_CODE,
hoi.ORG_INFORMATION6 ENABLED_FOR_HR_FLAG,
hoi.ORG_INFORMATION7 FIN_BUSINESS_UNIT_ID,
hoi.ORG_INFORMATION8 DEFAULT_CURRENCY_CODE,
hoi.ORG_INFORMATION9 PROFIT_CENTER_FLAG
FROM
HR_ALL_ORGANIZATION_UNITS_F hao,
HR_ORGANIZATION_UNITS_F_TL haotl,
HR_ORG_UNIT_CLASSIFICATIONS_F houc,
hr_organization_information_f hoi
WHERE
hao.ORGANIZATION_ID = haotl.ORGANIZATION_ID
AND houc.ORGANIZATION_ID = haotl.ORGANIZATION_ID
AND houc.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT'
AND hoi.ORGANIZATION_ID = haotl.ORGANIZATION_ID
AND hoi.ORG_INFORMATION_CONTEXT = houc.CLASSIFICATION_CODE
AND TRUNC(SYSDATE) BETWEEN haotl.EFFECTIVE_START_DATE AND haotl.EFFECTIVE_END_DATE
AND haotl.LANGUAGE = USERENV('LANG')
AND haotl.EFFECTIVE_START_DATE = hao.EFFECTIVE_START_DATE
AND haotl.EFFECTIVE_END_DATE = hao.EFFECTIVE_END_DATE
ORDER BY
BU_NAME

    hope this helpful

    See less
  8. Asked: June 3, 2023In: ,

    What is Inventory Item Table in Oracle Fusion

    Hassan AbdElrahman
    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro Alum ♠ | Oracle Senior ERP Technical Consultant
    This answer was edited.

    The table containing inventory item details in Oracle Fusion is "EGP_SYSTEM_ITEMS_B". It has one composite primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID). and here you can find a sample query to get the most used information about items in Oracle Fusion: Query Inventory Item in Oracle Fusion SELECRead more

    The table containing inventory item details in Oracle Fusion is “EGP_SYSTEM_ITEMS_B“. It has one composite primary key (INVENTORY_ITEM_ID, ORGANIZATION_ID). and here you can find a sample query to get the most used information about items in Oracle Fusion:

    Query Inventory Item in Oracle Fusion

    SELECT ITEM_NUMBER
,INVENTORY_ITEM_ID
,FULL_LEAD_TIME
,PLANNER_CODE
,DECODE (MRP_PLANNING_CODE, 3, 'MRP Planned', 4, 'MPS Planned', 6, 'Not Planned', 7, 'MRP/MPP Planned', 8, 'MPS/MPP Planned', 9, 'MPP Planned', NULL)
MRP_PLANNING_CODE
,INVENTORY_ITEM_STATUS_CODE
,MINIMUM_ORDER_QUANTITY
,MAXIMUM_ORDER_QUANTITY
,FIXED_ORDER_QUANTITY
,FIXED_LOT_MULTIPLIER
,DECODE (INVENTORY_PLANNING_CODE, 6, 'Not Planned', 2, 'Min-Max', 1, 'Reorder Point', 7, 'Vendor Managed') INVENTORY_PLANNING_CODE
,MIN_MINMAX_QUANTITY
,MAX_MINMAX_QUANTITY
,MTL_TRANSACTIONS_ENABLED_FLAG
,CUSTOMER_ORDER_ENABLED_FLAG
,SO_TRANSACTIONS_FLAG
,PRIMARY_UOM_CODE
,UNIT_LENGTH
,UNIT_WIDTH
,UNIT_HEIGHT
,UNIT_WEIGHT
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
FROM EGP_SYSTEM_ITEMS_B
WHERE ORGANIZATION_ID = NVL(:INV_ORG_ID,ORGANIZATION_ID);

    In the above query, we have one parameter, “:P_INV_ORG_ID” to get the item information in a specific inventory organization.

    You can refer to the Oracle doc to know all columns in this table.

    Hope this help.

    See less