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

Review :Oracle E-Business Suite 12 Financials Cookbook

Posted on October 11th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

I was recently asked by Packt Publishing to review Yemi Onigbode's "Oracle E-Business Suite 12 Financials Cookbook”. I just finished few Chapters reading the book, and wanted to share some thoughts.

oracle-e-business-suite-12-1-financials-cookbook-yemi-onigbodeThis is a good resource for EBS users and Financial consultant. The format of a “recipe book” is a wonderful idea, and is perfect for folks who are looking to become effective with EBS skill very quickly, looking for a point solution to an immediate problem, or just needing some creative inspiration when working on their user support or identifying key functionalities of the Oracle modules, to demonstrate a pilot to obtain the core requirements

The book’s 9 main chapters successfully provide more than 50 recipes to demonstrate the EBS R12 Financials core modules and their functionality. This book will give readers a step-by-step tour of the EBS R12 Financials core modules. The receivables process from billing to collection, including revenue accounting will be shown along with how to handle cash, create bank accounts, reconcile bank accounts, and create cash forecasts. Readers will not only learn how to create customers and manage sales orders, including shipping, pricing, and creating invoices, but also administer the general ledger, accounting setup, sub-ledger accounting, e-business tax, and create journals.

The authors have done a good job in selecting their recipes to cover common use cases most of support staff/consultant will face. This allows readers with a specific issue to skim through the Table of Contents for a relevant recipe and then work through the provided example.

Oracle E-Business Suite 12 Financials Cookbook is a good resource for a wide range of users specially for support staff who is working from end user side. This book is for EBS Financials specialists who want a broader understanding of particular areas of the financials modules.

You can read more about here: http://www.packtpub.com/oracle-ebusiness-suite-12-financials-cookbook/book

Posted in Beginner, Misc | No Comments »

Review :Oracle E-Business Suite R12 Supply Chain Management

Posted on February 19th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Recently I got a chance to go through the book 'Oracle E-Business Suite R12 Supply Chain Management' - Packt Publishing. I found this book to SCM Book R12be very informative. This is a must read for beginners as well as seasoned shop floor personnel who turn themselves to know how Oracle SCM product works. For the beginners, in particular, the book offers basic understanding through some examples such as that of Sarmixa telecom. Such discussion would certainly come handy for the beginners. The book is not a bulky one which is one of its USPs and major thrust is on SCM providing insights supplemented by business case with implementaion of EBS for Sarmixa Telecom. All in all, an interesting read.

Topics covered in the books:

Chapter 1: Getting Started with Oracle Supply Chain Management
Chapter 2: Getting Started with Oracle E-Business Suite
Chapter 3: Oracle Advanced Supply Chain Planning
Chapter 4: Overview of Oracle Order Management
Chapter 5: Overview of Oracle Purchasing
Chapter 6: Overview of Oracle Landed Cost Management
Chapter 7: Overview of Oracle Inventory Management
Chapter 8: Overview of Oracle Cost Management
Chapter 9: Overview of Oracle Advanced Pricing

Meanwhile you guys can have a look at one of the sample chapter on following link, more updates once i finish reading.

Posted in Beginner, Misc | No Comments »

Know a bit on Campaign-to-Cash

Posted on May 15th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Campaign to cash refers the ability track from the initial touch point with the prospect to the completed deal. At an aggregate level, it lets you track which campaigns, targets, messages or other dimensions are creating the most revenue and allows you to focus your marketing spend on the items that perform the best

Campaign-to-Cash(C2C) process, which includes all the activities involved in promoting and selling your products and services. This spans building and running lead and demand generation campaigns, qualifying leads, running the sales cycle and closing deals. This also includes sales, marketing and executive management efforts to understand, forecast, analyze and optimize performance.If you are trying to understand this in system prospective, C2C flow ,this can be further categorize into roughly 12 sub-process like:

  1. Go to Market Strategy & Managment (Go-to-market refers to plans made to launch a new product, that consist of start-up activities for getting the product out in the marketplace and includes pricing strategies, customer penetration plans, PR, sales training, beta site testing, and so forth )
  2. Marketing Execution
  3. Channel / Retail & Direct Sales Mgmt
  4. Guided Selling,Pricing, Proposals & Contracts / Agreements
  5. Customer Data Mgmt
  6. Order Capture
  7. Order Management
  8. Fulfillment Confirmation & Expediting
  9. Billing & Receivables Mgmt
  10. Channel Mgmt & Claims Settlement
  11. Sales Compensation Payout
  12. Performance Analysis

Implementing will add these Key Benefits to Business

  • Improved operational efficiency and customer responsiveness
  • Reduced working capital
  • Reduced lead times to customers
  • Automated promotion and sales comp settlement

dgreybarrow Campaign to Cash Flow in EBS

Typical Campaign to Cash Flow in EBS is consider to similar to fig 1 as below.

C2C

  • Oracle Marketing creates and executes campaigns, assigns call guides from Oracle Scripting, and targets the execution of the campaigns across all channels: call centers, web, and direct. These campaigns are executed using various different applications in the Oracle E-Business Suite.
  • Leads are generated based upon customer interaction and routed based on territories.
  • Sales people can access these Leads directly in Oracle Sales.
  • Leads are then qualified and ranked.
  • Leads can also be generated through sales campaigns created in Oracle Sales. By constructing natural language queries, Sales Managers can mine the installed base, identifying the most appropriate target customers for cross-sell and up-sell sales campaigns. Qualified leads are converted into opportunities, and budgetary and sales information updated.
  • Quotes are created directly from opportunities using Oracle Quoting.
  • From Oracle Quoting, salespeople can either publish quotes to Oracle iStore online stores for customer review or book orders directly, triggering back-end applications for shipping, inventory management, and payment.
  • When the quote is published, customers can enter the store, view its details, modify payment information, and place orders.
  • Throughout the sales process, Oracle Sales maintains campaign information tied to the sale and links this information back to Oracle Marketing for ROI analysis.

If you are able to do a mapping, with complete platform based our Oracle EBS, majority of them are fit with existing EBS module.Depending upon your business complexity and process , you can easily integrate with other application like Salesforce.com ,Demantra ,APS/ASCP,OTM depending upon how complex your company/client business have. Figure 2 gives you snapshots of the EBS product fitment.

C2CASH

Some of key application Potentially been qualified if any one is planning to implement C2C on Oracle Platform.

  • Oracle iStore provides you similar to e-commerce application that gives organizations the components necessary to create powerful internet store sites for selling products and services in a secure and personalized environment. This includes product catalog and pricing maintenance, web carts and shopping lists, and integrated media management utilities.
  • Oracle Advanced Pricing This supports sophisticated pricing rules, such as freight charges, pricing formulas and discounts based on many variables such as customer, product, purchase history, and shopping-cart contents.
  • Oracle Configurator guides the sales process through customer-driven configuration of complex or personalized products.
  • Oracle Order Management streamlines and automates the entire sales order management process, from order promising and order capture to transportation, shipment, and returns.
  • Oracle iPayments This processes payments or may be with online credit card authorization.
  • Oracle Incentive Compensation manages performance-related compensation (such as commissions and bonuses) for employees and business partners.
  • Oracle Financials This including Oracle Enterprise Planning and Budgeting, Oracle General Ledger, Oracle Cash Management, Oracle Receivables, and Oracle Payables.
  • Oracle Human Resources is a family of applications that automates the entire recruit-to-retire process (including Oracle Payroll), so you can align your workforce with strategic objectives.
  • Oracle Partner Relationship Management provides partner registration, program enrollment, and partner-specific functionality based on partner access rights.
  • Oracle Marketing enables an organization to manage marketing campaigns, budgets, and segments across all channels. This includes the ability to manage promotional collateral and discounts and maintain the product catalog, with seamless integration to Oracle iStore.
  • Oracle Sales, Oracle Quoting, and Oracle Proposals provide a full sales force automation solution for face-to-face salespeople, including the ability to create quotes that are published to the customer as shopping carts on their personal iStore pages.
  • Oracle Telesales empowers call-center agents to conduct outbound sales and marketing activities, including the ability to view and update all shopping carts created by customers using Oracle iStore.
  • Oracle Teleservice and Oracle iSupport enable an organization to provide excellent customer service, both in the call center and via self-service over the Web. This includes service request management, knowledgebase and online forums.

Hope this helps.

Posted in Beginner | No Comments »

Understanding of different Manufacturing Methods

Posted on July 19th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Manufacturing environments can be classifed as discrete, repetitive, or process, or combinations this post will give more insights on different methods.

dgreybarrow Project Manufacturing

Project manufacturing is used to meet demand driven production requirements for large contracts or projects.

Project manufacturing allows you to plan, schedule, process, and cost against a specific contract or a group of contracts for a specific customer.

Also it is possible to make task references to planned orders, jobs (part of Discrete Manufacturing), purchase orders, sales orders, miscellaneous transaction and other entities within Oracle Manufacturing.

dgreybarrow Discrete Manufacturing

Discrete manufacturing is used for assemblies that you make in groups or batches.

It involves defining jobs with a job name, a job type, assembly, a job quantity, a start date, and an end date and use assembly bills of material to create job material requirements and routings to schedule job production activities and create operation specific material and resource requirements.

Discrete manufacturing is the most common production method for the application of flow manufacturing. Shippable end items are usually measured in individual units or "each". The production quantities produced in manufacturing can vary from one to large order quantities. In contrast to process intensive factories, discrete manufacturing usually requires more people than machines.

dgreybarrow Flow Manufacturing

Flow Manufacturing is an innovative manufacturing approach that aligns production with customer demand.

Flow manufacturing employs Just-In-Time (JIT) concepts such as manufacturing to demand (vs. forecast),

  • Production lines for families of products
  • Pull material using kanbans
  • Consume automatically material and costs upon completion

These in turn helps decrease inventories, optimize machine utilization, reduce response time to customer needs, and simplify shop floor activities. The most important part is to design production lines and production processes so that each line can produce a constantly changing mix of products within a family at a steady rate.

In flow manufacturing a product progresses through its manufacturing processes without stopping, like water in a river, hence the term "flow.

The goal of the flow manufacturer is to design and create a manufacturing line capable of building different products, one at a time, using only the amount of time required to actually complete the work.

Wait time, queue time, and other delays are largely eliminated in flow manufacturing.

dgreybarrowProcess Manufacturing

Process Manufacturing automates the entire product lifecycle for recipe-based manufacturing, from new product development, recipe management and production, to cost, quality, and regulatory management. It enables you to formulate products to individual customer specifications, manage variability, optimize capacity, and drive continuous process improvement.

Continuous manufacturing is another name of "process" manufacturing.

dgreybarrow Assemble-to-Order(ATO) Manufacturing

This is where available options for unique product configurations. You can master schedule models and options then create work orders to build these unique configuration.

dgreybarrow Repetitive Manufacturing

You use repetitive manufacturing for assemblies you make on a continuous or semi continuous basis over a predefined interval.

You identify which assemblies are built on which production lines in advance. You can build assemblies on dedicated lines (one assembly per line) or on mixed model lines (many assemblies per line). You can build an assembly on multiple lines.

You define repetitive schedules by the assembly, its daily quantity and its production lines, no job or work order exists. You can schedule production of a single assembly continuously for just a few hours or for any number of days.

You can schedule repetitive production based on the fixed lead time of your production line if the lead time does not vary from one assembly to another assembly. If the lead time varies by assembly, you can schedule the repetitive production time based on the routing of the assembly the line is building.

In repetitive manufacturing, you charge the cost of production directly to the assembly and line. You analyze and report costs by assembly and line during the period close. At period close, all charges to a repetitive assembly for that period are totalled and divided by the number of assemblies produced during that period. Period close also calculates assembly costs and usage variances.

Oracle Applications supports discrete, project, repetitive, assemble-to-order, and flow (work order-less) manufacturing methods

Posted in Beginner, Oracle Manufacturing | No Comments »

Beginners’ Books for Oracle e-Business Suite

Posted on April 29th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Long time back , I got a complementary copy of EBS books from author Roel Hogendoorn.

These six books, roughly have 175-200 pages each, covering some of key areas of EBS.

  • System Administration
  • Workflow
  • Flexfields
  • Alert
  • Reporting in E-Business Suite
  • BI Publisher

books

I am so delighted with the content in these BOOK that I thought to share to rest of community people.

"...Extremely well written book, enjoyable and informative reading!"

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

The webshop for the books is: http://stores.lulu.com/learnworks

Posted in Beginner, Misc | No Comments »

Flow ,Discrete & Process manufacturing in ERP ?

Posted on November 10th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is a very basic question for ERP consultants , what is basic difference into two manufacturing operation : discrete manufacturing and process manufacturing . Lets redefined and understand in simple words:

As we know, in ERP prospective manufacturing operation can be broadly classified into two major category:

  • Flow manufacturing
  • Discrete manufacturing
  • Process manufacturing

arrow upDiscrete Manufacturing

discrateDiscrete manufacturing is distinguished by the production of distinct items that use bills of material and routings to determine costs and lead times.

Examples: Automobile manufacturing, computer manufacturing, dishwasher and washing machine manufacturing, etc .

Typically they follows either a Product, Process or a Combination Layout these layouts can be understood like:

  • Product Layout - Processes come to the product . typical example are Ship Building, Car Assembly Line, PC's, etc.
  • Process Layout - Products go to Process areas Typical Example are Cabinets and Casings, Sub-assemblies, Rubber Mixing, etc.

Is normally a Product that is "Built Up" from components or sub-assemblies.

A note with Oracle Product
Discrete manufacturing is Oracle Applications method to handle the unique problems in manufacturing equipment, like electronics, medical devices or a complicated assembly like the space shuttle as indicated above.

Discrete manufacturing is based on piece parts that are assembled or machined to make larger assemblies.

Oracle Discrete Manufacturing has a great deal of functionality to manage the Bills of Materials, Routings and Engineering changes that are required to adequately track assembly and cost the finished product.

arrow upFlow Manufacturing
Flow manufacturing is also called Lean Manufacturing or JIT(Just-In-Time) and uses the principles of demand flow manufacturing to produce product is required, for customer orders, quickly and to meet the demand exactly on-time.

Usually, in order to use Flow a company needs to have production facilities that subscribe to the principals of Lean Manufacturing. It is necessary to design production facilities so that production lines, resources, machines, and labor are making only what is needed for immediate customer orders.

arrow up

Process Manufacturing

discrate2Process manufacturing is distinguished by a production approach that has minimal interruptions in actual processing in any one production run, or between production runs of similar products. This approach produces multiple unique products in relatively small batches flowing through different production operations throughout the factory.

They typically follows a Process Layout.

They are normally producing a Product that is "Homogeneous" and equally divided for the convenience of packaging.

Typical examples are Food, pharmaceutical and other batched-based manufacturers such as refineries, wineries, etc .

A Note with Oracle Process Manufacturing
The OPM capabilities allow for multiple units of measure because the flexibility in batch production is required in process industries.

Process manufacturing is used at companies that make products that use formulas, receipts and/or have co-products or by products. Typical users of OPM are manufactures of food products or chemicals that have complex internal processes and need a high level of control.

The OPM capabilities allow for multiple units of measure because the flexibility in batch production is required in process industries.

greWhat makes process manufacturing different from discrete?

Process manufacturing uses formulations or recipes. A discrete manufacturer uses Bills of Materials (BOMs). A discrete manufacturer assembles along a routing, whereas a process manufacturer blends in a batch.Apart from these other difference with other factors are summurized as:

difference

bluWhich come under which category ?

industries

 

 

 

Posted in Beginner, Oracle Manufacturing | 15 Comments »

Quick note for Supplier in EBS

Posted on September 9th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In Oracle supplier can be entered from three different place.These are the Setup required to perform for a suppliers.

  • Supplier Accounts
  • Taxes
  • Payments
  • Term Date Basis
  • Due Date Basis
  • Invoice Currency
  • Holds

In Oracle these are the important features through the screen:

  • Enter Suppliers
  • Enter employees as Suppliers
  • Merge duplicate Suppliers

redArrow Supplier Data Entry

vendors

redArrow Other Details

  • Classification Information (Significant for type and employee name)
  • Parent subsidiary relationship
  • Supplier bank information
  • Appropriate GL accounts information
  • Record tax information
  • Hold conditions to supplier site (rather than on individual invoices)

and these are the optional field

  • Tax payer ID
  • VAT registration number
  • Inactive date (to prevent invoice/PO entry after a certain date)

redArrow Important Table that holds supplier

  • PO_VENDORS : this hold a suppliers information

Some important columns:

    • SEGMENT1 – SYSTEM GENERATED OR MANUALLY ENTERED NUMBER FOR SUPPLIER (PO_UNIQUE_IDENTIFIER_CONTROL)
    • VENDOR_ID – SYSTEM GENERATED UNIQUE NUMBER
    • CREDIT STATUS –GOOD/POOR
    • ORGANIZATION_TYPE_LOOKUP_CODE
    • VENDOR_TYPE_LOOKUP_CODE – VENDOR/EMPLOYEE (EMPLOYEE_ID)
    • ONE_TIME_FLAG
  • PO_VENDOR_SITES_ALL : This hold corresponding site information Contains Details of the site like Full Address/Work of site
    and its link with vendor_id.Important columns includes:

    • PURCHASING_SITE_FLAG, VENDOR_SITE_CODE, RFQ_ONLY_SITE_FLAG, PAY_SITE_FLAG,HOLD_ALL_PAYMENTS_FLAG, HOLD_FUTURE_PAYMENTS_FLAG, HOLD_UNMATCHED_INVOICES_FLAG
  • PO_VENDOR_CONTACTS : This hold supplier contact information for respective sites.

redArrow How they connected

These are typically connected as:

vendorER

Take a note Segment1 is holding suppliers Number.

redArrow

Quick query for new babies

select * from po_vendors
where segment1 = '1001‘;

select *
from po_vendor_sites pvs,
po_vendors pov
where pov.segment1 = '1001'
and pov.vendor_id = pvs.vendor_id;

select *
from po_vendor_contacts pvc,
po_vendor_sites pvs,
po_vendors pov
where pov.segment1 = '1001'
and pov.vendor_id = pvs.vendor_id
and pvs.VENDOR_SITE_ID = pvc.vendor_site_id;

redArrow Supplier Interface

Yes, that was one of the enhancement in oracle 11.5.10 release. Prior to that version, there was no interface or Public exist for supplliers, thus it was a tricky to handle supplier. As we have already seen AP availability of AP some time back.

If you are having 11.5.10+ version,and if you have requirement to create supplier from your legacy data than use Supplier Interface, life will be easier. Is n't.

How we start

This consist in 2 steps process:

Step 1. Populate the new interface tables with data. This can be done via SQL*Loader or typically used to load data in a table.

  • AP_SUPPLIERS_INT
  • AP_SUPPLIER_SITES_INT
  • AP_SUP_SITE_CONTACT_INT

Step 2. Run the Supplier Open Interface Request Set (FNDRSSUB1703)

Alternatively, run the individual import programs to load one table at a time

  • Supplier Open Interface Import (APXSUIMP)
  • Supplier Sites Open Interface Import (APXSSIMP)
  • Supplier Site Contacts Open Interface Import (APXSCIMP)

Some important notes for suppliers Interface

  • When you load the data it should be 'NEW' initially. After the Supplier Sites Open Interface is run the status gets changed to PROCESSED'/'REJECTED'.

The entire flow can be shown as:

supplierIntrerafce

redArrow A Note with R12 for Suppliers

As we know in R12 Supplier is part of TCA , thus the link between PO_VENDORS and HZ_PARTIES is PO_VENDORS.party_id. The link between
PO_VENDOR_SITES_ALL and HZ_PARTY_SITES is PO_VENDOR_SITES_ALL.party_site_id.

When a Supplier is created Record will be Inserted in HZ_PARTIES. When the Supplier Site is created Record will be Inserted in HZ_PARTY_SITES. When Address is created it will be stored in HZ_LOCATIONS.

Posted in Beginner, Oracle Payable | 9 Comments »

How to use Descriptive Flex Fields (DFF) in forms

Posted on August 24th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Implementing DFF in Form consist of two steps Process. The first steps consist of designing the table structure and registration and step 2 consist of enabling in the form.

Steps 1:

  • Define DFF fields in the custom tables

ATTRIBUTE1…ATTRIBUTE15 and ATTRIBUTE_CATEGORY are the normal fields used for DFF

  • Register the table with Oracle AOL
  • Register the DFF with Oracle AOL

For this you have to login into application with :

Application Developer -> Flex Field -> Descriptive -> Register

Then you should specify the name of the DFF (Say BTL_AR_DFF) and specify the associated table.

Step 2:

  • Create DFF fields in the custom form

1. Create a form based on the custom table

  • Copy TEMPLATE form has example descriptive flexfield which we can use
  • Use the TEXT_ITEM_DESC_FLEX property class
  • Attach ENABLE_LIST_LAMP_LOV for the field

2. Create a non-base table text item in the block with property class TEXT_ITEM_DESC_FLEX
3. Make sure that DFF is mapped to fields (ATTRIBUTE) of the table and is enabled.

  • Next is to call Flexfield Routines to add DFF built-ins in the form to invoke DFF.
    • This consist of these steps:

1. Write, a form level trigger WHEN-NEW-FORM-INSTANCE to invoke the DFF as

FND_DESCR_FLEX.DEFINE(
Block => 'Name of the DFF block',
Field => 'BTL_DFF',
Appl_short_name => 'AR',
Desc_flex_name => 'BTL_AR_DFF',
Title => 'BPL AR More Info' );

2. Write, block level triggers PRE-QUERY and POST-QUERY as

  • FND_FLEX.EVENT('PRE-QUERY');
  • FND_FLEX.EVENT('POST-QUERY');
  • FND_FLEX.EVENT('Pre-Query');
  • FND_FLEX.EVENT('When-Validate-Record');
  • FND_FLEX.EVENT('Post-Query');
  • FND_FLEX.EVENT('When-New-Item-Instance');
  • FND_FLEX.EVENT('Pre-Insert');
  • FND_FLEX.EVENT('When-Validate-Item');
  • FND_FLEX.EVENT('Pre-Update ');

Posted in AOL, Beginner | 4 Comments »

How to use Key Flex Fields (KFF) in forms

Posted on August 23rd, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

These are the steps required to implement KFF in customization.

  • Define KFF fields in your database tables.

The custom table should contain a field named as XXX_ID (where XXX means the entity. For ex. PART_ID, CODE_COMBINATION_ID etc) to capture the selected code combination ID.

  • Register the table with Oracle AOL.
  • Register the KFF with Oracle AOL

Logon as

Application Developer -> Flex fields -> Key -> Register
Existing KFF can also be used. Ex. Accounting FF

  • Create KFF in the custom form

1. Create a form based on the custom table.

2. In the block, create two non-base table text items of data type CHAR (2000). One text item is to store the code combinations (Say BTL_KFF ) and other one is to store description of the code (Say BTL_KFF_DESC. Make this item as non-updateable).

  • Add KFF standard built-ins in the form to invoke KFF

    The custom table should contain a field named as XXX_ID (where XXX means the entity. For ex. PART_ID, CODE_COMBINATION_ID etc) to capture the selected code combination ID.

this is typical registration of KFF. For Customization in custom development here are the steps:

1. Write a form level trigger WHEN-NEW-FORM-INSTANCE to invoke the KFF as

Fnd_Key_Flex.Define(
Block => ‘block_name’,
Field => ‘concatenated_segments_field_name’,
[Description => ‘description_field_name’,]
[ID => ‘Unique_ID_field’
Appl_Short_Name => ‘application_short_name’,
Code => ‘key_flexfield_code’,
Num => ‘structure_number’,

In above defination take a note,

  • These arguments specify location
  • All fields must reside in same block
  • ID is for Key Flexfields only
  • These arguments indicate which flexfield is being used
  • Short name is application where flexfield is registered
  • SQLGL is Oracle General Ledger
  • SQLAP is Oracle Payables
  • Code identifies Key Flexfield
  • GL# is Accounting Flexfield
  • Num is Key Flexfield structure number. Default is 101

Usage

FND_KEY_FLEX.DEFINE(
block => 'Custom block',
Field => 'BTL_KFF',
Description => 'BTL_KFF_DESC',
ID => 'XXX_ID',
Appl_short_name => 'SQLGL',
Code => 'GL#',
Num => '101',
Vrule => 'GL_GLOBAL\nDETAIL_POSTING_ALLOWED \nE\nAPPL=''SQLGL'';
name=Parent Values are not allowed\nN'
);

2. XXX_ID will store the code combination ID for each selection.

3.Invoke Flexfield functionality by calling FND_Flex.Event(event) from:

  • PRE-QUERY
  • POST-QUERY
  • PRE-INSERT
  • PRE-UPDATE
  • WHEN-VALIDATE-RECORD
  • WHEN-NEW-ITEM-INSTANCE
  • WHEN-VALIDATE-ITEM


3. Write an item level trigger WHEN-NEW-ITEM-INSTANCE on BTL_KFF as

FND_FLEX.EVENT('WHEN-NEW-ITEM-INSTANCE')

4. Write an item level trigger KEY-EDIT on BTL_KFF as

FND_FLEX.EVENT('KEY-EDIT');

5. Write an item level trigger WHEN-VALIDATE-ITEM on BTL_KFF as

FND_FLEX.EVENT('WHEN-VALIDATE-ITEM');

IF :CUSTOM_BLOCK.XXX_ID = -1 THEN
FND_MESSAGE.SET_STRING('You Have Selected An Undefined Code Combination !');
FND_MESSAGE.SHOW;
RAISE FORM_TRIGGER_FAILURE;
END IF;

These steps makes you flexfield enable in your form.

A NOTE FOR FLEX FIELD DEFINATION

Lets take a close scan to understand some of the paramater used in Flex Field defination.

1. [Validate=> ‘{FOR_INSERT|FULL|PARTIAL|NONE|PARTIAL_IF_POSSIBLE}’,]

  • This is used only for Key FlexFields only
  • “For_Insert” used in a block where the code_combinations table is the base table
  • “Full” used where the code_combination_id is a foreign key in the base table
  • “None” when any value is allowed, such a range flexfield for query purposes
  • “Partial” validates segment values but not the full combination
  • “Partial_If_Possible” only used when the flexfield has dependent segments

2.[Vdate => ‘date’,]

  • Validation date compared to segment value start/end dates

3.[Required=>’[Y|N’,]

  • This is applicable only in the case for key flexfields only
  • ‘Y’ requires user to enter a valid value for every required segment, even if the flexfield is never navigated to
  • ‘N’ only requires required segments to be entered when the flexfield has been updated

4.[Displayable => ‘{ALL | flexfield_qualifier | segment_number} [\0{ALL|flexfield_qualifier|segment_number}]’,]

  • Key Flexfields only. Default is “ALL”
  • Naming flexfield qualifier or segment number causes only those segments to appear.
  • Toggle this parameter by specifying more than one value separated with \0
  • Display all but the first segment by specifying:
  • DISPLAYABLE=>’ALL\01’
  • Same parameters for Updateable and Insertable

5.[COPY=>’block.field\n{ALL|flexfield qualifier|segment number} [\0block.field\n{ALL|flexfield qualifier|segment number}]’,]

  • Again, key flexfields only.
  • Copy a form field value into the segment indicated by flexfield qualifier or segment number
  • Value must be valid for segment or it will be erased
  • Copy works in reverse when flexfield pop-up window closes
  • Example copies a form global variable into the natural account segment of the Accounting Flexfield:
  • COPY=>’GLOBAL.default_expense_obj\nGL_ACCOUNT’

6.[VRULE => ‘flexfield qualifier\n
segment qualifier\n
{I[nclude] | E[xclude]}\n
APPL=application_short_name;
NAME=Message Dictionary message name\n
Validation value1\n
Validation value2…
[\0flexfield qualifier\n
…

  • Key or range flexfields
  • Impose additional validation
  • ‘\n’ is delimiter between parameters
  • ‘\0’ is delimiter between groups of parameters

Posted in AOL, Beginner | 2 Comments »

AOL – Descriptive Flex Field ( Deep Drive)

Posted on August 22nd, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

As we have seen DFF provide customizable expansion space in the form to capture additional information, which are not provided at present. A DFF describes an application entity, providing form and database expansion space that can be customized.

Why Descriptive Flex fields

  • Customers require more data to be stored than what Oracle provides
  • Oracle gave us additional “space” in most tables to store this data
  • Descriptive Flexfields will survive an upgrade

Global vs Context Sensitive

  • Global Data Elements mean the question will be asked for every occurrence of the Descriptive Flexfield.
  • Context Sensitive Elements are questions asked “depending” on the answer to some other question. This “other” question can use a Reference field from above for its answer.

How Segments Use Underlying Columns

  • A DFF uses columns that are added onto a database table. The table contains any columns that its entity requires.
    The DFF columns provide ‘blank’ columns that you can use to store information which is not already stored in another column of that table.
  • A DFF requires one column for each possible segment and one additional column in which to store structure information(i.e. The context value).
  • You can define as many segments in a single structures as you have DFF columns in your table.
    The DFF columns are usually named as ATTRIBUTEn, where n is a number.
    dff

Implementing Descriptive Flexfileds
For implementing DFF it requires five steps:

  • Define DFF columns in your Database table
  • Register your table with AOL/ Pl/SQL scripts
  • Register Your DFF with Oracle AOL
  • Create Your DFF in Your Form
  • Add DFF routines to Your Form

Drawbacks of DFF

  1. Disk space is wasted.
  2. DFF has limited segment for global as well as context-sensitive attribute.
  3. No query possible on DFF segment values.

Posted in AOL, Beginner | No Comments »

Page 1 of 212

« Previous Entries