Send Text from Email

Do you know if you can send text from your email?

Yes, you can and below are the email which will convert email to text. 

Below are the ways you can send text from different cell providers

AT&T

..coming soon..

Verizon

..coming soon..

T-Mobile

..coming soon..

Xfinity

If you want to send text to someone and it is from Xfinity then you can use <number>@vtext.com to send text messages.

For multimedia messages you can use <number>@mypixmessages.com to send MMS.

On the fence for going Solar

Are you on the fence for Solar ?

The President signed Inflation Reduction Act 2022 in fourth quarter of 2022 and that is a game changer for many people like me who is on the fence and have been thinking whether to go for Solar or not.

I have recently gone through the entire process myself and got Solar installed and I am quite impressed with it so far. I am in no way suggesting anyone to get Solar installed or not and I will let you decide yourself based on the factors I have learned during the entire process which happen to be 3-4 months process.

Here are some of the questions everyone should ask to himself or herself before thinking of going solar:

Why do you need solar installed?

1. To reduce your monthly electric bill
2. To avoid getting electric bill increased every year
3. To reduce dependency on electric companies
4. To have a backup plan for electricity
5. To remove dependency on non-renewable energy source

Factors you should consider before jumping on the ship to get Solar:

1. How long you are going to stay in your home ?
2. Does your HOA allow to install solar panels on your roof ?
3. How much roofing space you have for solar panels ?
4. What is the direction of the roof you are considering to have solar panels?
5. How many hours of Sun do you get on your roof ?
6. Is your roof new or too old - older than 5 years ?
7. How much electricity you consume per month ?
8. Whether you have an electric car or planning to have one ?
9. Is your electrical wirings and panel upto the city code ?
10. Do you have any trees which can obstruct direct sunlight ?
11. Temperature rating of the Solar panels & inverters
12. How much your electric company allow for Net metering ?

If you are ready to go for Solar now, use my referral to apply if you think this has helped you: https://estimator.enphase.com/lead?referral_code=63EC9D33R 

What are the rebates/credits available?

1. Federal is giving 30% tax refund as part of Inflation Reduction Act.
2. Every state has its own plan of providing rebates, IL has SREC.
3. Even City or Village might have their own rebates.
4. There might be additional rebates available for installing EV charger.

Frequently Asked Questions

How long it takes to get Solar panels installed on roof ?

Depending upon what time of the year you start the process and which brand of solar panels you wanted to install - it can take anywhere from 6 weeks to few months. There will be quite few back and forth of contract signing before actual process begins, so its important for you to not delay from your side. 

If you start the process in October, getting solar installed by year end is almost impossible.

Do I need to read the contracts for Solar ?

Even though contracts are standard its our responsibility as a consumer to read the contracts and you never know there might be a type or additional clause your Solar installer has added or even the Solar supplier has added any clause.

What is the upfront cost of installing Solar ?

The total cost of getting Solar panel installed might be anywhere from $20,000 to $60,000 depending upon the electricity usage, home size, number of panels, direction of panels, panel and invertor type you choose, company you choose to install Solar and the details of financing company.

Ideally you should be paying 0% percent APR with $0 financing fees for 18 months to be safe, few financing companies allow only 12 months.

How long it takes to get the rebates?

• Federal rebate is when you file taxes next year, IRS will refund.
• State rebates (if any) can take anywhere between 4 months to 12 months depending upon many factors.
• City rebates (if any) can also take anywhere between 4 months to 12 months.

What are the important steps in chronological order?

• Choose a Solar panel installation company
• Get the quote for your home from the selected company
• Solar installer will visit the home to check electric panel, grounding etc.
• Update the quote based on the Panel and Invertor selection
• Finalize the quote based on any changes in orientation and/or direction of panels
• Get the pre-approval from Financing company
• Sign the contract with Solar company and Financing company
• Get the HOA approval for Solar installation
• Get the Solar permit approved from local City/Village
• Updates needed on Solar panel orientation/placement/capacity asked by City (if any)
• Based on updates, new quote will be provided, new contracts need to be signed
• Get the permit approved from City
• Solar installer will schedule the installation date as per your convenience
• Installation can take 1-2 days max
• Solar installer will schedule the City inspection
• City will come and inspect the electrical, grounding, installation etc.
• City will approve if everything is in order, else Solar installer need to fix it.
• Solar installer will come and fix the ask (if any)
• Solar installer will schedule the City re-inspection
• City will approve this time assuming all OK
• Solar installer will remotely turn on the solar generation same day or next day
• Solar company rep will guide you about the app and login for you to monitor the generation
• Solar company will need to send you documents so that you can file the rebate with city
• Solar company will initiate the process for State rebate processor (SREC)
• SREC company will send you contract to sign
• Once contract from SREC is signed, they will prepare to file the SREC rebates

Does Solar panels come with warranty?

Yes All Solar panels and inverters come with some kind of warranty and it includes manufacturer warranty, installer warranty, roof leak warranty, Solar Insure warranty etc.

Make sure to ask about all the warranty questions and these should be part of the contract.

How long it takes to payoff the final cost of Solar?

Depending upon what was the final cost and how much electricity it generates, after all the rebates (Federal, State, City etc.) your final cost should be anywhere from $5000 to $12000 for a 8-9KW system.

Based on your monthly electric bill you can calculate how many months it will take to break even the cost.

If you are ready to go for Solar now, use my referral to apply if you think this has helped you: https://estimator.enphase.com/lead?referral_code=63EC9D33R 

What are the main parts of Solar panel system?

Solar panel, Inverters, Solar tracks, Roof Mount, Panel wirings, Inverter Combiner

Does it generate any electricity at all in cloudy days ?

With good quality of solar panels and inverters, it is possible to generate electricity even on cloudy days. It may not generate enough for the day but it will generate some.

Is there anyway to find out if my roof is good enough for Solar?

Yes, You can use https://sunroof.withgoogle.com/ to check if your roof is a good candidate for Solar panels. Based on number of hours your roof gets and area on the roof for solar panels - you can get the info even before contacting any Solar installer. Ideally 1200+ hours of Sun is good to get enough Solar electricity generation.

Feel free to post your questions if you have any and I will answer to the best of my knowledge and experience.

Here is how REC 405AA Alpha Pure solar panel looks:

Other factors you need to consider:

• Federal rebate is 30% of total Solar amount
• IL State has a limitation of 10KW system to purchase Renewable Energy Credit (REC) for a single family home, please research and compare the SRECs if you are going for more than 10KW
• Naperville City has a max rebate of $3000 for a single family home
• Naperville City has EV charger rebate as well of $700, upto a max of 50% provided the funding is not depleted.
• Comed 

For Naperville City specific Solar information visit: https://www.naperville.il.us/services/electric-utility/powering-our-community-for-the-future/solar-panel-guidelines/ 

For Comed specific Solar information visit: https://www.comed.com/SmartEnergy/MyGreenPowerConnection/Pages/SolarPromo.aspx

Net Metering & Solar Credits

From ComEd website: When you have a solar system and are being billed for net metering, you are charged only for the net amount of energy you use during each billing period (i.e., the amount of energy we deliver to you minus the excess amount you send back to the smart grid). And, if you send more energy to the grid than we deliver, you can receive credits on your bill. This program allows you to make full use of your own solar energy system, giving you more control over your energy costs. For more details on Net Metering, view our Frequently Asked Questions.

Similarly Naperville City also allows Net Metering 100%.

For details about Net Metering in other states and local government bodies: 

https://www.nrel.gov/state-local-tribal/basics-net-metering.html

How long it takes to get Solar installed ?

For few friends I know it took 3 months to 5 months, starting from the day contract was signed till the day when it was turned on. There are lot of steps involved in it, more like a guided tour.

How long it takes to get Naperville City rebate ?

From the time of submission of all the documents asked by Naperville City, if everything is correct and in order, rebate might get approved in 1-2 weeks and actual check will be sent by mail in next 4-6 weeks.

Few of my Naperville friends have got their rebate check within 6-8 weeks after they have submitted the rebate forms.

Who files Naperville City rebate ?

Solar panel owner (customer) files the rebate with Naperville City. It's fairly easy process, all it needs is to complete the questionnaires and send via email. 

How long it takes to get SREC rebate ?

SREC rebate processing times vary state to state. IL has three stages to go though for final payment.

Residential Solar installation is categorized under "Small Distributed Generation Part 1".

Currently IL SREC handler companies are saying that it can take anywhere between 12 to 18 months until consumers get the SREC payment check.

Official IL Shine website tracker: https://illinoisabp.com/project-application-reports/

Who files SREC rebate ?

Every Solar installer company has contracted the SREC handling part to a third party who takes their cut and files for SREC rebate with state. Consumer in this case has nothing to do other than tracking with Solar installer and the SREC handler. Some Solar installers are handling this by themselves and their selling point is that they don't charge SREC processing/handling fee but they do jack the total Solar installation cost. For RxSun, Carbon Solutions Group is SREC handler and their rebate/refund processing time is anywhere from 12 to 15 months to process and send the SREC check to customer.

As of 23 March 2024, I came to know about one of the Solar customer who got from RxSun and SREC was handled by Carbon Solutions Group, it took 14 months to deliver the SREC check, so its well within the range of 12 to 15 months.

How long it takes to get Federal tax refund ?

Federal tax refund timeline totally depend upon when you file your personal tax return with IRS. IRS federal refunds usually sends the refund via ACH transfer directly to the bank account linked (this is fastest) or via check.

For Solar panels installed in 2022, you will get federal tax refund in 2023 few weeks after tax return is filed and accepted by IRS.

Assuming that tax can be filed by April 15th, standard federal refund timeline is 2 weeks.

Who files Federal refund ?

Solar consumer or tax accountant who is handling consumer's tax returns files the tax return in upcoming tax year and it comes as a federal refund, currently 30% of total solar value.

Last updated: 23 March 2024.

...and I will keep adding as I learn through the process...so keep visiting.

Bankers or Cashiers check from Discover Bank

Bankers or Cashiers check from Discover Bank is totally free for Discover Bank account holders, all you need to do is call their 800 number (as of writing of this blog 800-347-7000, make sure you double check the number before calling Discover Bank).

Discover Bank Cashiers/ Bankers Check Issuer place would be Greenwood, DE if you need to fill any official form, as confirmed by customer service. Again all these information is for helping you all, please make sure to double check and confirm the information directly by calling Discover Bank.

Wonders of MarkLogic Queries

MarkLogic Query needs every correct set of braces to return correct results. 

When using cts.search(cts.AndQuery[query1(), query2()]) using server side javascript - it was not throwing any error or complaining about braces just returning all the documents in the document store.

Talked to Derek@MarkLogic and he was able to quickly spot the error, a curly brace was missing and that did the trick, he said its a bug in MarkLogic and it will be fixed in upcoming releases.

Corrected the query as cts.search(cts.AndQuery([query1(), query2()])) and it worked like a charm.

Lessons learned, if you query is not working as expected, verify your braces as well.

MarkLogic content store Documents vs named store

All documents created under MarkLogic "Documents" store are universally indexed and can be searched without creating any index manually. However documents created in content store created in MarkLogic other than Documents i.e. "my-content-store", documents are not indexed by default. Appropriate type of indexes need to be created for the fields or path for "my-content-store" document store.

Path range indexes are one of the most common index type that is created to use in enterprise applications.

Path range index example1:  "address/state"

Search documents will be based on either of these: field1/address/state or address/state or field1/field2/address/state

Path range index example2:  "/address/state"

Search documents will be based on exact path : /address/state only

Details of MarkLogic Connector for Kafka

How MarkLogic Kafka connector works and what it entails? 

MarkLogic has provided a connector to consume the messages out of a Kafka topic, calling as SINK process. 

Main Features:

- It's a Java utility and provided with community support, no enterprise support available.

- Connector consumes the messages out of Kafka topic and MarkLogic document names are unique but automatically generated UUIDs and cannot be changed. Although uri prefix and document extension is supported.

Example documents: AABC-WERE-UUID-THIS.json, uri/AABC-WERE-UUID-THIS.json

Had a conversation with MarkLogic original developer and he mentioned that the code can be updated to mend as needed but MarkLogic won't do it.

- Connector consumes the messages in batches periodically which can be configured, how frequently and how many to consume each time.

- It supports 2 Way SSL with candidate application

- It does not support AVRO format as of today and cannot validate the messages based on a schema

Documentation: https://www.marklogic.com/blog/kafka-marklogic-connector/

Github link: https://github.com/marklogic-community/kafka-marklogic-connector

How KStream, Ktable and Join works?

There were lot of unknowns or at least I was not knowing how KTable, KStreams and Join between them works or behaves when I started using these artifacts from Apache Kafka.

I would like to mention some of the unknowns that were not documented and we ran into issues because of them:

1. KTable stores the mapping as (key, value) pairs. Whenever there is an update to the key, the entire value object is getting replaced and it is not getting updated.

Example:

Key: A0001

Value: {id:001, name:ABC01}

Please keep visiting, will complete the post.

Updating producer handle deletes all remote portlet instances

Updating producer handle deletes all remote portlet instances

Platform: WebLogic Portal (Oracle formerly BEA)
Version: 10.3.7 (may be in earlier version too)

Description: When producer handle is updated using Portal Admin Console (with or without checking the Re-register Producer), it deletes all the remote portlets associated with the handle. This has been reported and Oracle has created a bug for this issue.

Solution: There are various ways to avoid deleting the associated remote portlets, when trying to update the remote producer handle:

1. Update the remote producer handle directly in the portal database  table by running the following query:
update PF_CONSUMER_REGISTRY set WSDL_URL = 'http://myNewProducer.com/webApp/producer?wsdl' where PRODUCER_ID = XXXX;

Warning: This seems pretty simple however involves touching the portal database directly, one small mistake and you can corrupt your portal database, so take extreme precaution! Don't forget to commit after you ran the query.

2. Get the patch for the bug from Oracle, here is the detail:
Bug 25227539 : Reregister of ProducerHandle deletes the existing portlets from DVT & PATconsole.
This requires a lot of work, but is safe and will fix the issue. After the patch is applied, producer handle can be updated using portal admin console without checking the re-register handle check box.

PS: If you are following any of the above solutions, please leave your comments.

Find hung transactions in Database

Find hung transactions in Database during two phase commit

Database: Oracle
Version: 11g

When using two phase commit involved in an application feature, to find out the hung transactions in Oracle database following query can be used:
select * from dba_2pc_pending;

This should display the list of hung transactions with all the particular details including the calling client/user and other details.

Remove Zone2 from Sony STR DH820 Receiver

Here is how you can achieve the followings:

1. Remove Zone2 from Sony STR DH820 Receiver
2. Reset the receiver remote RM-AAP061

Problem: Somehow someone pressed the zone2 button on remote or receiver and can't go back to zone 1 using remote.

Solution:
Step 1. Turn off all the receivers (zone 1 and zone 2) by pressing (On/Off) and (AV On/Off) same time on the remote pointing to the receiver.

Result: Receiver will be in standby mode for both zone 1 and zone 2.

Reference: Page 67, right column user guide.

Step 2. While holding down (MASTER VOL -) key, press and hold (On/Off) and then press (A/V On/Off) on the remote pointing to the receiver.

Result: The RM SET UP indicator flashes 3 times.

Reference: Page 85, left column user guide.

User guide URL: http://pdf.crse.com/manuals/4266497121.pdf

Align the contents using af:panelGroupLayout

Want to align the contents using af:panelGroupLayout ?

Use the following code snippet to horizontally right align the contents:

<af:panelGroupLayout id="vinaypgl01" width="400px" layout="horizontal" halign="right">
<af:outputText id="vinayot01"> This line will be right aligned.</af:outputText>
</af:panelGroupLayout>

Use the following code snippet to horizontally center align the contents:

<af:panelGroupLayout id="vinaypgl01" width="400px" layout="horizontal" halign="center">
<af:outputText id="vinayot01"> This line will be center aligned.</af:outputText>
</af:panelGroupLayout>

AF:PanelGroupLayout not stretching to its full width

Want to stretch the contents to its full width using af:panelGroupLayout ?

Use the following code snippet to stretch the content to its full width:

<af:panelGroupLayout id="vinaypgl01" width="400px" styleClass="afStretchWidth">
<af:outputText id="vinayot01"> This line will not be wrapped, it will be in full width of the panel grid layout i.e. 400 pixels.</af:outputText>
</af:panelGroupLayout>

Use the following code snippet to arrange the content blocks horizontally:

<af:panelGroupLayout id="vinaypgl01" layout="horizontal">
<af:panelGroupLayout id="vinaypgl02" width="400px" styleClass="afStretchWidth">
<af:outputText id="vinayot01"> This is first block.</af:outputText>
</af:panelGroupLayout >
<af:panelGroupLayout id="vinaypgl03" width="400px" styleClass="afStretchWidth">
<af:outputText id="vinayot01"> This is another block.</af:outputText>
</af:panelGroupLayout>

</af:panelGroupLayout>

Use the following code snippet to arrange the content blocks vertically:

<af:panelGroupLayout id="vinaypgl01" layout="vertical">
<af:panelGroupLayout id="vinaypgl02" width="400px" styleClass="afStretchWidth">
<af:outputText id="vinayot01"> This is first block.</af:outputText>
</af:panelGroupLayout >
<af:panelGroupLayout id="vinaypgl03" width="400px" styleClass="afStretchWidth">
<af:outputText id="vinayot01"> This is another block.</af:outputText>
</af:panelGroupLayout >

</af:panelGroupLayout >

AF:GridCell not stretching to its width

When using the contents are wrapped even after giving the width.

To stretch the component to its full width of the cell use the following snapshot of code:

<af:panelGridLayout id="vinaypgl01" width="400px">
<af:gridRow id="vinaygr01">
<af:gridCell id="vinaygc01" halign="stretch" width="50%">
<af:outputText id="vinayot01"> This line will not be wrapped, it will be in full width of the panel grid layout i.e. 400 pixels.</af:outputText>
</af:gridCell>
</af:gridRow>
</af:panelGridLayout >

Generate Framework Portal MAR file without Jdeveloper in non Windows OS

How to generate AutoGenerated.mar file without opening Jdeveloper ?

Currently AutoGenerated.mar file can be build only in Jdeveloper in Windows OS and there is no UNIX equivalent tool provided by Oracle to create the same.

This can be achieved using custom ANT task, which I am working on and will be publishing soon to the world.

Click here to follow this link to get the source code and ant task details.

More details coming soon, thanks for visiting...

Generate TaskFlow jar without Jdeveloper in non Windows OS

How to generate task flow view controller jar file without opening Jdeveloper ?

Currently task flow jar can be build only in Jdeveloper in Windows OS and there is no UNIX equivalent tool provided by Oracle to create the same jar.

This can be achieved using custom ANT task, which I am working on and will be publishing soon to the world.

More details coming soon....

Add Access Permission to Resources

How to add access permission to web center portal resources ?

Coming soon...

Integrate Taskflow and Framework Portal

How to access your taskflow from a framework portal in WebCenter Portal environment?

Here is the step by step instructions:

Assumptions:

• Assuming the task flow project name is CookTaskFlow and it has a task flow name cook-task-flow-definition.xml. 
• Framework portal project name is FoodPortal.

Prerequisites:

• Make sure that you create a test page (jspx) in CookTaskFlow project to test the task flow cook-task-flow and it is working as you expect.
• Make sure that you create a test page (jspx) in FoodPortal to test that framework portal is working as you expect.

Integration Steps:

Step 1. Navigate to case task flow project and create the view controller jar file by using the "deploy to jar" option for the task flow and you should see that CookTaskFlow.jar has been created in ViewController/deploy folder.

Step 2. Navigate to framework portal project and create a file system connection in the Resources palette, enter the name of the resource as CookTaskFlow and enter the folder path as ViewController/deploy folder path. Make sure you test the connection before you save it.

Step 3. You should be able to see the view controller jar under CookTaskFlow file system connection in the resources palate.

Step 4. Open the jspx page where you want to add the task flow as a region and make sure this jspx has no compilation errors and it is working as a test page. Drag an drop the task flow from view controller jar from resource palate to this jspx page, it should give you a choice of selecting a region and others, select region.

Step 5. You should see a tag created, which points to the definition of the task flow you are trying to add.

Step 6. When you are trying to drag and drop the task flow in step 4, it should ask whether you want to add the task flow jar as a library and you should say yes.

With this you should be able to right click and run the jspx page.

Note: Access permission to allow the users to view the task flow can be set using jazn-data.xml file. See my other blogs on how to add permission to view a task flow or any other resource.

JDeveloper: An expected severe error has occured

Popup to show An expected severe error has occured in JDeveloper

The program may be unstable, which could result in data loss. Decide how you want to proceed and click OK.

• Save and exit
• Exit without saving
• Continue

Error details

Uncaught exception
java.lang.OutOfMemoryError: Java heap space
  j.util.Arrays.copyOf(Arrays.java:2882)
  j.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:100)
  j.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:390)
  j.lang.StringBuffer.append(StringBuffer.java:224)
  org.tmatesoft.svn.core.SVNErrorMessage.getFullMessage(SVNErrorMessage.java:257)
  org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:58)
  org.tmatesoft.svn.core.internal.wc.admin.SVNAdminAreaFactory.open(SVNAdminAreaFactory.java:163)
  org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.doOpen(SVNWCAccess.java:364)
  org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess.java:272)
  org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.open(SVNWCAccess.java:265)
  org.tmatesoft.svn.core.internal.wc.admin.SVNWCAccess.openAnchor(SVNWCAccess.java:145)
  org.tmatesoft.svn.core.wc.SVNStatusClient.doStatus(SVNStatusClient.java:320)
  org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:296)
  org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:278)
  org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:480)
  org.tigris.subversion.svnclientadapter.svnkit.SvnKitClientAdapter.getStatus(SvnKitClientAdapter.java:141)
  org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:466)
  o.ji.vcs.svn.SVNURLInfoCacheSimpleStrategy.getURLInfo(SVNURLInfoCacheSimpleStrategy.java:79)
  o.ji.vcs.svn.SVNURLInfoCache.getPropStatus(SVNURLInfoCache.java:59)
  o.ji.vcs.svn.SVNStatusResolver.getStatus(SVNStatusResolver.java:159)
  o.ji.vcs.svn.SVNStatusResolver.populateStatuses(SVNStatusResolver.java:82)
  o.ji.vcs.generic.GenericClient$2.getImpl(GenericClient.java:531)
  o.j.vcs.spi.VCSStatusCache.getValuesImpl(VCSStatusCache.java:31)
  o.j.vcs.spi.VCSURLBasedCache.getValuesImpl(VCSURLBasedCache.java:204)
  o.j.vcs.changelist.ChangeListLocalStatusCache$2.call(ChangeListLocalStatusCache.java:78)
  o.j.vcs.spi.VCSURLBasedCache.callUnderWriteLock(VCSURLBasedCache.java:224)
  o.j.vcs.changelist.ChangeListLocalStatusCache.getValuesImpl(ChangeListLocalStatusCache.java:73)
  o.j.vcs.spi.VCSURLBasedCache.getValues(VCSURLBasedCache.java:107)
  o.j.vcs.changelist.ChangeListEventQueue.filterByStatus(ChangeListEventQueue.java:513)
  o.j.vcs.changelist.ChangeListEventQueue.processRequeryEvent(ChangeListEventQueue.java:373)
  o.j.vcs.changelist.ChangeListEventQueue.processEvent(ChangeListEventQueue.java:258)
  o.j.vcs.changelist.ChangeListEventQueue.processEvents(ChangeListEventQueue.java:685)

When you get this error, probably there is an error with your application too, close the application and JDeveloper and start from scratch.

Tips to avoid this:
1. While working with JDeveloper, you need to close and open application so many times. When I want to delete an application, I will choose to Close Application rather from Jdeveloper and then delete the application folder physically later after closing JDeveloper.
2. After running JDeveloper for long, it starts consuming more memory, give it a break, close the JDeveloper and open it again.
3. Always refer the external jars as user library, create a library name to your physical path and then extend the library to add external jars to the classpath.

SOA Composite Cheat sheet

Declaring a new variable of XMLType
Technically it can be defined in any scope of any XMLType (if not found import it), but it is recommended to define it where it is really needed.
Create a new scope in the block where it is needed and define it, otherwise it may throw totally unrelated exceptions - you will not be able to figure out.

Initializing a new variable of XMLType already declared
Any XMLType variable must be initialized before it is getting used.


How to avoid generation of xmlns="" while doing mapping in xpaths
Declare and initialize the parent XMLType variable and while assigning or appending use the child of the newly defined variable to avoid getting xmlns="" in the xml tag.


How to append instead of assign while mapping xpaths
Do the mapping as you normally do first. Once mapping is done then right click the mapped path and convert it to append, it should create a + plus icon in the left xml xpath which shows that it got converted to append instead of assign.

Oracle Business Rules Cheat sheets

Section 1: Oracle Business Rules

Details:

• When facts are modified as part of action inside business rules, business rules are getting fired again based on the new data
• Priority/Order can be set in business rules in order to call them in a particular order
• Business rules can be made active/inactive by checking the "Rule Active" check box
• Inactive business rules are not getting fired and are same as commented code

Section 2: Oracle Business Rule Facts

Details:

• Facts can be defined as RL Facts and properties (one or more) can be added to the fact.
• While defining a property as an ArrayList, defining the property's array list item type (e.g. Person type fact) throws an undefined fact error, so its better to leave the array list item type as blank.
• Facts can be asserted using assert new action in initial action, these assertions will not be maintained by names -
• Facts can be created using assign new and then can be asserted, these will be available by names as well
• Facts are directly accessible in Oracle Business Rules
• Facts are not accessible in BRE Functions
• Collection of facts or fact itself can be passed from Oracle BRE to function while calling the function
• Facts need to be used in BRE, if they are not used in BRE, BRE cannot be compiled and deployed even if they are used in initial actions

Section 3: Oracle Business Rule Functions

Details:

Section 4: Oracle Business Rule Initial Action

Details:

Reset SVN (Subversion) account information in JDeveloper

Once the account info (username, password or repository url) is set in JDeveloper, SVN (subversion) plugin its hard to change any of these using jDeveloper.

Here is how these can be changed:

1. Save your data and close JDeveloper
2. Find the repositories.xml file, normally it is located in user's home directory and in following subdirectory: 
     .jdeveloper/system11.1.1.6.38.61.92/o.jdeveloper.subversion
3. Rename the file repositories.xml to repositories.xml.bak
4. Open JDeveloper and try to checkout a file, it will ask you to enter the account information again.
5. Enter the updated account info, test access and you are done!