Query: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, e.execution_file_name, lv.meaning file_type, fat.application_name “Application Name” FROM fnd_request_sets_vl rs, fnd_req_set_stages_form_v rss, fnd_request_set_programs rsp, fnd_concurrent_programs_vl cp, fnd_executables e, fnd_lookup_values lv,…
Read MoreIntroduction:- Oracle has a seeded API fnd_user_pkg which has a procedure to create new user login account. Below is the sample script to create user account, change the parameters as per your…
Read MoreIntroduction:- fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities from one user account to another user account.Below is the script to copy responsibilities of user “ORACLE_TEST_USER_12” to “ORACLE_TEST_USER_89”. API…
Read MoreObjective: Query to handle with zero if no onhand quantities in Inventory or onhand is NULL SQL: Select NVL(MAX(COUNT(moq.TRANSACTION_QUANTITY)),0) –MAX(NVL(SUM(moq.TRANSACTION_QUANTITY),0)) from mtl_onhand_quantities moq, MTL_ITEM_LOCATIONS_KFV mil, mtl_system_items_b msib where moq.LOCATOR_ID…
Read MoreThe normal behavior of if-else condition looks like If <contion> then <value> –for true condition else <value> end in RTF it can be achieved using following syntax <?xdoxslt:ifelse(condition,true,false)?> Example <?xdoxslt:ifelse(ADDRESS1=SENDOR_NAME,’’,ADDRESS1)?>
Read MoreOverview:- In this post , I am sharing the example how to create Supplier Site through Oracle Standard API. You can refer this code to create suppliers through backend in…
Read MoreOverview:- In this post , I am sharing the example how to create Supplier through Oracle Standard API. You can refer this code to create suppliers through backend in oracle…
Read MoreOverview:- In this post , We will discuss about AP aging report query in oracle apps. The AP aging report helps us to identify the creditor aging which is due…
Read MoreQuery: SELECT pu.username,prdt.role_id, prdt.role_name, prd.role_common_name FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd WHERE pu.user_id = pur.user_id AND pu.username = <:P_USERNAME> AND prdt.role_id = pur.role_id AND prdt.role_id = prd.role_id…
Read MoreOverview : Below query to give the organization information in Fusion Query: SELECT hra.organization_id as bu_id ,hro.name organization_name ,hra.business_group_id, hro.* FROM HR_ALL_ORGANIZATION_UNITS_F hra, HR_ORGANIZATION_UNITS_F_TL hro WHERE 1=1 hra.ORGANIZATION_ID =…
Read More