Toggle navigation
Tutorials
Oracle DBA
Oracle Apps
Weblogic
Oracle DataGaurd
Oracle RAC
Linux
Important Queries and Scripts
Oracle Ace Journey
Contact US
Disclaimer
Sitemap
Submit
HAPPY NEW YEAR 2021
For Any queries,collaborations please mail us at support@funoracleapps.com
Compiling Objects in Database
Himanshu
1 comment
ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;
ALTER PROCEDURE my_procedure COMPILE;
ALTER FUNCTION my_function COMPILE;
ALTER TRIGGER my_trigger COMPILE;
ALTER VIEW my_view COMPILE;
Newer Post
Older Post
1 comment :
Ammie
March 12, 2020 at 10:51 PM
Hi, How i compile mass oracle reports 12c(rdf)??
Reply
Delete
Replies
Reply
Add comment
Load more...
Subscribe to:
Post Comments ( Atom )
Oracle Jobs - Via Jooble
Popular Posts
Query to find Responsibility for which Menu / Form Function is assigned
Query to find Responsibility for which Menu / Form Function is assigned To get responsibility based on Menu SELECT DISTINCT a.respon...
Understanding Different Phases for ADOP
In the previous post, we have seen an overview about ADOP . Now we will try to understand Various phases of ADOP in detail. Prepare Phase...
Finding Scheduled Concurrent Program
The below query can be used for getting all the details for a scheduled concurrent program. select a.requested_by,a.status_code,a.phase...
Query to find Form Function attached to which Responsibility
Query to find Form Function attached to which Responsibility Script: SELECT DISTINCT faa.application_name application, rtl.respon...
Finding the Weblogic URL and Port from R12.2 Context File
We can find the weblogic URL and port from the CONTEXT_FILE by using the below variable. Steps: 1. Go to Application Tier 2. Set the R...
Query to get list of EBS users with responsibility and last login date (responsibility wise)
Query to get list of EBS users with responsibility and last login date (responsibility wise) Script: SELECT usr.user_name, rsp.respo...
FRMCMP for FMB and PLL compilation
frmcmp Module=<pll name> Userid=<userid/password> [Parameters]. Optional parameters with default values given: Mo...
FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508
Error: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508 Cause: This may be occur while opening forms after clone or if ...
Query to find Concurrent Request Details from Concurrent Program Name
Query to find Concurrent Request Details from Concurrent Program Name Script SELECT distinct user_concurrent_program...
Stopping and Starting RAC Services
STOP ORACLE RAC 1. emctl stop dbconsole 2. srvctl stop listener -n racnode1 3. srvctl stop database -d RACDB 4. srvctl stop ...
Have you taken taking from me!! Request for a Certificate
"Certificate is just to showcase your learning! Its not the measurement of your Knowledge". Please note this section will be opened for students
About Me
I am an Oracle Ace
UrbanPro
Followers
CONTACT US
Articles Index
►
21
(29)
►
Feb
(13)
►
Jan
(16)
►
20
(148)
►
Dec
(11)
►
Nov
(22)
►
Oct
(16)
►
Sep
(14)
►
Aug
(11)
►
Jul
(4)
►
Jun
(15)
►
May
(13)
►
Apr
(18)
►
Mar
(13)
►
Feb
(6)
►
Jan
(5)
►
19
(55)
►
Dec
(4)
►
Nov
(5)
►
Oct
(5)
►
Sep
(5)
►
Aug
(3)
►
Jul
(3)
►
May
(9)
►
Apr
(7)
►
Mar
(4)
►
Feb
(5)
►
Jan
(5)
►
18
(48)
►
Nov
(1)
►
Oct
(1)
►
Sep
(3)
►
Aug
(2)
►
Jul
(3)
►
Jun
(7)
►
May
(11)
►
Apr
(6)
►
Mar
(4)
►
Feb
(2)
►
Jan
(8)
►
17
(16)
►
Aug
(1)
►
Apr
(3)
►
Feb
(10)
►
Jan
(2)
►
16
(1)
►
Dec
(1)
►
15
(3)
►
Nov
(2)
►
May
(1)
►
14
(14)
►
May
(4)
►
Mar
(9)
►
Jan
(1)
►
13
(35)
►
Dec
(3)
►
Nov
(3)
►
Oct
(4)
►
Sep
(8)
►
Aug
(5)
►
Jul
(2)
►
May
(10)
▼
12
(61)
►
Dec
(7)
►
Oct
(5)
►
Sep
(2)
►
Aug
(4)
►
Jul
(5)
►
Jun
(12)
►
May
(5)
►
Apr
(1)
▼
Mar
(20)
Identifying Various Services Running on Applicatio...
Locating and Creating the Context File
Internal Concurrent Manager status could not be de...
Getting Source for Objects in Oracle Database
Log Files Location In Oracle Apps
FNDLOAD
MWA Mobile Web Appilcation
JSP File Compilation
Terminating a Concurrent Requests
Check the Concurrent requests which are running
FND_NODES
Finding time required for Gather Stats
FNDCPASS
FNDFS and FNDSM
Stopping Concurrent Manager
Getting current Session ID
Different states of Concurrent Manager
Explaination of Different Status Code and Phase co...
Compiling Objects in Database
FRMCMP for FMB and PLL compilation
Copyright Funoracleapps.com@2020. Powered by
Blogger
.
Hi, How i compile mass oracle reports 12c(rdf)??
ReplyDelete