16.8 C
Amersfoort

[vc_row tdc_css=”eyJhbGwiOnsicGFkZGluZy10b3AiOiI0OCIsImRpc3BsYXkiOiIifX0=”][vc_column tdc_css=”eyJhbGwiOnsiZGlzcGxheSI6IiJ9fQ==”]

[/vc_column][/vc_row][vc_row][vc_column width=”2/3″]

Dataloader Library

In the past years being an Oracle E-Business Suite consultant I've created and built up a big library of Dataloader scripts which...

Quickly enable or disable users through code

A while ago I got a question from someone how to disable a bunch of users...

How to unlock an user through code

It happens that for some reason you totally forget your password and entered it a number...

SQL to retrieve a list of descriptive flexfields with column usages and valueset definitions

For a little project I needed to retrieve E-Business Suite Descriptive Flexfields for all applications together...

How to get the name of the Oracle E-Business Suite ICX authentication cookie?

If you want to integrate other applications with Oracle E-Business Suite it might be needed to...

How to hide the “Preferences” link from the E-Business Suite Homepage on site level

I got a question recently how the Preferences link, which resides on the homepage of E-Business...

OBIEE

Start your BI Node Manager as Windows Service

When you have installed the Oracle BI suite on Windows you may want to configure the Node...

Locked cwallet.sso after BIDomain Configuration Wizard – unable to start?

I needed a new BI playground environment within my in house environment so last week I tried...

How to change the default scrolling option of a table view in OBIEE

By default the scrolling option in table view of your analysis is set to Fixed headers...

SOA

How to create an UUID in SOA?

For a project we make extensive use of Oracle SOA with a number of messages exchanged with external parties. These messages need...
[/vc_column][vc_column width=”1/3″ is_sticky=”yes”][td_block_social_counter custom_title=”STAY CONNECTED WITH US” facebook=”justknowitjustdoit” twitter=”JustKnowITDoIT” style=”style4 td-social-colored” open_in_new_window=”y”]

SQL

Extract profile option values for all possible levels

When needed one and the same profile option can be assigned to different levels. For example,...

Generate an overview of your End User Layer in Discoverer

When you're doing a Discoverer implementation Oracle delivers by default a number of seeded Business Area's which provide the ability to...

Retrieve patch information for a specific module

It sometimes happens that you quickly want to get an overview of patches that are applied...

Retrieve which Oracle Discoverer workbooks are shared with a specific user

Discoverer is a great reporting tool from Oracle which you use to create reports from your Oracle eBS database. You create...

MOST COMMENTED

Custom Time Entry Rules in Time and Labour (OTL) – Prevent 0 hours time entry

Last week I received a requirement from a client for Oracle Time and Labour and Timecard...

How to add a context dependent descriptive flexfield on OAF Control Item page (type dependent)

We all know (I think :-)) the way in Oracle Forms to create context dependent descriptive...

User Preferences in Oracle E-Business Suite

You probably know the User Preferences link at the right top of your E-Business Suite homepage....
[/vc_column][/vc_row][vc_row tdc_css=”eyJhbGwiOnsicGFkZGluZy10b3AiOiI0OCIsImRpc3BsYXkiOiIifX0=”][vc_column width=”2/3″]

CUSTOMIZATION

How to change the default scrolling option of a table view in OBIEE

By default the scrolling option in table view of your analysis is set to Fixed headers...

Change the default user interface style of OBIEE

Starting from OBIEE 11.1.1.7 you can do more and more with customising the OBIEE GUI. By...

Custom Time Entry Rules in Time and Labour (OTL) – Prevent 0 hours time entry

Last week I received a requirement from a client for Oracle Time and Labour and Timecard...

How to create a report with BI Publisher using a data template

In my current project but also in previous ones I make use of the BI (XML)...
[/vc_column][vc_column width=”1/3″]

Want something to read?

Retrieve which Oracle Discoverer workbooks are shared with a specific responsibility

After my earlier post regarding the SQL query to extract the shared workbooks with a specific user...

How to split a string by backslash in Java

The other day I was working on some Java code and I needed to split a string...

How to quickly compile Fast Formulas and Regenerate the Function Wrapper from the prompt

When working the other day on some new FastFormula to be used in Oracle Time and...

Hierarchical queries on Oracle database – part 2

After some time I'm back in business and ready to publish a bunch of new articles. In...
[/vc_column][/vc_row][vc_row][vc_column]
[/vc_column][/vc_row][vc_row tdc_css=”eyJhbGwiOnsicGFkZGluZy10b3AiOiI0OCIsImRpc3BsYXkiOiIifX0=”][vc_column width=”1/3″][/vc_column][vc_column width=”1/3″][/vc_column][vc_column width=”1/3″][/vc_column][/vc_row][vc_row tdc_css=”eyJhbGwiOnsicGFkZGluZy10b3AiOiI0OCIsImRpc3BsYXkiOiIifX0=”][vc_column]
[/vc_column][/vc_row][vc_row][vc_column width=”2/3″][tdb_loop modules_on_row=”eyJhbGwiOiI1MCUiLCJwaG9uZSI6IjEwMCUifQ==” modules_gap=”eyJsYW5kc2NhcGUiOiI0MCIsInBvcnRyYWl0IjoiMjgifQ==” modules_category=”image” show_excerpt=”none” show_btn=”none” ajax_pagination=”numbered” custom_title=”LATEST ARTICLES”][/vc_column][vc_column width=”1/3″ el_class=”” is_sticky=”yes”]

MOST POPULAR

SQL to extract active user list with responsibilities

Today I got the request to generate an extract with active users together with their active...

How to add a context dependent descriptive flexfield on OAF Control Item page (type dependent)

We all know (I think :-)) the way in Oracle Forms to create context dependent descriptive...

Signon Password Policies

I just recently got the requirement that user passwords should follow the password security policy of...

User Preferences in Oracle E-Business Suite

You probably know the User Preferences link at the right top of your E-Business Suite homepage....
[vc_wp_recentcomments custom_title=”RECENT COMMENTS” number=”5″ com_divider=”solid” f_title_font_style=”normal” auth_color=”#8224e3″ com_divider_color=”#dd9933″][/vc_column][/vc_row]