+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
The following is a Query to check if Oracle Apps Modules Licensed or not

Code sql:
SELECT fat.application_name
      ,fa.application_id
      ,fpi.patch_level
      ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
  FROM fnd_product_installations
...
Read More Read More
Published by
The following is a Query to display Responsibility wise profile Options and it's Values

Code sql:
SELECT fu.user_name
      ,fr.responsibility_name
      ,fpo.user_profile_option_name
      ,NVL(xxtest_sql(fpo.sql_validation,fpov.profile_option_value,
          fpo.profile_option_name),fpov.profile_option_value)
...
Read More Read More
Published by
The following is a Query to display Transaction Types in Receivables R12

Code sql:
--Transaction Types in Receivables R12
SELECT hou.name operating_unit
      ,xep.name legal_entity
      ,rctt.name      
      ,rctt.description
      ,al.meaning class
...
Read More Read More
Published by
Navigation
-----------

Receivables Resp--> Oracle Receivables-->Setup-->Receipts-->Receivable Activities

--Receivable Activities
---------------------------------
Code sql:
SELECT hou.name operating_unit
      ,arta.name
      ,arta.description
...
Read More Read More
Published by
Navigation
------------
Receivables Resp--> Oracle Receivables-->setup-->Receipts--> Receipt Sources
--Receipt Sources
------------------------------------------

Code sql:
SELECT hou.name operating_unit	
      ,absa.name	
      ,absa.description
...
Read More Read More
Published by
Navigation
----------

Receivables Resp--> Oracle receivables-->Setup-->Receipts-->Receipt Classes

Code sql:
--Receipt Class and Bank Accounts attached to them
SELECT arc.name
      ,al.meaning creation_method
      ,nvl(al1.meaning,'No Remittance')
...
Read More Read More
Published by
Navigation
-----------

Fixed Assets Manager Resp-->Setup-->Asset System-->Asset categories

Code sql:
--Asset Category Listing
SELECT fct.segment1||'.'||fct.segment2||'.'||fct.segment3||'.'||fct.segment4||'.'||fct.segment5 category
      ,fct.enabled_flag
...
Read More Read More
Published by
Query To Display Quarter for given date.....

Code sql:
SELECT sysdate
      ,(CASE WHEN to_char(given_date,'MON') IN ('JUN','JUL','AUG') THEN 'Q1' 
             WHEN to_char(given_date,'MON') IN ('SEP','OCT','NOV') THEN 'Q2' 
             WHEN to_char(given_date,'MON') IN ('DEC','JAN','FEB')
...
Read More Read More 1 Comment
Published by
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

Solution
---------

Hi All,

Recently I came across the above error.

I created one Global Temporary Table and insert the data in to that table like ...
Read More Read More
Published by
How To Find Missing Number?

Code sql:
---------------------------------------------------------------------------------
CREATE TABLE test2 (sno NUMBER);
---------------------------------------------------------------------------------
INSERT INTO test2 VALUES(1);
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7