+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
The Oracle database is an object-relational database management (RDBMS) system developed by Oracle. The data are physically stored in the Oracle database in the form of data files. Today, oracle database is widely used across various organizations. It has various features and advantages including the ...
Read More Read More
Published by
Page Break Before:

The Page Break Before property indicates that you want the object to be formatted on the page after the page on which it is initially triggered to print. Note that this does not necessarily mean that all the objects below the object with Page Break Before will move ...
Read More Read More
Published by
Recently I come across one issue. I have a XMLP report which is giving excel output. So when I ran the report, In invoice_number column it is showing 2.01213E+12

But actually Invoice number is 2012131000014.

If it is 2012131000015 also it will show as 2.01213E+12.
...
Read More Read More
Published by
The below code is forr a Program used to submit a concurrent program (XML Publisher) from backend.

Code sql:
DECLARE
-- This program is used to submit an concurrent program (XML Publisher) from back end.--
l_responsibility_id NUMBER;
l_application_id     NUMBER;
l_user_id
...
Read More Read More
Published by
Purpose

This code is a generic version of a function posted recently by Jagadekara to calculate the sum of all digits of a given number up to a single digit which was limited to a 12 digit number.

This new function aims at removing this restriction and works for any number ...
Read More Read More
Published by
Code sql:
SELECT fif.id_flex_name
      ,fifs.id_flex_structure_name
      ,ffksv.parent_segment_name
      ,ffvrv.flex_value_rule_name
      ,ffvrv.description
      ,ffvrv.error_message
      ,decode(ffvrl.include_exclude_indicator,'I','Include','E','Exclude')
...
Read More Read More
Published by
Query to display Finacial Options details in Oracle apps R12

Payables
Set Up
Options
Financial Options

Code sql:
SELECT hou.name "Operating Unit"
      ,fsp.future_period_limit 
      ,gcck.concatenated_segments
...
Read More Read More
Published by
Query to Display Payables Options Details In Oracle Apps R12

Code sql:
-------------------------------------------------------------
SELECT hou.name "Operating unit"
-------Accounting Option Tab Details--------------------------------------------
      ,aspa.when_to_account_pmt
...
Read More Read More 1 Comment
Published by
Query To Display All Forms and Pages for a Responsibility In Oracle Applications R12

Code sql:
SELECT  fmev.prompt , user_function_name,TYPE
FROM (SELECT * FROM fnd_menu_entries_vl WHERE prompt IS NOT NULL AND grant_flag ='Y' ) fmev
    , fnd_form_functions_vl ffv
WHERE fmev.function_id
...
Read More Read More
Published by
Opened Forms details Query

Code sql:
SELECT ffv.user_form_name, ff.FUNCTION_ID, ff.FUNCTION_name
    ,to_char(flr.end_time,'dd-mon-yyyy hh24:mi:ss')  end_time
    , to_char(flr.start_time,'dd-mon-yyyy hh24:mi:ss')  start_time,
      (flr.end_time - flr.start_time)*24*60 duration
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7