PL/SQL Normal Insert and Bulk Insert

PL/SQL NORMAL INSERT AND BULK INSERT

create table forall_test (
  id           number(10),
  code         varchar2(10),
  description  varchar2(50));

alter table forall_test add (
  constraint forall_test_pk primary key (id));

alter table forall_test add (
  constraint forall_test_uk unique (code));

set serveroutput on


declare
  type t_forall_test_tab is table of forall_test%rowtype;

  l_tab    t_forall_test_tab := t_forall_test_tab();
  l_start  number;
  l_size   number            := 10000;
begin
  -- populate collection.
  for i in 1 .. l_size loop
    l_tab.extend;

    l_tab(l_tab.last).id          := i;
    l_tab(l_tab.last).code        := to_char(i);
    l_tab(l_tab.last).description := 'description: ' || to_char(i);
  end loop;

--  execute immediate 'truncate table forall_test';

  -- time regular inserts.
  l_start := dbms_utility.get_time;

  for i in l_tab.first .. l_tab.last loop
    insert into forall_test (id, code, description)
    values (l_tab(i).id, l_tab(i).code, l_tab(i).description);
  end loop;
 

  dbms_output.put_line('normal inserts: ' ||
                       (dbms_utility.get_time - l_start));
 
  execute immediate 'truncate table forall_test';

  -- time bulk inserts.
  l_start := dbms_utility.get_time;

  forall i in l_tab.first .. l_tab.last
    insert into forall_test values l_tab(i);

  dbms_output.put_line('bulk inserts  : ' ||
                       (dbms_utility.get_time - l_start));

  commit;
end;

/

how to find values set values

select * from fnd_flex_value_sets where flex_value_set_name='p_conv_opt'--flex_value_set_id=1015234

 select flex_value          ,
  flex_value_meaning        ,
  description               ,
  enabled_flag              ,
  start_date_active         ,
  end_date_active           ,
  summary_flag              ,
  hierarchy_level           ,
  flex_value_set_id         ,
  parent_flex_value_low     ,
  parent_flex_value_high    ,
  flex_value_id             ,
  last_update_date          ,
  last_updated_by           ,
  structured_hierarchy_level,
  compiled_value_attributes ,
  value_category            ,
  attribute1                ,
  attribute2                ,
  attribute3                ,
  attribute4                ,
  attribute5                ,
  attribute6                ,
  attribute7                ,
  attribute8                ,
  attribute9                ,
  attribute10               ,
  created_by                ,
  creation_date             ,
  last_update_login         ,
  attribute11               ,
  attribute12               ,
  attribute13               ,
  attribute14               ,
  attribute15               ,
  attribute16               ,
  attribute17               ,
  attribute18               ,
  attribute19               ,
  attribute20               ,
  attribute21               ,
  attribute22               ,
  attribute23               ,
  attribute24               ,
  attribute25               ,
  attribute26               ,
  attribute27               ,
  attribute28               ,
  attribute29               ,
  attribute30               ,
  attribute31               ,
  attribute32               ,
  attribute33               ,
  attribute34               ,
  attribute35               ,
  attribute36               ,
  attribute37               ,
  attribute38               ,
  attribute39               ,
  attribute40               ,
  attribute41               ,
  attribute42               ,
  attribute43               ,
  attribute44               ,
  attribute45               ,
  attribute46               ,
  attribute47               ,
  attribute48               ,
  attribute49               ,
  attribute50               ,
  attribute_sort_order      ,
  row_id
   from fnd_flex_values_vl
  where ((''                   is null)
or (structured_hierarchy_level in
  (select hierarchy_id
     from fnd_flex_hierarchies_vl h
    where h.flex_value_set_id = 1015234
  and h.hierarchy_name like ''
  )))
and (flex_value_set_id=1015234)
rder by flex_value

Enable or Disable Help Diagnostics Examine

Profile Option:
Utilities:Diagnostics - Yes (if you set to YES at site level the Help -> Diagnostics -> Examine can access without passwork asking)
Utilities:Diagnostics - No (If you set to NO at site level no one can access the Help -> Diagnostics -> Examine and other optoins)

Go to System Administrator Responsibility=>profile=>system=>on which level you want to set =>Utilities:Diagnostics - Yes

Record History is not available here

Record History is not available here ?
Sol."FND:Record History Enabled" could be set to Yes


Go to System Administrator =>Profile => System=>user --Give Your Users Name

and 

find FND:Record History Enabled

set yes at User Level.

Document Category Override Payables option is disabled

Applies to:

Internet Expenses - Version: 12.0.4
This problem can occur on any platform.

Symptoms

Expense Report Export is rejecting an expense report with the
Rejection Description:
Document Category Override Payables option is disabled

Cause

Oracle Payables Responsibility
Navigation:  Setup -> Options -> Payables
Invoice tab -> Main Section
Allow Document Category Override was unchecked.

Solution

1)  Access the appropriate Oracle Payables Responsibility
2)  Navigation: Setup -> Options -> Payables
     Invoice tab -> Main Section
3)  Check:  Allow Document Category Override 

R12 Customer Contacts Query

SELECT hcasa.org_id,
  role_acct.account_number,
  hcasa.orig_system_reference,
  rel.subject_id,rel.object_id
  ,party.party_id                                           party_id,
  rel_party.party_id                                      rel_party_id,
  acct_role.cust_account_id                         ,
  acct_role.cust_acct_site_id                        ,
  party.person_pre_name_adjunct                 contact_prefix,
  substr(party.person_first_name, 1, 40)       contact_first_name,
  substr(party.person_middle_name, 1, 40)  contact_middle_name,
  substr(party.person_last_name, 1, 50)        contact_last_name,
  party.person_name_suffix                           contact_suffix,
  acct_role.status, org_cont.job_title             contact_job_title,
  org_cont.job_title_code                              contact_job_title_code,
  rel_party.address1                                       contact_address1,
  rel_party.address2                                       contact_address2,
  rel_party.address3                                       contact_address3,
  rel_party.address4                                       contact_address4,
  rel_party.country                                         contact_country,
  rel_party.state                                              contact_state,
  rel_party.city                                               contact_city,
  rel_party.county                                          contact_county,
  rel_party.postal_code                                  contact_postal_code
FROM    hz_contact_points                         cont_point,
        hz_cust_account_roles                         acct_role,
        hz_parties                                             party,
        hz_parties                                             rel_party,
        hz_relationships                                   rel,
        hz_org_contacts                                   org_cont,
        hz_cust_accounts                                 role_acct,
        hz_contact_restrictions                        cont_res,
        hz_person_language                            per_lang,
        hz_cust_acct_sites_all                        hcasa
WHERE   acct_role.party_id                   = rel.party_id
  and   acct_role.role_type                        = 'CONTACT'
  and   org_cont.party_relationship_id      = rel.relationship_id
  and   rel.subject_id                                  = party.party_id
  and   rel_party.party_id                           = rel.party_id
  and   cont_point.owner_table_id(+)        = rel_party.party_id
  and   cont_point.contact_point_type(+)   = 'EMAIL'
  and   cont_point.primary_flag(+)            = 'Y'
  and   acct_role.cust_account_id              = role_acct.cust_account_id
  and   role_acct.party_id                          =  rel.object_id
  and   party.party_id                                 = per_lang.party_id(+)
  and   per_lang.native_language(+)         = 'Y'
  and   party.party_id                                 = cont_res.subject_id(+)
  and   cont_res.subject_table(+)               = 'HZ_PARTIES'
  and   role_acct.cust_account_id              =  hcasa.cust_account_id
  and   hcasa.cust_acct_site_id                  =  acct_role.cust_acct_site_id
--  and   acct_role.cust_account_id           =  p_customer_id --3177
--  and   acct_role.cust_acct_site_id         =  p_address_id
--  and   hcasa.org_id                                =  90

Basics of R12

How to Initialize Apps in BACK END ?


Ans.


BEGIN
fnd_global.apps_initialize(user_id => fnd_global.USER_ID,resp_id => fnd_global.RESP_ID,resp_appl_id => fnd_global.RESP_APPL_ID);
end;