How to Clear Apache Cache (Oracle EBS General) Steps to Clear Apache Cache Step – 1 Navigate to Functional Administrator responsibility. Step – 2 Go to: Home > Core Services > Caching Framework Step – 3 Go to: Global Configuration > Clear All Cache. Click Apply. Apache Cache is now clear.
Here’s how you can see whether a patch has been applied or not, how many patches have been applied in the given days, patches details and history. Navigate to System Administrator Responsibility > System Administration > Oracle Applications Manager > Patching and Utilities – Enter the Number of Days or Date Range to see which […]
Background:When we run, the following SQL Query/Script will provide the profile option values set at different levels. That is Site, Application, Responsibility, User.So, this script lists ALL Users/Responsibilities/Applications set against a particular Profile optionSQL Script:Enter ‘Profile Option Name’ while running this query.Eg. FND: Debug Log Enabled, MO: Operating Unit[You can get the exact name from table fnd_profile_options_tl] […]
Developing XML Publisher Report – Using Data Template as Data Source Background: Developing XML Publisher Report – Using Data Template(.xml) as Data Source and Template(.rtf) as Layout.Note that, we can use .rdf file as data source. But for this demo we are using Date XML Template. Prerequisite for the below Example: 1. Create a tableCREATE TABLE […]
Standard Package : INV_CONVERT Get the Conversion rate from below function easily. FUNCTION inv_um_convert (p_item_id IN NUMBER, p_from_uom_code IN VARCHAR2, p_to_uom_code IN VARCHAR2) RETURN NUMBER; select msi.segment1, msi.primary_uom_code, […]
Recent Comments