Oracle Apps Techo-Functional

Monday 29 April 2013

Bill Presentment Architecture (BPA) in Oracle Receivables



Bill Presentment Architecture is a responsibility that provides a customized invoice request by customers due to government policies or tax deduction norm. Usually Customer request their vendors to develop invoices in various formats already present in Oracle Application

Bill Presentment Architecture is a responsibility that develops template based configuration of bills for online presentation and printing. In R12 to develop customized bill, it has become simple by creating new items for existing template, creating templates, and assigning the same to a particular customer
Steps to Implement / Creating the New Item Bill Presentment Architecture 

BPA Implementation
Responsibility:
Bill Presentment Super user -> Bill Management
Template management - > Content Item
Press create button


                                 Figure 1 : Bill Presentation Architecture -  Content Item
  
Define the Items fields, description, Display and also define item type whether it will be text or images (like logo, etc.)
     

                              Figure 2 : Bill Presentation Architecture -  Create Content Item

 Press apply to complete it  

 Go to Templates Menu
 Select your template and open

For Edit option, select Update icon to click   in the particular Layout Template

                                               Figure 3 : Bill Presentation Architecture -  List of Templates

Then select particular layout layer (like header, footer, body) - click the “select Content and layout”



Figure 4 : Bill Presentation Architecture -  Template Design layout
 

                                              Figure 5 : Bill Presentation Architecture -  Data Source View

Then Change user Data source view -> custom:None 


                                                 Figure 6 : Bill Presentation Architecture -  Move Data Source View

press Go button,it will be listed out all custom items created, then select your custom item and move . Then Apply

Now your custom item added success full in layout templates design
Here your template will be update is completed.
Now select Interactive
You have to query e.g
  •  Operation Unit - > Vision Operation
  •  Customer Name  -> XXXXX
  •  Select -> Go
Select online preview, to view the template design

Wednesday 24 April 2013

Barcode font with BI Publisher - Font Creation and Font Mapping in Oracle Apps



Barcode font mapping based on barcode code39 format. You can download the barcode39 below links itself



Login Oracle Instance
Change the Responsibility -> XML Publisher Administrator 

Step::1
Click Home -> under Administrator tab-> Font files ->create font file
Name of the font name is “free 3 to 9” upload the TTF (True Type Font) File


 
Step::2
Navigate to Font Mapping -> Create Font Mapping Set


  1.   Mapping name is the name you will give to a set of fonts.
  2.   Mapping code is the internal name you will give to this set.
  3.  Type: 'PDF Form' for PDF templates. 'FO to PDF' for all other template types

Step::3
Create the Font Mapping (this will allow to add multiple fonts to a set)




 
Font Family is the exact same name you see in Word under Fonts.
If you don't use the same name the font will not be picked up at run-time.
Style and weight must also match how you use the font in windows.
Normal and Normal are good defaults.

Step::4
Now you can navigate to Configuration in left corner





Navigate to Configuration General-> FO Processing
Click the FO Processing and expand
Now select font mapping set file
 



After then apply it
When you the report now it should generate the bar code and if you can print is it and scan the bar code

Friday 19 April 2013

RICE Components



RICE Components

While implementing an Oracle ERP Application system to a client, to meet the client requirements a consultant needs to make changes to original Vanilla system (Unchanged Oracle ERP Implemented system). The changes made to Original Oracle ERP come under RICE components.

Notes: In information technology, vanilla (pronounced vah-NIHL-uh) is an adjective meaning plain or basic. The unfeatured version of a product is sometimes referred to as the vanilla version.

Mostly an oracle apps technical consultant will be working on RICE components.
R--Reports
I--Interfaces
C--Conversions
E--Extensions (Forms personalization)

During an implementation, development of RICE components involves:
1. Creation of Reports that are not available as standard reports in the oracle apps modules / standard report customizations

2. Creation of the Interfaces to external systems and internal system
Interfaces are of two types
1) Inbound Interface
2) Outbound Interface
Inbound Interface: Transferring the data from the legacy system(in our case it is excel sheet) into the Oracle apps base tables.
Outbound Interface: Transferring the data from the Oracle apps base tables into the legacy system (It might be any of these SAP, People-soft etc).

3. Creation of Conversion programs to transfer data from a legacy system to the new system.(like upgrade  the 11i to R12 ) . Conversation is one time process.

4. Enhancements (or extensions) to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system. Its creating custom code from scratch, existing objects (views, packages and java classes etc) can be used. It is having different behavior from seeded one.
RICE terminology has been introduced by Oracle Corporation and later some Oracle consultants has added their own flavor and introduced some other terminologies like FRICE and RICEW.

FRICE stands for Forms, Reports, Interfaces, Conversions and Enhancements / Extensions

RICEW stands for Reports, Interfaces, Conversions, Enhancements / Extensions and Workflows

Documenting terminology for RICE components
AIM (Applications Implementation Methodology) is documenting structure introduced by Oracle Corporation which is used throughout the life cycle of a RICE component object. Process in AIM methodology includes approval to develop, functional design specification, technical design specification, coding, testing and implementation.(like as MD50,MD70,Testing Documents)

Monday 15 April 2013

CONCURRENT PROGRAM - ‘COPY TO ' Option



Copying the existing report  that  must be customized new report , by using 'Copy to ' method

Step1 :
Open the existing Concurrent program (Report name) in Application developer form
 Application Developer---> Concurrent Program
Then Query your existing concurrent program. Like 


                                                            Figure1: Open Existing Report Program

 Step2:

Click on “Copy Program button” selecting check box option “Copy Parameters”. This will help you copy    the current program definition to custom version of the program.
Also note down the name of the executable as it appears in concurrent program definition screen.


                                                           Figure2 : Concurrent Program Copy to Option


                                                             
                                                          Figure3 : Concurrent Program - Parameter

Then click ok , save it 

 Note: Note down the application within which it is registered. If the application is Oracle Purchase, then you must go to the database server and get hold the file named XXXX.rdf in $PO_TOP/reports/US.