Home/ Saly/Answers
  1. 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
  2. Asked: August 9, 2016In:

    oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified responsibility.

    Saly
    Saly Explorer

    hi beter check these two responsibilities assigned to your application user or not : Framework ToolBox TutorialFramework ToolBox Tutorial Labs

    hi beter
    check these two responsibilities assigned to your application user or not :

    Framework ToolBox Tutorial
    Framework ToolBox Tutorial Labs
    See less
  3. Asked: July 31, 2016In:

    How to Raise User-Defined Exception and display Custom SQLERRM ?

    Saly
    Saly Explorer

    thanks so much to @Stephan Borsodi for this solution

    thanks so much to @Stephan Borsodi for this solution

    See less