Sign Up

Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.

Have an account?

Sign In

Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

Sorry, you do not have permission to ask a question, You must login to ask a question.

Need An Account,

Sorry, you do not have permission to add post.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question

You Will Never Get Stuck Again!

This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".

Join 15000+ Exceptional

What's your question?
  1. Asked: July 24, 2024In:

    Query to Get Business Units in Oracle Fusion

    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
    • 0
  2. Asked: June 3, 2023In: ,

    What is Inventory Item Table in Oracle Fusion

    Best Answer
    Hassan AbdElrahman Master Oracle ACE Pro ♠ | 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
    • 0
  3. Asked: April 2, 2023In:

    How to Initialize Oracle APPS session using SQL Developer

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

    You can use this script to initialize a session in SQL Developer and to be able to select from multi-org views in Oracle EBS R12 DECLARE l_user_id NUMBER; l_resp_id NUMBER; l_app_id NUMBER; l_org_id NUMBER; l_err_num VARCHAR2(1000); l_err_msg VARCHAR2(1000); BEGIN SELECT user_id INTO l_user_id FROMRead more

    You can use this script to initialize a session in SQL Developer and to be able to select from multi-org views in Oracle EBS R12

    DECLARE
    l_user_id NUMBER;
    l_resp_id NUMBER;
    l_app_id NUMBER;
    l_org_id NUMBER;
    l_err_num VARCHAR2(1000);
    l_err_msg VARCHAR2(1000);

BEGIN

    SELECT user_id
    INTO l_user_id
    FROM fnd_user
    WHERE user_name = 'OPERATIONS';

    SELECT responsibility_id, application_id
    INTO l_resp_id,l_app_id
    FROM fnd_responsibility
    WHERE responsibility_key = 'PAYABLES_MANAGER';

    BEGIN

        fnd_global.apps_initialize(l_user_id,l_resp_id,l_app_id);

        fnd_global.set_nls_context(p_nls_language => 'AMERICAN'
                                  ,p_nls_date_format => NULL
                                  ,p_nls_date_language => NULL
                                  ,p_nls_numeric_characters => NULL
                                  ,p_nls_sort => NULL
                                  ,p_nls_territory => NULL);

        fnd_profile.get(name => 'DEFAULT_ORG_ID',val => l_org_id);
        mo_global.set_policy_context(p_access_mode => 'S',p_org_id => l_org_id);
        mo_global.init(p_appl_short_name => 'SQLAP');

    EXCEPTION WHEN OTHERS THEN
        l_err_num := sqlcode;
        l_err_msg := substr(sqlerrm,1,1000);
        raise_application_error(l_err_num,l_err_msg);
    END;
END;
    See less
    • 0
  4. Asked: March 21, 2023In:

    API to close workflow notifications in Oracle APPS R12

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

    You can use the following script to close a workflow notification from the backend using API: ------------------------------------------ -- Description: API to close Workflow Notification in oracle EBS R12 -- nid - Notification Id -- resp - Respond Required? 0 - No, 1 - Yes -- responder - User or roRead more

    You can use the following script to close a workflow notification from the backend using API:

    
------------------------------------------
-- Description: API to close Workflow Notification in oracle EBS R12
--   nid - Notification Id
--   resp - Respond Required?  0 - No, 1 - Yes
--   responder - User or role close this notification
-- Created By: Hassan @ Oraask.com
-- Creation Date: 21-MAR-2023
------------------------------------------

DECLARE
L_RESPONDER FND_USER.USER_NAME%TYPE := 'SYYADMIN';

CURSOR NOTIFICATIONS_CUR
IS
--
--Modify the below query as per your requirement
--
SELECT ITEM_KEY, NOTIFICATION_ID, RECIPIENT_ROLE
FROM WF_NOTIFICATIONS
WHERE MESSAGE_TYPE LIKE '%HRSSA%'
AND STATUS = 'OPEN'
AND NOTIFICATION_ID = NVL ( :P_NOTIFICATION_ID, NOTIFICATION_ID);
BEGIN
--
FOR NOTIFICATIONS_REC IN NOTIFICATIONS_CUR
LOOP
BEGIN
--
WF_NOTIFICATION.CLOSE (NID => NOTIFICATIONS_REC.NOTIFICATION_ID, RESPONDER => L_RESPONDER);

DBMS_OUTPUT.PUT_LINE ('Closing Notification ID: ' || NOTIFICATIONS_REC.NOTIFICATION_ID);
--
END;
END LOOP;

--
COMMIT;
--
END;

    In the above example we created a cursor that fetchs the open notifications in HRMS which is HRSSA workflow item type and we have used the NOTIFICATION_ID if we need to close specific notification. We have used WF_NOTIFICATION standard package to achieve our goal.

    See less
    • 0
  5. Asked: February 21, 2023In:

    Query to Get Supplier Details in Oracle APPS R12

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

    Hi @Beter, Please find below a query to get the master supplier informations: SELECT HOU.NAME OU_NAME ,APPS.ORG_ID ,APS.SEGMENT1 SUPPLIER_NUMBER ,APS.VENDOR_TYPE_LOOKUP_CODE SUPPLIER_TYPE ,APS.VENDOR_NAME SUPPLIER_NAME ,APS.VENDOR_NAME_ALT SUPPLIER_NAME_ALT ,APS.NUM_1099 TAXPAYER_ID ,APS.VAT_REGISTRRead more

    Hi Beter, Please find below a query to get the master supplier informations:

    SELECT HOU.NAME OU_NAME
,APPS.ORG_ID
,APS.SEGMENT1 SUPPLIER_NUMBER
,APS.VENDOR_TYPE_LOOKUP_CODE SUPPLIER_TYPE
,APS.VENDOR_NAME SUPPLIER_NAME
,APS.VENDOR_NAME_ALT SUPPLIER_NAME_ALT
,APS.NUM_1099 TAXPAYER_ID
,APS.VAT_REGISTRATION_NUM TAX_REGISTRATION_NUM
,APS.ALLOW_AWT_FLAG SUPPLIER_ALLOW_WITHHOLDING_TAX
,DECODE (APS.END_DATE_ACTIVE, NULL, 'ACTIVE', 'IN ACTIVE') ACTIVE_CODE
,APPS.VENDOR_SITE_ID
,APPS.INACTIVE_DATE
,APPS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
,APPS.VENDOR_SITE_CODE_ALT SITE_CODE_ALT
,APPS.ALLOW_AWT_FLAG SITE_ALLOW_WITHHOLDING_TAX
,APPS.ADDRESS_LINE1
,APPS.ADDRESS_LINE2
,APPS.ADDRESS_LINE3
,APPS.ADDRESS_LINE4
,APPS.CITY
,APPS.STATE
,APPS.ZIP POST_CODE
,APPS.SUPPLIER_NOTIF_METHOD SITE_PO_NOTIF_METHOD
,APPS.EMAIL_ADDRESS SITE_PO_EMAIL
,APS.PAY_GROUP_LOOKUP_CODE
FROM AP_SUPPLIERS APS, AP_SUPPLIER_SITES_ALL APPS, HR_OPERATING_UNITS HOU
WHERE APS.VENDOR_ID = APPS.VENDOR_ID(+)
AND APS.END_DATE_ACTIVE IS NULL
AND APPS.INACTIVE_DATE IS NULL
AND HOU.ORGANIZATION_ID(+) = APPS.ORG_ID;

    Above query will list all suppliers details: OU_NAME, ORG_ID, SUPPLIER_NUMBER, SUPPLIER_TYPE, SUPPLIER_NAME, SUPPLIER_NAME_ALT, TAXPAYER_ID, TAX_REGISTRATION_NUM, SUPPLIER_ALLOW_WITHHOLDING_TAX, ACTIVE_CODE, VENDOR_SITE_ID, INACTIVE_DATE, SUPPLIER_SITE_CODE, SITE_CODE_ALT, SITE_ALLOW_WITHHOLDING_TAX, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, ADDRESS_LINE4 ,CITY, STATE, POST_CODE, SITE_PO_NOTIF_METHOD, and SITE_PO_EMAIL. And the list is open to add any other column/s you prefer. Note: If you are looking also about other details for the supplier you can find them in the list below:

     

    Hope this helps.

    See less
    • 0
  6. Asked: September 14, 2021In:

    Query To Find Operating Unit And Corresponding Inventory Organizations Details in Oracle Apps R12

    andy.haack Junior
    This answer was edited.

    You can use the following SQL from the GL Ledgers and Organizations using blitz report SELECT HAOUV.NAME BUSINESS_GROUP , (SELECT DISTINCT LISTAGG (GL0.NAME, ', ') WITHIN GROUP (ORDER BY GL0.NAME) OVER (PARTITION BY GLSNAV.LEDGER_ID) LEDGER_SET FROM GL_LEDGER_SET_NORM_ASSIGN_V GLSNAV, GL_LEDGERS GL0Read more

    You can use the following SQL from the GL Ledgers and Organizations using blitz report

    SELECT HAOUV.NAME BUSINESS_GROUP
, (SELECT DISTINCT LISTAGG (GL0.NAME, ', ') WITHIN GROUP (ORDER BY GL0.NAME) OVER (PARTITION BY GLSNAV.LEDGER_ID) LEDGER_SET
FROM GL_LEDGER_SET_NORM_ASSIGN_V GLSNAV, GL_LEDGERS GL0
WHERE GL.LEDGER_ID = GLSNAV.LEDGER_ID
AND GLSNAV.LEDGER_SET_ID = GL0.LEDGER_ID)
LEDGER_SET
,GL.NAME LEDGER
,XXEN_UTIL.MEANING (GL.LEDGER_CATEGORY_CODE, 'GL_ASF_LEDGER_CATEGORY', 101) LEDGER_CATEGORY
,GL.CURRENCY_CODE CURRENCY
,FIFSV.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
,HOU.NAME OPERATING_UNIT
,OOD.ORGANIZATION_CODE
,OOD.ORGANIZATION_NAME ORGANIZATION
,FTV.TERRITORY_SHORT_NAME COUNTRY
,XEP.NAME LEGAL_ENTITY
,GL.LEDGER_ID
,FIFSV.ID_FLEX_STRUCTURE_CODE CHART_OF_ACCOUNTS_CODE
,GL.CHART_OF_ACCOUNTS_ID
,OOD.OPERATING_UNIT OPERATING_UNIT_ID
,OOD.ORGANIZATION_ID
FROM GL_LEDGERS GL
,FND_ID_FLEX_STRUCTURES_VL FIFSV
,HR_OPERATING_UNITS HOU
,HR_ALL_ORGANIZATION_UNITS_VL HAOUV
,ORG_ORGANIZATION_DEFINITIONS OOD
,HR_ALL_ORGANIZATION_UNITS HAOU
,HR_LOCATIONS_ALL HLA
,FND_TERRITORIES_VL FTV
,XLE_ENTITY_PROFILES XEP
WHERE NVL (OOD.DISABLE_DATE, SYSDATE) >= SYSDATE
AND NVL (HOU.DATE_TO, SYSDATE) >= SYSDATE
AND NVL (OOD.DISABLE_DATE, SYSDATE) >= SYSDATE
AND NVL (HOU.DATE_TO, SYSDATE) >= SYSDATE
AND GL.OBJECT_TYPE_CODE = 'L'
AND GL.CHART_OF_ACCOUNTS_ID = FIFSV.ID_FLEX_NUM
AND FIFSV.APPLICATION_ID = 101
AND FIFSV.ID_FLEX_CODE = 'GL#'
AND GL.LEDGER_ID = HOU.SET_OF_BOOKS_ID(+)
AND HOU.BUSINESS_GROUP_ID = HAOUV.ORGANIZATION_ID(+)
AND HOU.ORGANIZATION_ID = OOD.OPERATING_UNIT(+)
AND OOD.ORGANIZATION_ID = HAOU.ORGANIZATION_ID(+)
AND HAOU.LOCATION_ID = HLA.LOCATION_ID(+)
AND HLA.COUNTRY = FTV.TERRITORY_CODE(+)
AND OOD.LEGAL_ENTITY = XEP.LEGAL_ENTITY_ID(+)
ORDER BY CHART_OF_ACCOUNTS_NAME
,LEDGER_SET
,BUSINESS_GROUP
,LEDGER
,CURRENCY
,OPERATING_UNIT
,COUNTRY
,ORGANIZATION_CODE
    See less
    • 0
  7. Asked: December 10, 2022In:

    Query to Get Chart of Account Description in Oracle APPS R12

    andy.haack Junior
    This answer was edited.

    You can use the following query from blitz report FND Key Flexfields: SELECT FAV.APPLICATION_NAME,FIF.ID_FLEX_NAME TITLE ,FIF.DESCRIPTION ,FIF.ID_FLEX_CODE ,FIF.APPLICATION_TABLE_NAME ,FIF.UNIQUE_ID_COLUMN_NAME ,FIF.SET_DEFINING_COLUMN_NAME ,DECODE (FIFSV.ENABLED_FLAG, 'Y', 'Y') STRUCTURE_ENABLED ,FRead more

    You can use the following query from blitz report FND Key Flexfields:

    SELECT FAV.APPLICATION_NAME
    ,FIF.ID_FLEX_NAME TITLE
,FIF.DESCRIPTION
,FIF.ID_FLEX_CODE
,FIF.APPLICATION_TABLE_NAME
,FIF.UNIQUE_ID_COLUMN_NAME
,FIF.SET_DEFINING_COLUMN_NAME
,DECODE (FIFSV.ENABLED_FLAG, 'Y', 'Y') STRUCTURE_ENABLED
,FIFSV.ID_FLEX_STRUCTURE_CODESTRUCTURE_CODE
,FIFSV.ID_FLEX_STRUCTURE_NAMESTRUCTURE_NAME
,FIFSV.ID_FLEX_NUM
,FIFSV.CONCATENATED_SEGMENT_DELIMITER DELIMITER
,FIFSV.SHORTHAND_PROMPT
,FIFSGV.SEGMENT_NUMSEGMENT_NUMBER
,FIFSGV.SEGMENT_NAME
,FIFSGV.FORM_LEFT_PROMPT WINDOW_PROMPT
,FIFSGV.APPLICATION_COLUMN_NAMECOLUMN_NAME
, (SELECT DISTINCT LISTAGG (XXEN_UTIL.MEANING (FSAV.SEGMENT_ATTRIBUTE_TYPE, 'XLA_FLEXFIELD_SEGMENTS_QUAL', 602), ', ')
WITHIN GROUP (ORDER BY XXEN_UTIL.MEANING (FSAV.SEGMENT_ATTRIBUTE_TYPE, 'XLA_FLEXFIELD_SEGMENTS_QUAL', 602))
OVER (PARTITION BY FSAV.APPLICATION_ID
,FSAV.ID_FLEX_CODE
,FSAV.ID_FLEX_NUM
,FSAV.APPLICATION_COLUMN_NAME)
SEGMENT_ATTRIBUTES
FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FIFSGV.APPLICATION_ID = FSAV.APPLICATION_ID
AND FIFSGV.ID_FLEX_CODE = FSAV.ID_FLEX_CODE
AND FIFSGV.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FIFSGV.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL')
FLEXFIELD_QUALIFIER
, (SELECT DISTINCT LISTAGG (FSAV.SEGMENT_ATTRIBUTE_TYPE, ', ')
WITHIN GROUP (ORDER BY FSAV.SEGMENT_ATTRIBUTE_TYPE)
OVER (PARTITION BY FSAV.APPLICATION_ID
,FSAV.ID_FLEX_CODE
,FSAV.ID_FLEX_NUM
,FSAV.APPLICATION_COLUMN_NAME)
SEGMENT_ATTRIBUTES
FROM FND_SEGMENT_ATTRIBUTE_VALUES FSAV
WHERE FIFSGV.APPLICATION_ID = FSAV.APPLICATION_ID
AND FIFSGV.ID_FLEX_CODE = FSAV.ID_FLEX_CODE
AND FIFSGV.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
AND FIFSGV.APPLICATION_COLUMN_NAME = FSAV.APPLICATION_COLUMN_NAME
AND FSAV.ATTRIBUTE_VALUE = 'Y'
AND FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL')
FLEXFIELD_QUALIFIER_CODE
,FFVS.FLEX_VALUE_SET_NAME VALUE_SET_NAME
,DECODE (FIFSGV.ENABLED_FLAG, 'Y', 'Y') ENABLED
,DECODE (FIFSGV.DISPLAY_FLAG, 'Y', 'Y') DISPLAYED
,DECODE (FIFSGV.REQUIRED_FLAG, 'Y', 'Y') REQUIRED
,DECODE (FIFSGV.SECURITY_ENABLED_FLAG, 'Y', 'Y') SECURITY_ENABLED
,XXEN_UTIL.MEANING (FFVS.VALIDATION_TYPE, 'SEG_VAL_TYPES', 0) VALIDATION_TYPE
,FFVT.APPLICATION_TABLE_NAME VALIDATION_TABLE
,FFVT.ADDITIONAL_WHERE_CLAUSE WHERE_CLAUSE
,FIFSGV.FLEX_VALUE_SET_ID
FROM FND_APPLICATION_VL FAV
,FND_ID_FLEXS FIF
,FND_ID_FLEX_STRUCTURES_VL FIFSV
,FND_ID_FLEX_SEGMENTS_VL FIFSGV
,FND_FLEX_VALUE_SETS FFVS
,FND_FLEX_VALIDATION_TABLES FFVT
WHERE FIF.ID_FLEX_CODE = 'GL#'
AND 1 = 1
AND FAV.APPLICATION_ID = FIF.APPLICATION_ID
AND FIF.APPLICATION_ID = FIFSV.APPLICATION_ID(+)
AND FIF.ID_FLEX_CODE = FIFSV.ID_FLEX_CODE(+)
AND FIFSV.APPLICATION_ID = FIFSGV.APPLICATION_ID(+)
AND FIFSV.ID_FLEX_CODE = FIFSGV.ID_FLEX_CODE(+)
AND FIFSV.ID_FLEX_NUM = FIFSGV.ID_FLEX_NUM(+)
AND FIFSGV.FLEX_VALUE_SET_ID = FFVS.FLEX_VALUE_SET_ID(+)
AND DECODE (FFVS.VALIDATION_TYPE, 'F', FFVS.FLEX_VALUE_SET_ID) = FFVT.FLEX_VALUE_SET_ID(+)
ORDER BY FAV.APPLICATION_NAME
,FIF.ID_FLEX_NAME
,FIFSV.ID_FLEX_STRUCTURE_NAME
,FIFSGV.SEGMENT_NUM
    See less
    • 0
  8. Asked: January 23, 2023In:

    How to Find Queries Running For More than 5 Minutes

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

    To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need: Query: SELECT S.USERNAME ,Q.SQL_ID ,ROUND (S.LAST_CALL_ET, 2) TIME_IN_SECONDS ,ROUND (S.LAST_CALL_ET / 60, 2) TIME_IN_MINS ,S.SID ,Q.SQL_TEXT FROM GV$SESSION S,Read more

    To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need:

    Query:

    SELECT S.USERNAME
,Q.SQL_ID
,ROUND (S.LAST_CALL_ET, 2) TIME_IN_SECONDS
,ROUND (S.LAST_CALL_ET / 60, 2) TIME_IN_MINS
,S.SID
,Q.SQL_TEXT
FROM GV$SESSION S, V$SQL Q
WHERE S.SQL_ID = Q.SQL_ID
AND STATUS = 'ACTIVE'
AND USERNAME LIKE '%APPS%'
AND S.LAST_CALL_ET > 300;

    Output:

    USERNAME SQL_ID TIME_IN_SECONDS TIME_IN_MINS
    —————————— ————- ————— ————
    SID
    ———-
    SQL_TEXT
    ——————————————————————————–
    APPS 497wh6n7hu14f 10562436 176040.6
    331
    BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); END;

    1 row selected.

    Note: 300 is (5*60). change it as you want to.

    See less
    • 1
  9. Asked: January 25, 2023In:

    Query to get posted AP invoice in Oracle APPS R12

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

    There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) . This function take the invoice_id parameter and return one of four values: 'Y' - Posted 'N' - Unposted 'S' - Selected 'P' - Partially Posted ThesRead more

    There is a seeded standard function provided from oracle to identify whether the invoice is posted or not. Which is (AP_INVOICES_PKG.GET_POSTING_STATUS) .

    This function take the invoice_id parameter and return one of four values:

    ‘Y’ – Posted
    ‘N’ – Unposted
    ‘S’ – Selected
    ‘P’ – Partially Posted

    These values is the invoice posting status flag.

    Example:

    SELECT AIA.INVOICE_NUM, AP_INVOICES_PKG.GET_POSTING_STATUS (AIA.INVOICE_ID) INVOICE_POSTING_FLAG
FROM AP_INVOICES_ALL AIA;

    Output:

    INVOICE_NUM
    ————————————————–
    INVOICE_POSTING_FLAG
    ——————————————————————————–
    ERS-9163-109073
    Y

    19879-781
    N

    ERS-4400-109091
    Y

    ERS-9164-109093
    P

    ERS-6970-109094
    Y

    ERS-6971-109095
    Y

    See less
    • 1
  10. Asked: November 24, 2022In:

    Directory Object vs BLOB

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

    It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and youRead more

    It depends on the number and size of files you want to store. If you have a small amount of files you can store them into the database however, the database size will get bigger by time. On the other side the directory you can assign a specific space you need based on your size of the files and you can leverage other advantages like to open the file write into it and so on.

    This a brief and for sure there are other benefits for each option but hopefully my answer give you a little insight.

    See less
    • 0

Latest Python Wiki's

Python Program to Check Prime Number using While Loop
Python
2 years ago
4 mins read

Python Program to Check Prime Number using While Loop

Python Program to Check Prime Number using While Loop

Prime numbers are an essential concept in mathematics and computer science. They are numbers that are only divisible by 1 and themselves. In ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0
Python Delete Variable: How to Free Up Memory Space in Your Code
Python
2 years ago
3 mins read

Python Delete Variable: How to Free Up Memory Space in Your Code

Python Delete Variable: How to Free Up Memory Space in Your Code

Introduction: Python is a popular programming language used in a variety of applications, from data analysis to web development. One ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0
How to Swap Characters in String in Python – 3 Techniques
Python
2 years ago
7 mins read

How to Swap Characters in String in Python – 3 Techniques

How to Swap Characters in String in Python – 3 Techniques

Swapping the string is one of the most commonly used operations by programmers. The string is a data type to store the text ...

Asif Rahaman
Asif Rahaman
Freelancer | Coder | Reader | Student | Learner
0
0
More Python Wiki's

Latest Data Visualization Wiki's

Python Pandas Date: Parsing, Arithmetic, and Resampling
Pandas
1 year ago
10 mins read

Python Pandas Date: Parsing, Arithmetic, and Resampling

Python Pandas Date: Parsing, Arithmetic, and Resampling

Pandas is one of the most popular libraries of Python. This data visualization library deals with the operations related to data. In data ...

Asif Rahaman
Asif Rahaman
Freelancer | Coder | Reader | Student | Learner
0
0
Exploring Python Pandas Options: Your Data Power Tool
Pandas
1 year ago
5 mins read

Exploring Python Pandas Options: Your Data Power Tool

Exploring Python Pandas Options: Your Data Power Tool

Pandas is a trendy Python library used for data analysis. One of the essential features of data analysis is the options system. This ...

Asif Rahaman
Asif Rahaman
Freelancer | Coder | Reader | Student | Learner
0
0
Python Pandas Join: Where Datasets Converge
Pandas
1 year ago
6 mins read

Python Pandas Join: Where Datasets Converge

Python Pandas Join: Where Datasets Converge

Introduction The topic of Python Pandas join is crucial for data manipulation and analysis. It is a process of ...

Asif Rahaman
Asif Rahaman
Freelancer | Coder | Reader | Student | Learner
0
0

Latest Java Wiki's

Java Variable Types: Are You Using Them Correctly?
Java Tutorial
2 years ago
7 mins read

Java Variable Types: Are You Using Them Correctly?

Java Variable Types: Are You Using Them Correctly?

Introduction Programs manage data stored in memory. On the machine level, data can only be called by the numeric ...

Zoran Gacovski
Zoran Gacovski
MSc degree in Computer Engineering
0
0
Java Data Types: The Basics Explained
Java Tutorial
2 years ago
6 mins read

Java Data Types: The Basics Explained

Java Data Types: The Basics Explained

Introduction Each variable in Java must have a data type. There are several Java data types available. The type determines ...

Zoran Gacovski
Zoran Gacovski
MSc degree in Computer Engineering
0
0
Java Arrays
Java Tutorial
2 years ago
5 mins read

Java Arrays

Java Arrays

Introduction An array is a set of members. Each member can contain an object or primitive value. Arrays in Java ...

Zoran Gacovski
Zoran Gacovski
MSc degree in Computer Engineering
1
0
More Java Wiki's

Latest Oracle Wiki's

How to Convert Decimal to Hexadecimal in Oracle SQL
SQL
2 years ago
3 mins read

How to Convert Decimal to Hexadecimal in Oracle SQL

How to Convert Decimal to Hexadecimal in Oracle SQL

Introduction Are you struggling to convert decimal numbers to hexadecimal in Oracle SQL? Don't worry; you are not alone. ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0
How to Create Table with Foreign Key in Oracle
Basics
2 years ago
9 mins read

How to Create Table with Foreign Key in Oracle

How to Create Table with Foreign Key in Oracle

Introduction If you are working with large amounts of data in an Oracle database, you may have come across ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0
ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve
SQL
2 years ago
4 mins read

ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve

ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve

Oracle databases are widely used in the industry; sometimes, you may encounter errors when working with them. One such error is the ORA-01034 ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0

Latest JavaScript Wiki's

Easily Convert Decimal to Hex in JavaScript Today
JavaScript
2 years ago
3 mins read

Easily Convert Decimal to Hex in JavaScript Today

Easily Convert Decimal to Hex in JavaScript Today

As a developer, knowing how to work with different numeral systems is essential. One such system is hexadecimal, which is commonly used in ...

Hassan AbdElrahman
Hassan AbdElrahman
Oracle ACE Pro ♠ | Oracle Senior ERP Technical Consultant
0
0
JavaScript Variables
JavaScript
4 years ago
1 mins read

JavaScript Variables

JavaScript Variables

What are JavaScript variables? Variables are simply containers where we can store values. You can simply place the values in ...

isouravghosh
isouravghosh
isouravghosh
0
0
JavaScript Syntax
JavaScript
4 years ago
3 mins read

JavaScript Syntax

JavaScript Syntax

Introduction In HTML documents and webpages JavaScript can be included in two ways. One way is to include the JavaScript ...

isouravghosh
isouravghosh
isouravghosh
0
0
More JavaScript articles