Profile cover photo
Profile photo
shiva kumar kandigatla
250 followers
250 followers
About
Communities and Collections
View all
Posts

Post has attachment
Convert Number into Time hours Minutes seconds in Oracle SQL
select to_char(trunc(70000/3600)) || to_char(to_date(mod(70000, 86400),'sssss'),':mi:ss') as time from dual; 
Add a comment...

Post has attachment
Menu Changes and Profile Options in Oracle Apps Sysadmin
function not available to this responsibility change responsibilities or contact System Administrator the Menu then run the program called "Compile Security" and Parameter is "Y". Help -> Examine -> failed Profile Option: "Hide Diagnostics menu entry"  set ...
Add a comment...

Post has attachment
Cost Manager in Inventory Oracle Application
The Inventory Cost Manager will kick off "Actual Cost Worker" Concurrent Program. You can see any errors or warning in this concurrent requests. Basically The Transactions not costed issues are: 1) Cost Cutoff date is past dated for that organization. 2) Co...
Add a comment...

Post has attachment
Item Cost Details Query in Oracle Applications
SELECT msi.segment1 "ITEM_NAME", msi.inventory_item_id, cic.item_cost, mp.organization_code, mp.organization_id, cct.cost_type, cct.description, cic.tl_material, cic.tl_material_overhead, cic.material_cost, cic.material_overhead_cost, cic.tl_item_cost,     ...
Add a comment...

Post has attachment
PO XLA GL and RCV XLA GL queries in Oracle Applications
/* Formatted on 2017/08/08 14:31 (Formatter Plus v4.8.8) */ SELECT poh.org_id, poh.segment1 po_num, pol.line_num, poll.shipment_num, por.release_num, pod.distribution_num, NVL (poll.price_override, pol.unit_price) unit_price, pod.quantity_ordered, pod.quant...
Add a comment...

Post has attachment
Inventory Material Transaction Accounting query in Oracle Apps
SELECT msi.segment1,ACCOUNTING_LINE_TYPE, mtt.TRANSACTION_TYPE_NAME,(select MEANING from apps.FND_LOOKUP_VALUES WHERE LOOKUP_CODE =A.ACCOUNTING_LINE_TYPE AND VIEW_APPLICATION_ID = 700 AND LANGUAGE = 'US' AND LOOKUP_TYPE = 'CST_ACCOUNTING_LINE_TYPE') ACCOUNT...
Add a comment...

Post has attachment
SLA Query and Information in Oracle Applications EBS
SELECT apl.application_name, xah.je_category_name,xev.EVENT_TYPE_CODE, xte.*   FROM xla.xla_transaction_entities xte,        xla.xla_events xev,        xla.xla_ae_headers xah,        xla.xla_ae_lines xal,        apps.fnd_application_vl apl  WHERE xev.entity...
Add a comment...

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...
Add a comment...

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...
Add a comment...

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...
Add a comment...
Wait while more posts are being loaded