Thursday, September 17, 2009

Create Item approval procedure using eBS eRecords

For this procedure my main documentation has been:
Oracle® E-Records
Implementation Guide
Release 12.0
Part No. B40038-01
October 2006

In this link you will have interesting information about what erecords is and how use it.
download from http://download.oracle.com/docs/cd/B40089_10/current/acrobat/120edredrig.pdf

Before start:

- Be carefull with this note:
After Upgrade To 11.5.10. ''Create Business Event'' Button Disappear
Doc ID: 357679.1 Type: PROBLEM


- tips:
You need one of user has AME Application Administrator responsability else you couldn't create Approval groups and users



Overview:

You must complete the following steps to enable the E-Records functionality:

1. Enable profile options.
2. Enable the Event.
3. Enable the Subscription.
4. Set up Oracle Approval Manager Rules.
5. Set up Input Configuration Variables for Oracle Approval Manager Rules.
6. Run Concurrent Programs.


1.Enable Profile Options

-eSignatures Enabled






Wednesday, September 2, 2009

Flexfield

Some interesting querys regardless flexfield:

select APPLICATION_ID,ID_FLEX_CODE,ID_FLEX_NAME from FND_ID_FLEXS;
 return information about flexfield stored in our eBS.



select fdftl.title,

fdf.application_table_name
from apps.fnd_descriptive_flexs fdf,
apps.fnd_descriptive_flexs_tl fdftl
where fdf.descriptive_flexfield_name=
fdftl.descriptive_flexfield_name
and fdf.application_id='101'
and fdftl.title not like '$SRS$%'
order by fdftl.title;


order by fdftl.title;return information about flexfield about Oracle General Ledger- application ID 101 and not show information form flexfield used with SRC.

Information extracted from this:
http://www.jiltin.com/index.php/oracle-applications/11i-scripts/oracle-applications-key-flex-field-structures-how-to-retrieve-information/

Where is the tables, forms?

Tables are stored in DB datafiles(.dbf extension) on machine(ioversondb2) in this folder:/u02/oracle/iosatestdata

Importants tables:
FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS
for doing query into database you can use:
sqlplus user/password@instance_name
one trick for know the names of tables are use :


Forms are stored in OAS machine(ioversonas2) in this folder:/u02/oracle/iosatestappl/au/11.5.0/forms and US(for United State language) or E(for spanish language)

one trick is recover form name from eBS menu directly:

othe trick is use help-About Oracle Applications

How is the environment?

In my environment i have five servers, one for backup, two for test purposes and two more for production.

In Production Environment(PE), one of sever has installed oracle database(DB) and the other has Oracle Application Server(OAS). Test Environment(TE) has a copy of production environment and it's used for new developments, testing them, news products installation. When new developments has been checked then pass from TE to PE.

 In TE, i have installed two different eBS instances. One of them called  desa and the other called test.

Desa and test instance has differents folder in differents machines:
- In db machine(called ioversondb2):
              /u02/oracle/iosadesadata
        /u02/oracle/iosatestdata
with this datafiles:
archive01.dbf                a_ref02.dbf                      a_txn_ind04.dbf                 olap.dbf               a_archive02.dbf            a_summ01.dbf          a_txn_ind05.dbf            owad01.dbf                     a_int01.dbf                        a_tools01.dbf        cntrl03.dbf            portal01.dbf                a_media01.dbf           a_txn_data01.dbf                       ctxd01.dbf              temp01.dbf                      a_nolog01.dbf                     a_txn_data02.dbf         discoverer01.dbf           undo01.dbf                             a_queue01.dbf           a_txn_data03.dbf             log01b.dbf
undo02.dbf                 a_queue02.dbf             a_txn_ind01.dbf                       log02b.dbf               user_data01.dbf                archive a_txn_ind02.dbf log03b.dbf                  user_idx01.dbf            a_ref01.dbf                               a_txn_ind03.dbf        odm.dbf                         xx_data01.dbf          

- In oas machine(called ioversonas2):
 /u02/oracle/iosatestappl
/u02/oracle/iosatestcomn
/u02/oracle/iosatestora

/u02/oracle/iosadesaappl
/u02/oracle/iosadesacomn
/u02/oracle/iosadesaorap



Depending on login user: appltest or applmgr, then start .bash_profile within:
/u02/oracle/iosatestappl/APPSIOSATEST_ioversonas2.env for appltest

/u02/oracle/iosatestappl/APPSIOSADESA_ioversonas2.env for applmgr

inside APPSIOSATEST_ioversonas2.env appears very important path:

# APPL_TOP is the top-level directory for Oracle Applications.
APPL_TOP="/u02/oracle/iosatestappl"

eBS Overview

 A good start for understanding whar oracle e Business Suite is a series of link as below:

http://www.club-oracle.com/forums/what-is-oracle-applications-t49/