STEP BY STEP GUIDE TO CREATING A CUSTOM APPLICATION IN APPLICATIONS 11I - Applications (Korean)

제품: AOL
작성날짜 : 2005-11-29
STEP BY STEP GUIDE TO CREATING A CUSTOM APPLICATION IN APPLICATIONS 11I
=======================================================================
PURPOSE
-------
고객의 Custom Module등록하기 위한 방법
Explanation
-----------
1) mz이라는 Directory생성.
     cd $APPL_TOP
     mkdir mz
     mkdir mz/11.5.0
     mkdir mz/11.5.0/admin
     mkdir mz/11.5.0/admin/sql
     mkdir mz/11.5.0/admin/odf
     mkdir mz/11.5.0/sql
     mkdir mz/11.5.0/bin
     mkdir mz/11.5.0/reports
     mkdir mz/11.5.0/reports/US
     mkdir mz/11.5.0/forms
     mkdir mz/11.5.0/forms/US
     mkdir mz/11.5.0/$APPLLIB
     mkdir mz/11.5.0/$APPLOUT
     mkdir mz/11.5.0/$APPLLOG
2) 환경 파일 등록
ADX.E.1를 적용하고 topfile.txt에 Top entry등록
Customo 환경변수는 APPSORA.env에 의해 불려지는 s_custom_file를 사용하여 AutoConfig로 등록될수있다
Forms Listener Servlet를 사용한다면 $CUSTOM_TOP을 $APACHE_TOP/Jserv/etc아래 formsservlet.ini에 등록한다
3) Table Space 생성
     create tablespace MZ datafile '/emea/oracle/visuk09/visuk09data/mz.dbf' size 10M default storage(initial 10k next 10k)
4) Create schema
     create user mz identified by mz
          default tablespace mz
          temporary tablespace temp
          quota unlimited on mz
          quota unlimited on temp;
     grant connect, resource to mz;
5) Register your Oracle Schema.
Login to Applications with System Administrator responsibility
Navigate to Application-->Register
     Application = MZ Custom
     Short Name = MZ
     Basepath = MZ_TOP
     Description = MZ Custom Application
6) Register Oracle User
Naviate to Security-->Oracle-->Register
     Database User Name = MZ
     Password = MZ
     Privilege = Enabled
     Install Group = 0
     Description = MZ Custom Application User
7) Add Application to a Data Group
Navigate to Security-->Oracle-->DataGroup
     Data Group = MZGroup
     Description = MZ Custom Data Group
Click on "Copy Applications from" and pick Standard data Group, then add the following entry.
     Application = MZ Custom
     Oracle ID = APPS
     Description = MZ Custom Application
8) Create custom request group
Navigate to Security-->responsbility-->Request
     Group = MZ Request Group
     Application = MZ Custom
     Code = MZ
     Description = MZ Custom Requests
9) Create custom menu
Navigate to Application-->Menu
     Menu = MZ_CUSTOM_MENU
     User Menu Name = MZ Custom Application
     Menu Type = <leave blank>
     Description = MZ Custom Application Menu
     Seq = 100
     Prompt = View Requests
     Submenu = <leave blank>
     Function = View All Concurrent Requests
     Description = View Requests
     Seq = 110
     Prompt = Run Requests
     Submenu = <leave blank>
     Function = Requests: Submit
     Description = Submit Requests
     Menu = MZ_CUSTOM_MENU_SSWA
     User Menu Name = MZ Custom Application SSWA
     Menu Type = <leave blank>
     Description = MZ Custom Application Menu for SSWA
10) Create new responsibility. One for Core Applications and One for Self Service (SSWA)
Navigate to Security-->Responsibility-->Define
     Responsibility Name = MZ Custom
     Application = MZ Custom
     Responsibility Key = MZCUSTOM
     Description = MZ Custom Responsibility
     Available From = Oracle Applications
     Data Group Name = mzGroup
     Data Group Application = MZ Custom
     Menu = MZ Custom Application
     Request Group Name = MZ Request Group
     Responsibility Name = MZ Custom SSWA
     Application = MZ Custom
     Responsibility Key = MZCUSTOMSSWA
     Description = MZ Custom Responsibility SSWA
     Available From = Oracle Self Service Web Applications
     Data Group Name = mzGroup
     Data Group Application = MZ Custom
     Menu = MZ Custom Application SSWA
     Request Group Name = MZ Request Group
11) Add responsibility to user
Navigate to Security-->User-->Define
Add MZ Custom responsibility to users as required.
12) 다른 고려 사항
database Objects, custom Reports, Forms, Packages을 생성할 준비가 되었다
각각의 Source Code는 MZ_TOP directory 아래 적당한 위치에 Copy하도록 한다 forms은 $MZ_TOP/forms/US , package source code $MZ_TOP/admin/sql
Table , Database Objects, indexes , sequences 는 MZ Schema아래에서 만들어 져야 하고
a) Grant all privilege를 APPS Schema에 부여해야 한다
     For example : logged in as MZ user
     grant all privileges on myTable to apps;
b) 모든 Data object 에 대한 synonym을 APPS에 대해서 부여해야 한다      For example : logged in as APPS user
     create synonym myTable for mz.myTable;
Other database objects, view나 package 는 APPS Schema로 만들어 져야 한다
Example
-------
Reference Documents
-------------------
216589.1

Related

KIMYONG :  Basic Login Problem Troubleshotting 가이드

Purpose
------------
Clonning, Install이후 Login 관련 Error들을 고객들이 많이 접하며
이럴경우 Login procedure를 궁금해 하는 경우가 많습니다.
이에 대한 상세한 Flow을 소개하고자 합니다.
Explanation
-----------------------
아래 Note들을 바탕으로 소개되었습니다.
NOTE - If you are using AS 10g with Apps 11i, please refer to Note 280167.1 - AS10g with Apps 11i - Summary of Login process
Since FND patchset G (patch 2655277) and/or 11.5.9 maintenance pack, there is a new URL to launch Applications, namely:
     http://<host name>.<domain name>:<HTTP port>/oa_servlets/AppsLogin
     
See note 226825.1 - Release 11i, Oracle Application Object Library Mini-pack FND.G
This is a shortcut defined in zone.properties as below servlet.AppsLogin.code=oracle.apps.fnd.sso.AppsLogin
"Self Service Personal Home Page Mode" profile option should be set to "Framework Only" to see the new Framework based Homepage. Setting to "Personal Home Page" reverts the Homepage to the old style look and feel.
Login Flow
/oa_servlets/Appslogin servlet
Gets WebAppsCOntext
Sets requestURL = APPSHOMEPAGE unless passed as a parameter.
Sets cancelUrl = oracle.apps.fnd.sso.SSOManager.getLoginUrl(); unless passed as a parameter.
This finds profile option APPS_SERVLET_AGENT (Apps Servlet Agent) and returns error if cannot get.
Sets variable "url" using oracle.apps.fnd.sso.SSOManager.getLoginRedirectUrl
sets Mode using Utils.getSSOMode()
which gets profile option APPS_SSO (Applications SSO Type) SSWA is set by default if not profile option.
Depending on mode, sets url = LOCAL_LOGIN | SSO_LOGIN_REDIRECT | PORTAL
     if SSWA = SSOUtil.getLocalLoginUrl()
This gets profile option APPS_LOCAL_LOGIN_URL (Applications Local Login URL) (AppsLocalLogin.jsp for example) and prepends '/OA_HTML/'
if PORTAL = SSOUtil.getPortalUrl()
This gets profile option APPS_PORTAL (Applications Portal) This is full URL normally pointing to /pls/XXX_portal30/portal30.home
     Then calls "constructUrl" to determine the URL to return, which builds URL consisting of url, requestURL, cancelURL, errCode, langCode, errText and home_url parameters
If "url" is null, then returns FND-9930 error code, otherwise will redirect to the constructed URL
At this point, we have got as far as rendering the Username/PAssword entry screen... /OA_HTML/AppsLocalLogin.jsp or portal30.home
/OA_HTML/AppsLocalLogin.jsp
Gets Profile options FND_BRANDING_SIZE (FND: Branding Size) and ICX_LANGUAGE (ICX: Language)
Sets up some message text (Message.class) Uses Package FND_MESSAGE.GET_MESSAGE_INTERNAL ()
Once we click "Login" button we follow through as below:-
fndvald.jsp
Utils.getConnection() - this throws FND-9902 if cannot get DB connection.
SessionMgr.createAppsSession which itself calls wctx.getSessionManager().validateLogin followed by createSession if username.password validated OK.
There is some STATEMENT level diagnostics messages from here (for oracle.apps.fnd.sso.SessionMgr)
Gets Cookie name from dbc file ICX_COOKIE_NAME or otherwise calls package FND_SESSION_MANAGEMENT.getsessioncookiename
Creates SSO Cookie for new user session
If requestURL = APPSHOMEPAGE it calls SSOUtil.getHomePage otherwise just passes requestURL through...
This calls computeURL, which looks for profile option APPLICATIONS_HOME_PAGE (Self Service Personal Home Page mode)
Runs getEnvStore90.getEnv(ICX_PV_SESSION_MODE) which I dont understand... but seems to be 115P | 115J ?
If APPLICATIONS_HOME_PAGE = "PHP" or "PHP_FWK" then will set URL = PLSQL_AGENT/OracleNavigate.Responsibility
else (for example "FWK") will set URL = "/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE&dbc=" + AppsAgent.getDBC()
OA.jsp
oracle.apps.fnd.framework.webui.OAPageBean.class
oracle.apps.fnd.framework.webui.OAJSPHelper
Uses OAJSPHelper to set character encoding for the session, mainly by getting ICX_CLIENT_IANA_ENCODING (ICX: Client IANA Encoding) profile option
Then sets redirectURL = pageBean.preparePage
Sets flag for Portlet or not
Sets functionName from the parameters in the URL (OAHOMEPAGE for example, if URL param is ?OAFunc=OAHOMEPAGE)
Sets redirectURL = preparePage() method... this calls "redirectURL = validateUser()" but I think this should return null if I have logged in (this seems to be to do with bookmarkable URLs)
sets funcURL = createRFURL()
This does some session validation, then calls OAPageContextImpl.createRFURL
Which calls FunctionSecurity.getFunction and Function.getFunction...
This bit runs SQL to find FunctionID "select function_id from fnd_form_functions where function_name = :1"
Then "select function_name, context_dependence, maintenance_mode_support, parameters, type, web_agent_name, web_host_name, web_html_call, web_icon, form_id from fnd_form_functions where function_id = :1"
For OAHOMEPAGE the following will be set
web_html_call = "OA.jsp?page=/oracle/apps/fnd/framework/navigate/webui/HomePG&homePage=Y&OAPB=FWK_HOMEPAGE_BRAND"
type = "JSP"
isOAFCall is set to TRUE (as the URL has OA.jsp in the URL)
funcCall = web_html_call
          hasTransactionId = FALSE
          so adds "&transactionid=xxx" to the funccall then returns this as the new url
This new URL is returned to OA.jsp as the redirectURL, so we call OA.jsp with some different parameters.....
OA.jsp - part 2
By now, we should have URL something like:
OA.jsp?page=/oracle/apps/fnd/framework/navigate/webui/HomePG&homePage=Y&OAPB=FWK_HOMEPAGE_BRAND&transactionid=xxxxxxx
Back into "redirectURL = pageBean.preparePage()"
regionCode = OAPageContextImpl.getUrlParameter(request, "page") (page=/oracle/apps/fnd/framework/navigate/webui/HomePG)
//Get the application module java class from AK.
OAApplicationModule staticAppMod = OAJSPApplicationRegistry.getStaticAKApplicationModule(mRequest);
This creates AM called "oracle.apps.fnd.framework.server.OAApplicationModule" with DB connection.
Creates MDS context, seems to have handles to MDS repository.
Gets page region, using WebBeanTypeData, from MDS repository.
Gets transaction_ID
Get profile option "FND_FORCE_PAGE_REFRESH"
Get profile option "FND_CUSTOM_OA_DEFINTION"
<< This bit still WIP >>
portal30 HOME procedure
Does a owa_util.redirect_url to wwpob_page_util.get_page_url (wrapped PLSQL)
Refernece
-----------------
좀더 상세한 내용은 Note 273449.1 를 참고하세요.

Getting Insufficient Privileges Error while running Pages in Jdeveloper

Hi,
When I am running my pages in JDeveloper, I am getting the Error:
"You have insufficient privileges for the current operation." and the Application login page is being shown.
Looking at the log window, I see that the system expects my page to be shown correctly. However the login screen gets displayed.
I suspected that my login/password is incorrect in Jdeveloper Project settings. But I tried that. It is finw. Any suggestions as to what the problem might be would be great.
Please find excerpts from the Jdev log window:
*********************************************************************************************
*********************************************************************************************
[328] Connected to Oracle JBO Server - Version: 9.0.3.13.88
[329] Loading from /lalith/oracle/apps/xxtmg/graph/server/server.xml file
[330] Loading from indvidual XML files
[331] Loading the Containees for the Package 'lalith.oracle.apps.xxtmg.graph.server.server'.
[332] Loading from /lalith/oracle/apps/xxtmg/graph/server/GraphAM.xml file
[333] Created root application module: 'lalith.oracle.apps.xxtmg.graph.server.GraphAM'
[334] Locale is: 'en_US'
[335] DefaultConnectionStrategy is establishing an application module connection
[336] mUsePersColl is false
[337] ViewObjectImpl.mDefaultMaxRowsPerNode is 70
[338] ViewObjectImpl.mDefaultMaxActiveNodes is 30
[339] Oracle SQLBuilder: Registered driver: oracle.jdbc.driver.OracleDriver
[340] Successfully logged in
[341] JDBCDriverVersion: 9.2.0.5.0
[342] DatabaseProductName: Oracle
[343] DatabaseProductVersion: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options
[344] Root application module, lalith.oracle.apps.xxtmg.graph.server.GraphAM, was created at 2007-01-02 14:08:08.391
[345] setConnectionReleaseLevel - Set connection release level to 0
[346] OAApplicationPoolImpl.setConnectionReleaseLevel was called with isReleased = false, isReserved = false
[347] setConnectionReleaseLevel - Set connection release level to 0
[348]
<ICX_SessionValues_Diagnostics - ICX Cookie = m6BVBr6qeAiK1S9ptOKjFou1:S>: WebRequestUtil.validateContext is called.
[349]
<ICX_SessionValues_Diagnostics - ICX Cookie = m6BVBr6qeAiK1S9ptOKjFou1:S>: WebRequestUtil.validateContext returned status = VALID.
ICX Session Values after WebRequestUtil.validateContext:
============================================================
<ICX_SessionValues_Diagnostics - ICX Cookie = m6BVBr6qeAiK1S9ptOKjFou1:S>:
Current ICX Session (Oracle Applications User Session) Values:
1. User ID (DB, ICX_SESSIONS) = 6
2. Responsibility ID (DB, ICX_SESSIONS) = -1
3. Responsibility Application ID (DB, ICX_SESSIONS) = -1
4. Org ID (DB, ICX_SESSIONS) = 132
5. Org ID (DB, CLIENT_INFO) = 132
6. Org ID (ProfileStore.getProfile) = 132
7. Org ID (ProfileStore.getSpecificProfile with new ICX_SESSIONS values) = 132
8. Employee ID (DB, FND_GLOBAL.EMPLOYEE_ID) = -1
9. Employee ID (AppsContext.getFNDGlobal) = -1
10. Function ID (DB, ICX_SESSIONS) = -1
11. Security Group ID (DB, ICX_SESSIONS) = -1
===========================================================
[350] New Language Code = null
[351] Current Language Code = US
[352] ViewDefImpl_1_2>#q computed SQLStmtBufLen: 64, actual=24, storing=54
[353] select sysdate from dual
[354] **********oracle.jdbc.driver.OraclePreparedStatement#11abd68
[355] Column count: 1
[356] Column count: 1
[357] ViewObject : Created new QUERY statement
[358] ViewDefImpl_1_2>#q old SQLStmtBufLen: 54, actual=24, storing=54
[359] select sysdate from dual
[360] ViewObject close prepared statements...
[361] Loading from /oracle/apps/ak/region/server/server.xml file
[362] Loading from indvidual XML files
[363] Loading the Containees for the Package 'oracle.apps.ak.region.server.server'.
[364] Loading from /oracle/apps/ak/region/server/AkAmParameterRegistryVO.xml file
[365] ViewDef: oracle.apps.ak.region.server.AkAmParameterRegistryVO using glue class
[366] Column count: 2
[367] ViewObject : Created new QUERY statement
[368] AkAmParameterRegistryVO>#q computed SQLStmtBufLen: 140, actual=100, storing=130
[369] select PARAM_NAME, PARAM_SOURCE
from AK_AM_PARAMETER_REGISTRY
where APPLICATIONMODULE_DEFN_NAME = :1
[370] Binding param 1: lalith.oracle.apps.xxtmg.graph.server.GraphAM
[371] OAApplicationPoolImpl.setConnectionReleaseLevel was called with isReleased = true, isReserved = true
JRAD_PERF : /lalith/oracle/apps/xxtmg/graphs/webui/GraphPG - processRequest : 1313ms
*********************************************************************************************
*********************************************************************************************
We have recently migrated our 9i database to 10G database. Is it something related to that?
Thanks 
Check whether the following thread helps.
Re: Error: You have insufficient privileges for the current Operation. 
Thanks Ranjit,
The link provides good suggestions. I am looking into those.
Regards

TROUBLESHOOTING CONCURRENT MANAGER STARTUP PROBLEMS - 11.0

제품 : AOL
작성날짜 : 2004-05-13
     
TROUBLESHOOTING CONCURRENT MANAGER STARTUP PROBLEMS - 11.0
==========================================================
PURPOSE
-------
CM기동시 발생하는 문제를 진단하기 위한 절차를 설명하고 있다(11.0.3 기준)
UNIX & NT Platform에서 모두 사용할수 있는 절차를 포함하고 있다.
Explanation
-----------
1) ICM or Manager Log 를 확인한다.
The default name for theInternal Manager log file is 'CM_<hostname>.log' on NT
or >ManagerName>.mgron Unix.
$APPLCSF/$LOG directory for relevant messages.
2) Applmgr User로 접속했는지 확인한다.
3) ICM or Alert Log에 Extent Error가 발생했는지 확인한다.
4) Invalid Object을 확인해 본다.
5)CM 모두를 내리고 관련 table,log정보를 clear합니다.
a) Check there are no FNDLIBR, FNDCRM or other Concurrent Manager
processes running. This can be done via the
Concurrent Manager-->Administer screen, or from the operating system -
Note 68993.1 has a list of the process names to look for.
b) In SQLPLUS run the following SQL
-- If you do not want to keep the Concurrent Request data,
-- then delete all records from this table:
TRUNCATE TABLE fnd_concurrent_requests;
-- OR: IF you want to keep them, use the following UPDATE command
-- (highly recommended in a live environment):
UPDATE fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where status_code = 'T';
UPDATE fnd_concurrent_queues SET running_processes = 0;
SELECT concurrent_queue_name, control_code, running_processes,
max_processes
FROM fnd_concurrent_queues;
The control_codes should be 'E' for deactivated managers, blank for all others
except FNDICM which should be 'X'. You will need to update the table
manually if you find any exceptions to these values.
For example:-
UPDATE fnd_concurrent_queues SET control_code = 'X'
WHERE concurrent_queue_name = 'FNDICM';
c) Delete all log and output files in FND_TOP/log, APPLCSF/log and APPLCSF/out if these files are no longer needed.
Having to many files in these directories has caused issues previously, so may be worth temporarily removing these files.
6) 환경변수를 확인한다.(NT는 Registry, LOCAL등을 확인한다.)
On NT using REGEDT32 check the following keys have these values:
WARNING - ensure you do not change or delete any registry Settings as this
may irrecoverably damage your Oracle or NT Server installation :-
HKEY_LOCAL_MACHINE-->Software-->Oracle-->Applications-->11.0.0-->APPL_CONFIG=<Appl Config Name>
HKEY_LOCAL_MACHINE-->Software-->Oracle-->LOCAL=<SID Name>
HKEY_LOCAL_MACHINE-->Software-->Oracle-->Applications-->11.0.0--><APPL_CONFIG>-->DIAG=Y
HKEY_LOCAL_MACHINE-->Software-->Oracle-->Applications-->11.0.0--><APPL_CONFIG>-->pmon=20
HKEY_LOCAL_MACHINE-->Software-->Oracle-->Applications-->11.0.0--><APPL_CONFIG>-->LOCAL=<SID Name>
HKEY_LOCAL_MACHINE-->Software-->Oracle-->Applications-->11.0.0--><APPL_CONFIG>-->SERVICE_SID=<SID Name>
On Unix check :-
$ORACLE_SID
$LOCAL
If any of these settings are incorrect, reset them to the correct value.
7) Program Version을 확인한다.
On NT check versions of FND_TOP/bin/FNDLIBR.EXE and AU_TOP/bin/FNDCORE.DLL.
This is achieved by highlighting the program file, then using the right mouse
button to click-->Properties-->Version. Compare this information to that found
in bug 881201 - this patch delivers v11.1.179 of FNDCORE.DLL (pre-req of this
patch is to be on 11.0.3) Alternatively you may need to apply patch 872159
which is FNDCORE.dll v11.0.215
On Unix you can run the following command to determine the version numbers:
'strings -a $FND_TOP\bin\FNDLIBR | grep Header > fndlibr_versions.txt'
This will create a file called 'fndlibr_versions.txt' to send to Oracle Support.
8) TRACE 를 걸어본다.
a) set TRACE_LEVEL_SERVER=16 in the SQLNET.ORA file on the database server.
b) Set SQL_TRACE=true in the init.ora file
NOTE - the database will need to be restarted for this change to take effect.
It will also generate trace files for every database session, which induces
a great deal of processing overhead as well as a lot of disk writing. Once
the database has been restarted, try starting the Concurrent Manager, then
stop the database and reset 'SQL_TRACE=false' in the init.ora file and
restart the database again.
9) Dual table을 확인한다.: (assuming no-one is in the system and Concurrent Manager processes are not running)
a) select count(*) from sys.dual; There must be one and only one row returned.
b) select count(*) from apps.fnd_dual; There must be at least one row.
10) Profile File Option을 확인한다.
Check system level profile option 'Concurrent:Use ICM'; by default this should
be set to 'No'. Try changing this value to 'Yes' and see if this changes the
nature of the problem.
11) Pmon Method를 확인한다.
SELECT profile_option_value
FROM fnd_profile_option_values
WHERE level_id = 10001
AND level_value = 0
AND application_id = 0
AND profile_option_id =
(SELECT profile_option_id
FROM fnd_profile_options
WHERE profile_option_name = 'CONC_PMON_METHOD');
This should return one row with a value of 'RDBMS' or 'LOCK'
If the value is 'RDBMS' run the script FND_TOP/sql/AFIMPMON.SQL - this will set
the PMON method to LOCK instead of RDBMS.
Example
-------
Reference Documents
-------------------
Note 74717.1

HOW TO TURN ON DEBUG OPTION OF APXIIMPT

제품 : FIN_AP
작성날짜 : 2003-05-13
HOW TO TURN ON DEBUG OPTION OF APXIIMPT
=======================================
PURPOSE
-------
PAYABLES OPEN INTERFACE IMPORT PROGRAM (APXIIMPT) 수행시 erorr 가 발생하였을 경우 debug mode로 log를 생성하게 하여 문제해결에 도움을 준다.
Explanation
-----------
1. Loggon to Applications with System Administrator Responsibility.
2. Go to 'Concurrent -> Program -> Define'
3. Query 'APXIIMPT' in Short Name field
4. Click Parameter button
5. Select 'Trace Switch' Row and then check 'Display' checkbox in the bottom
6. Select 'Debug Switch' Row and then check 'Display' checkbox in the bottom
7. Save what you are done
8. Change Responsibility to 'Payables User'.
9. Run the open interface program with parameter 'Trace Switch' to 'Yes' and 'Debug Switch' to 'Yes'
Example
-------
N/A
Reference Documents
-------------------
NOTE 107617.1

HKONG: Inter-Organization Transfers의 receive시 "rvtptcontrol failed" Error처리

PURPOSE
-------
Inter-Organization Transfers의 receive시 발생하는 "rvtptcontrol failed" Error처리 방법을 기술하고자 함.
Problem Description
-------------------
Inter-Organization Transfers의 receive시 "rvtptcontrol failed" Error 발생.
debug file :
[12-JUN-06 09:31:24] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: LOT NOT ENTERED ON PARENT: WMSINB-22155
[12-JUN-06 09:31:24] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: LOT CONTROL FROM ORG: 2 : WMSINB-22161
[12-JUN-06 09:31:24] INV_RCV_INTEGRATION_PVT: Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2006-06-12 09:12:24:WMSINB-22192
[12-JUN-06 09:31:24] INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES :
[12-JUN-06 09:31:24] inv_receiving_transaction: TXN_COMPLETE - Enter txn_complete : 10: 2006-06-12 09:12:24
Workaround
----------
N/A
Solution Description
--------------------
1. Patch 4473106 적용
Update RcvTrxManager.java to version 115.51.115100.4 or higher.
2. 만약, datafix가 필요하다면 다음 정보들을 수집하여 SR을 등록하여 주시기 바랍니다.
1.Screenshot of the Shipping Networks between the two orgs:
Inventory: Setup -> Organizations -> Shipping Networks
2.Run the statements below and upload the results in excel format with column headings:
a. select * from rcv_transactions
where shipment_line_id = &shipment_line_id;
b. select * from rcv_transactions_interface
where shipment_line_id = &shipment_line_id;
c. select * from rcv_serials_supply
where shipment_line_id = &shipment_line_id;
d. select * from rcv_shipment_headers
where shipment_line_id = &shipment_line_id;
e. select * from rcv_lots
where shipment_line_id = &shipment_line_id;
3. Run the "Diagnostics: Apps Check" Report using a Purchasing responsibility:
- Reports > Run
- Submit a Single Request
- Name: Diagnostics: Apps Check
- Parameters: Application 1: Oracle Purchasing
Application 2: Oracle Inventory
- Submit the request
- View > Requests
Select the Concurrent Request and upload the report output (not the log)
Reference Documents
-------------------
Bug 4473106 - ''RCVTPT CONTROL FAILURE'' ERROR ON RECEIVING IN DIFFERENT UOM FOR LOT ITEM
Bug 5352266 - DATAFIX: ''RVTPTCONTROL FAILED'' ERROR WHEN ATTEMPTING TO RECEIVE INTRANSIT
Note 299497.1 - How to Generate Receiving Transaction Debug Statements in 11.5.10

Categories

Resources