Create Trigger JD Edwards Table

Create Trigger JD Edwards

1.Check out the table to which you want to attach event rules and click Design.

2.On the Table Design form, select the Design Tools tab and click Start Table Trigger Design Aid.

3.Select an event from the Events list.

4.On Event Rules Design, click one of the event rule buttons and complete the event rules.

5.Click Save to save the event rule specifications and then click Close.

6.If you are creating a new table in Oracle's JD Edwards EnterpriseOne Table Design Aid, select the Table Operations tab and click Generate Table.

http://download.oracle.com/docs/cd/E17984_01/doc.898/e14702/createtableeventrules.htm

IDENTITY column in sql-server in select into

select

IDENTITY(INT, 10, 1) idnt ,* from testdta.F5510004

my first TRIGGER ever sql-server

ALTER

TRIGGER testTRIGGER

ON

dbo.QTD_HOURS1

FOR

INSERT

AS

BEGIN

insert

into QTD_HOURS1Trg

select

a.* from QTD_HOURS1 a

left

outer join QTD_HOURS1Trg b on a.[column 0]=b.[column 0] and a.[column 1]=b.[column 1]

where

b.[column 0] is null

END

Convert Date range into month

select

--startdate,enddate,datepart(MM,startdate),datepart(MM,enddate),enddate,

case

when (datepart(MM,startdate)<='1' and datepart(MM,enddate)>'1') then 1 else 0 end Jan,

case

when (datepart(MM,startdate)<='2' and datepart(MM,enddate)>'2') then 1 else 0 end Feb,

case

when (datepart(MM,startdate)<='3' and datepart(MM,enddate)>'3') then 1 else 0 end Mar,

case

when (datepart(MM,startdate)<='4' and datepart(MM,enddate)>'4') then 1 else 0 end Apr,

case

when (datepart(MM,startdate)<='5' and datepart(MM,enddate)>'5') then 1 else 0 end May,

case

when (datepart(MM,startdate)<='6' and datepart(MM,enddate)>'6') then 1 else 0 end Jun,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'7') then 1 else 0 end Jul,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'8') then 1 else 0 end Aug,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'9') then 1 else 0 end sep,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'10') then 1 else 0 end Oct,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'11') then 1 else 0 end Nov,

case

when (datepart(MM,startdate)>='1' and datepart(MM,enddate)>'12') then 1 else 0 end Dec,

*

from dbo.EmpNew

where

emplno IN(101274,101429,101483,101513,101560,101592,101605)

Fusion Middleware Developer's Guide for Oracle SOA Suite

Fusion Middleware Developer's Guide for Oracle SOA Suite 11g Release 1 (11.1.1.4.0)

 

Business Process Execution Language (BPEL), short for Web Services Business Process Execution Language (WS-BPEL) is an OASIS[1] standard executable language for specifying actions within business processes with web services. Processes in BPEL export and import information by using web service interfaces exclusively.

Service-oriented architecture (SOA) is a flexible set of design principles used during the phases of systems development and integration in computing. A system based on an SOA will package functionality as a suite of interoperable services that can be used within multiple, separate systems from several business domains.

 

 

http://download.oracle.com/docs/cd/E17904_01/integration.1111/e10224/bp_appx_ref.htm#CIAHDJHB

 

JD Edwards OBIEE Time dimension

Very good sample on Julian date time dimension to create sales report check this out sample.

http://www.youtube.com/watch?v=IsNTTweoZ4s

OBIEE development document

http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e12187.pdf

OBIEE 11g installation Windows

OBIEE 11g installation for windows...

 

 

http://debaatobiee.wordpress.com/2011/02/13/oracle-business-intelligence-enterprise-editionobiee-11g-installation/

http://www.adivaconsulting.com/adiva-blog/item/10-obiee_install

http://www.oraclenerd.com/2010/08/obiee-11g-install-part-i.html

 

UBE0000084 ERROR: Function: PDFDocGen_Save, Code: 3, Message: Bad parameter.

The issue is that in tools release 8.98.4.4 if a batch job is suppose to produce print
output that is just a single blank page, no PDF file is generated for the
batch job and the batch job ends in an 'E' (error) status. 

Bug# 12977338

The fix will go in tools release 8.98.4.6.

POC fix JD Edwards

A POC fix is an untested fix that you can apply to your tools release to test with to see if it works or not.

Difference Between OBIEE 10g and OBIEE 11g

Difference Between OBIEE 10g and OBIEE 11g

Architectures-
OBIEE 11g architecture...http://www.rittmanmead.com/2010/07/09/obiee-11gr1-architecture-and-use-of-weblogic-server/
OBIEE 10g architecture....http://gerardnico.com/wiki/dat/obiee/obiee_overview

Features-
New features in OBIEE11g...http://forums.oracle.com/forums/thread.jspa?messageID=4392154
http://blogs.oracle.com/robreynolds/2010/07/new_administration_features_of.html

check this out https://forums.oracle.com/forums/thread.jspa?threadID=1554799

ASP.NET MVC dynamic view sections

Intrigued by the question and having no clue on how to do this, I quickly hacked together a SettingsViewModel, to which he could add all section view models no matter what type they are:

 

http://blog.maartenballiauw.be/post/2011/09/08/ASPNET-MVC-dynamic-view-sections.aspx

 

Is Microsoft Office 2000 compatible with Windows 7

Outlook 2000 is not supported on Windows 7

 

Delete All Rows From Table JD edwards

0001 Get Input Output Env Handles
        SL LoginEnvironment                -> szInputEnvironment
        VA rpt_GenericLong <- idInputEnvHandle
        SL LoginEnvironment                -> szOutputEnvironment
        VA rpt_GenericLong_Out <- idOutputEnvHandle
        SL LoginEnvironment                -> szLoginEnvironment
0002 Delete All Rows From Table
        "F550154" -> szTableName
        VA rpt_GenericLong_Out -> idOutputEnvHandle