Shulou(Shulou.com)06/03 Report--

Transferred from:

Http://blog.csdn.net/samt007/article/details/38304239

Requests that have used EBS know that submitting a new report requires several buttons, one of which is to choose the type to submit the new request: a single request or a set of requests.

In fact, 99% of the cases are a single request, this is really not necessary to choose.

Now there is a perfect solution to this problem.

The logic is:

Add a profile value setting to enable the identity of the default submission of a single request.

If enabled, then:

Each time a new request is submitted, when the running request type is located, a single request is selected by default, and the "OK" button is automatically clicked to jump directly to the single request screen.

Each time you unsubmit a request, when you locate the running request type, you automatically click the cancel button to return to the previous screen.

1 first create a new profile value to determine whether to default to a single request:

XXXXX_SINGLE_REQUEST_FLAG

XXX: submitting a new request is a single request by default

SQL= "SELECT MEANING\" Log Enabled\ ", LOOKUP_CODE

Into: visible_option_value

: profile_option_value

From fnd_lookups

Where lookup_type = 'YES_NO' "

COLUMN= "\" Log Enabled\ "(30)"

2 then click the personalization at the request, and then maintain the personalization:

There are four personalizations in total.

Initialize global parameters:

Activity:

Type = Properti

Object type = global variable

Target object = PRE_BLOCK

Property = VALUE

Value =''

-

NVL (: GLOBAL.PRE_BLOCK,'JOBS') IN ('JOBS_QF','JOBS') AND NVL (FND_PROFILE.VALUE (' XYG_ALD_SINGLE_REQUEST_FLAG'),'N') ='Y'

The default to submit a new request is a single request (submit request):

-

: GLOBAL.PRE_BLOCK = 'WORK_ORDER' AND NVL (FND_PROFILE.VALUE (' XYG_ALD_SINGLE_REQUEST_FLAG'),'N') ='Y'

When the point returns, the "cancel" button should be clicked automatically, and everything else is the same as the one above:

: SYSTEM.CURSOR_BLOCK IN ('JOBS_QF','WORK_ORDER','JOBS')

3 then set my user's profile to Y, and then:

You can jump directly to the request screen:

After clicking cancel, you can automatically return to the screen of the query request.

The great task has been completed!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.