Oracle Applications Technical Docs

SQLPLUS Script in UNIX Shell Produce Output on Same Line

2011-10-08T00:49:00.001+05:30

A Simple Select statement is executed from CURRENT a shell. The value returned by the select query is transferred back to the shell.

For example:

RESULT=`sqlplus -s apps/WELCOME123@DEVPR12 < <(printf "set pages 0 \n select SYSDATE from dual; \n")`
echo "RESULT=${RESULT}"

Another Way to Execute sqlplus from unix shell

sqlplus -s /nolog << EOF
connect apps/Welcome123
select sysdate from dual;
exit;
EOF

Groovy Support in ADF

2011-10-08T00:44:00.001+05:30

Groovy Support in ADF

Groovy is as an agile dynamic language, Oracle JDeveloper and Oracle ADF 11g introduce support for the Groovy scripting language, allowing you Groovy expressions to be used in attribute validation and as a source for attribute values Groovy need to have a minimum java version 1.5.Groovy comes into its own is within Oracle ADF Business Components is helping to bridge the gap between Oracle ADF's declarative business logic,Groovy supports 99% of java syntax it's so easy to paste some java code into groovey programs

Oracle ADF provides a number of different declarative points into which you can drop Groovy code:

• Values for view and entity objects attributes
• Validation rules on entity object attributes
• Expressions for error messages Oracle White Paper-Introduction to Groovy support in JDeveloper and Oracle ADF 11g.
• Values for view object bind variables
• View object transient attribute validation

Groovy Expressions in ADF Business Components View Objects

ADF Business Components view objects also provide the ability to use Groovy expressions. As with entity objects, view objects can support:
• Referencing attributes in the same view object
• Referencing attributes in other view objects
• Transient attribute validation Oracle White Paper-Introduction to Groovy support in JDeveloper and Oracle ADF 11g.
• Referencing methods in the Java class that backs the view object
• Referencing built in calls such as sum and min
View objects also allow Groovy expressions to be used in bind variables

Things to be aware of

· Semicolons are optional. Use them if you like (though you must use them to put several statements on one line).
· the return keyword is optional.
· You can use this keyword inside static methods (which refers to this class).
· Methods and classes are public by default.
· Protected in Groovy has the same meaning as protected in Java, i.e. you can have friends in the same package and derived classes can also see protected members.
· Inner classes are not supported at the moment. In most cases you can use Closures instead.
· The throws clause in a method signature is not checked by the Groovy compiler, because there is no difference between checked and unchecked exceptions.
· You will not get compile errors like you would in Java for using undefined members or passing arguments of the wrong type.

Some Examples:

Java code

class HelloWorld {
private final Thing thing = new Thing ( ) ;
   {
          thing.doSomething ( ) ;
   }
}

Groovy Code

class HelloWorld {
private final thing = new Thing ( )
{
thing.doSomething ( )
}
}

Semicolons is optional in Groovy

A = 10
println x

A = new java.util.Date()
println A

A = -3.1499392
println A

A = false
println A

A= "Hi"
println A

println is equalant to System.out.println

The first line java import tells to groovy the full name of sql object
The second line creates SQL DB connection and stores in variable
Third line calls "eachRow" Method of sql and passing two parameters

1.Query String is first param
2.printing some sql result values
The closure the fields of "it" are accessed in two different ways. The first is as a simple field reference, accessing the id field of it. The second is the included Groovy expression mentioned above

Who will Benefit

Who don't already know java and who don't want learn java they can use Groovy to use power of JVM and Development kit while programming

conclusion

Java is Groovy,Groovy is Java

1.99% java code supports Groovy
2.Groovy supports JSR 175 annotation same as Java
3.Increases developer productivity by reducing scaffolding code when developing web, GUI ,database or console applications
4.Compiles straight to Java byte code so you can use it anywhere you can use Java

Source from: http://groovy.codehaus.org and oracle.com

2011-10-06T01:12:00.004+05:30

Toad start-up Script

Save below script in c:\toad.startup.sql

BEGIN
INSERT INTO FND_SESSIONS
SELECT USERENV('SESSIONID'), TRUNC( SYSDATE )
FROM DUAL;
COMMIT;
END;
/
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO( 101 );
END;
/
BEGIN
FND_GLOBAL.SET_NLS_CONTEXT (P_NLS_LANGUAGE => 'AMERICAN');
COMMIT;
END;
/
---End of script

open toad then click on view-> Toad options->schema browser->Startup(As shown below)

click on apply and restart the toad, The above script files executed automatically and set to language and org information to your toad session.

If you want execute above script for every new connecton call same file in " File to execute on new connections: c:\toad_startup.sql "

2011-10-06T01:09:00.000+05:30

SQL connect Tip

I am lazy to make Tns entry in TNSNAMES.ORA file
But, still you can connect sqlplus session using following tip
make the tns entry as shown below , First open sqlplus connect window then follow below steps

Syntax:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xyzabc.com)(PORT=1521))(CONNECT_DATA=(SID=Devep11i)))

Username : apps
Password : apps
Host string : < paste above tns entry here>

click on ok , it will connect to specified dbserver with making entry in TNSNAMES.ORA

2011-10-06T01:06:00.003+05:30

Linux server auto connect using Putty

if you want auto connect to specific server using putty here is some tips

First locate "putty.exe" then right click on "putty.exe" goto properties-> short cut

Consider below syntax as example
in target field enter below syntax

C:\putty.exe -ssh "user_name"@"servername" "port_number" -pw "Password"

-ssh is connection type
-pw is password
-port number (By default is 22 for ssh)

C:\putty.exe -ssh ABCABC@devUnix100.com 22 -pw Welcome123!

click on Apply then double click on "putty.exe" it will connect you server without password

Be careful it's not good practice to keep your password at file properties :)

2011-10-06T01:02:00.006+05:30

comparison ADF vs OAF

Oracle recommendations

If you want to integrate your extensions tightly with the E-Business Suite,
you should use the OAF Release 12 technology stack, which includes the
use of JDeveloper 10g and ADF BC (or use OAF Release 11i, which uses
JDeveloper 9i).

If you are building a separate application that does not integrate tightly
with the E-Business Suite, but needs E-Business Suite-specific capabilities
like Flexfields and personalization, you should use the OAF Release 12
technology stack. If your application does not need to integrate with the
E-Business Suite, or doesn't require any of the E-Business Suite-specific
capabilities enumerated above, you should use ADF 10g with SOA based
integration with E-Business Suite.

If you are building a separate application that does not need to integrate at
all with the E-Business Suite, and you need an AJAX-style rich client user
interface, you should use ADF 11g.

Source : oracle support

2011-10-03T17:30:00.001+05:30

inv item categories and iproc item categories

Below query gives Mapping between inv item categories and iproc item categories using mapping table ICX_POR_CATEGORY_ORDER_MAP

SELECT
MC . SEGMENT1 ,
MC . DESCRIPTION ,
MCT . CATEGORY_ID ,
ICCT . CATEGORY_NAME ,
ICCT . RT_CATEGORY_ID
FROM
MTL_CATEGORIES_TL MCT ,
MTL_CATEGORIES_KFV MCK ,
ICX_POR_CATEGORY_ORDER_MAP IPCO ,
ICX_CAT_CATEGORIES_TL ICCT ,
MTL_CATEGORIES MC ,
MTL_CATEGORY_SET_VALID_CATS mcsv
WHERE MCT . CATEGORY_ID = MCK . CATEGORY_ID
AND MCT . CATEGORY_ID = MC . CATEGORY_ID
AND mct . CATEGORY_ID = mcsv . CATEGORY_ID
AND IPCO . EXTERNAL_SOURCE_KEY = MCK . CATEGORY_ID
AND ICCT . RT_CATEGORY_ID = IPCO . RT_CATEGORY_ID

Script to Converting BLOB to CLOB

2011-10-03T17:22:00.001+05:30

BLOB to CLOB

step-1) create temp table
step-2) prepare conversion script
step-3) execute script to store converted CLOB to temp table

Table creation

CREATE TABLE
APPS . XXNR_XML_DATA_TEMPLATE_TEMP (
TEMPLATE_CODE VARCHAR2 ( 200 BYTE),
DATA_SOURCE_CODE VARCHAR2 ( 200 BYTE),
FILE_NAME VARCHAR2 ( 200 BYTE),
FILE_DATA CLOB
);

Conversion Script

CREATE OR REPLACE PROCEDURE XX_BLOB_RAMA
IS
v_clob CLOB ;
v_varchar VARCHAR2 ( 32767 );
v_start PLS_INTEGER := 1 ;
v_buffer PLS_INTEGER := 32767 ;

BEGIN
DBMS_OUTPUT.put_line ( 'starting blob to clob conversion' );
alter session set nls_language= 'AMERICAN' ;

FOR x
IN (SELECT xtv . template_code ,
xdd . DATA_SOURCE_CODE ,
xl . LOB_CODE ,
xl . file_data ,
xl . FILE_NAME
FROM XDO_TEMPLATES_VL xtv , XDO_DS_DEFINITIONS_VL xdd , XDO_LOBS xl
WHERE xdd . DATA_SOURCE_CODE = xtv . DATA_SOURCE_CODE
AND xl . LOB_CODE = xtv . DATA_SOURCE_CODE
AND lob_type = 'DATA_TEMPLATE'
AND xl . APPLICATION_SHORT_NAME IN ( 'XXPEP' , 'XXABC' ))
LOOP
BEGIN

DBMS_OUTPUT.put_line ( 'prccessing DATA_SOURCE_CODE ' || x . DATA_SOURCE_CODE );
v_start := 1 ;
v_clob := NULL;
v_varchar := NULL;
DBMS_LOB.CREATETEMPORARY ( v_clob , TRUE);
FOR i IN 1 .. CEIL ( DBMS_LOB.GETLENGTH ( x . file_data ) / v_buffer )

LOOP
v_varchar :=
UTL_RAW . CAST_TO_VARCHAR2 (
DBMS_LOB.SUBSTR ( x . file_data , v_buffer , v_start ) );
DBMS_LOB.WRITEAPPEND ( v_clob , LENGTH ( v_varchar ), v_varchar );
v_start := v_start + v_buffer ;
END LOOP;

INSERT INTO XXNR_XML_DATA_TEMPLATE_TEMP
VALUES ( x . TEMPLATE_CODE ,
x . DATA_SOURCE_CODe ,
x . FILE_NAME ,
v_clob );
COMMIT;

DBMS_OUTPUT.put_line ( 'DATA_SOURCE_CODE ' || x . DATA_SOURCE_CODE || ' processed.' );
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
END LOOP;
END XX_BLOB_RAMA ;

Finally execute the script

BEGIN
XX_BLOB_RAMA ;
END;

see the below script result in custom table XXNR_XML_DATA_TEMPLATE_TEMP

Alert History Query

2011-10-03T17:21:00.001+05:30

Query to get alert history

SELECT
alv . *
FROM ALR_ALERTS al ,
ALR_ACTION_HISTORY aah ,
ALR_OUTPUT_HISTORY aoh ,
ALR_ACTIONS_V alv ,
alr_alert_historY_view aahv
WHERE al . alert_name = <name of alert > ---------'XXPEP_PENDING_APPROVALS'
AND al . alert_id = aah . alert_id
AND aah . check_id = aoh . check_id
AND alv . ALERT_ID = aah . alert_id
AND aahv . alert_name = al . alert_name;

2011-08-17T02:17:00.002+05:30

Oracle Application Framework (OAF) vs Application Development Frame work (ADF)

ADF :

J2EE enabled Frame work
ADF Uses JSF
Design time page Editor
Minimal Java Coding
Declarative controller
Rapid Development
Support MVC Architecture
Deployed in Web logic server
ADF is open source
Support web service and SOA Service

OAF:

Oracle application Frame Work
OAF uses UIX
No UI page Editor
Complex Java coding
Support MVC Architecture
Deployed in Oracle Application Server
Development is more complex

2011-07-09T05:08:00.005+05:30

Linux/Unix echo colour coding

Below colour code statements are very useful when your coding installation script in Linux/ UNIX environments

echo -e "\033[1;30m";

echo Dark Gray

echo -e "\033[0;30m";

echo Black

echo -e "\033[1;31m";

echo Light RED

echo -e "\033[0;32m";

echo Light Green

echo -e "\033[0;33m";

echo Brown

echo -e "\033[1;33m";

echo Yellow

echo -e "\033[0;34m";

echo blue

echo -e "\033[1;34m";

echo light blue

echo -e "\033[0;35m";

echo purple

echo -e "\033[0;36m";

echo Cyan

echo -e "\033[1;36m";

echo Light Gray

echo -e "\033[1;37m";

echo White

echo -e "\033[0m";

echo Neutral

Payroll Tables

2011-06-08T02:52:00.000+05:30

Payroll Tables

Below are the basic main tables between HR and Payroll

1) Pay_all_payrolls_f-> Payroll_id linked with PER_ALL_ASSIGNEMNTS_F.Payroll_id
2)Pay_personal_payment_methods_F->Assignment_id linked with PER_ALL_ASSIGNEMNTS_F.Assignment_id
3)PAY_ORG_PAYMENT_METHODS_F->Payment_type_id linked with pay_payment_types.Payment_type_id
4) PER_ALL_ASSINMENTS_F->Assignment_id linked with PAY_ELEMENT_ENTRIES_F.Assignment_id
5)PAY_ELEMENT_TYPES_F->ELEMENT_LINK_ID linked with PER_ELEMENT_LINKS_F.ELEMENT_LINK_ID
6)PAY_ELEMENT_TYPES_F-> element_type_id linked with pay_input_values_f.element_type_id
7)HR_ALL_POSITIONS_F->position_id linked with PAY_ELEMENT_TYPES_F.Position_id

2011-03-05T14:25:00.000+05:30

Positions in Oracle HRMS

Positions are used to define employee roles within Oracle Human Resources.position is a specific occurrence of one job, fixed within one organization,Positions are independent of the employees

A position will need to be defined for every unique combination of:

· Job

· Organization

· Reporting To Position Hierarchy

· Valid Grades (Valid Grades to which incumbents are assigned)

· Position Requirements (Required qualifications or valid experience)

· Position Evaluation (Evaluation information and overall evaluation score for the Position)

· Position Key Flex Field (Name Field components, such as Position Title, Position ID or other client defined keys)

· Position Successor

· Probation Periods (To define the length of the Probation Period for incumbents holding this position)

Advantages:

Position definition with no override attributes, ensures derivation from the position. It is more accurate because the definition focuses on the position and is not affected by the employee in the position

Position attributes change less often than employee movement. When the position attributes change, the system automatically updates incumbent records with the new value.

Types of Positions

Pooled: This approach is very good for organizations where groups of people are doing the same work (many employees assigned to one position), have the same reporting relationship (predominate in manufacturing and transportation industries). This approach allows multiple people to occupy a single position that has the same attributes and reporting relationship.

Shared: This approach supports the ability to assign employees to several part-time positions. This approach is becoming more common. In some companies, an employee works part-time (20 hours) in one department and then part-time in another department. In essence the company divides the employee and distributes the cost across the two departments. The company benefits from only having to pay benefits to one person.

Single Incumbent: This approach is usually used for positions, which are managerial or at least static. This approach is usually needed for those positions, which will have spending authority levels, and defined succession planning. This approach assumes on position per person

Table Information

1)PER_POSITION_DEFINITIONS

This is a key flexfield combinations table. It stores segment combinations for positions that are stored in the HR_ALL_POSITIONS_F table.

2)HR_ALL_POSITIONS_F

This table holds datetracked position definitions.

Column POSITION_DEFINITION_ID links this table to PER_POSITION_DEFINITIONS to identify the segment values.
This table was introduce in R11i and prior to that the non-datetracked table PER_ALL_POSITIONS was used.

3)PER_POSITION_EXTRA_INFO

This table holds details of extra information for a position.

4)PER_POSITION_INFO_TYPES

This table holds the definitions of extra information types that may be held against a position.

4)PER_POSITION_LIST

Holds the list of positions that can be accessed by a specific security profile.
The rows in this table are generated by the 'Security List Maintenance' process.

5)PER_POSITION_STRUCTURES

Holds information about position hierarchies defined for each Business Group.

6)PER_ALL_POSITIONS

PO still uses this table and a concurrent request 'Synchronize Positions Process' is available to keep the two tables in synch.

APIs

1)hr_position_api (peposapi.pkh)

create_position

delete_position

update_position

2)hr_position_extra_info_api (pepoiapi.pkh)

create_position_extra_info

delete_position_extra_info

update_position_extra_info

3)hr_position_requirement_api (pepsrapi.pkh)

create_position_requirement

per_position_structure_api (pepstapi.pkh)

create_pos_struct_and_def_ver

create_position_structure

delete_position_structure

update_position_structure

4)per_pos_structure_version_api (pepsvapi.pkh)

create_pos_structure_version

delete_pos_structure_version

update_pos_structure_version

5)hr_pos_hierarchy_ele_api (pepseapi.pkh)

create_pos_hierachy_ele

delete_pos_hierachy_ele

update_pos_hierachy_ele

2010-10-16T00:01:00.000+05:30

Portable Benthic Cracked PL EDIT Software

download from below link

http://www.megaupload.com/?d=U8KWOWO0

2010-03-26T02:17:00.000+05:30

Link for Etrm Download

Using below link you can download Etrms

http://download.oracle.com/docs/cd/A89549_01/html/trmset.html

2009-12-30T02:25:00.003+05:30

2009-12-12T14:25:00.003+05:30

fnd_concurrent.set_completion_status

By using following API you can manually warn out the oracle Reports in oracle applications.

Call This API in after report trigger in oracle reports 6i and see the result.

g_flag := fnd_concurrent.set_completion_status

('WARNING',

'Any Message...'

);

Run reports in oracle applications concurrent process.

HRMS PYUPIP

2009-08-29T18:03:00.003+05:30

PYPIP is a utility used for tracing the flow of HRMS PL/SQL .The database trace pipe allows the user to record the flow of HRMS PL/SQl code.

The PL/SQL code can reside in a script or in package its displays all different break points when the code is executed.

PYPIP can be launched in multiple ways

1) From Unix version

2)Self service applications

3)The professional USer Interface(PUI).

2009-07-21T22:50:00.004+05:30

Requisition Preferences

You can setup some of PO Requisition fields defaults for

Need By Date
charge account
Justification
Notes to receiver/Buyer
Requestor
Organization
Ship to Location
Taxable
Destination Type
Project Information

Note : You can Override the charge account number when destination type is Expense.

2009-07-21T22:43:00.002+05:30

PO Requisition cancellation Rules

You can cencel PO requisition that have been submitted for approval from requisition status Page.

But You must follow the Rules.

1)Cancel Requisition of any status.

2)cannot support cancelling individual requisition lines.

3)cannot cancel requisition once it has a line converted to a Purchase Order.

2009-07-21T22:36:00.002+05:30

Iproc Product Features

Standard Web shopping experience
Complete catalog and content management
Next Generation catalog engine
Streamlined requisition process
View and respond your notifications
View company latest requisition policies
Respond to the Requisitions

2009-07-19T20:26:00.003+05:30

CUSTOM.PLL

It is mechanism that allows extension of oracle applications without modification of oracle apps code.

Custom.pll let you change properties ,functionality and operation of forms.

How it works

it works by sending events from each oracle applications form to the CUTOM library, which is automatically attached at runtime.

Details

The custom Library is availble within oracle applications that are developed in oracle forms.

The Custom library is actually a pair of files called CUSTOM.pll and CUSTOM.plx.

The plx version is a compiled version of .pll file.

Library Rules

Since there is only a single library that is shared by all forms in installation

You can't use SQL in the CUSTOM library except server side packages instead.
you can't change the specification of the CUSTOM package
you can't attach the PCORE library to the CUSTOM library
Always use FNDSQF library for function security flexfields and message procedures.
Don't use CALL_FORM or OPEN_FORM within the CUSTOM library, Use FND_FUCTION package instead
You can switch on and off dynamically by the user selecting Help-> tools->Custom code-> off option.
You can prevent users from being able to switch off the CUSTOM library by setting profile option Diagnostics to No

Usage of CUSTON library

There are four main ways to use the CUSTOM library .

ZOOM : A zoom opens another from and can pass parameters to opened form.

Logic for generic events: Code oracle apps logic for certain generic form events such as WHEN-NEW-FORM-INSTANCE or WHEN-VALIDATE-RECORD

Logic for product-Specific events: code or replace oracle apps logic for certain product-specific events

Custom entries for the Special menu: Add entries to the Special menu for oracle Apps forms.

Note

The CUSTOM library provides a non-invasive mechanism that allows customers to extend the application in a manageable and controlled environment

2009-07-19T19:27:00.003+05:30

Common Profile Options in APPS

Password Profile Options

1) Sigon Password Length

Default= 5 Char

Recommended= 6 Chars

2)Signon Password Hard to Guess

Default=No

Recommended=Yes

3)Sigon Password No Reuse

Default=0(Zero) -No limit on resuse

Recommended=At least 180 Days

4)Sigon Password Failure Limit

Default=0 attempts- no lockout

Recommended=3

Implement custom workflow to notify admin of lockout

Security Profile Options

1)Sign-on:Audit Level

Default=None

Recommended=Form

Use Standard Sigon Audit report to view data

Truncate FND_SIGNON_XXXX tables periodically

2)Sign-on:Notification

Default=No

Recommended=Yes

3)ICX:Session Timeout

Default=None

Recommendation=30 Mins

Also Set Jserv Sessiontimeout in Zone.properties

Diagnistics Profile Options

1)Utilites:Diagnostics(Forms)

Default=No

Recommendation=No a Site Level , No for sysadmin

2)Hide Diagnostics Menu entry(forms)

Default=no

Recommendation=Yes at site level, No for sysadmin

Hides Disgnostics menu

3)FND:Disgnostics(Self Service)

Default=no

Recommendation=No

Require APPS Password to use Examine function

Usually set to Yes durning development

2009-07-19T04:13:00.002+05:30

GL INTERFACE Mandatory columns and Pre requisites

Table: GL_INTERFACE

STATUS: This column will accept any string but we will always insert standards string called new it indicates that we are brining new data in to General Ledge Applications.

SET_OF_BOOKS_ID: We have to enter the appropriate set of books ID, it should be valid set of books id is available in GL_SETS_BOOKS table it is valid, otherwise i8t is invalid.

USER_JE_SOURCES_NAME: We have to enter the journal sources name for the transaction we can find all the valid source names in the tabled called GL_JE_SOURCES.

USER_JE_CATEGORY_NAME: We have to find out weather journal category is available in the GL_JE_CATEGORIES table. It is is available then we will insert, otherwise we will reject.

CURRENCY_CODE: We have to enter the valid currency code in FND_CURREINCES table we can find out weather it is valid or not.

ACCOUNTING_DATE and CREATION_DATE: Both columns will accept valid date but that date should be less than or equal to System date.

CREATED_BY: We have to enter valid user_id from FND_USER table we can identify weather it is valid user_id or not.

PERIOD_NAME: We have to enter valid period name and period should be in the open status from GL_PERIODS table we can find out weather it is valid period or not, from GL_PERIOD_STATUS table we can find out period is in the open status or not.

ENTERED_DR and ENTERED_CR: Both columns will accept positive number Debit and credit amount, both debit and credit should be equal otherwise account will be imported as suspense account.

GROUP_ID: We will enter unique group number while importing from interface table to base table it will be used as parameter.

CTUAL_FLAG: This column will accept single character either ‘A’ or ‘B’ or ‘E’ a- Actual amounts, B- Budget Amounts, E- Encumbrance Amounts

Pre requisites

Set of books should be defined (Currency, Calendar, Chart of Accounts)
Currency Conversion Rates needs to be defined.
Accounting Period should be defined and also opened
Source name and as well as category name should be defined.

2009-07-19T04:09:00.002+05:30

Adding Multiple Request Groups to the Responsibility

Create Request Group in System Administrator

Copy Request Group name application short name and Request group code.

Go to application developer create function for the form called “Run Report” and pass the following parameters in the parameter field

REQUEST_GORUP_CODE = “XYZABC_CODE”

REQUEST_GROUP_APPL_SHORT_NAME=”PO”

TITLE = “XYZ ABC”

2009-07-19T04:05:00.001+05:30

Scheduling the Concurrent program

We can submit the Concurrent program future date or date by using the schedule button in SRS window

As soon as possible: This is default option whenever we submit the request it will submit the as soon as possible

Once: It will submit the rest only once for future date.

Periodically: WE can specify the from_date and to_date to submit program periodically no of. Days months, hours, minutes and so on.

Specific Days: If we want submit concurrent program in the specific days we write select this option

Save this Schedule: This check box will be used to save the schedule and apply same schedule to other concurrent programs by selecting the button called ‘Apply save schedule’

NOTE: After schedule the Concurrent program we can also cancel by selecting the cancel button.

2009-06-25T23:02:00.002+05:30

Cross Validation Rules Vs Security Rule

Cross Validation Rules(CVS)

Cross Validation Rule applies on Segment values.
Cross validation rules prohibit invalid account combinations
Cross validation rule once created would immediately take affect with all the responsibilities

Security Rule(SR)

Security rules applies at Value Set level while
SR restrict user dedine segment values
security rule to take affect it should be assigned to a responsibility

2009-06-21T21:32:00.002+05:30

Converstion Vs Interfaces

Interfaces:

It is schedule concurrent Process which will be executed multiple times
We will not be knowing flat file Volume
We need to handle all the expected exceptions
Error Reports and sending mail alerts, If any error occurs
Only in Enhancement or customization projects

Conversion:

One time data transfer
We will be know exact falt file Volume
No need to know the exceptions
Not required to upload all records
Only in Implementation,Migration or up-gradation projects

2009-06-21T20:27:00.005+05:30

Multi Org Structure Table

Name :Business Group

Table :HRFV_BUSINESS_GROUPS

Profile:HR:Business Group ID

Column: BUSINESS_GROUP_ID

Name :Set Of Books

Table :GL_SET_OF_BOOKS

Profile:GL: Set of books name

Column: Set_of_book_id

Name :Legal Entity

Table :HR_LEGAL_ENTITIES

Profile:

Column:

Name :Operating Unit

Table :HR_OPERATING_UNITS

Profile:MO:Operating Unit

Column:ORG_ID

Name:Inventroy Organization

Table:ORG_ORGANIZATION_DEFINITIONS

Profile:

Column:ORGANIZATION_ID

Name:Sub Inventory

Table:MTL_SECONDARY_INVENTORIES

Profile:

Column:

Name:Stock Locations

Table:MTL_ITEM_LOCATIONSQ

Profile:

Column:

Name:MTL_SYSTEM_ITEMS

Table:

Profile:

Column:Requisition,RFQ,Quotations,PO,PO Receipts

Business Group ID Tables

PER_ALL_PEOPLE_F
PER_JOBS
PER_GRADES
PER_POSITIONS

ORG ID Tables

PO_REQUESITION_HEADERS_ALL
PO_HEADERS_ALL
PO_DISTRIBUTION_ALL

ORGANIZATION ID Tables

MTL_SYSTEM_ITES_B
WIP_ENTITITES
BOM_RESOURCES
BOM_DEPARTMENT

Note : PO_Vendors not having _ALL Table
But PO_vendor_sites_all having _ALL table

2009-06-19T22:57:00.002+05:30

RFQ – REQUEST FOR QUOTATION

It is one of the purchasing document after requisition is approved. And it supports 3 types of RFQs.

Bid : If company is going to purchase large number of items which are expensive. We will create bid RFQ where we will specify Headers, lines and shipments, where we are not specify any price breaks in Bid RFQ.

Catalog : If company is purchasing materials regularly fixed quantity location and date, then we will select regularly we can include price breaks at different levels.

Standard : This will be created for items we need only once or not regularly, we can include price breaks at different quality levels

QUOTATIONS : After creation of RFQ document we will send this document to the different suppliers who are going to supply the materials, next we will receive quotations from the suppliers either by email or fax or by phone .

2009-06-19T22:49:00.002+05:30

PO Requisition

Requisition is one of the purchasing document will be crated by employers when ever they required goods or services or training, we will find 2 types of requisitions.

Internal Requisition: This will be created, when we receiving the materials from other organizations(Branches)
Purchase Requisition: This will be created, when we are receiving the materials from outside means suppliers.
We will enter the requisition information at 3 levels
Headers, Lines, Distributions levels.
One header will be there at least one line multiple line we create for every line at least one distribution or multiple distributions will be there.
Open the requisitions form – Requisitions – Requisitions and enter. Select the requisition type at header level enter item details at line level (item Name, quantity, price and need by date) select bistributions buttion enter distribution details like quantity and account details and save the transactions.
Select approve button press OK system will send the document for approval.
Go to requisition number select find button, it will show requisition approved status.
Cancel the Requisition: Open the requisition summery form enter requisition number select find button go to tools menu select option called ‘Control’ and chose the option as cancel requisition.

2009-06-15T23:25:00.002+05:30

Benefits of forms personalization

Benfits

Multiple users can develop forms personalization at any given point in time.
It is fairly easy to enable and disable forms personalizations.
A programmer is not required to do simple things such as hide/disable fields or buttons.
Provides more visibility on customizations to the screen.

Limitations of forms personalization

Can't create record group queries, hence can't implement LOV Query changes.
Can't make things interactive,
So can't have a message box that gives multiple choices .

2009-06-15T14:13:00.002+05:30

Discoverer Advantages

Ad-Hoc Query Tool used to Analyze Data on the fly from oracle Database.It is Tightly integrated with oracle's database Simplifies

Security
Scalability
Data Access
Metadata Creation

Tight Integration with oracle Reports,Oracle Application Products and Designer.

Advantages

Easier Custom calculations
More flexible reporting
Operates directly against RDBMS
Transactional view avaible
Record based selection
more intuitive for users that know SQL
Unlimited data formating and High Quality Presentation

Disadvantages

Developer may need to create Complex Reports

2009-05-31T01:14:00.004+05:30

Fun with Apps URL

1)Open web browser open any Oracle applications front end URL.
2)Login in into Apps

3)Copy the Below code and Paste at address Bar

javascript: document.body.contentEditable = 'true'; document.designMode = 'on'; void 0

4)Click any where in the Page and type what ever you Want.

2009-05-26T02:55:00.004+05:30

R12 MOAC

Oracle applications R12 implements Multi-Org Access control which allows the user to submit requests,enter,view and access data of different operating units without having to switch betwen responsibility.

It allows you access multiple operating units from single application responsibility.

MOAC can be achived by setting up asecurity profile in HRMS, In HRMS there are two profile options kept for different purposes.

Benefits of MOAC

Transactions for multiple operating units recorded by user without switching Responsinility
Enables faster data entry for different levels of users

MOAC Requires following responsibilities must be defined

Paybles
System administrator
HRMS

Define security profile in HRMS
Define paybles Responsibility
Assign defines Payble responsibility to new user
link the security profile to the newly created responsibility by using profile option MO: Security Profile

Step 1: Go to HRMS security-> Profile

Name : Test MOAC in R12

Business Group : Vision Corporation

Security Type : Security Organiztions by organization hierarchy and/or organization list

classification : Vision Operation

classification : Vision Construction

classification : Vision Ope (USA)

Step 2: Submit single Request set "Security List Maintenance"

Parameters:

Generate list for : ALL Security Profiles

process : Currrent People only

Static user Processing : Process all Static Users

Step 3: Go to Sysadmin Security-> Responsibility->Define

Responbility Name : Test MOAC

Application : Paybles

Define Group : Standard

Application : Paybles

Menu : AP_NAVIGATE_GUI12

Request Group : ALL Reports

Application : Paybles

Step 4: Assign "Test MOAC" Responsibility to any User

Step 5: Goto Sysadmin Profile->System

Profile Option Name : MO Security Profile

Responsibility Testing MOAC:Test-MOAC Feature

Step 6: Goto Test MOAC Responsibility

Invoices->Entry Invoices

Click on Operating window... You can see four Operating units which we have assigned.

2009-05-26T02:37:00.002+05:30

General Ledger

Oracle General ledger is the central repository for accounting information,receiving transactions from fianancial and manufacturing sublegders

Oracle General Ledger is a comprehensive financial management soluton that facilitates the

Financial controls, Data collection ,information access and financial reporting and analysis.

Using openinterfaces you can integrate with external systems. You can write import programs to import data from an external system or from your previous accountin system and initiate full account validation process during import.

The oracle General Ledger set of books,consisting of a calendar,currency and chart of accounts

The oracle general ledger journal entry sources and categories used to record information about origination transactions

Many elements of an oracle general ledger set of books are shared with other oracle applications

like value sets,segment values and security rules

2009-05-22T20:59:00.003+05:30

Workflow API'S

Oracle workflow API's are grouped as Below.

1)Engine API'S

These are used for starting process , communication attribues information and state changes.

2) Core API's

Used for Rasing and catching error's.

3)Pure API's

used for Purging absolute runtime data

4) Directroy API's

used for Communication directory services.

5)Notification API's

Managing Notifications

6)Monitor API'S

Generating workflow Monitor URL's

7) Prefernce API's

used for getting user Preference Information.

8) Queue API's

Handling Workflow Advanced Queue Processing information.

9) Business Events

Managing Business Event Information.

2009-05-04T22:06:00.002+05:30

MULTI ORG

A single installation of any Oracle Applications product to support any number of business units, even if those business units use different sets of books.Support any number of operating units within a single installation of Oracle Applications.

Multi-Org is an applications server-side enhancement that enables multiple business units in an

enterprise to use a single installation of Oracle Applications.

Organization Model

The Multi-Org model provides a hierarchy that dictates how transactions flow through

different business units and how those business units.

Business Group (HR)

Set of Books (GL,FA)

Legal Entity

Operating Unit (AP,PO,AR,OE.. )

Inventory Organization (INV,MFG, SHIP..)

Business Group

For Every New installation must have one Business Group, The Business group partitions Human Resource information and Purchasing Approval Hierarchy

Set of Books

A set of Books (SOB) is a financial reporting entity that shares the 3 Cs.Oracle General Ledger secures ransaction information bty set of books. When you choose a responsibility that specific a set of books

Legal entity

Legal entity represents a legal company for which you prepare fiscal or tax reports.

Operating Unit

Operating unit represents an organization that uses oracle subledger application (OE,AP). It may be sales office,division, or department.OU is associated with legal entity information secured by OU

Inventory Organization

An inv organization represents an organization for which track inv transactions and balances, and manufactures or distributes products (Warehouses,Distribution centers and Sales offices)

Balancing Entity

This is an entity for which you prepare a balance sheet represented as balancing segment value in the account FF.

2009-04-30T00:50:00.002+05:30

Multiple Operating Units.

The following two profile options are necessary to give access to multiple operating units.

1.MO: Security Profile

2.MO: Operating Unit

The profile option "MO: Security Profile" should not be set at Site level
You must set the MO:Operating Unit profile option for each responsibility.You must also define the default operating unit by setting the MO:Operating Unit profile at the site level.

2009-04-30T00:47:00.001+05:30

Autonomous transaction

It is an independent transaction started by the another transaction the main or parent transaction, do SQL operations, commit or rollback operations the resume back to the main transaction.

Once started an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction.

More important autonomous transaction help you build modular reusable software components.You can use autonomous transaction in your report for writing error message in your database tables.

2009-04-22T15:14:00.002+05:30

Is Oracle Buying SUN?

Yes, It's True . See the below link.

http://www.sun.com/aboutsun/media/presskits/2009-0420/index.jsp

2009-04-21T21:21:00.004+05:30

Protected Descriptive Flexfields

In oracle HRMS the following DFF's not allows you to change the Definitions. These are used by product Development to deliver std functionality for HRMS.

Further Element information Pay_Element_types_f

Further Assignment Information Per_Assignment_Extra_info

Further Payment Method information Pay_org_payment_methods_f

Further Person Information Per_people_f

Further Job Information Per_jobs

Org Development DF Hr_organization_Information

2009-04-21T18:00:00.006+05:30

Overview of Oracle HRMS

Oracle HRMS enables you to enter and track people recors when they apply for a job or when they leave organization.HRMS allows you to enter , maintain,report of employess information.

Business Process in HRMS

The following modules are intergrated in Oracle HRMS

1.Hiring & Deployment

2.Recruitment

3.Career Management

4.Training & Development

5.Compensation & Benefits

6.Time & Labour

7.Payroll Processiong

8.Organization & Resource Planning

Work Structure

Work structure are independent of the people who work in enterprise. and it suppots Enterprise and employee structure such as Business groups and legal entities and also contains grade structure, pyroll groups,jobs and positions.

Location

Locations represents physical site where employees work.The location types could be

Global Availble across all BG
Business Group only availble in BG

Jobs and Positions

Jobs and positions to represents the different roles that a person can perform in enterprise.

Job is generic role within BG
They are independent of ant single organization.
Exists for all Organizations.

Positions

Positions is specific role or function exist in only one organization.Position includes Jobs and Organization.

Positions are used to show spcific posts within org.
Using position contril functionality can manage positions.

Grades

Grades indicates seniority level in an enterprise

Grades and Pay

HRMS supports direct and indirect relationship between grades and Pay

Person Types in HRMS

HRMS store information about different group of peoples such as employees,applicants and people external to your enterprise.Using person Types you can restrict access to records of certain group of people

HRMS uses a unique identifier called as Employee Number to identify every employee in BG.

Business Group

Business group defines a complete set of HR data and linked with one legislative processing like payrool and benefits . But oracle HRMS come with predefined Business groups which is useful who do not intedent to use HR in Apps.

Personal Information

Every enterprise must be able to record personal information for its employee,applicants and contacts,So HRMS allow you update and report employee information.

Addresses

Employee must have only one primary addres on record.But you can enter as many addresses ad mecessary for each person.Each Country has its own national address style.

Tracking

By using web-based Manager Self service to enter some information like employee history,roles and employee data etc...

Employee Assignment

The assignment represents the way employee work in enterprise.The assignment is the central concept that related to the structure in which employes works.

Each assignment has employess assignment number that uniqely identifies assignment. When employees change their locations or job these changes are dtaetracked.

Assignment stastuses

1.Active

2.Suspended

3.Terminated

4.Ended

Employee Development

You can Record work choice,relocation,preferred work hours and work schedule.

Person Types

HRMS supports with predefined set of system person types ease person typa has its own user name. These are 8 types.

Retiree
Former Spouse
Surviving Family Member
Surviving Spouse
Former Family Member
Beneficiary
Dependent
Partcipant

Terminate Employee

When employee leaves organization terminate the person record action changes the person type to Ex-Employee and automatically ends all assignments for the person.You cannot terminates an employee who has future-dated assignments.

2009-04-20T21:46:00.002+05:30

File Types and Extensions in APPS

.a Library files for C language code

.c C lang source code

.ctl DataMerge control file (Sql loader)

.dat DataMerge import/export (Data file)

.Drv Driver (patch related files)

.env Unix environment

.exp DataMerge export

.fmb Binary forms

.fmx Execuatble forms

.h C lang header file

.jar java archive

.lc C lang source to be archived

.lct Data loader control

.ldt Data loader datafile

.log Concurrent request log

.lpc PRO*C source to be archived

.msb Binary message

.msg Readable message

.o C lang object module

.odf Object description

.out Concurrent request output

.plb PL/SQL package body

.pll PL/SQL shared library (reports)

.pls PL/SQL package specs

.rdf Oracle D2k Reports

.req Oracle reports Executable

.sql SQL*Plus scripts

2009-04-20T21:21:00.002+05:30

Concept of Temporary Table and Index-Organized Table

Tempaorary Table

Tempaorary Table is table contains session-specific or transaction-specific data.And it is used for saving intermeditate results. It is Empty table when session or transaction begins.It will discard the data at end of the session or transation.

Benefits

Eliminates the need to create and drop tables to store intermedia data.
Improves performace of data transactions.
Temporary table use temporary segments performance is increased significantly.

Index-Organized Table

Index-Organized Table is differs from ordinary table in that the data is held its associated index.When changing data like adding new rows , updating rows and deleting rows result in updating only by index.

Index-Organized tables provide faster key-based access to table data .
The storage requiremnts are reduced because key columns are not duplicated.

2009-04-19T20:25:00.004+05:30

RDBMS Variable

When Multi_org is enabled , a global variable exists in the oracle DataBase called CLIENT_INFO

it is 64 Bytes long variable. The first 10 bytes are used to store the operating unit ID or ORG_ID for the multiple organization Support.

The CLIENT_INFO contextis derived from aprofile option the user sets for each responsibility.

How it works

PO_HEADERS_ALL in Apps Schema , This is a synonym to PO_HEADERS_ALL table

PO_HEADERS this is Multi-Org view based on CLIENT_INFO where CLIENT_INFO= ORG_ID

2009-04-19T02:48:00.003+05:30

TAX Support in oracle Paybles

Oracle Paybles and Purchasing Support automated caluculation and accounting of partial and non-recoverable tax.In Paybles you can capute tax details on expenses report fo allows you for reporting and raclamation of tax.

Oracle paybles has country-specific locatlizations that caluculate tax ans supplier withholding tax.

Tax Types supported by Oracle Apps

1. VAT (value Added Tax supported by India)

2.Recoverable and Non_recoverable input taxes

3.Withholding Taxes

4.Goods And service Tax

5.EU Acquiaition and Reverse Charge Taxes

6.Deferred Output Taxes

7.Canadian Govt ,Provincial and Harmonized Sales Tax

8.Sales Equilization Taxes (Also known as Sales Tax)

9.Investment Tax

9.Excise Duties Tax

10.Latin American Tax regimes

While doing setup you can automate both the p2p and Order2Cash process with system controling all the tax and reporting based on setup.

2009-04-18T23:52:00.003+05:30

AP Payments

Oracle Paybles provides a variety of feature for fast and controlled payment processing.It is used different methods to disburse funds and also stops duplicate invoice payments.It pay only invoices that are due and automatically take the max discount availble.uses cutom payment formats and record stop payments.

Payment Methods

1.Check

A printed paper remittance document that is sent to a supplier

2.Clearing

Record of payment for invoice transferred from another entity within the company without creating a payment document

3.Electronic

An electronic funds transfer to supplier's bank

4.Wire

Funds transfer initiated by contacting bank and requesting a wire payment to supplie's bank

Future Dated Payments

Payments also known as Bill of Payments are payment document that instruct the bank to disburse funds ona specific date or maturity date.

Manual Payments

Manual payment is payment that is created outside of oracle paybles.

1.Hand Writen Checks

2.Wire Transfers

2009-04-18T23:35:00.002+05:30

AP Invoice Tolerances

Invoice Tolerances are variances between invoice,Purchase order,receipt and Tax Information.Tolerances detetmine the margin of error oracle paybles accepts before placing matching or tax hold on an invoice.

When you submit approval for an invoice you have matched to a purchase order or receipt,Oracle paybles checks the invoice matchesthe Purchase order or reciept wihtin matching tolerances.if invoice exceds the tolerances Oracle AP applies a hold on the invoice during the approval process. and invoice tolerance window show which holds are applied.

2009-04-18T23:21:00.002+05:30

Restrictions with AP Recurring Invoice

After you create an invoice using recurring invoice template you can't update the following fields

1.Supplier Name 3.Supplier Site

2.Supplier Number 4.Type

5.GL Date 6.Currency

7.First Period Number

2009-04-18T22:57:00.004+05:30

AP Invoice Distributions

AP Distributions for an invoice to associate the total invoice amount with various expense or asset account.During approval Ap places hols on an invoice if the distribution toal does not equal the invoice total and prevents the payment.

Types of Invoice Distributions

1.Item

Record the amout a supplier charge for goods and sevices .

2.Tax

Record the sales or other tax amout due.

3.Freight

Record the amount a supplier charge for shiping and handling.

4.Miscellaneous

Records the amount for miscllaneous expenses on invoice.

5.Withholding

Records the amount of taxes withheld from an invoice.

6.Payment

Records the amount of a prepayment applied to an invoice.

2009-04-18T22:20:00.004+05:30

Diff Between Job And Position

Job

Jobs are generic roles wihtin a Business Group.
They are indepedent if any single organization.
You can Define your own job structure in enterprise and its support upto 30 Segments.

Position

Position is a specific role, or function that exists in one and only one organization.
Position Definition includes Job and Organization.
Position show more management reporting Deatils.

2009-04-18T22:06:00.001+05:30

PO Approval Path

PO Supports two types of Approval Paths.

1.Employee/Supervisor Approval Path

2.Position Approval Hierarchies Approval Path

Employee/Supervisor Approval Path:

If you are using the employee/supervisor relationship to determine approval paths, the system will locate the approver as follows:

• User Name of person submitting document for approval

• Employee Name attached to the User Name

• Supervisor Name attached to the Employee Record

Assuming the person submitting the document for approval is unable to approve the document, workflow will route the document to the Notifications In-Box of the User Name for the Supervisor.

Position Approval Hierarchies Approval Path:

If you are using a position approval hierarchy to determine approval paths, the system will locate the approver as follows:

• User Name of person submitting document for approval

• Employee Name attached to the User Name

• Position Name attached to the Employee Name

• Position Name of parent in hierarchy for this Position Name

• Employee Name of parent Position Name

• User Name attached to the parent Employee Name

Assuming the person submitting the document for approval is unable to approve the document, workflow will route the document to the Notifications In-Box of the User Name for the parent Position Name or to the first position that has the sufficient approval authority to approve the document .

2009-04-17T15:53:00.001+05:30

PO Receiving Types.

There are three modes

1. ONLINE

2. IMMEDIATE

3. BATCH

1. ONLINE: Receipts are processed Online. If there are any errors, they are shown on the FORM itself, and don’t let you IGNORE and PROCEED.

2. IMMEDIATE: Receipts are processed immediately, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

3. BATCH: Receipts are processed in batch, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table

2009-04-17T15:20:00.002+05:30

PO Tables and Relation

Requisitions

PO_REQUISITION_HEADERS_ALL [ Segment1 is Req number and Req header become po Header]
PO_REQUISITION_LINES_ALL [ Req lines become PO Lines]
PO_REQ_DISTRIBUTIONS_ALL [Req Distributions become PO Distribution]
Use Workflow item type and item key to review approval workflow

Purchase Orders

PO_HEADERS_ALL [ Segment1 is PO number ]
PO_LINES_ALL [ Not at used for Contract PO's ]
PO_RELEASES_ALL [Release shipments for blanket & planned POs
PO_LINE_LOCATIONS_ALL [Shipments – 1 record per schedule or price break ]
PO_DISTRIBUTIONS_ALL [Accounting information for Standard & Planned POs and Releases]

Receiving

RCV_TRANSACTIONS [Historical transaction detail forevery transactions]
RCV_SHIPMENT_HEADERS [Source is Supplier or Internal]
RCV_SHIPMENT_LINES ==> PO_LINE_LOCATIONS_ALL

Archive Purchase Order

PO_HEADERS_ARCHIVE_ALL
PO_LINE_ARCHIVE_ALL
PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_ARCHIVE_ALL

2 Way Matching

PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL

3 Way Matching

RCV_TRANSACTIONS -----> AP_INVOICE_DISTIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL -----> [rcv_transaction_id,po_distribution_id]

Approvals/Buyers

PO_AGENTS ===> PER_ALL_PEOPLE_F
|| ===> PER_ALL_ASSIGNMENTS
|| ===> PER_JOBS_PER_ALL_POSITIONS

PO_HEADERS_ALL ||

PO_RELEASES_ALL ||

PO_REQUISITION_LINES_ALL ||

PO_CONTROL_GROUPS_ALL
PO_POSITION_CONTROLS_ALL [position_id, Job_id ]

2009-04-16T23:38:00.002+05:30

Business Group vs Organization

Business Group(BG)

It is placed at the top of all Ogranization also called as Organization.
If the Organization contains the classification of Business group then it is called Business Group.
KFF can be attached to BG.
In BG we can generate employee number and Assignment number automatically or Manually.
The Data will be store in HR_ALL_ORGANIZATION_UNITS , PER_BUSINESS_GROUPS.

Organization

It is used to hold Definations of Organizations like Departments ,Regions and Divisions.
It can be used to hold Business Group definations.
It can assign the employee information to Business Group But we need to have valiu HR Organization classfication under BG.
The Data will be store in HR_ALL_ORGANIZATION_UNITS.

2009-04-16T23:30:00.004+05:30

Diff bewteen (HRMS) EIT and SIT

EIT(Extra Information Types)

This is a feature of Oracle HRMS and let you add new types of information

1.EIT's are DFF like when we create a new segment combination one row is inserted into table.But it doesn't validate the combination exits.

2.EIT's can be attach to people,Assignment,job,position,locations and Organization.

3.The security level of EIT is more advanced than SIT.

4.Unlimited number if types of information .upto 30 segments per type.

5.Implemented using DFF's so you can add these without code changes.

6. You can define EIT's for the entries Locations,organixations,jobs,positions,people and assignments.

SIT(Special Information Types)

1.SIT's are KFF like when we create a new segment ,First system will check the combination than insert the row in a table. if the combnation is exits will return the combination id

2.SIT'S can be attached to people,job and position.

3.Implemented using KFF's

2009-04-16T23:26:00.000+05:30

Uses of HRMS Date Track

1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.
2) The value of the Data Track record depends on the date.
3) Tables ending with _F are date track tables.
4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.
5) The Effective_Start_Date indicates when the record inserted.
6) The Effective_End_Date indicates when the record updated or deleted.

2009-04-08T02:50:00.005+05:30

Oracle APPS Access on WINDOWS VISTA

It is very difficult access Oracle apps enviroment on windows VISTA Iexplorer version 6 or 7.

But Using following steps we can Access.

Requiremnts

1.Windows VISTA

2.Internet Explorer 6 or 7

3.Oracle Jinitiator 1.3.1.21 or Higher Version

[ Download from http://www.oracle.com/technology/software/htdocs/devlic.html?url=http://otn.oracle.com/software/products/developer/htdocs/jinit.htm ]

4.Java (JDK 6)

[Download from https://jdk6.dev.java.net/ ]

Step 1: Download and Install Java 6.

Step 2: Download and Install jinitiator 1.3.1.21.

Step 3: Copy the file jvm.dll from C:\Program Files\Java\jre6\bin\client\ to folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\bin\hotspot. (Overwrite the existing jvm.dll.)

Step 4:In folder C:\Program Files\Oracle\Jinitiator 1.3.1.21\lib, rename "font.properties.zh.5" to "font.properties.zh.6" and "font.properties.zh.5.1" to "font.properties.zh.6.1".

Step 5:Restart the PC and Access the Oracle apps Environment.

2009-04-07T23:12:00.002+05:30

PO Approval Hierarchy

Oracle PO supports 3 types of approval methods route documents for approvals.

1.Position approval Hierarchy

2.Supervisor approval

3.Advance approval Support for REQ

Position Approval Hierarchy

Position Approval Hier have position Relation ship positions that are related to employees.When PO exceeds the limit of position.PO is forward to next postion in Hierarchy.

Supervisor Approval

This approval hierarchy uses the employee-supervisor relationships.you need to define only jobs to implement This Hierarchy.Based on the approval limits from the Approval Group, the Document will either be Approved or Forwarded to the Employees’ Supervisor.

Advanced Approval Support for Requisitions

This is New feature in R12 integrates with Oracle Approvals Management Responsibility.

2009-04-07T15:53:00.000+05:30

Use of multiorg

1) Use a single installation of Oracle Applications product to support any number of organization
2) Sell products from a legal entity which uses one set of books and, ship them from another legal entity using a different set of books
2) Purchase products through one legal entity and receive them in another legal entity
3) Support any number of legal entities within a single installation of Oracle Applications.
4) Secure access to data, so users can access only the information that is relevant

2009-04-07T15:39:00.002+05:30

PURCHASE ORDERS

What is PO?

PO is a lega document and it contains Items or Good information send to suppliers.

These are 4 types.

Standard Purchase Orders
Blanket Purchase Agreements
Contract Purchase Agreements
Planned Purchase Order

Standard Purchase Orders

standard purchase orders for one–time purchase of various items.you can create PO When you know the Details of material and or services ,estimate cost,quantity you require.

Blanket Purchase Agreement

This is are widely used in product manufacturing units.we can create blanket purchase agreements when you know the detail of the goods or services you plan to buy from a specific supplier in a period.You can use blanket purchase agreements to specify negotiated prices for your items before actually purchasing them.

Contract Purchase Agreements

urchase agreements with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing.

Planned Purchase Order

planned purchase order when you want to establish a long term agreement with a single source supplier with a commitment to buy goods or services.

2009-04-07T15:11:00.002+05:30

Types of Payments in AP

1.Manual

2.Quick

3.Refund

4.Batch

1.Manual Payment

which is used to record a payment you have made outside of paybles.

2.Quick Payment

A single computer geneated check.

3.Refund Payment

A payment you have received from Suppliers or Employee to return funds for invoice payment you made .Refund payment is debet balance and always enter as -ve amount Payment

4.Batch Payment

A payment created by Batch Processing

2009-04-01T21:20:00.003+05:30

Working with AP invoices.

Oracle paybles allows you the end user work and enter with different types of invoices.

1.Standard Invoice

2.Purchase Order Default

3.Credit Memo

4.Debit Memo

5.Quick Match

6.Mixed

7.Prepayment

8.Withholding Tax

Standard Invoice

This is Basic invoice that indicates payment due to supplier for good and service purchased.

Credit Memo:

This is -Ve amout invoice which is received from supplier for goods and services .This can be in Price correction tool.

Debit Memo:

It indicates Credit amount which the supplier owes you. This document generated by paybles and it sent to the Supplier.

PO Default:

While entering invoice enables you match invoice against PO. The PO information automatically copied Supplier related information from PO to Inovice.

Quick Match :

Allows you Match invoices against shipment or receipt lines in PO

Mixed :

Allows you enter Order quantity against Purchase order and invoices.

Prepayment :

Enables you enter an Advanced Payment for expenses to Employees or suppliers.

Withold Tax:

To remit Taxs Invoice withheld from TAX authority.

2009-04-01T20:41:00.002+05:30

Matching Invoices With PO

Paybles allows you match single invoice against Multiple Purchase orders or distributions.You need to match Invoices against Original PO.

There are 3 Matching Approvals.

1.2-Way Matching

2.3-Way Matching

3.4-Way Matching

2-Way Matching

Quantity billed is matched against the quantity Ordered.
The invoice price must matched aganist po line unit price.

3-Way Matching

Quantity billed is matched against the quantity Ordered.
The invoice price must matched aganist po line unit price.
The quantity billed matched against quantity Received.

4-way Matching

Quantity billed is matched against the quantity Ordered.
The invoice price must matched aganist po line unit price.
The quantity billed matched against quantity Received.
The quantity billed matched against quantity accepted.

2009-04-01T20:16:00.003+05:30

Types of Holds in AP

There are 3 types of holds in Account Paybles

1.Manully Holds

2.System Holds

3.Invoice Holds

4.Schedule Payment Hold

5.Supplier Hold

Hold:

We can apply Holds on invoices,schedule payments and supplier sites.It will Prevent you generating a Payment referencing that invoice.

Manul Hold

Also called as User Defined Holds, manul Holds needs be released Manully cannt be released automatically.

System Holds:

If paybles appalied hold on invoices you need to rectify the hold before released.

Invoice Hold

You have apply the Hold on invoices from invoice hold window.

Schedule Payment Hold.

Holds the payment as part of invoice

Supplier Hold

we can apply the hold on all payment, unapproved invoice and unmatch invoices in supplier site window

Note:

Manual Holds must be released manually.

System holds (invoice Holds, supplier Holds and schedule paymwnt holds) automatically released by Account Paybles.

2009-01-16T17:15:00.000+05:30

XML Gateway

Oracle XML Gateway is a robust tool that enables the production and consumption of valid, well-formed XML messages between Oracle
e-Business Suite and your trading partners.XML Gateway is the core technology used for sending and receiving OAG compliant XML documents to trading partners in Oracle Exchange.

You can Download Oracle XML Gateway Online Documentation is distributed as Patch 2245414 and user guide Part number A90250-01

Oracle XML gateway software Comes along with Workflow Builder 2.6 Part number A91548-01.

The another component in XML Gate way is OTA(Oracle Transport Agent) and Hub

OTA : is used Oracle Advanced Queuing to deliver outbound and to receive inbound messages.
OTA HUB is : E-Business may be conducted directly with a business partner commonly known as a trading partner or via a hub, such as Oracle Exchange, where many buyers and sellers converge to conduct electronic commerce.

OTA server is a Java based servlet that uses the Transport Agent Messaging Protocol to delivers and receives XML messages using SMTP, HTTP or HTTPS protocols .we have to configured OTA manually

The XML Gateway Execution Engine interfaces with Oracle Workflow to actively notify the XML Gateway system administrator regarding system or process errors, or the Trading Partner contact for data errors.

XML Gateway Supports following Sources, data Types and queues.

Sources
Source RDBMS to Target XML

Source XML to Target RDBMS

Source XML to Target XML

DateTypes

VARCHAR2

DATE

NUMBER

CHAR

Queues

ECX_INBOUND Inbound Message Queue:
Holds all messages that enter the process through the Transport Agent, or are placed directly on the queue by an API.

ECX_OUTBOUND Outbound Message Queue:
XML Gateway enqueues all outbound messages that it formatted on this queue.

ECX_IN_OAG_Q Inbound Transaction Queue:
Holds inbound messages that originated from the ECX_INBOUND queue, then enqueued on this queue by Oracle Workflow.

WF_ERROR Workflow Error Queue:
For errors detected by XML Gateway or WF BES.

Following command is used to delete a DTD from an XML Gateway Repository.

···java DeleteDTDFromClob DB username DB password Hostname:Port:SID mydtd.dtd
···RootElementName Location
···
This command to load Message Map into the XML Gateway Repository.

···java LoadMap DB username DB password Hostname:Port:SID mymap.xgm
···Ex: java LoadMap operations welcome apps04.za.oracle.com:80002:VIS mymap.xgm
···
Command to delete Message Map from the XML Gateway Repository

java DeleteMap DB username DBpassword Hostname :Port:SID mapcode
Ex: java DeleteMap operations welcome apps04.za.oracle.com:8002:VIS mapcode

2009-01-13T12:38:00.000+05:30
Request ID Parameter LoV Not Populated for XML Publisher Report Program(R12).

When you submit the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation.The LoV for this parameter is not being populated due to an incorrect profile option reference.you select the appropriate data file to complete the request.
So,you must change the references to the incorrect profile option in the XDO_REPORT_REQUEST_ID value set

1) Go to System Administrator responsibility, open the Value Set form. Navigation: Application > Validation > Set.
2) Query the value set name as XDO_REPORT_REQUEST_ID
3)Click Edit Information.
4)Modify Where/Order By as Below
5) Save your work

Before Modification

WHERE ( ( FND_PROFILE.VALUE('CONC_REPORT_ACCESS_LEVEL') = 'U'
AND R.REQUESTED_BY = :$PROFILES$.USER_ID ) or
( FND_PROFILE.VALUE('CONC_REPORT_ACCESS_LEVEL') = 'R'
AND R.RESPONSIBILITY_ID = :$PROFILES$.RESP_ID ) )
AND R.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND XDS.APPLICATION_SHORT_NAME=
( SELECT APPLICATION_SHORT_NAME
FROM FND_APPLICATION
WHERE APPLICATION_ID=CP.APPLICATION_ID)
AND XDS.DATA_SOURCE_CODE = CP.CONCURRENT_PROGRAM_NAME
AND R.OUTPUT_FILE_TYPE='XML'
AND R.STATUS_CODE not in ('E', 'D', 'T', 'X')
ORDER BY R.REQUEST_ID DESC

After Modification

WHERE (R.REQUESTED_BY = :$PROFILES$.USER_ID or
R.RESPONSIBILITY_ID = :$PROFILES$.RESP_ID )
AND R.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND XDS.APPLICATION_SHORT_NAME=
( SELECT APPLICATION_SHORT_NAME
FROM FND_APPLICATION
WHERE APPLICATION_ID=CP.APPLICATION_ID)
AND XDS.DATA_SOURCE_CODE = CP.CONCURRENT_PROGRAM_NAME
AND R.OUTPUT_FILE_TYPE='XML'
AND R.STATUS_CODE not in ('E', 'D', 'T', 'X')
ORDER BY R.REQUEST_ID DESC

Metalink Ref:Note:404928.1

2009-01-12T13:22:00.000+05:30

How to Search Apps Documents in Google

1) The following Article shows how to download oracle apps related PPT or PDF documents in Google.
open google site in Search box type following string

"oracle applications framework" filetype:ppt
(shows only PPT files)
"oracle applications framework" filetype:pdf
(show only pdf files)
"oracle applications framework" filetype:doc
(shows only doc files)

you can found the site contains ppt ,pdf and doc file.

2) Type in searh box "sparsh site: oracle.com"
You will get the pages only from Oracle.com site where the word 'Sparsh' is referred

3)Type in seatch Box "related:www.oracle.com"
you can found a useful website and want to find other site info

4) Open blogsearch.google.com
you can search only in Blogs

5) google.com/codesearch
you search any public source code

6)Type in search box intitle:"index.of"(mp3|mp4|avi|dat|mpeg) oracle apps
you can found oracle apps related avi ,mp3 and demo video and audio files.

7)Type in seach box site:oracle.com XML find all sites containing the word XML located within the *.oracle.com domain.

8)Type in seach box intitle:XML OAF BPEL find all sites with the word XML,OAF and BPEL in the title.
It is Equivalent to intitle:OAF intitle:XML intitle:BPEL

9)Type in seach box inurl: BPEL SOA find all sites containing the word BPEL and SOA.

10)Type in seach box link.www.oracle.com will return documents containg one or more links to www.oracle.com.

2009-01-09T15:47:00.000+05:30
FTP (FILE TRANSFER PROTOCOL)

File Transfer Protocol is designed to do exactly that, transfer files between a server and a client.you can start up the FTP program on your machine and connect to a server. FTP service running on default port 21 on a remote machine.FTP service supports on most of today's operating systems.

FTP COMMANDS
You can get a list of the commands by typing '?' and pressing the enter key.

INTIATING FILE TRANSFERS FROM THE COMMAND LINE

1)On the command line, enter FTP .
2)Enter your login information if prompted.
3)Set your transfer mode to either 'Ascii' or 'Binary' depending upon the type of file you are transferring.
4)You can discover what directory you have connected to by entering the comand 'pwd'.
5)To change directories on the remote machine, enter 'cd' and the name of the directory.
6)To change directories locally, enter 'lcd' To put a file on the remote machine, enter PUT and the name of the file.
7)Once the transfer completes, you cen enter 'close' and then 'quit'('!' and 'bye' also serve the same function as quit).

Passive Mode
You can tranfer the files in Passive mode also.

1)The client opens a connection to the server on TCP port 21
2)The server accepts the connection.
3)The server initiates a connection to the client using port 20 as the source port (for the data channel)
4)The client accepts the connection and acknowledges all data transfers on port 20.

2008-12-31T11:46:00.000+05:30

List of KFF in Apps

Accounting Flexfield ···GL ·········GL_CODE_COMBINATIONS CHART_OF_ACCOUNTS_ID
Assets KFF ···FA ·········FA_ASSET_KEYWORDS
Category Flexfield ···FA ·········FA_CATEGORIES_B
Location Flexfield ···FA ·········FA_LOCATIONS
Sales Tax Location Flexfield ···AR ·········AR_LOCATION_COMBINATIONS LOCATION_STRUCTURE_ID
Territory Flexfield ···AR ·········RA_TERRITORIES
Item Catalogs ···INV········· MTL_ITEM_CATALOG_GROUPS
Item Categories ···INV ·········MTL_CATEGORIES_B ········· STRUCTURE_ID
Stock Locators ···INV ·········MTL_ITEM_LOCATIONS ········· ORGANIZATION_ID
System Items ···INV ·········MTL_SYSTEM_ITEMS_B ········· ORGANIZATION_ID

2008-12-31T11:31:00.000+05:30

PL/SQL compiler directives

As of the current release of PL/SQL, we have 4 directives

1)AUTONOMOUS_TRANSACTION.
2)RESTRICT_REFERENCES
3)EXCEPTION_INIT.
4)SERIALLY_REUSABLE.

AUTONOMOUS_TRANSACTION:
A subprogram marked with this pragma can do SQL operations and commit or roll back those operations, without committing or rolling back the data in the main transaction.

RESTRICT_REFERENCES:
To be callable From SQL statements, a stored function must obey certain purity rules, which control side-effects. If any SQL statement inside the function body violates a rule, you get an error at run time. You can declare the pragma RESTRICT_REFERENCES only in a package spec or object type spec.

EXCEPTION_INIT:
The pragma EXCEPTION_INIT associates an exception name with an Oracle error number.A pragma is an instruction to the Oracle compiler that tells it to do something. In this case you are telling Oracle to associate an error that you choose to a variable that you choose

SERIALLY_REUSABLE:
The pragma SERIALLY_REUSABLE indicates that the package state is needed only for the duration of one call to the server. An example could be an OCI call to the database or a stored procedure call through a database link. PRAGMA
Signifies that the statement is a pragma (compiler directive). Pragmas are processed at compile time, not at run time

2008-12-18T12:35:00.000+05:30

Types of Reports in APPS

Oracle Reports(D2k 6i): This is the most used tool for reporting on Oracle Applications. Most of reports customizations are built with this tool. Once customized the output of the report can be in Excel (Not group By Report), word, Acrobat documents or text format.

Oracle Discoverer:This is an intuitive tool for creating reports and performing on-line analysis.The flexibility of this tool allows the user to create cross tab reports that perform like pivot tables in Excel

Oracle XML Publisher: This is a new Oracle tool for reporting. It enables users to utilize a familiar desktop tool, like MS Word or MS Excel, to create and maintain their own report, XML Publisher merges the custom templates with the concurrentrequest extracts data to generate output in RTF, PDF, HTML and EXCEL.

Business Intelligence System (BI): This tool provides helps managers to take the right decision with the daily data that is uploaded on their systems.
This tools to provide high level information to run their business such as the profitability of a particular business unit.

FSG Reports (Financial Statement Generator): Very powerful report building tool for Oracle General Ledger. Benefits of using this tool are that a user can generate financial reports, and schedule reports to run automatically. The only Disadvantage of this tool is that it is only available for the general ledger responsibility and can be used to see only financial account balances.

RXi Report:(Variable reports) :With this tool a user has the ability to print the same report with multiple layouts.This tool is most used on Oracle Financials Applications>

2008-12-03T13:24:00.000+05:30

Benfits of XML Publisher.

1)MLS Support
Supports 160 languages and 200 Territories.
2)XML Publisher will integrate with the workflow product
3)Rapid Development
4)Reduce Maintence Cost
5)High Performance and Scalability
6)Compressed PDF OUTPUT
7)Repeating Header and Footer
8)Greater Flexibility of customization
9)Schedule Print and FAX directly from the server
10)Support for Internet Printing Protocol(InternetFAX protocol,SMTP,WebDAV)
11)Handle Large XML input files and accept from different source like DB2,SQL server.. etc
12)Security At PDF level like (read only, Password Protection)

2008-11-26T13:20:00.000+05:30

*****Default username/passwords in Oracle Applications*****

Many Applications users are predefined in the Vision Demo.
The following username/password pairs have System Administrator responsibility.

1.SYSADMIN/SYSADMIN
2.MFG/WELCOME
3.OPERATIONS/WELCOME
4.SERVICES/WELCOME
5.MRC/WELCOME
6.HRMS/WELCOME

Note: password are small case.

2008-11-24T17:58:00.000+05:30

FNDLOAD

when we are working in oracle application development/implementation project? The equally important AOL data Migration takes place necessary to synchronize the data across databases instance during installation and upgarde.

Using FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.The Conversion between database format and text file format is specified by a configuration file.

What can be Done?

·It can be done following list

· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Concurrent Manager Schedules

Advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. No learning curve. this is relief for developer/dbas
3. Fully supported and recommended by Oracle
4. Capture the migrations in a file and use it during installations(log file).
5. Pin-point when something happened and where (database) easily
6. AOL data migration process is now simplified!

Disadvantages
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. No validation against migrating database/instance sensitive data

The Syntax
To use FNDLOAD, the following syntax is needed.
FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1.....]
· The mode is either DOWNLOAD or UPLOAD.
· The configfile is the file that Fndload needs to download on upload data.
· T he data file is the output file, in which the downloaded data is written
· The entity is the entity you want to download,
·

Example of download:
FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=application_short_name

Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt - CUSTOM_MODE=FORCE undocumented parameter

Where is Config File Located

· Configuration files with extension .lct
o On Unix - all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix Oracle also places the original configuration files in $FND_TOP/admin/import directory
·Data files with extension .ldt
· The configfiles (.lct) are delivered and maintained by Oracle
· It has entity definitions, parent-child relationships and user input parameters identified by :NAME
oDownloading a parent automatically downloads all children - (Example) Concurrent Program download

Sample Script Code for these Objects :

1 - Printer Styles
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=printer style name

2 - Lookups
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=prod LOOKUP_TYPE=lookup name

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=prod DESCRIPTIVE_FLEXFIELD_NAME=desc flex name P_CONTEXT_CODE=context name

4 - Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=prod ID_FLEX_CODE=key flex code P_STRUCTURE_CODE=structure name

5 - Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=prod CONCURRENT_PROGRAM_NAME=concurrent name

6 - Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=value set name

7 - Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=value set name

8 - Profile Options
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=profile option APPLICATION_SHORT_NAME=prod

9 - Requset Group
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=request group APPLICATION_SHORT_NAME=prod

10 - Request Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=prod REQUEST_SET_NAME=request set

11 - Responsibilities
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=responsibility

12 - Menus
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=menu_name

13 Forms/Functions
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES The Upload syntax for all styles: FNDLOAD apps/apps@seed115 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt

14. User/Responsibilities
FNDLOAD apps/apps@seed115 0 Y DOWNLOAD @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER Then UPLOAD FNDLOAD apps/apps@seed115 0 Y UPLOAD [UPLOAD_PARTIAL] @FND:patch/115/import/afscursp.lct file_name.ldt FND_USER []

2008-11-11T16:55:00.000+05:30
Yellow Bar at Oracle Apps forms

Some times you may see "Yellow Bar" while opening Oracle apps forms.This will cause stop the Copying the content from Apps to Any other applications.

Solution :

Download and Reinstall jinitiator directly from apps environment
Example: http://appsurl:port/OA_HTML/oajinit.exe
else
Copy or download the identitydb.obj same version of file from your co-workers,internet and paste it under C:\Program Files\Oracle.

2008-11-11T12:57:00.000+05:30
How to Unlock the Objects

The following query could be useful :

Select SPID from V$PROCESS where ADDR in
(select PADDR from V$SESSION where SID in
(select SESSION_ID from V$LOCKED_OBJECT where OBJECT_ID in
(select OBJECT_ID from DBA_OBJECTS where OBJECT_NAME=’Locked Object’)))

Get the Process id from the query. Login as unix user and run the following command to kill the process.

$kill -9 SPID

2008-11-07T16:17:00.000+05:30
Types of Application Patches

There are several different types of Oracle Applications patches. These are the more common patches

1)One-off patch: This is the simplest type of patch. It is created to resolve a specific bug.
2)Minipack patch: This is a collection of one-off patches and enhancements related to a particular module
3)Family Pack patch: This is a collection of Minipack patches for a particular family group of application modules
4)Maintenance Pack patch: This is a collection of Family Packs that serves as a point-level release upgrade
5)Consolidated patch: This is a collection of one-off fixes for a Family Pack or Maintenance Pack
6)Interoperability patch: This is a patch that is required for Oracle Applications to function with a newer version of a technology stack
component;
7)NLS patch: This is a patch that updates language-specific information for multi-language installations
8)Rollup patch: This is a collection of one-off patches that update code levels for particular products
9)Legislative patch: This is a special patch for HR Payroll customers; it contains legislative data for multiple countries.

2008-10-22T12:05:00.000+05:30
User Session Limits Profiles

There are two user Session profiles specify the limits on user session.

1) ICX: Session Timeout

This profile option tnforce and Inactivity timeout.
If user is not perform any operation for a time period ,the user session is disable.

Profile option is 0 or NULL the session time will never time out.

2) ICX: Limit time

This profile specify the obsolute max lenght of time in hours for user.

2008-10-17T11:04:00.000+05:30

Benefits of Flexfields

Key flexfields provide a flexible way for the Oracle Applications to represent objects such as accounting codes, part numbers, job descriptions, and more

Benefits

1)Customize data fields to your meet your business needs without programming.
2)Customize your applications to conform to your current business for accounting codes, product codes, and other codes.
3)Query intelligent fields for very specific information.
4)Customize your applications to capture data that would not otherwise be tracked by your application.
5)A flexfield qualifier identifies a particular segment of a key flexfield.

2008-10-17T10:56:00.000+05:30

Warning About Changing Data

Oracle Recommended : Do Not Use Database Tools to Modify Oracle Applications Data

Oracle provides powerful tools you can use to insert, update, and delete information in an Oracle 9i,10g database. But, if you use Oracle tools like SQL*Plus or Oracle Data Browser to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle Applications tables are interrelated, any change you make using an Oracle Applications form can update many tables at once. But when you modify Oracle Applications data using anything other than Oracle Applications forms, you may change a row in one table without making corresponding changes in related tables.

When you use Oracle Applications forms to modify your data, Oracle Applications automatically checks that your changes are valid. Oracle Applications also keeps track of who changes information. But, if you enter information into database tables using database tools, you may store invalid information
Warning: Oracle Applications does not support any customization of Oracle Application Object Library tables or modules, even by Oracle consultants. Oracle Application Object Library table names begin with "FND_". (Foundation)
Do not write data directly into or change data in FND_ tables through any custom program or using any tool, including SQL*Plus, Oracle Data Browser, database triggers or other programming tools. You risk corrupting your database and damaging all your applications

ORACLE STRONGLY RECOMMEND that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle Applications tables, unless we tell you to do so in our installation, implementation, or open interface guides.

2008-10-14T15:26:00.000+05:30
Setting Character-Mode vs. Bitmap Printing

Character mode Oracle Reports programs take their page dimensions and orientation from the print style associated with the request to run the program. Some print styles are predefined, and a System Administrator can define additional styles, if necessary.

Running Bitmap Oracle Reports Concurrent Programs

To run an Oracle Reports program in bitmap mode, query the concurrent program's definition in the Concurrent Programs form, and enter "VERSION=2.0b" in the Execution Options field. This defines the program to use the bitmap version of Oracle Reports. Bitmap Oracle Reports programs take their page dimensions and orientation from the program's definition (note: when printing a bitmap report, a print style is still required). If you wish to override the program's definitions, you can enter values in the Execution Options field for ORIENTATION and PAGESIZE. When entering more than one execution option, each option should be separated by a single space. There should be no spaces before or after the options.

For example: VERSION=2.0b ORIENTATION=LANDSCAPE PAGESIZE=7.5x9

Notes about PAGESIZE in the Execution Options field

In Oracle Reports, when defining a report the units and size of the report are specified in the report settings.
For bitmapped reports, x for PAGESIZE is usually in inches; however, this depends on the particular report definition.
You can enter the PAGESIZE parameter in the Execution Options field of the Concurrent Programs form (for bitmapped reports only) when you want to override the values specified in the report definition.

For example: VERSION=2.0b PAGESIZE=7.5x9

If the dimensions specified with the PAGESIZE parameter are smaller than what the report was designed for, you will generate a "REP-1212" error.

2008-10-14T15:01:00.000+05:30
Managing Concurrent Processing Files

The database tables that are affected by running the Purge Concurrent Request and/or Manager Data program are:

FND_CONCURRENT_REQUESTS
This table contains a complete history of all concurrent requests.

FND_RUN_REQUESTS
When a user submits a report set, this table stores information about the reports in the report set and the parameter values for each report.

FND_CONC_REQUEST_ARGUMENTS
This table records arguments passed by the concurrent manager to each program it starts running.

FND_DUAL
This table records when requests do not update database tables.

FND_CONCURRENT_PROCESSES
This table records information about Oracle Applications and operating system processes.

FND_CONC_STAT_LIST
This table collects runtime performance statistics for concurrent requests.

FND_CONC_STAT_SUMMARY
This table contains the concurrent program performance statistics generated by the Purge Concurrent Request and/or Manager Data program. The Purge Concurrent Request and/or Manager Data program uses the data in FND_CONC_STAT_LIST to compute these statistics.

2008-10-14T14:44:00.000+05:30
Example of $FLEX$ Syntax

Here is an example of using :$FLEX$.Value_Set_Name to set up value sets where one segment depends on a prior segment that itself depends on a prior segment ("cascading dependencies"). Assume you have a three-segment flexfield where the first segment is car manufacturer, the second segment is car model, and the third segment is car color. You could limit your third segment's values to only include car colors that are available for the car specified in the first two segments. Your three value sets might be defined as follows:

Segment Name Manufacturer

Value Set Name Car_Maker_Name_Value_Set
Validation Table CAR_MAKERS
Value Column MANUFACTURER_NAME
Description Column MANUFACTURER_DESCRIPTION
Hidden ID Column MANUFACTURER_ID
SQL Where Clause (none)

Segment Name Model

Value Set Name Car_Model_Name_Value_Set
Validation Table CAR_MODELS
Value Column MODEL_NAME
Description Column MODEL_DESCRIPTION
Hidden ID Column MODEL_ID
SQL Where Clause WHERE MANUFACTURER_ID =
:$FLEX$.Car_Maker_Name_Value_Set

Segment Name Color

Value Set Name Car_Color_Name_Value_Set
Validation Table CAR_COLORS
Value Column COLOR_NAME
Description Column COLOR_DESCRIPTION
Hidden ID Column COLOR_ID
SQL Where Clause WHERE MANUFACTURER_ID =
:$FLEX$.Car_Maker_Name_Value_Set
AND MODEL_ID =
:$FLEX$.Car_Model_Name_Value_Set

In this above example, MANUFACTURER_ID is the hidden ID column and MANUFACTURER_NAME is the value column of the Car_Maker_Name_Value_Set value set. The Model segment uses the hidden ID column of the previous value set, Car_Maker_Name_Value_Set, to compare against its WHERE clause. The end user never sees the hidden ID value for this example.

2008-10-10T14:07:00.000+05:30
Concurrent Request Phase and Status

The Concurrent Requests window displays a phase and status summary for each concurrent request listed
A concurrent request has a life cycle consisting of the following phases: pending, running, completed, and inactive.
During each phase, a concurrent request has a specific condition or status. lists each phase/status combination and describes its meaning in relation to a request.
If a request is pending, you can determine when it will start by using the Concurrent Managers For the Request window from the Requests window to review the request's position in the queues of current managers that can run that request.

Phase Status Description

PENDING Normal Request is waiting for the next available manager

Standby Program to run request is incompatible with other program(s) currently running

Scheduled Request is scheduled to start at a future time or date.

Waiting A child request is waiting for its Parent request to mark it ready to run. For example, a request in a request set that runs sequentially must wait for a prior request to complete

RUNNING Normal Request is running normally

Paused Parent request pauses for all its child requests to finish running. For example, a request set pauses for all requests in the set to complete.

Resuming All requests submitted by the same parent request have completed running. The Parent request resumes running.

Terminating Request is terminated by choosing the Cancel Request button in Requests window

COMPLETED Normal Request completed successfully.

Error Request failed to complete successfully

Warning Request completed with warnings. For example, a request is generated successfully but fails to print

Cancelled Pending or Inactive request is cancelled by choosing the Cancel Request button in the Requests window.

Terminated Request is terminated by choosing the Cancel Request button in the Requests window.

Inactive Disabled Program to run request is not enabled. Contact your system administrator.

On Hold Pending request is placed on hold by choosing the Hold Request button in the Requests window.

No Manager No manager is defined to run the request. Check with your system administrator. A status of No Manager is also given when all managers are locked by run-alone requests.

2008-10-03T13:34:00.000+05:30
Locate Trace file and Enviroment files from Front End

After completing traceinge, You can find the Trace file location path by using following methods

Method 1) select value from v$parameter
where name ='user_dump_dest'

The above Query returns Trace file location Path.

Method 2) Login As sysadmin
Click at Goto ->OAM->OAM Setup->Site MAP->Monitoring->System Configuration-> Databse Init.ora Setting.

Here You can find out Parameter name as user_dump_dest , utl_file_dir and corresponding values.

2008-09-26T14:46:00.000+05:30
Accessing PO Reports from INV

Some times you may Get requiremnet like running PO standard reports into Inventory

1) Login as sysadmin go To security-> responsibility-> define-> Query the Responsibility name as Inventory Super User, Vision Operations
Note down the menu name
ie : INV_NAVIGATE
Same as query the Responsibility name as Purchasing, Vision Operations
Note down the menu from menu box
ie : Purchasing SuperUser GUI

2) Go To Application -> menu

query the user menu Name as INV_NAVIGATE
And add the below entries like

Seq =1.1
Prompt =XX Purchasing Reports
Submenu= Purchasing SuperUser GUI
Function=Submit Requests
Description=XX Purchsing Menu
Grant=Yes

3) Save and compile menu

4) Switch Responsibility to Inventory
Identify the XX Purchasing Reports menu
Finally Run PO reports from Inv

2008-09-24T13:56:00.000+05:30
Concurrent Program output in MS Excel format

1)Login as sysadmin
2) switch to Sysadmin responsibility
3)go to Install->Viewer Options
4) Add entries as Below

File Format =Text Mime
Type=application/vnd.ms-excel
Description=Microsoft Excel

5) save the changes
6) Run any concurrent program
7) Goto-> tools and Copy file
Your able to see the output into Excel format

2008-09-24T12:32:00.000+05:30
CONCSUB

. By Using CONCSUB You can submit a concurrent request to execute and Controlling any concurrent program at UNIX(operating system level) without having to log on to Oracle Applications.
The CONCSUB executable is located at $FND_TOP/bin/CONCSUB

Syntax:

$ CONCSUB APPS username>/APPS password
responsibility application short name
responsibility name
username
[WAIT=N|Y|n seconds]
CONCURRENT
program application short name
program name
[PROGRAM_NAME=”description”]
[REPEAT_TIME= [REPEAT_INTERVAL= number]
[REPEAT_INTERVAL_UNIT= resubmission unit]
[REPEAT_INTERVAL_TYPE= resubmission type]
[REPEAT_END=resubmission end date and time]
[START=date]
[IMPLICIT= type of concurrent request
[parameter 1 ... parameter n]

Example :

CONCSUB APPS/APPS \
·················· SYSADMIN \
··················”System Administrator” \
·····················SYSADMIN \
·····················WAIT=N \
··· CONCURRENT \
··· FND \
··· FNDSCURS \
··· PROGRAM_NAME=’”Active Users”’

Syntax for Controlling Concurrent Managers

CONCSUB apps/apps_password SYSADMIN ‘System Administrator’ SYSADMIN WAIT=N CONCURRENT FND SHUTDOWN

Note : You can't use the CONCSUB to start the concurrent manager.Instead of that you can use startmgr which located in $FND_TOP/bin dir.

Oracle Applications Technical Docs

SQLPLUS Script in UNIX Shell Produce Output on Same Line

A Simple Select statement is executed from CURRENT a shell. The value returned by the select query is transferred back to the shell.

RESULT=`sqlplus -s apps/WELCOME123@DEVPR12 < <(printf "set pages 0 \n select SYSDATE from dual; \n")`
echo "RESULT=${RESULT}"

Another Way to Execute sqlplus from unix shell

sqlplus -s /nolog << EOF
connect apps/Welcome123
select sysdate from dual;
exit;
EOF

Groovy Support in ADF

Oracle ADF provides a number of different declarative points into which you can drop Groovy code:

Java code

class HelloWorld {
private final Thing thing = new Thing ( ) ;
   {
          thing.doSomething ( ) ;
   }
}

Groovy Code

class HelloWorld {
private final thing = new Thing ( )
{
thing.doSomething ( )
}
}

Semicolons is optional in Groovy

A = 10
println x

A = new java.util.Date()
println A

A = -3.1499392
println A

A = false
println A

A= "Hi"
println A

Who will Benefit

Who don't already know java and who don't want learn java they can use Groovy to use power of JVM and Development kit while programming

conclusion

Java is Groovy,Groovy is Java

1.99% java code supports Groovy
2.Groovy supports JSR 175 annotation same as Java
3.Increases developer productivity by reducing scaffolding code when developing web, GUI ,database or console applications
4.Compiles straight to Java byte code so you can use it anywhere you can use Java

Script to Converting BLOB to CLOB

Alert History Query

Payroll Tables

HRMS PYUPIP

PO Approval Hierarchy

Phase	Status	Description
PENDING	Normal	Request is waiting for the next available manager
	Standby	Program to run request is incompatible with other program(s) currently running
	Scheduled	Request is scheduled to start at a future time or date.
	Waiting	A child request is waiting for its Parent request to mark it ready to run. For example, a request in a request set that runs sequentially must wait for a prior request to complete
RUNNING	Normal	Request is running normally
	Paused	Parent request pauses for all its child requests to finish running. For example, a request set pauses for all requests in the set to complete.
	Resuming	All requests submitted by the same parent request have completed running. The Parent request resumes running.
	Terminating	Request is terminated by choosing the Cancel Request button in Requests window
COMPLETED	Normal	Request completed successfully.
	Error	Request failed to complete successfully
	Warning	Request completed with warnings. For example, a request is generated successfully but fails to print
	Cancelled	Pending or Inactive request is cancelled by choosing the Cancel Request button in the Requests window.
	Terminated	Request is terminated by choosing the Cancel Request button in the Requests window.
Inactive	Disabled	Program to run request is not enabled. Contact your system administrator.
	On Hold	Pending request is placed on hold by choosing the Hold Request button in the Requests window.
	No Manager	No manager is defined to run the request. Check with your system administrator. A status of No Manager is also given when all managers are locked by run-alone requests.

Oracle Applications Technical Docs

SQLPLUS Script in UNIX Shell Produce Output on Same Line

A Simple Select statement is executed from CURRENT a shell. The value returned by the select query is transferred back to the shell.

RESULT=`sqlplus -s apps/WELCOME123@DEVPR12 < <(printf "set pages 0 \n select SYSDATE from dual; \n")` echo "RESULT=${RESULT}"

Another Way to Execute sqlplus from unix shell

sqlplus -s /nolog << EOF connect apps/Welcome123 select sysdate from dual; exit; EOF

Groovy Support in ADF

Oracle ADF provides a number of different declarative points into which you can drop Groovy code:

Java code class HelloWorld {private final Thing thing = new Thing ( ) ; { thing.doSomething ( ) ; }}

Groovy Code

class HelloWorld {private final thing = new Thing ( ){ thing.doSomething ( )}}

Semicolons is optional in Groovy A = 10println x A = new java.util.Date()println A A = -3.1499392println A A = false println A A= "Hi" println A

Who will Benefit

Who don't already know java and who don't want learn java they can use Groovy to use power of JVM and Development kit while programming

conclusion

Java is Groovy,Groovy is Java

1.99% java code supports Groovy 2.Groovy supports JSR 175 annotation same as Java 3.Increases developer productivity by reducing scaffolding code when developing web, GUI ,database or console applications 4.Compiles straight to Java byte code so you can use it anywhere you can use Java

Script to Converting BLOB to CLOB

Alert History Query

Payroll Tables

HRMS PYUPIP

PO Approval Hierarchy

RESULT=`sqlplus -s apps/WELCOME123@DEVPR12 < <(printf "set pages 0 \n select SYSDATE from dual; \n")`
echo "RESULT=${RESULT}"

sqlplus -s /nolog << EOF
connect apps/Welcome123
select sysdate from dual;
exit;
EOF

Java code

class HelloWorld {
private final Thing thing = new Thing ( ) ;
{
thing.doSomething ( ) ;
}
}

class HelloWorld {
private final thing = new Thing ( )
{
thing.doSomething ( )
}
}

Semicolons is optional in Groovy

A = 10
println x

A = new java.util.Date()
println A

A = -3.1499392
println A

A = false
println A

A= "Hi"
println A

1.99% java code supports Groovy
2.Groovy supports JSR 175 annotation same as Java
3.Increases developer productivity by reducing scaffolding code when developing web, GUI ,database or console applications
4.Compiles straight to Java byte code so you can use it anywhere you can use Java