History of Oracle and its ERP Versions

History  of Oracle and its ERP Versions

 

Oracle Corporation was co-founded by Ellison and Bob Miner and Ed Oates in 1977 under the name Software Development Laboratories (SDL).

In 1979 SDL changed its name to Relational Software, Inc. (RSI).

In 1982, RSI renamed itself Oracle Systems Corporation to align itself more closely with its flagship product Oracle Database.

At this stage Bob Miner served as the company's senior programmer.

 

In 1995, Oracle Systems Corporation changed its name to Oracle Corporation.

 

On March 12, 1986: Oracle gone public with revenues of $55 million USD.

Oracle E-Business Suite started life as Oracle Financials in 1987. 

August 1987: Oracle founds its Applications division, building business-management software closely integrated with its database software.

Oracle Corporation acquired TCI for its project management software.

October 1987: Oracle Applications Release 1

Sometime in August 1988 they released their first ERP application called accounting system that has only general Ledger functionality enabled.

This is one of the reason of having General ledger application_id is 101.

November 1988: Release 3

January 1989: Release 4

May 1989: Release 5

October 1989: Release 6

May 1990: Release 7

November 1990: Release 8

June 1992: Release 9

1995: Release 10

Release 10 Sub versions are 10.7NCA, 10.7.16.1, 10.7

April 1998: Release 11

Release 11 sub versions are 11.0, 11.0.1, 11.0.2, 11.0.3

July 16, 1998: First combined production installation of Oracle Applications Release 10.7 NCA at Leeson Electric Corporation.

May 1999: Release 11.0.3

May 2000: Release 11.5.1

11i Sub Versions are 11.5, 11.5.1, 11.5.2, 11.5.3, 11.5.4, 11.5.5, 11.5.6, 11.5.7, 11.5.8, 11.5.9, 11.5.10.0, 11.5.10.1, 11.5.10.2.

Oct 2000: Release 11.5.2

Jan 2001: Release 11.5.3

Jun 2001: Release 11.5.4

Sep 2001: Release 11.5.5

Jan 2002: Release 11.5.6

May 2002: Release 11.5.7

Nov 2002: Release 11.5.8

Jun 2003: Release 11.5.9

Nov 2004: Release 11.5.10

Feb 2006: Release 11.5.10.2

Jan 2007: Release R12.0.0

R12 Sub Versions are 12.0.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, 12.0.5, 12.0.6, 12.0.7, 12.1, 12.1.1, 12.1.2, 12.1.3 and latest version is R12.2.2 31

26th Apr 2007: R12.0.1 Released

18th Jul 2007: R12.0.2 Released

16th Oct 2007: R12.0.3 Released

15th Jan 2008: R12.0.4 Released

7th Nov 2008: R12.0.6 Released

4th May 2009: R12.1.1 Released

17th Dec 2009: R12.1.2 Released 

20th Aug 2010: R12.1.3 Released

19th Sep 2013: R12.2 (R12.2.1) Released

20th Sep 2013: R12.2.2 Released

16th Dec 2013: R12.2.3 Released      

And so on….

How to check the responsibility for a concurrent program or report

SELECT --fr.responsibility_id,
         frt.responsibility_name,
         fr.responsibility_key,
         fr.start_date,
         fr.end_date,
         frt.description,
         --fr.request_group_id,
         --rgu.application_id,
         rg.request_group_name,
         --rg.description rq_desc,
         --rgu.request_unit_id,
         rg.request_group_code,
         --cp.concurrent_program_id,
         CP.CONCURRENT_PROGRAM_NAME,
         cp.enabled_flag program_enabled,
         cpt.user_concurrent_program_name,
         cpt.description ccp_desc
    FROM fnd_responsibility_tl frt,
         fnd_responsibility fr,
         FND_REQUEST_GROUP_UNITS rgu                --appid, rqgid, uaid,rquid
                                    ,
         fnd_request_groups rg                           --appid,rqgid,rqgcode
                              ,
         fnd_concurrent_programs cp --application_id, concurrent_program_id, concurrent_program_name, enabled_flag
                                   ,
         FND_CONCURRENT_PROGRAMS_TL cpt -- application_id, concurrent_program_id, user_concurrent_program_name, description
   WHERE     cp.application_id = cpt.application_id
         AND cp.concurrent_program_id = cpt.concurrent_program_id
         AND rgu.application_id = rg.application_id
         AND cp.concurrent_program_id = rgu.request_unit_id
         AND rgu.request_group_id = rg.request_group_id
         -- does something, sometimes null for valid items
         --and request_group_code is not null
         AND fr.request_group_id = rg.request_group_id
         AND frt.application_id = fr.application_id
         AND frt.responsibility_id = fr.responsibility_id
         --frt.responsibility_name like 'General Ledger Supervisor'
         --and fr.responsibility_id = '2222'
         AND rgu.request_unit_type = 'P'
         --REQUEST GROUP
         --and upper(rg.request_group_name) like upper(:REQ_GRP_NAME)
         --PROGRAM READABLE NAME
         AND UPPER (cpt.user_concurrent_program_name) LIKE UPPER (:CONCURRENT_PROGRAM_FULL_NAME)
         --PROGRAM SHORT NAME
         --AND upper(cp.concurrent_program_name) LIKE upper(:CONCURRENT_PROGRAM_SHRT_NAME)
ORDER BY cp.concurrent_program_name

How to enable Audit Trail functionality in Oracle apps R12.2.8

How to enable Audit Trail functionality in Oracle apps

Step 1: Select the module, the intended table belongs to, to be enabled for this functionality.

Navigation: System Administrator > Security > Audit Trail > Install

Query the module to be enabled:

Step 2: Create the Audit Group where we can have single or multiple tables belonging to the Application(module).

Navigation: System Administrator > Security > Audit Trail > Group

Step 3: Select the columns of the selected tables under Audit Group.

Navigation: System Administrator > Security > Audit Trail > Tables

Step 4: Create Audit Industry Template for the group that we have created. A single template can have multiple groups.

Navigation: System Administrator > Security > Audit Trail > Audit Trail Reporting > Audit Industry Template

Step 5: Validate the setup.

Navigation: System Administrator > Security > Audit Trail > Audit Trail Reporting > Audit Hierarchy Navigator

On this form, we can see the linking between

·         Audit Industry Template

·         Audit Group

·         Tables

·         Columns (of the tables) enabled for Audit trail

Step 6: Run the concurrent programs to enable audit trail functionality for the above setups:

Please follow the sequence

1)      AuditTrail Update Tables (No parameters)

2)      AuditTrail Report for Audit Group Validation (Parameter as Group Name)

Step 7: Perform transaction in which, data in our required table will be populated/modified.

Step 8: Run the report to print the audit trail.

Navigation: System Administrator > Security > Audit Trail > Audit Trail Reporting > Audit Report

Select the columns to be printed in report in the desired sequence: Press “Select column” Button and the select the columns to be printed. 

Press Run Report Button.

Solution for Budgetary control where Encumberance enablement is not feasible

Solution for Budgetary control where Encumberance enablement is not feasible:

Make a custom form to show all requisitions
requisitions converted to PO and standalone requisitions
all direct invoices
all direct PO and invoices
having the account codes: lets say dept and natural account.

Club all and show the total.

Keep one approver (just before the final approver) who can verify this for approving the requisition.
He will have the account code in approval notification, his task would be just to search the account code and he will come to know allocated, consumed budget and pending budget

Roles required to enable Procurement functionality in Oracle Cloud

Accounts Payable Manager US1 Business Unit	AP_ACCOUNTS_PAYABLE_MANAGER_JOB_US1 Business Unit
Accounts Payable Specialist US1 Business Unit	AP_ACCOUNTS_PAYABLE_SPECIALIST_JOB_US1 Business Unit
Accounts Payable Supervisor US1 Business Unit	AP_ACCOUNTS_PAYABLE_SUPERVISOR_JOB_US1 Business Unit
Advanced Procurement Requester US1 Business Unit	POR_ADVANCED_PROCUREMENT_REQUESTER_ABSTRACT_US1 Business Unit
Application Implementation Administrator	ASM_APPLICATION_IMPLEMENTATION_ADMIN_ABSTRACT
Business Practices Director US1 Business Unit	OKC_BUSINESS_PRACTICES_DIRECTOR_JOB_US1 Business Unit
Enterprise Contract Administrator	ORA_OKC_ENTERPRISE_CONTRACT_ADMINISTRATOR_JOB
Enterprise Contract Manager	ORA_OKC_ENTERPRISE_CONTRACT_MANAGER_JOB
Enterprise Contract Team Member	ORA_OKC_ENTERPRISE_CONTRACT_TEAM_MEMBER_ABSTRACT
GSE ABOUTME UHP	GSE_ABOUTME_UHP
GSE ANALYTICS UHP	GSE_ANALYTICS_UHP
GSE ASSESSMENTS UHP	GSE_ASSESSMENTS_UHP
GSE DASHBOARD UHP	GSE_DASHBOARD_UHP
GSE GET STARTED UHP	GSE_GET_STARTED_UHP
GSE HOUSEHOLDS UHP	GSE_HOUSEHOLDS_UHP
GSE MARKETPLACE UHP	GSE_MARKETPLACE_UHP
GSE MYTEAM UHP	GSE_MYTEAM_UHP
GSE PARTNERMANAGEMENT UHP	GSE_PARTNERMANAGEMENT_UHP
GSE PRC UI Developer	GSE PRC UI Developer
GSE RECRUITING UHP	GSE_RECRUITING_UHP
GSE SALES UHP	GSE_SALES_UHP
GSE Sandbox	GSE Sandbox
GSE WORKFORCE UHP	GSE_WORKFORCE_UHP
IT Security Manager	FND_IT_SECURITY_MANAGER_JOB
Internal Auditor	FND_INTERNAL_AUDITOR_JOB
Internal Auditor US1 Business Unit(BU)	FND_INTERNAL_AUDITOR_JOB_US1 Business UnitBU_
Procurement Application Administrator	PO_PROCUREMENT_APPLICATION_ADMIN_JOB
Procurement Catalog Administrator	ORA_POR_PROCUREMENT_CATALOG_ADMINISTRATOR_ABSTRACT
Procurement Contract Administrator	PO_PROCUREMENT_CONTRACT_ADMIN_JOB
Procurement Integration Specialist	ORA_PO_PROCUREMENT_INTEGRATION_SPECIALIST_JOB
Procurement Manager	PO_PROCUREMENT_MANAGER_JOB
Procurement Preparer US1 Business Unit	POR_PROCUREMENT_PREPARER_ABSTRACT_US1 Business Unit
Procurement Requester US1 Business Unit	POR_PROCUREMENT_REQUESTER_ABSTRACT_US1 Business Unit
Project Application Administrator	PJF_PROJECTS_APPLICATION_ADMINISTRATOR_JOB
Project Execution	ORA_PJF_PROJECT_EXECUTION_ABSTRACT
Receiving Agent
Requisition Viewing as Administrator Duty	POR_REQUISITION_VIEWING_AS_ADMIN_DUTY
Sourcing Project Collaborator	ORA_PON_SOURCING_PROJECT_COLLABORATOR_ABSTRACT
Supplier Administrator	ORA_POZ_SUPPLIER_ADMINISTRATOR_ABSTRACT
Supplier Contract Administrator	OKC_SUPPLIER_CONTRACT_ADMINISTRATOR_JOB_US1 Business Unit
Supplier Manager

Receiving Process in fusion Procurement

Following is my channel where this functionality is explained

https://tinyurl.com/wke38je

Purchase order creation in fusion procurement

Following is my channel where this functionality is explained

https://tinyurl.com/wke38je