Technology Changes in R12 By Avinash And Rahul


Technology Changes in R12

Technologies Used:
 OA Framework (Replacing Oracle Forms)
BI Publisher (XML publisher) (Replacing Oracle Reports and Discoverer)
 BEPL (Replacing Workflow Builder)
 Java, Java Scripting (Replaces PL/SQL)

Existing objects in Oracle Forms, Reports, Discoverer, Workflow Builder and PLSQL are
working as it is but all the new development is done in OA Framework, BI Publisher,
BEPL, Java and Java Scripting etc.

Multi Org Access Control (MOAC) is introduced.

From Release 12 the Multi-Org Access Control feature, will enable users to
access data in one or more Operating Units from a single responsibility. This
feature allows users in a shared services environment to access/transact data
within several operating units from a single responsibility at the same time
restricting access to other users through a security policy. This allows flexibility
and convenience for shared service users. At same time you can prevent access
to data from users who are not authorized to access this information. Before
Release 12, users were limited to access information only from within the context
of their own operating unit from a single responsibility.

Virtual Private Database (VPD) feature introduced will replace usage of
CLIENT_INFO(Org Context) function in Multi-Org Architecture. All calls made to
previous org context function will not work any longer. All such views/synonyms
will need to be accessed only through security profile.

For eg. previously following script could be run for accessing information in
po_headers view.

begin
dbms_application_info.set_client_info('&org_id');
end;
/
select * from ap_invoices;
/
But in R12 the above will not work unless we request access through Security
Policy in the database. MO_GLOBAL package can be used to obtain this access.
This is true with Workflow packages.
Also custom forms and reports need to be initialized to secure access through
security profile.

In your design you need to consider future possibility of the customizations and
extensions being used in a shared services environment. This will mean
additional task for eg. addition of Operating Unit filed to your LOVs or joining your
queries explicitly with org_id when tables or views have Operating Unit sensitive
data.

Subledger accounting concept

1. Set Of Books is replaced by the term Ledger. The column set_of_books_id
has been replaced with ledger_id in Gl Tables

2. Subledger Accounting (SLA) options has been introduced and accounting
entries can be viewed at SLA menu

3. Accounting entries can be created manually at SLA level and can be imported
to GL by doing the journal import

4. As a part of Subledger Accounting, new SLA tables XLA_AE_HEADERS and
XLA_AE_LINES have been introduced.


5. PO details are not available in reference columns(reference_1,reference_2...)
in GL_JE_LINES and GL_BC_PACKETS. Hence accounting entries in these
tables can be retrieved only using SLA tables and GL_IMPORT_REFERENCES
6. Receiving Subledger is not directly linked to GL_JE_LINES,instead it is linked
through the subledger tables XLA_AE_HEADERS and XLA_AE_LINES.
XLA_AE_LINES is mapped to GL_IMPORT_REFERENCES with the
gl_sl_link_id and gl_sl_link_table columns. The linking columns between
GL_IMPORT_REFERENCES and GL_JE_LINES are je_header_id and
je_line_num


Let us take the example of Encumbrance Entries. Below are the differences in
Behavior between 11i and 12i:

1. In 11i, Encumbrance entries created in GL_BC_PACKETS will be directly
moved to GL_JE_LINES by running the CJE program, whereas in 12i,
Encumbrance entries gets generated in a new table PO_BC_DISTRIBUTIONS in
addition to GL_BC_PACKETS. These entries will be moved to GL by running the
program "Transfer Journal Entries to GL" instead of CJE program.

2. In 11i, it is not possible to view the Encumbrance entries in Purchasing
module, where as in 12i, the entries can be viewed from SLA menu in
Purchasing

3. In 11i, a Credit against the Reserve For Encumbrance a/c (RFE) can be seen
only at the time of posting the Encumbrance Debit entry in GL, But in 12i, RFE
a/c gets credited along with the PO Reservation ( budget a/c debit entry) and
these entries can be viewed from SLA menu in Purchasing

Oracle Integration Repository is being introduced instead of API guide.