Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
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.
Query to Get Oracle Fusion Users and their Attached Roles
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:
You can adjust the query based on your specific requirements. If you need further customization or have any questions, let me know!
See lessWhat is the Impact if we change the username in Oracle Fusion
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:
Note: The recommended approach is to deactivate the old username and create a new one.
See lessHow to use AND , OR in IF() function of " add element by expression" in data model
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:
See lessWhat is Inventory Item Table in Oracle Fusion
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
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 lessHow to Initialize Oracle APPS session using SQL Developer
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
API to close workflow notifications in Oracle APPS R12
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:
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 lessQuery to Get Supplier Details in Oracle APPS R12
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:
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 lessHow to Find Queries Running For More than 5 Minutes
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:
Output:
Note: 300 is (5*60). change it as you want to.
See lessQuery to get posted AP invoice in Oracle APPS R12
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:
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
See lessY
Directory Object vs BLOB
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