APPS-ORACLE.RU

New improvements have been introduced into OA Personalization Framework:

• An administrator can create a SQL-based read only view object through Personalizations and bind it to new items on a page. This feature lets administrators declaratively add new content from Oracle E-Business Suite tables to an existing page.
[...]

New improvements have been introduced into OA Personalization Framework:

• An administrator can create a SQL-based read only view object through Personalizations and bind it to new items on a page. This feature lets administrators declaratively add new content from Oracle E-Business Suite tables to an existing page.

• More item types [...]

New in release R12.2
Record History now shows user names rather than user IDs for the ‘Last Updated By’ and ‘Created By’ fields.

Release 12.1.1
Record History is a feature that allows a user to see data about a particular record, such as who created the record and [...]

New in release R12.2
Record History now shows user names rather than user IDs for the ‘Last Updated By' and ‘Created By' fields.

Release 12.1.1
Record History is a feature that allows a user to see data about a particular record, such as who created the record and when, and who most recently [...]

ADF Integration with Oracle apps release 12.1.3

Release 11g applications deployed on an Oracle Fusion Middleware Release 11g container from the Oracle E-Business Suite home page. Each ADF application will have an FND Function of type ‘ADFX’ defined for it.

If such a function is granted to a [...]

ADF Integration with Oracle apps release 12.1.3

Release 11g applications deployed on an Oracle Fusion Middleware Release 11g container from the Oracle E-Business Suite home page. Each ADF application will have an FND Function of type ‘ADFX' defined for it.

If such a function is granted to a user, then when the [...]

Finally long wait for Oracle E-Business Suite 12.2 is over. Now officially available from OracleOracle E-Business Suite 12.2 Now Available
Cheers!!!
[...]

Анонс
Обзор изменений (требуется доступ на support.oracle.com) [...]

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/poster/OUTPUT_poster/poster.html#tab_1 [...]

declare
type tablas_t is table of varchar2(64) index by binary_integer ;
tablas_tab tablas_t ;
titulos_tab tablas_t ;
begin
tablas_tab(1) := 'XXAMX_CABECERAS_PEDIDO' ;
tablas_tab(2) := 'XXAMX_LINEAS_PEDIDO' ;
titulos_tab(1) := 'XXAMX - Cabeceras Pedido' ;
titulos_tab(2) := 'XXAMX [...]

При выдаче привилегии GRANT SELECT на таблицу пользователь другой схемы данных поличивший привилегию кроме возможности чтения данных получает неявно возможность заблокировать данные командой select for update. [...]

1.Наконец появился синтаксис для страничной выборки данных.
Синтаксис таков.

Пример выборки пяти первых записей.

SQL> create table t
2 as
3 select * from all_objects;
Table created.

SQL> create index t_idx
on t(owner,object_name);
Index created.

SQL> select owner, [...]

Source: http://www.oracle-developer.net/display.php?id=513

The external table preprocessor was introduced in 11g Release 1 (patchset 11.1.0.7) and formally documented in 11g Release 2. Briefly, the preprocessor enables us to define an executable or shell/batch script that can be used to generate a rowsource for the external table [...]

Источник - http://apps-oracle.ru/regexp_replace_only_char_number/ with t as (select '#2 apps(0_-ORACLE+*.ru_ )ПРИ13мер' str from dual)select str , regexp_replace(str,'*[^[[:alpha:]]]*') as only_char , regexp_replace(str,'*[^[[:digit:]]]*') as only_numberfrom t/ STR [...]

Common information about Host Concurrent Program, find on many web-sites

---------------------------------------
SOURCE: http://oracleappsnotes.wordpress.com/2012/02/21/all-about-host-concurrent-programs/
---------------------------------------

One of the things to remember while registering a host concurrent program is that the first five parameters are reserved by Oracle E-Business Suite for its own use. The sixth parameter onwards [...]

Oracle Text - это бесплатная компонента, входящая в состав Oracle Database, предназначенная для создания приложений с использованием полнотекстового поиска. В предыдущих версиях Oracle имела также названия ConText и interMedia Text. Начиная с 11ой версии входит во все редакции СУБД.

Полнотекстовый поиск - это поиск документов в базе данных текстов [...]

Oracle Text - это бесплатная компонента, входящая в состав Oracle Database, предназначенная для создания приложений с использованием полнотекстового поиска. В предыдущих версиях Oracle имела также названия ConText и interMedia Text. Начиная с 11ой версии входит во все редакции СУБД.

Полнотекстовый поиск - поиск документов в базе данных текстов с использованием полнотекстового [...]

Oracle SQL Developer Allround Automations PL/SQL Developer Quest Software SQL Navigator Quest Software TOAD EMS SQL Management Studio for Oracle Embarcadero DBArtisan SQLTools for Oracle AquaFold Aqua Data Studio TOra dbForge Studio for Oracle Alt SQL Developer for [...]

Добавлена статья Поиск не индексированных внешних ключей в Oracle [...]

http://habrahabr.ru/post/129018/http://psoug.org/reference/xml_functions.htmlhttp://martin-mares.com/2010/08/oracle-db-how-to-processing-xml-with-multiple-nodes-xmlsequence/http://citforum.ru/database/oracle/xml-oracle/http://www.oracle-base.com/articles/9i/parse-xml-documents-9i.phphttp://docs.oracle.com/cd/B10501_01/appdev.920/a96621/adx20ppl.htm [...]

http://oracleappsnet.blogspot.comhttp://shivakumarkura.blogspot.comhttp://psoug.org/snippet/Create-User-example_85.htmhttp://www.oracle-base.comhttp://oracleappsnet.blogspot.comhttp://www.blog.unimansys.comhttp://oraclemaniac.comhttp://www.oracleappshub.comhttp://www.oracleerp4u.comhttp://oracle.amox.mx [...]

Здесь собраны полезные ссылки на статьи о создании шаблонов EXCEL

https://blogs.oracle.com/xmlpublisher/entry/real_excel_templates_ihttp://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T527073T571887.htm [...]

Найти описание ошибки по ее коду можно в разделе Oracle® Database Error Messages официального сайта Oracle Database Documentation Library. Если же у вас нет доступа в интернет, то можно воспользоваться утилитой oerr, которую можно найти в папке bin сервера. К сожалению, и в первом и во [...]

Найти описание ошибки по ее коду можно в разделе Oracle� Database Error Messages официального сайта Oracle Database Documentation Library. Если же у вас нет доступа в интернет, то можно воспользоваться утилитой oerr, которую можно найти в папке bin сервера. К сожалению, и в первом и во [...]

1] Add A Row: To add an ‘Add a Row’ button, in the advanced table, go to Advanced Table > Advanced Table Components > Footer > Table Footer > New > Add A Row. In the Structure pane, select the addTableRow item that is newly created, as shown in the [...]

1] Naming Standards for a Custom Package: If you want to create new pages, business logic, or whole applications and deploy your code with existing Oracle E-Business Suite applications, you must define a new application and use its short name for any related package and seed data definitions. For example, [...]

In March 2013, First book dedicatedly on OAF was published. This book “Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook” is authored by Andy Penver, who is having around 18 years of experience around Oracle E-Business Suite applications. In this post I will [...]

In March 2013, First book dedicatedly on OAF was published. This book “Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook” is authored by Andy Penver, who is having around 18 years of experience around Oracle E-Business Suite applications. In this post I will share [...]

Эту ошибку получаем при возникновении проблем с UNDO пространством.

Предлагаю стандартное решение.

[...]