Hey Friends, The basic idea for creating this blog is to have a Technical information about Oracle Applications. To have one such place where you will have a TECHNO-FUNCTIONAL knowledge of Oracle Applications.

Wednesday, February 28, 2007

AOL Refresh

Concurrent Program WHO Columns:
REQUEST_ID
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE

Table Registration API:
Package Name : AD_DD
Procedure Names :

register_table
Register_column
Delete_table
Delete_column

USER PROFILE: The changeable options which affects the way your applications runs.
System Administrator sets the values for each users profile option.
FND_PROFILE.PUT(name, value)
FND_PROFILE.GET(name, value)

Multiple segment structure for single flexfield:
FF lets you define multiple segment structures for same flexfield.
Your FF can display different prompts and different structure depending on end user.
FF Structure is the particular arrangement of segments.

Concurrent program information:
select concurrent_program_id,

concurrent_program_name
from fnd_concurrent_programs;

select

request_id,
status_code,
concurrent_program_id,
number_of_arguments,

output_file_type
from

fnd_concurrent_requests;

Stored procedure as a concurrent program:
create procedure proc_name

( errbuf out varchar2,
retcode out varchar2,
arg1 in varchar2,
arg2 in varchar2…)
Restricted to 100 parameters.
ERRBUF: to return any error message.
RETCODDE: to return 0 for success, 1 for success with warning and 2 for error.

Submitting concurrent request:
Call FND_REQUEST.SUBMIT_REQUEST

To check request status:
Call FND_CONCURRENT.GET_REQUEST_STATUS
Steps for concurrent program:
1 executable
2 define
3 register/attach
4 SRS
NOTE:
On program define form there is a check box called “Run in SRS” which is checked by default.
If it is unchecked then your concurrent program will not appear in submit request window.

LOG/OUTPUT file locations:
PROD_TOP/log lxxxxxx.req
PROD_TOP/out oxxxxxx.req


FND_REQUEST.SUBMIT_REQUEST(application, prog_name, desc)

To submit REQUEST SET through API:
FND_SUBMIT_SET.REQUEST_SET(application, req_set_name) return boolean;

Request Set:
Request set allows you to submit several requests together using more than one execution path. [conditional execution of programs]. Is divided in stages, each stage can contain one or more concurrent request. One stage at a time is executed. All the concurrent programs in one stage are executed parallel. Depending on the result [completion status: SUCCESS, WARNING, ERROR] of first stage the next stage is launched for execution.

F L E X F I E L D
KFF:
Let me give you an example for KFF,
Take an example of mobile phone call. You make a call from your cell phone from Mumbai. Consider the data which is being associated with your cell phone location.
Your location will be identified as follows:
Country – Circle – State – City - Zone.

And the possible values would be.
India - West - MH - Mumbai - CST
This is nothing but a KFF. The collection of meaningful fields [Called SEGMENT] which provides KEY INFORMATION.

DFF:
Now additional [descriptive] information about you/ who is making call which is not as much important as the above one for making a call like your address, account number, payment details, unbilled amount and other will be captured in DFF.

Value Set:
The possible values for KFF field will be validated using value sets.
The types of value set are:

None
Independent
Dependent
Table type
Translatable dependent
Translatable independent
Special
Pair

FF Structure: is the arrangement of the fields [segment] used in FF. You can have multiple FF structure.

NOTES:
Every FF has at least one base table associated with it known as Combination Table which stores all the valid combinations of values in your KFF.

FF Qualifier: To identify particular segment/field of KFF.
Segment Qualifier: To identify value in particular segment.
Dynamic Insertion: If you allow the dynamic inserts [checkbox on FF form] while creating the KFF, you can directly insert the valid combination in combination base table using any other form than the main combination form.

Table validated value set: You can use your own table or any other table for valid set of values.

$FLEX$.value_set_name is used in where/order by clause where the value of current segment depends on value of previous segment. Ex WHERE user_id = :$FLEX$.sales_person_id

:block.field represents the form where your DFF appears.

$PROFILES$.profile_option_name can be used to pick value of user profile.
This cant be used with Accounting FF. Steps to create this value set:
1 create table if you want to use your own custom table. Shd must have PK. No duplicate records.
2 register this table using AD_DD.register_table API.
3 Give grants and create synonym in APPS.
4 Create value set using value set form.
5 In this form you can provide sql statement in TABLE NAME [separated by comma] field. [But if you are using some complex sql on table then better to create a view and provide the name of this view here]
6 If you provide column name in hidden ID field then FF saves the value of this column you specified instead of the displayed value.

Reporting on FF Data:
FF Views: Once you create and freeze your KFF a view is created with suffix of “_KFV” and “_DFV” in case of DFF.

Coding for Oracle Reports as a Concurrent Program:
USER EXITS:
A program to be called from with in the oracle application, which when called takes the control out of the oracle application temporarily, performs some operation and returns the control to Oracle application.
In case of coding for Oracle Reports following are some of the User exits we will use:
FND SRWINIT

FND SRWEXIT : To reset the profile option values and de allocate the memory occupied by user exits.
FND FLEXSQL
FND FLEXIDVAL
FND FORMAT_CURRENCY

FND SRWINIT: must be the first USER EXIT called from Reports and should be called from before report trigger of Report. You need to create P_CONC_REQUEST_ID number (15) user parameter in Report.
- To set required profile option values.
- Also it allows the Report to use the correct organization [for multi org].
FND FLEXSQL: This allows you to use the flex field in your report.
FND FORMAT_CURRENCY: This formats the currency amount dynamically depending upon the precision of actual currency value.

Steps are as follows:
Define the parameter P_CONC_REQUEST_ID number(15)
Call srw.user_exit(‘FND SRWINIT’); from before report trigger of report.
Call srw.user_exit(‘FND SRWEXIT’); from after report trigger of report.

Labels:

1 Comments:

Anonymous Anonymous said...

Hello,

When ever I surf on web I never forget to visit this website[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url]Lots of good information here oracle-apps-technical.blogspot.com. Let me tell you one thing guys, some time we really forget to pay attention towards our health. Let me show you one truth. Research presents that almost 90% of all U.S. grownups are either fat or overweight[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url] Hence if you're one of these citizens, you're not alone. Infact many among us need to lose 10 to 20 lbs once in a while to get sexy and perfect six pack abs. Now next question is how you can achive quick weight loss? [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss[/url] is not like piece of cake. Some improvement in of daily activity can help us in losing weight quickly.

About me: I am author of [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss tips[/url]. I am also mentor who can help you lose weight quickly. If you do not want to go under hard training program than you may also try [url=http://www.weightrapidloss.com/acai-berry-for-quick-weight-loss]Acai Berry[/url] or [url=http://www.weightrapidloss.com/colon-cleanse-for-weight-loss]Colon Cleansing[/url] for quick weight loss.

March 21, 2010 at 3:11 PM

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home