Month: November 2012

Oracle E-Business suite custom application development-How to submit a concurrent request from a FORM module through push button click

On By windows7bugsIn Oracle Applications (R12.0.4)3 Comments

 

Required: FNDCONC.pll attached to custom form

with when-button-pressed trigger, attach the following code (Please remove what is not applicable in your case)

Declare
  l_ord_num               NUMBER := 0;
   l_ord_type_name         VARCHAR2 (240);
   l_req_id_Rep            NUMBER;
   l_request_completed     BOOLEAN := FALSE;
   l_req_phase             VARCHAR2 (20);
   l_req_status            VARCHAR2 (1000);
   l_req_dev_phase         VARCHAR2 (1000);
   l_req_dev_status        VARCHAR2 (1000);
   l_req_message           VARCHAR2 (1000);
   l_conc_mgr_status       NUMBER;
   p_call_stat             NUMBER;
   p_activep_stat          NUMBER;

   l_order_category_code   NUMBER;
   l_inv_report_name       VARCHAR2 (40);
   l_ret_report_name       VARCHAR2 (40);
   l_req_id                                 NUMBER;
   l_order_type_name                VARCHAR2(30);
Begin
  l_req_id :=
      fnd_request.submit_request (‘ONT’,—Actual application short name
                                  l_inv_report_name,—Short name of concurrent program, please note this is not the executable name
                                  NULL,—Description not required
                                  SYSDATE,—start time, not required
                                  FALSE,—subsequent report name, not required

/*You can pass a total of 100 parameters, just make sure to pass them in the same order you have defined them in the parameter session for the concurrent program*/
                                  :ORDERS.OE_ORDER_NUMBER,                                   l_order_type_name,                                   NULL,
                                  NULL,
                                  apps.fnd_profile.VALUE (‘ORG_ID’));

:SYSTEM.Message_Level := ’25’;
   COMMIT;

   l_request_completed :=
      fnd_concurrent.wait_for_request (request_id   => l_req_id,
                                       INTERVAL     => 1,
                                       phase        => l_req_phase,
                                       status       => l_req_status,
                                       dev_phase    => l_req_dev_phase,
                                       dev_status   => l_req_dev_status,
                                       MESSAGE      => l_req_message);

—   :SYSTEM.Message_Level := ’25’;
   COMMIT;

:SYSTEM.Message_Level := ‘0’;

   editor_pkg.report (l_req_id, ‘Y’);

/*for displaying the pdf automatically with a new window or tab after the concurrent request completes successfully*/
END;

This should provide you the desired functionality.

regards,

admin

Oracle E-Business Suite R12, a simple view for Active Application Users!

On By windows7bugsIn Oracle Applications (R12.0.4), Oracle Applications(R12)Leave a comment 
CREATE VIEW ERP_ACTIVE_USERS_V
AS
SELECT user_id, user_name, full_name
FROM fnd_user fu, per_all_people_f papf
WHERE papf.person_id = fu.employee_id
AND SYSDATE BETWEEN fu.start_date AND NVL (fu.end_date, SYSDATE)
AND SYSDATE BETWEEN papf.effective_start_date
AND NVL (papf.effective_end_date, SYSDATE)
ORDER BY 2;

regards,

admin

Oracle developer 10g, developer 6i default values for columns using :PARAMETER.name

On By windows7bugsIn Oracle related, Windows 7, Windows 8Leave a comment

We just came across a peculiar situation. Recently we had developed a new approach towards developing new applications for Oracle EBS instance.

We do the following

Develop the prototype using developer 6i forms (hacked and patched for Windows 7 & Windows 8). The only change we make with the developer 6i is changing the “coordinate system” property from points to “inches”

image

This approach gives us rapid development scenarios, as we don’t have to upload the form module to instance top and compile it and try it against the TEST instances.

All we are doing is, once the complete application is tested on developer 6i, a copy of the same opened with Developer 10g forms, and copying the objects following the following sequence

  1. Window( s )
  2. Canvases
  3. Blocks
  4. Procedures & functions
  5. Parameters (if any)

Once mapping the PARAMETERS with PROFILE values, the form is ready for APPS instance testing (99% of the times everything is already tested, so a failure is seldom experienced)

Now, coming to one actual issue we are still struggling with is, using the :PARAMETER.xyz, :PARAMETER.abc as initial values for block elements.

The hacked developer 6i does not populate the initial value from :PARAMETER.xyz or :PARAMETER.abc during run time. ie, the first record (record orientation: forms) will not show the already populated values for the columns, however, the very next record(a delete does it) starts showing the :PARAMETER.xyz, abc values being populated to columns wherever they are set as initial values!!!

Do you have solutions? Please let us know with the comment section

Update 19.11.2012

With developer forms 6i, we loaded the values to column through the WHEN-NEW-FORM-INSTANCE like following

:PARAMETER.ORGANIZATION_ID := FND_PROFILE.VALUE(‘org_id’);
:PARAMETER.ORG_ID := FND_PROFILE.VALUE(‘mfg_organization_id’);
:PARAMETER.USERNAME := FND_PROFILE.VALUE(‘username’);

then, explicitly assigned the values to block columns like

:BLOCK.COLUMN1 := :PARAMETER.ORGANIZATION_ID;

in addition to setting up the initial value for the columns using :PARAMETER.xyz

Looks like the stuff are in place now :)

With Developer 10g, this issue has much easier to fix. All we had to do was to change the case of coding like following:

:parameter.organization_id := fnd_profile.value(‘org_id’);
:parameter.org_id := fnd_profile.value(‘mfg_organization_id’);
:parameter.username := fnd_profile.value(‘username’);

To

:PARAMETER.ORGANIZATION_ID := FND_PROFILE.VALUE(‘org_id’);
:PARAMETER.ORG_ID := FND_PROFILE.VALUE(‘mfg_organization_id’);
:PARAMETER.USERNAME := FND_PROFILE.VALUE(‘username’);

and without any further hacks, the 10g forms started showing initial values.

If you experienced the same, have a solution, please provide us the same with the comment section

regards,

admin

Windows 8, Should Microsoft enable the start menu?

On By windows7bugsIn Windows 81 Comment

Huge arguments everywhere! Being developers all around the clock, #windows7bugs believes, the choice should be left alone on individual user.

We are trying to demonstrate, how a classic menu approach would make things a bit better for developers, techies who have to browse through pool of sub-menu elements to do their everyday job!

Windows 8 new startup interface

start-menupng

Okay, we are techies and we will find out what we want from the tiled interface (after spending pretty decent time) pool and “try” to pretend that we are with the move

Worse scenarios, we just use classic shell and get straight on to our desired application. We are not ashamed to say we are from the ol ol schools Smile

classic_start

Bravo, now we can see Microsoft sending away few techies who thought they would be remembered for their “outstanding” visionary approaches with a no-harm meant “start” button elimination and easy access to applications through “metro” tiled application UI!

Yes, Microsoft, bring back what was there, let the users decide whether they want to change, finally like our employer always reminds us “Customer is the GOD”. So listen to customers and give them what they ask for.

for windows7bugs

admin

Windows 8, Classic Shell

On By windows7bugsIn Windows 8Leave a comment

Okay guys, after a week of “tolerating” windows 8 without a start button, being developers who are always trying to get “stuff” through start button –> programs, decided to go back to “Classic Shell” approach.

Neat and free, this small application could make a developer’s life pretty easier with a mouse click access to all programs! Give it a try and download it from here

for windows7bugs

admin

Windows 8, Antivirus solution(s)

On By windows7bugsIn Windows 8Leave a comment

Should you use a third party antivirus, anti-malware solution with your new Windows 8 OS is entirely a new debate, as Windows 8 comes with built-in solution for both antivirus, anti-malware.

Windows defender akka Microsoft security essentials in new shape should be more than enough to protect a normal user who doesn’t take risks by visiting websites known for spyware and other malicious codes.

We prefer to stay with Windows defender, as the complete solution is developed and maintained by Microsoft. Who knows the OS better than the them?

However, Avast suite (both free and paid editions) should give you a better level of peace of mind. We, as windows7bugs have already tried both scenarios (Windows defender and Avast paid edition) and opted to stay with Windows defender.

Now it is your turn to make a decision! The rule of thumb is, don’t take unwanted risks by visiting ill reputation sites and trying cracks, patches one use to “crack” legitimate software!

for windows7bugs

admin