oracleappsscriptsandtips.blogspot.com
Daily DBA activites in Oracle Applications | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2016/06/daily-dba-activites-in-oracle.html
Oracle Apps Scripts and Tips. Monday, June 27, 2016. Daily DBA activites in Oracle Applications. Connect to Oracle Application Thru’ Internet Explorer as SYSADMIN Login for System Administrator Responsibility. Checking of Administer Concurrent Manager (where Actual = Target should be same). Checking of View All Concurrent Requests (to see Report Server is connected). Run Active Roles or Active Responsibilities to check reports are working properly. Connect to TOAD (PROD, MIPLPROD, PREPROD, MIPLPRE).
oracleapps4u.blogspot.com
Useful oracle apps queries/ scripts/ codes/ tips | Oracle Apps
http://oracleapps4u.blogspot.com/2011/05/useful-scripts.html
Useful oracle apps queries/ scripts/ codes/ tips. Visit our new blog:. Oracle apps scripts and tips. I am working on this blog post. For now i have placed only few scripts. Keep checking this post for further updates:. How to get Login Passwords for application and Data Base instances. Wait for request in Oracle Apps. Queries related to Security profile in Oracle apps MOAC. How to add System administrator responsibility from backend. Useful queries/code/scripts in Oracle Apps Order Management. Book an Or...
oracleapps4u.blogspot.com
OAF | Oracle Apps
http://oracleapps4u.blogspot.com/p/tutorial.html
OA Frame Work Page Structure. MVC Architecture in OA Framework. OA Frame Work - The MVC Architecture. Important Profile Options Used In OA Framework. Useful Scripts in OA Frame Work. Displaying an OAF Page through Workflow Notification. Oracle OAF Personalization Training Video. Execute a Concurrent Program from OAF/Self Service page. Migrating Oracle Frame Work Personalizations. Contact us for OAF Training, course structure and fee details:. Subscribe to: Posts (Atom). Enter your email address:.
oracleapps4u.blogspot.com
Conditionally disable DFF components in Oracle apps | Oracle Apps
http://oracleapps4u.blogspot.com/2015/01/conditionally-disable-dff-components-in.html
Conditionally disable DFF components in Oracle apps. IF event name = 'WHEN-VALIDATE-RECORD' then. IF NVL(get item property('D SUM FOLDER.ATTRIBUTE1',. NVL(name in('D SUM FOLDER.ATTRIBUTE1'),'xyz-912'). Fnd message.set string(. DFFAttribute at is not Updateable. Modifiedvalue will. Revert back to the original value');fnd message.show;. Copy(get item property('D SUM FOLDER.ATTRIBUTE1',. Database value),'D SUM FOLDER.ATTRIBUTE1');. JOIN THIS SITE and GET FREQ. UPDATES ON NEW BLOG POSTS.
oracleappsscriptsandtips.blogspot.com
June 2012 | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2012_06_01_archive.html
Oracle Apps Scripts and Tips. Tuesday, June 26, 2012. Interface error tables in Oracle Apps. Following are the interface error tables used in oracle apps:. This table stores the processing messages which will be generated during Order Entry concurrent program execution or UI process. This is a multi-lingual table. 160; FROM OE PROCESSING MSGS OPM, OE PROCESSING MSGS TL OPT. 160;WHERE OPM.TRANSACTION ID = OPT.TRANSACTION ID. 160; AND OPT.LANGUAGE = US. Sunday, June 24, 2012. PO CHANGE API1 S.
oracleappsscriptsandtips.blogspot.com
September 2013 | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2013_09_01_archive.html
Oracle Apps Scripts and Tips. Thursday, September 5, 2013. APPEND THE DATE AND TIME TO A SQL*PLUS OUTPUT FILENAME. APPEND THE DATE AND TIME TO A SQL*PLUS OUTPUT FILENAME. If you've got an output file that you SPOOL to regularly from SQL*Plus,. But you don't want to overwrite the file, you can uniquely identify it by. Appending the date and time to the filename. Here's an example:. Column date column new value var1. Select to char (sysdate, 'YYYY-MM-DD-HH24MISS') '.txt' date column. Stuff you want to spool.
oracleappsscriptsandtips.blogspot.com
September 2012 | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2012_09_01_archive.html
Oracle Apps Scripts and Tips. Friday, September 14, 2012. Create Group using the TCA API - HZ PARTY V2PUB. Running The Create Group API. Name of the API: CREATE GROUP API. Base Tables Affected: HZ PARTIES. PL/SQL Procedure used : CREATE GROUP. Package Used: HZ PARTY V2PUB. Labels: HZ PARTY V2PUB. Create Person using the TCA API - HZ PARTY V2PUB. Running the Create Person API. Name of the API: CREATE PERSON API. Base Tables Affected: HZ PARTIES. PL/SQL Procedure used: CREATE PERSON. HZ CUST ACCOUNT V2PUB.
oracleappsscriptsandtips.blogspot.com
Query to find out online users | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2016/06/query-to-find-out-online-users.html
Oracle Apps Scripts and Tips. Thursday, June 30, 2016. Query to find out online users. The following query is mainly intended to identify online users as batch jobs can be monitored via the Concurrent Manager. SELECT c.SID, c.serial# ser, c.module, SUBSTR (c.program, 1, 10) program,. Clast call et last call, c.sql hash value, d.spid, c.process. FROM v$session c, v$process d. WHERE c.status = 'ACTIVE' - the session is running in the database. AND clast call et 300 - has been running for over 300 seconds.
oracleappsscriptsandtips.blogspot.com
July 2013 | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2013_07_01_archive.html
Oracle Apps Scripts and Tips. Monday, July 1, 2013. REP-80009: Invalid help topic. Cause: Invalid help topic. Action: Correct the help topic. REP-80010: Trace write failure. REP-80010: Trace write failure. Cause: Fail to write to trace file. Action: Check trace file setup, file write permission, and disk full. REP-80011: Not able to set sign-on parameter {0} for {1}. Cause: The column is not a valid sign-on parameter of this plugin type. REP-80012: Invalid link between columns of mismatched datatypes.
oracleappsscriptsandtips.blogspot.com
April 2013 | Oracle Apps Scripts & Tips
http://oracleappsscriptsandtips.blogspot.com/2013_04_01_archive.html
Oracle Apps Scripts and Tips. Saturday, April 13, 2013. API To Upload Value Set Values. 160; v enabled flag VARCHAR2 (2) := Y;. 160; v summary flag VARCHAR2 (2) := Y;. 160; v start date active DATE := SYSDATE;. 160; v error msg VARCHAR2 (1000) := NULL;. 160; v who type fnd flex loader apis.who type;. Labels: add new line to an order. Fnd flex values pkg. Labels: Create API Hook Call. AND Fcr...