I need assistance with writing a SQL query to retrieve a list of users and their attached roles in Oracle Fusion. Specifically, I am looking for a query that can: Identify all users within the Oracle Fusion system. List the roles assigned ...
Oraask Latest Questions
I'm interested in understanding the consequences of changing a username in Oracle Fusion. Specifically, I'd like to know: Pending Approval Transactions: How are these transactions impacted by a username change? Database 'Who' Columns: What happens to the 'who' columns in ...
What is the syntax for using an IF condition in the 'Add Element by Expression' feature within the BI Data Model in Oracle Fusion?
I need to create an SQL query that retrieves information about BPM (Business Process Management) tasks in Oracle Fusion. What are the key tables and columns I should focus on, and could you provide an example query to get me ...
Need some help to get business unit information using BI query in Oracle fusion
I have written PL/SQL code to store XML into cursor. Refer the below code Requirement: As of line at line 83, I am inserting the result into another table (XML_GEN) as XMLTYPE datatype. Line: insert into xml_gen (fxdoc) values (i.FXML); But ...
In most cases in Oracle Fusion, we have tables ended with an underscore like "EGP_CATEGORIES_B_", and it's almost the exact version of the regular table, which is "EGP_CATEGORIES_B". So what is the difference, and when to query the ...
What are the key columns and their corresponding data types in the Inventory Item table in Oracle Fusion?
I have started using SQL Developer recently, and facing a problem when trying to select from APPS views that use multi-org like po_headers, ap_invoices, and so on. I tried some scripts to initialize the session, like fnd_global.apps_initialize but ...
Can you please someone help me to know what are the primary tables that are involved in the Return to Vendor transaction in Oracle APPS R12?