DBA
Showing posts with label DBA. Show all posts
Showing posts with label DBA. Show all posts

Query to find Locked Object in Oracle Apps R12


How can find Locked Object in Oracle Apps R12 ?or How can find Locked object name and Oracle User name in Oracle Apps R12 ?





Query 1 -

SELECT b.owner
     , b.object_name
     , a.oracle_username
     , a.os_user_name
FROM   v$locked_object a
     , all_objects b
WHERE  a.object_id = b.object_id

Query 2 -

SELECT c.owner
     , c.object_name
     , c.object_type
     , b.SID
     , b.serial#
     , b.status
     , b.osuser
     , b.machine
FROM   v$locked_object a
     , v$session b
     , dba_objects c
WHERE  b.SID = a.session_id
AND    a.object_id = c.object_id;

Query 3 -

SELECT a.session_id
     , a.oracle_username
     , a.os_user_name
     , b.owner "OBJECT OWNER"
     , b.object_name
     , b.object_type
     , a.locked_mode
FROM   ( SELECT object_id
              , session_id
              , oracle_username
              , os_user_name
              , locked_mode
        FROM   v$locked_object ) a
     , ( SELECT object_id
              , owner
              , object_name
              , object_type
        FROM   dba_objects ) b
WHERE  a.object_id = b.object_id;







“A GUIDE FOR ORACLE E-BUSINESS SUITE” – A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
Read More

How can make entry for "TNSNAMES.ORA" on the local host for Oracle Application (In Oracle Apps R12).



TNSNAMES.ORA entry to runs Oracle Application R12 at local Host 
OR 
TNS Entry steps to runs Oracle Application R12



Please follow the given steps -:

1- Go to  Host Desktop Screen 

2- Press Home key + R and Type 'drivers'




Then Press Enter .

3- Now Go to Folder etc < Hosts




Then



Then




In the Host File please make entry for -

IP Address   |   Hostname   |  SID

As - 192.168.1.5  ebs.example.com  EBSDB


Important -:  Default setup for Oracle Vision Instance to connect database and Application 


Host -  Host IP Address -  192.168.1.5 

Port -  Port Number       - 1521

SID -   Service Identification  -  EBSDB


Note - You can also Explorer the path directly .Follow the given below directory for the same .

C:\Windows\System32\drivers\etc



“A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Read More

Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)


Error "You have exceeded the transaction quantity". 




Applies to: 

Information in this document applies to any platform.

FORM:RCVRCERC.FMB - Enter Receipts GUI

FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI

FORM:RCVTXERE.FMB - Enter Returns GUI

FORM:RCVTXECO.FMB - Enter Corrections GUI

"You have exceeded the transaction quantity"


Symptoms:

"You have exceeded the transaction quantity"

Note: Internal error message may indicate this message:
INV_QUANTITY_TOO_BIG

Steps:
  1. Go to Receiving Screen
  2. Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005)
  3. Go to Lot/Serial form
  4. Enter lot number and qty as 7200.00001 (which was rounded to 5 digits)
  5. Message "you have exceeded the transaction quantity "
Cause Can Be-:



a) Restriction of precision support up to 6 decimal places were added for the quantity field 

b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to 5 decimal precision.

Quantity Precision support from now on will be as follows:
Receiving supports unlimited precision in Receiving forms.
Core Inventory's lot entry block still supports only 5 decimal precision. 
Important: The revised Quantity Precision support affects any quantities entered in all of the receiving forms (not just LOT based items).

Solution:

To implement the solution, please execute the following steps:

1. Download and review the readme for Patch 5880504 

2. Apply Patch 5880504 on a non-Production instance

3. Confirm the following file version:
     $AU_TOP/resource/RCVRCERL.plx  115.157.11510.45
     $AU_TOP/resource/RCVTXECO.plx  115.67.11510.20
     $AU_TOP/resource/RCVTXERT.plx  115.110.11510.22
     $PO_TOp/forms/US/RCVTXERE.fmb  115.79.11510.9
   You can use the commands like the following:
    strings -a $AU_TOP/resource/RCVRCERL.plx | grep 'Header:'

4. Retest the issue

5. If the issue is resolved, migrate the solution as appropriate to other instances


References:

BUG:6000073 - RECEIVING, INVENTORY AND PO SHOULD ALL SUPPORT 15 DECIMAL PRECISION
BUG:7626008 - DECIMAL POSITIONS NOT CONSISTENT ON RCV FORMS; CANNOT RETURN SMALL QTY


BUG:5880504 - ONDEMAND: OUT TO 9-10 DECIMAL PLACES, RECEIVING TRANSACTIONS ROUNDING ONLY TO 5


Note- All Reference Taken from Oracle Forum and manipulate then to make better understandable for Oracle Apps Technical and Oracle Apps Functional Developer .


For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide. For live issue discussion, Solution and Error in Oracle Apps R12 and in Oracle Apps 11I ;Please visit on Oracle Apps Guide.
Read More

Error:- APP-SQLAP-10771: Could not reserve record.



Error:- APP-SQLAP-10771: Could not reserve record.

Solution :-

Step (1) Run the query given below-:

SELECT vlo.object_id, vlo.session_id, substr(dbo.object_name, 1, 40) OBJECT_NAME
FROM v$locked_object vlo, dba_objects dbo
WHERE vlo.object_id = dbo.object_id
AND dbo.object_name like 'AP_%'
ORDER BY dbo.object_name;

Output look likes-:

OBJECT_ID
SESSION_ID
OBJECT_NAME
41097
495
AP_INVOICES_ALL

Step (2)  Now again Run the Query given below-:

SELECT l.*, ao.owner object_owner, ao.object_name
FROM SYS.all_objects ao, v$lock l
WHERE l.TYPE = 'TM'
AND ao.object_id = l.id1
AND ao.object_name in ('AP_ALLOCATION_RULES','AP_ALLOCATION_RULE_LINES','AP_INVOICES_ALL','AP_INVOICE_DISTRIBUTIONS_ALL','AP_INVOICE_LINES_ALL');

Output:-

ADDR
KADDR
SID
TYPE
ID1
ID2
LMODE
00000003BDC546F0
00000003BDC54748
495
AE
352852
0
4


REQUEST
CTIME
BLOCK
OBJECT_OWNER
OBJECT_NAME
0
13825
0
AP
AP_INVOICE_ ALL
 


Step (3)  Now again Run the Query given below-:


SELECT SID, SERIAL#
FROM v$session
where sid='495'   


Note-: SID should be =< SID from dba_objects Table

Output :- 

SID
SERIAL#
495
19801


Step (4)  Now again Run the Query given below-:

ALTER SYSTEM KILL SESSION '495,18758' IMMEDIATE


Error:- APP-SQLAP-10771: Could not reserve record.

For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide
Read More
Subscribe to: Posts (Atom)