Need some help to get business unit information using BI query in Oracle fusion
Oraask Latest Questions
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?
Can somebody provide some guidance on how to use the API to close workflow notifications in Oracle APPS R12? I am having trouble figuring out the proper syntax and steps to take. any help will be appreciated.
Could you please somebody help me with a query to list supplier details in Oracle Apps R12
I need to get only posted AP invoices in Oracle EBS R12. Is there any function to check with whether an invoice is posted or not?
How to know the queries running for x minutes or y seconds in Oracle database