Kill session for lock

1. find target session.

SELECT aob.object_name
,aob.object_id
,b.process
,b.session_id,c.SID, c.SERIAL#,c.LOGON_time,c.seconds_in_wait, c.state
FROM all_objects aob, v$locked_object b, v$session c
WHERE aob.object_id = b.object_id
and b.session_id = c.sid


2. delete session.

alter system kill session '<sid>,<serial>'

How to open multiple OAF to work

As an Oracle ERP engineer, we often need to access multi window in OAF to execute job, then below method will help you to get it!

1) make a IE shortcut and edit attribute.
2) put -nomerge in the target bottom.

How to resume PR lines in AutoCreate Documents

It's often to get buyer to request to resume PR lines in AutoCreate Document pool. It could be some reasons like they don't want to group lines or somehow to cancel PO etc..

2 actions to resume:

1:  Clean line_location_id value in po_requisition_lines_all.

2:  Put 'Y' in reqs_in_pool_flag in po_requisition_lines_all. 

Then you will see  they show up in the pool.

Oracle EBS R12 interface & APIs Information Document - Integration Repository

Add Integration Repository responsibility.

Forms Process (FRMWEB) Consumes 100% of CPU

1) First we had to update the context file on the application middle tier as follows:

s_forms_catchterm=0

2) Since the FORMS_RECORD_GROUP_MAX is not a default variable in the app tier context file, you need to create a custom template as follows.

cd $AD_TOP/admin/template
mkdir custom
cp $AD_TOP/admin/template/APPLSYS_ux.env $AD_TOP/template/custom/APPLSYS_ux.env

Edit the custom template file:

vi $AD_TOP/admin/template/custom/APPLSYS_ux.env

Set the environment variable FORMS_RECORD_GROUP_MAX to a high value such as 10000 or greater.

FORMS_RECORD_GROUP_MAX=10000
export FORMS_RECORD_GROUP_MAX

Save the file.

3)Run autoconfig utility for apps middle tier server.

4)Start app tier services and test.

Ref (Doc ID 745711.1)

How to re-Compile Invalid Objects (Package, Function, Procedure, View, Trigger)

Step 1. Create sql file as compile.sql in shell and content as below:

connect &1/&2

set pages 1000
set head off
set feedback off

spool compile1.sql
prompt set feedback on
select 'alter '||decode(object_type,'PACKAGE BODY',
    'PACKAGE',object_type)||' '||object_name||' '||
     decode(object_type,'PACKAGE BODY','compile body','compile')||';'
from user_objects
where status='INVALID'
/
spool off
@compile1.sql


Step 2. Login Oracle by sqlplus:

#sqlplus / as sysdba

Step 3. execute sql file:

> @compile.sql

HZ & HR Employee tables

1.PER_ALL_ASSIGNMENTS_F

2.PER_ALL_PEOPLE_F

1. HZ_PARTIES

2. HZ_ORGANIZATION_PROFILES

3. HZ_PERSON_PROFILES

4. HZ_CUSTOMER_PROFILES

5. HZ_LOCATIONS

6. HZ_PARTY_SITES

7. HZ_PARTY_SITE_USES

8. HZ_CUST_ACCOUNTS

9. HZ_CUST_ACCT_SITES

10. HZ_CUST_SITE_USES

11. HZ_CONTACT_POINTS

12. HZ_ORG_CONTACTS

13. HZ_ORG_CONTACT_ROLES

14. HZ_RELATIONSHIPS

15. HZ_CLASS_CATEGORIES

16. HZ_CLASS_CODE_DENORM

17. HZ_CODE_ASSIGNMENTS

18. HZ_CLASS_CATEGORY_USES

19. HZ_RELATIONSHIP_TYPES

PO_EMPLOYEE_HIERARCHIES_ALL