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.
How to find the last refresh date for the TEST environment (P2T) in Fusion ERP
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.
the last_update_date column in this table gives the completion date of last refresh date.
See lessIs There Any Depreciation Projection Report Available in Oracle Fusion?
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 lessWhat is the difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in Oracle Fusion
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:
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 lessQuery 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 less