Profile cover photo
Profile photo
shiva kumar kandigatla
254 followers
254 followers
About
shiva kumar kandigatla's interests
View all
shiva kumar kandigatla's posts

Post has attachment
How to find the process sid from concurrent request id in Oracle Applications or Oracle EBS
/* Formatted on 2017/07/17 16:22 (Formatter Plus v4.8.8) */ SELECT d.username,d.status, d.MACHINE, a.request_id, d.SID, d.serial#, d.osuser, d.process, c.spid, d.inst_id   FROM apps.fnd_concurrent_requests a,        apps.fnd_concurrent_processes b,        g...

Post has attachment
OAF Standard Page Debugging Process
Enable Profile option at user level FND: Debug Log Enabled = Yes FND: Debug Log Filename for Middle-Tier = NULL (Leave The field BLANK) FND: Debug Log Level = Statement FND: Debug Log Module = ICX% (Set the short name of the module you wish to debug Run the...

Post has attachment
OAF Personalizations Query
SELECT PATH.PATH_DOCID PERZ_DOC_ID, jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH FROM JDR_PATHS PATH WHERE PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization' AND COMP_I...

Post has attachment
How to call SQL Loader from Command Prompt
sqlldr username@server/password control=loader.ctl sqlldr username/password@server control=loader.ctl

Post has attachment
GL Period Status Query in Oracle Application
SELECT   sob.NAME "Set of Books", fnd.product_code "Product Code",          ps.period_name "Period Name", ps.start_date "Period Start Date",          ps.end_date "Period End Date",          DECODE (ps.closing_status,                  'O', 'O - Open',       ...

Post has attachment
To increase Oracle EBS Performance
We can run the program "Program - Optimizer" for each module. Then Run the Gather Statistics Program for Each module too to improve performance.

Post has attachment
Query has exceeded 200 rows in OAF
For this error set the Profile option "FND: View Object Max Fetch Size" to 999 at site level.

Post has attachment
Error looging on Table in PLSQL Oracle 11g Feature
CREATE TABLE TEST(
id NUMBER(10) NOT NULL,
code VARCHAR2(10) NOT NULL,
description VARCHAR2(50),
CONSTRAINT dest_pk PRIMARY KEY (id)
); -- Create the error logging table.
BEGIN
DBMS_ERRLOG.create_error_log (dml_table_name =>...

Post has attachment
Automatic Reversal query for General Ledger Entries in Oracle Applications
SELECT led.name,    jb.name batch_name,    jh.name journal_name,    jh.je_header_id,    jc.user_je_category_name,    jh.status, jh.period_name, jh.accrual_rev_status,jh.accrual_rev_period_name FROM gl.gl_je_headers jh,    gl.gl_je_batches jb,    gl.gl_autor...

Post has attachment
Query to find GL XLA AP Link invoices in Oracle Applications
SELECT   SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount,          invoice_num     FROM ap_invoices_all aia,          xla.xla_transaction_entities xte,          xla_ae_headers xah,          xla_ae_lines xal,          gl.gl_import_referenc...
Wait while more posts are being loaded