Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle Application Development Framework (Oracle ADF) and EBS – An Inside look

Posted on April 28th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle ADF provides an easier way to develop, provides solution to many of the infrastructure needed and abstraction from the complex technologies.

In other word , you can say its development framework that simplifies development of Java EE-based SOA applications.

  • Abstract developers from technology complexities such as UI Components abstract from Ajax, Flash, Javascript, DOM
  • Provides end-to-end infrastructure solutions, like O/R Mapping, persistence, caching, controller, binding, UI framework, security
  • Easy way to use with jdeveloper

dgreybarrow Oracle ADF – High Level Architecture

The Fusion StackThis is the basic architecture of Oracle ADF is based of Model-View-Controller (MVC) design pattern.

An MVC application is separated into:

1) a model layer that handles interaction with data-sources and runs the business logic,

2) a view layer that handles the application user interface, and

3) a controller that manages the application flow and acts as the interface between the Model and the View layers

When it comes in Oracle Fusion Stack, this typically looks like figure below.

Here is what each of the components of ADF provides

  • ADF Faces Rich Client Components -UI components with built-in Ajax support
  • ADF Controller -Declarative definition of Web-pages and task flows
  • ADF Model -Declarative way to bind UI to business services
  • ADF Business Components -Reusable components to manage DB access and logic

dgreybarrow ADF Business Components

  • This is a framework that simplifies developing Java EE business services for developers familiar with 4GL tools, declarative development, and relational databases
  • Mapping database objects into Java
  • Provides the ability to define basic validation rules
  • Exploit the power of the database
  • Provides a rich event model, much like the triggers
  • One key aspect of ADF BC is that it provides a lot of functionality out of the box that save you coding. This helps
    • Query by example any field
    • Master/Detail coordination
    • List of values
    • Calculated fields
    • Various validations
    • Exposing SDO Web services
    • Range fetching
    • Transaction control
    • Locking mechanism
    • State management
    • All done declaratively without coding

dgreybarrowApplication Development Framework -benefits does it provide specifically for EBS

If you came from EBS background, here are the same benifits :

  • You will get Richer Web UIs - Typical you can graphs, Maps, Dashboards
  • Mobile Interfaces
  • Mash-up Oracle E-Business Suite with other applications
    • You can get Oracle E-Business Suite data into Oracle ADF applications
    • You can get Oracle ADF applications into Oracle E-Business Suite

dgreybarrow ADF Extensions with Oracle E-Business Suite

In order to Protect your investment in the future, and co-exist with Fusion Applications, ADF Extensions exist with Oracle E-Business Suite. These extension are typicall help Navigation , Embedding Rich ADF content in EBS and accessing EBS data as mention is EBS benefits in previous section.

dgreybarrow ADF Extensions with Oracle E-Business Suite

FYI, here is the some of key information on ADF Extension [Adopted] from Navigation, Security and Session Management.

First is Navigation , here to go.

  • From Oracle E-Business Suite to Oracle ADF
    • External ADF server profile option, FND_EXTERNAL_ADF_URL
    • Register ADF pages as ADFX-type functions with WEB_HTML call as “GWY.jsp?targetPage=<URL for ADF page>”
    • Put functions in EBS menus or permission sets
    • This required EBS12.1.3
  • Oracle ADF to Oracle E-Business Suite
    • Construct RF URL for a given EBS Page
    • Generate the RF.jsp URL to the EBS function using FND_RUN_FUNCTION.get_run_function_url

In Security , here are ADF extensions mostly used for EBS Authentication and Authorization - JAAS, which helps to

  • Protect your application using EBS Security Model
  • Use EBS Credentials (Username/password)
  • Authorize only certain Roles/Responsibilities

where are in Session Management

  • Use Session variables between EBS and ADF such as Language and User
  • If you log out from ADF, EBS session should also log out, and vice versa
  • Transaction Management with EBS and ADF
  • Timeouts between EBS and ADF sessions

where for Accessing E-Business Suite Data, extension are there for both the options as:

  • SOAP Services – Loose Coupling (preferred technology)
    • From SOA Suite, you can use Apps Adapter
    • Integrated SOA gateway for Native Services
  • Public API’s from E-Business Suite – Tight coupling
    • Use Apps Data Source
    • Access any Public API in Integration Repository

dgreybarrow Learning ADF

If you starter, you start understanding subject from these Oracle tutorials.

The more information you can obtain from Oracle ADF Finder

Posted in Emerging Technologies | No Comments »

What is a Framework

Posted on April 28th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Developer usually get confused with this term specially in Oracle.

  • Toolkit of handy code and techniques for dealing with common use cases
  • Process implementing the best practice for solving a particular problem
    • Configuring, not coding
    • Runtime component
    • Design-time component

You should understand a good framework is consider with these attributes.

  • Functional depth
  • Functional scope
  • As declarative as possible
  • Clean APIs
  • Tools
  • Acceptance
  • Support

OAF, Form, ADI are sorts framework in Oracle.

Posted in Misc | No Comments »

Report Manager-Setting default parameters when uploading template.

Posted on April 26th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Report Manager Publishing issue:

  1. You have done setup the profile option BNE Allow Set Parameters = Yes ( System Administrator > Profile>System)
  2. Created template from Report Manager(Report Manager>Financial Report Template Editor)
  3. Upload the template.
  4. Now you are trying to modify the same template and trying again to upload (Report Manager>Financial Report Template Editor)
  5. System will not allow as the overwrite existing template not enabled.

You might get this issue, when you are trying to achive this. Therefore if you are using Report Manager to run FSGs, when you created template for upload, you need the paramters like "Enable Drill" and "Overwrite Existing Template" to be checked by default.

These two options might help you in achieve this

Options 1

What you need is to default "Enable Drill" and "Overwrite Existing Template" check box to true.

You can achieve this by simple update from backend directly by running this script from database.

  1.  
  2. UPDATE BNE_PARAM_LIST_ITEMS T
  3. SET T.BOOLEAN_VALUE_FLAG = 'Y',
  4. T.DESC_VALUE = 'Defaulting to True'
  5. WHERE T.APPLICATION_ID = 265
  6. AND T.PARAM_LIST_CODE = 'FRM_EXCEL_UPLOAD'
  7. AND T.PARAM_NAME IN('frm:template_drill_enable','frm:template_overwrite');
  8.  
  9.  

on successful commit, you need to recreate the template by bouncing the Apache.

Options 2

Another Options is follow as per Oracle metalink Note (#784512.1 ) , this will enable you to default "Enable Drill" and "Overwrite Existing Template" check box to true, you need to edit upload parameters of FSG Template Editor.(Adopted from metalink)

  1. Login to application navigate to Desktop Integration responsibility. Open Create Document function.
  2. Browser address bar will display an URL like
    http://<host>:<port>/oa_servlets/oracle.apps.bne.webui.BneApplicationService?bne:page=BneCreateDoc change it
    http://host:port/oa_servlets/oracle.apps.bne.webui.BneApplicationService?bne:page=BneParameter and click enter.
  3. Uncheck the "Restrict to this application" check box and click next.
  4. Click Name LOV. Search for the parameter list code "FRM_EXCEL_UPLOAD" and select it.
  5. To Update the parameter "frm:template_overwrite" click the pencil icon next to the parameter.
  6. In the resulting Define Parameter page set the default value to True and enter description as "Defaulting to True" and save.
  7. Now repeat the same for "frm:template_drill_enable" parameter to default the value.
  8. Once you complete click the Save button in the main page ("Define Parameter List" page).
  9. You can perform test the changes by clicking test button in the main page.

Posted in Oracle General Ledger | Comments Off on Report Manager-Setting default parameters when uploading template.

Where is my Missing Transaction Numbers?

Posted on April 25th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Lets revisit some Basic things

  • Invoice Numbers/Transaction Number : These are Numbers generated and controlled by the Source definition. Oracle Reference column is TRX_NUMBER.
  • Document Numbers : This you need to define a Sequence & assign it to the Document Category which is the AR Transaction Type. Oracle Reference column is DOCUMENT_SEQUENCE_VALUE.

dgreybarrow Why Transaction Number sequence is so important

As far as I know, some of European Countries(Italy) and some of APAC(Taiwan, Singapore) Countries have to maintain the Transaction number in sequence. Any Jump in the transaction number may be subject to audit issue with auditors. Therefore its very important to alter the underline seeded sequence definition.

dgreybarrow Why Oracle gives some jump in number

The reason is cache value which comes with seeded sequence .

If you have "caching" enabled on the sequences. This is a feature that is meant to speed up retrieval of heavily used sequences. If the sequence isn't used for a while the cache "ages out" and those numbers that were in the cache get skipped.

Most of Oracle seeded sequence come with Default 20 values.

dgreybarrow Technical note on Oracle Sequence

Based out of Robert Vollman note in his blog. Basically there are 2 potential issues with Oracle sequences

  1. The sequence number may "jump", that is 1,2,3,5,6,8,... with number 4 and 7 missing. One reason is if you do a transaction with NEXTVAL and then rollback, the sequence doesn't roll back to where you started.
  2. By default, the sequence caches the 20 next values for faster retrieval. Thats the reason why most of seeded Oracle sequence have value 20. If there is a system failure, we will lost the cached values upon system recovery. Thus you end up with a gap of up to 20. One way to avoid this is to use NOCACHE command when creating the sequence. And of course you lose the benefit cache brings as well.

dgreybarrow Step to alter the Seeded sequence

1) Query up your invoice source , which user have reported Jump in number.

Navigate>Setup>Invoice>Source

2) Execute the following script using your source as in step 1.

  1.  
  2. SELECT batch_source_id, org_id, name FROM ra_batch_sources_all WHERE name LIKE '<source>';
  3.  

or use this query if you have access from database.

  1.  
  2. SELECT 'alter sequence AR.'||seq.sequence_name||' nocache;' FROM
  3. name bsname, org_id org,
  4. 'RA_TRX_NUMBER_'||BATCH_SOURCE_ID||'_'||org_id||'_S' seqname
  5. FROM RA_batch_sources_all) src,
  6. dba_sequences seq
  7. WHERE src.seqname=seq.sequence_name
  8. AND seq.cache_size;
  9. ORDER BY org
  10. /
  11.  
  12.  

3) Using the batch_source_id from the above query , execute the followingscript:

  1.  
  2. SELECT sequence_owner, sequence_name, cache_size
  3. FROM all_sequences
  4. WHERE sequence_name LIKE 'RA_TRX_NUMBER%1146%';
  5.  
  6.  

4) Execute the following:

  1.  
  2. ALTER sequence SEQUENCE_NAME increment BY 1 nocache;
  3.  
  4.  

Example, if your sequnce is RA_TRX_NUMBER_1146_1166_S

then script would be

  1.  
  2. ALTER sequence RA_TRX_NUMBER_1146_1166_S increment BY 1 nocache;
  3.  

dgreybarrow Few Tips

1.When you create a source and attach a sequence, Oracle will create a sequence like RA_TRX_NUMBER_<batch_id>_<org_id>_S
2. Sequence RA_TRX_NUMBER_<batch_id>_<org_id> _S as is owned by AR.

dgreybarrow How to handle those missing Number

If you have identified in early stage, and missing numbers are very less in count, than create another source with non-automatic number sequence and tell user to use those number which havn't used by Oracle earlier. Once you used all missing number than end date the source.

Posted in Oracle Receivable | 1 Comment »

R12 AR Month End Close and Reconciliation

Posted on April 1st, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

As requested by some of reader , Here are steps and checklist for R12 AR Month End Close and Reconciliation.

1. Complete All Transactions for the Period Being Closed

2. Complete and review your unapplied receipts

3. Reconcile Receipts to Bank Statement Activity for the Period

Read the rest of this entry »

Posted in Oracle Receivable, R12 | No Comments »

Page 1 of 11