Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
- Ebooks
- Hardware
- Other
- Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots
E-book details
Log in, If you're interested in the contents of the item.
Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots
Ebook
Oracle's suite of applications is used by many major businesses and public sector organizations throughout the world. The book will show you how to build different types of extensions with different toolsets with Oracle E-Business Suite R12. It will take you from start to finish with fully working examples. This book will show you how to extend Oracle E-Business Suite Release 12. You will learn highly desirable skills on how to extend the application and develop your expertise. The book will provide detailed information about why things have to be done in certain ways, and will take you through the process of how to get started, what tools are needed, how to develop working examples, and how to deploy them within the application. Learn how to extend Oracle E-Business Suite (EBS) Release 12. There are detailed examples to work through, such as how various components are configured and how we can extend standard functionality. The book focuses on core development and extension and each chapter will introduce a topic before going through working examples from start to finish. There are plenty of detailed screen shots throughout each chapter giving clear instructions of what we are doing and why. Each recipe will develop a solution that will utilize core components to that topic. The Oracle E-Business Suite R12 Core Development and Extension Cookbook focuses on starting an extension right from the beginning, to deploying it within E-Business Suite. At the end of each chapter the reader will have a good understanding of what they need to do for each area to take away, and start using it in practice. Each chapter will detail how to build an extension in the supported manner and also comes with complete fully tested code, and scripts that can be downloaded.
- Oracle E-Business Suite R12 Core Development and Extension Cookbook
- Table of Contents
- Oracle E-Business Suite R12 Core Development and Extension Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers, and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers, and more
- Preface
- Extending Oracle E-Business Suite
- Understanding the EBS architecture
- Before we start
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- Extending Oracle E-Business Suite
- 1. Creating Concurrent Programs
- Introduction
- Defining a concurrent program
- Introducing concurrent programs
- Types of concurrent programs
- Executable file location
- Output and log files
- Register a custom application
- How to do it...
- How it works
- Configure an executable
- Getting ready
- How to do it...
- How it works...
- Configure a concurrent program
- How to do it...
- How it works...
- Introducing concurrent programs
- Making a concurrent program available to a user
- Configure a menu
- How to do it...
- How it works...
- Theres more...
- Viewing a menu structure
- Create a new request group
- How to do it...
- How it works...
- Create a new responsibility
- How to do it...
- How it works...
- Assign the responsibility to a user
- How to do it...
- How it works...
- Run the concurrent program
- How to do it...
- How it works...
- View the request
- How to do it...
- How it works...
- See also...
- Configure a menu
- Adding a concurrent program parameter
- Adding a parameter to the concurrent program
- How to do it...
- How it works...
- Amend the XXHREEBS package to add the new parameter
- Getting ready
- How to do it...
- How it works...
- Amend the XXHREEBS package to change the completion status of the concurrent program
- Getting ready
- How to do it...
- How it works...
- Testing the concurrent program
- How to do it...
- How it works...
- There's more...
- Adding a parameter to the concurrent program
- Creating a value set
- Create a value set
- How to do it...
- How it works...
- There's more...
- What happens to the data entered?
- Create a new parameter for the concurrent program
- How to do it...
- How it works...
- Modify the executable to accept the new parameter
- How to do it...
- How it works...
- Run the concurrent program
- How to do it...
- How it works...
- Create a value set
- Creating dependent parameters
- Create a dependent value set
- How to do it...
- How it works...
- Create a new parameter for the concurrent program
- How to do it...
- How it works...
- Modify the executable to accept the new parameter
- How to do it...
- How it works...
- Run the concurrent program
- How to do it...
- How it works...
- Create a dependent value set
- Adding messages to the concurrent program log file
- Create a profile option to turn logging on or off
- How to do it...
- How it works...
- There's more...
- Set the profile option value
- How to do it...
- How it works...
- Add a procedure to write to the log file
- How to do it...
- How it works...
- Writing to the log file
- How to do it...
- How it works...
- Run the concurrent program
- How to do it...
- How it works...
- Viewing the log file
- How to do it...
- How it works...
- Create a profile option to turn logging on or off
- Reporting to the concurrent program output file
- Add a procedure to write to the output file
- How to do it...
- How it works...
- Add a cursor to get some data
- How to do it...
- How it works...
- Add code to fetch data and write to the output file
- How to do it...
- How it works...
- Running the concurrent program
- How to do it...
- How it works...
- View the concurrent program output file
- How to do it...
- How it works...
- Add a procedure to write to the output file
- Scheduling a concurrent program
- Add default values for any required parameters
- Getting ready
- How to do it...
- How it works...
- Schedule the concurrent program
- How to do it...
- How it works...
- Add default values for any required parameters
- Creating multiple concurrent programs
- Copy an existing concurrent program
- How to do it...
- How it works...
- Add a concurrent program to a request set
- How to do it...
- How it works...
- Copy an existing concurrent program
- Creating request sets
- Run request set wizard
- How to do it...
- How it works...
- Add a request set to a request group
- How to do it...
- How it works...
- Run the request set
- How to do it...
- How it works...
- Run request set wizard
- Installing the database objects
- How to do it...
- How it works...
- Creating a HOST concurrent program
- Creating a PL/SQL executable
- How to do it...
- How it works...
- Configuring a concurrent program to call the PL/SQL executable
- How to do it...
- How it works...
- Creating a HOST executable
- How to do it...
- How it works...
- Configuring a concurrent program to call the HOST executable
- How to do it...
- How it works...
- Adding concurrent programs to a request group
- How to do it...
- How it works...
- Creating an OUT directory
- How to do it...
- How it works...
- Creating a symbolic link
- How to do it...
- How it works...
- Testing a host concurrent program
- Getting started...
- How to do it...
- How it works...
- Creating a PL/SQL executable
- 2. Oracle Forms
- Introduction
- Using forms builder for E-Business Suite
- Creating a custom schema
- Installing the database objects
- How to do it...
- How it works...
- Getting started with forms
- Installing Oracle Developer Suite
- How to do it...
- How it works...
- Creating the forms builder desktop shortcut
- How to do it...
- How it works...
- Adding a TNS names entry
- How to do it...
- How it works...
- Setting runtime parameters in the environment file
- How to do it...
- How it works...
- FTP forms and libraries
- Getting ready
- Forms (FMB files)
- Libraries (PLL files)
- How to do it...
- How it works...
- Getting ready
- Opening the TEMPLATE form
- How to do it...
- How it works...
- Renaming the TEMPLATE form
- How to do it...
- How it works...
- Installing Oracle Developer Suite
- Creating a master block and container objects
- Creating a block using the block wizard
- How to do it...
- How it works...
- Setting the block properties
- How to do it...
- How it works...
- Setting the item properties
- How to do it...
- How it works...
- Setting the canvas properties
- How to do it...
- How it works...
- Setting the window properties
- How to do it...
- How it works...
- Setting the module properties
- How to do it...
- How it works...
- Creating a dummy item
- How to do it...
- How it works...
- Removing unwanted objects
- How to do it...
- How it works...
- Renaming prompts
- How to do it...
- How it works...
- Resizing the viewport
- How to do it...
- How it works...
- Creating a block using the block wizard
- Modifying the template code
- Modifying the PRE-FORM trigger
- How to do it...
- How it works...
- Modifying the WHEN-NEW-FORM-INSTANCE trigger
- How to do it...
- How it works...
- Modifying the APP_CUSTOM procedure
- How to do it...
- How it works...
- Modifying the PRE-FORM trigger
- Adding a detail block to a form
- Creating a lookup
- How to do it...
- How it works...
- Creating a detail block
- How to do it...
- How it works...
- Setting the block properties
- How to do it...
- How it works...
- Setting the item properties
- How to do it...
- How it works...
- Creating a relationship between the master and detail blocks
- How to do it...
- How it works...
- Adding a record indicator to the block
- How to do it...
- How it works...
- Creating a lookup
- Adding insert, update, and delete events
- Creating a program unit package specification
- How to do it...
- How it works...
- Creating a program unit package body
- How to do it...
- How it works...
- Creating ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK triggers
- How to do it...
- How it works...
- Creating PRE-INSERT and PRE-UPDATE triggers to set the WHO columns
- How to do it...
- How it works...
- Creating a program unit package specification
- Deploying forms
- Registering a form
- How to do it...
- How it works...
- Creating a function that calls a form
- How to do it...
- How it works...
- Adding a form to a menu
- How to do it...
- How it works...
- FTP the form to the application tier
- How to do it...
- How it works...
- Compiling a form
- How to do it...
- How it works...
- Testing a form
- How to do it...
- How it works...
- Registering a form
- Adding buttons, list, and checkbox items
- Adding OK and Cancel buttons
- How to do it...
- How it works...
- Modifying the layout
- How to do it...
- How it works...
- Adding triggers to the buttons
- How to do it...
- How it works...
- Creating an LOV for the society name field
- How to do it...
- How it works...
- Configuring the date fields
- How to do it...
- How it works...
- Creating a list item
- How to do it...
- How it works...
- Creating a checkbox item
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Adding OK and Cancel buttons
- Adding a query screen to a form
- Adding code to the WHEN-NEW-FORMS-INSTANCE trigger
- How to do it...
- How it works...
- Copying the QUERY_FIND object group
- How to do it...
- How it works...
- Setting the block, canvas, and window properties
- How to do it...
- How it works...
- Editing the button triggers on the QUERY_FIND block
- How to do it...
- How it works...
- Creating items in the query block
- How to do it...
- How it works...
- Resizing the objects on the canvas
- How to do it...
- How it works...
- Creating a PRE-QUERY trigger
- How to do it...
- How it works...
- Creating a QUERY_FIND trigger
- How to do it...
- How it works...
- How to do it...
- How to do it...
- How to do it...
- Adding code to the WHEN-NEW-FORMS-INSTANCE trigger
- Passing parameters to a form
- Creating a parameter
- How to do it...
- How it works...
- Bypassing the query find screen
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Testing the form with the PERSON_ID parameter passed in
- How to do it...
- How it works...
- Creating a parameter
- 3. Advanced Oracle Forms
- Introduction
- Installing the database objects
- How to do it...
- How it works...
- How to do it...
- Using messages from the message dictionary
- Creating a message directory
- How to do it...
- How it works...
- Creating a message
- How to do it...
- How it works...
- Creating a message file
- How to do it...
- How it works...
- Coding logic to display messages
- How to do it...
- How it works...
- Compiling the form
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Creating a message directory
- Creating tabs within a form
- Creating a tabbed region
- How to do it...
- How it works...
- Resizing objects on a canvas
- How to do it...
- How it works...
- Creating a new block
- How to do it...
- How it works...
- Setting block properties
- How to do it...
- How it works...
- Setting item properties
- How to do it...
- How it works...
- Creating a relationship between the master and detail blocks
- How to do it...
- How it works...
- Adding a record indicator to a block
- How to do it...
- How it works...
- Sizing and positioning items on a tabbed canvas
- How to do it...
- How it works...
- Aligning a tabbed canvas on a content canvas
- How to do it...
- How it works...
- Adding a form level trigger to show a tabbed canvas
- How to do it...
- How it works...
- Adding code to manage a tabbed canvas
- How to do it...
- How it works...
- Creating a tabbed region
- Creating program units
- Creating a new package to handle database transactions
- How to do it...
- How it works...
- Adding triggers to capture transactional events on a block
- How to do it...
- How it works...
- Creating triggers to set the WHO columns
- How to do it...
- How it works...
- Creating a new package to handle database transactions
- Adding lookups, date fields, and lists
- Creating a lookup
- How to do it...
- How it works...
- Creating a new LOV based upon a record group
- How to do it...
- How it works...
- Configuring date fields
- How to do it...
- How it works...
- Creating a list item
- How to do it...
- How it works...
- Creating a lookup
- Controlling menu items
- Copying the standard menu from the application server and opening it in forms
- How to do it...
- How it works...
- Disabling an existing menu item
- How to do it...
- How it works...
- Adding a new menu item
- How to do it...
- How it works...
- Adding a trigger to capture new menu item events
- How to do it...
- How it works...
- There's more...
- Compiling the form
- How to do it...
- How it works...
- Copying the standard menu from the application server and opening it in forms
- Creating pop-up menu items
- Adding items to a pop-up menu
- How to do it...
- How it works...
- Compiling the form
- How to do it...
- How it works...
- Adding a trigger to capture pop-up events
- How to do it...
- How it works...
- How to do it...
- Adding items to a pop-up menu
- Adding flexfields to forms
- Adding flexfield items to a table
- How to do it...
- How it works...
- Registering a table within EBS
- How to do it...
- How it works...
- Viewing the table registration in EBS
- How to do it...
- How it works...
- Registering a Descriptive Flexfield
- How to do it...
- How it works...
- Enabling a flexfield value
- How to do it...
- How it works...
- Adding a flexfield item to a form
- How to do it...
- How it works...
- Adding flexfield items to a table
- Creating triggers for flexfield events
- Adding a WHEN-NEW-FORM-INSTANCE event
- How to do it...
- How it works...
- Adding a WHEN-NEW-ITEM-INSTANCE event
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Adding a WHEN-NEW-FORM-INSTANCE event
- Adding a zoom using the CUSTOM library
- Finding the short name of the form we want to zoom from
- How to do it...
- How it works...
- Finding the name of a block
- How to do it...
- How it works...
- Enabling a zoom
- How to do it...
- How it works...
- Creating an object-specific library
- How to do it...
- How it works...
- Attaching a library to the CUSTOM library
- How to do it...
- How it works...
- Coding an event in the CUSTOM library
- How to do it...
- How it works...
- Compiling libraries on the application server
- How to do it...
- How it works...
- Adding a function to a menu
- How to do it...
- How it works...
- Testing the zoom
- How to do it...
- How it works...
- Finding the short name of the form we want to zoom from
- Adding a spreadtable to a form
- Adding the CRM Administrator responsibility
- How to do it...
- How it works...
- Configuring a spreadtable
- How to do it...
- How it works...
- Adding a tab page
- How to do it...
- How it works...
- Adding the JTF_GRID object group
- How to do it...
- How it works...
- Adding a block
- How to do it...
- How it works...
- Adding an item
- How to do it...
- How it works...
- Adding a library
- How to do it...
- How it works...
- Adding code to manage the grid
- How to do it...
- How it works...
- Adding code to populate the grid
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Adding the CRM Administrator responsibility
- Capturing events for a spreadtable
- Configuring a hyperlink on a spreadtable
- How to do it...
- How it works...
- Adding triggers to capture events for a grid
- How to do it...
- How it works...
- Adding a custom trigger to capture an event
- How to do it...
- How it works...
- Adding code to manage events from a grid
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Configuring a hyperlink on a spreadtable
- 4. Forms Personalization
- Introduction
- Opening the personalization screen
- Getting started
- How it works...
- The Personalization screen
- Definition
- Condition tab
- Context region
- Actions tab
- Property
- Message
- Builtin
- Menu
- How it works...
- Getting started
- Installing the database objects
- How to do it...
- How it works...
- How to do it...
- Changing properties
- Changing prompts
- How to do it...
- How it works...
- Disabling buttons
- How to do it...
- How it works...
- Renaming tabs
- How to do it...
- How it works...
- Hiding fields
- How to do it...
- How it works...
- Moving fields
- How to do it...
- How it works...
- Testing the form after applying personalization
- How to do it...
- How it works...
- Fixing personalization that doesn't seem to work
- How to do it...
- How it works...
- Changing prompts
- Adding a menu item to a form
- Adding a menu item
- How to do it...
- How it works...
- Testing whether the menu item has been added
- How to do it...
- How it works...
- Adding a menu item
- Performing a simple validation and displaying a message
- Adding validation when an event is triggered
- How to do it...
- How it works...
- Adding a message
- How to do it...
- How it works...
- Testing the form
- How to do it...
- How it works...
- Adding validation when an event is triggered
- Launching a form
- Adding a condition
- How to do it...
- How it works...
- Adding a builtin to launch a form
- How to do it...
- How it works...
- Testing the form is launched
- Getting started
- How to do it...
- How it works...
- Adding a condition
- Adding a toolbar icon to a form
- Adding an icon to the toolbar
- How to do it...
- How it works...
- Testing to see if the toolbar icon is displayed
- How to do it...
- How it works...
- Adding an icon to the toolbar
- Performing complex validation
- Creating a lookup
- How to do it...
- How it works...
- Calling a database function in a condition statement
- Getting ready
- How to do it...
- How it works...
- Adding a warning message
- How to do it...
- How it works...
- Testing the validation
- How to do it...
- How it works...
- Stop any further processing
- How to do it...
- How it works...
- Checking a database value against a form value
- How to do it...
- How it works...
- There's more...
- Creating a lookup
- Altering an LOV's record group
- Creating a new record group
- How to do it...
- How it works...
- There's more...
- Assigning a new record group to an LOV
- How to do it...
- How it works...
- Testing a radio group has changed
- How to do it...
- How it works...
- Creating a new record group
- 5. Workflow
- Introduction
- Introducing Workflow Builder
- How to do it...
- How it works...
- There's more...
- See also
- Installing the database objects
- How to do it...
- How it works...
- Creating an advanced queue
- Getting started
- How to do it...
- How it works...
- Building a workflow
- Creating a new workflow
- Getting ready
- How to do it...
- How it works...
- Creating a new item type
- How to do it...
- How it works...
- Creating a new process
- How to do it...
- How it works...
- Creating a start function
- How to do it...
- How it works...
- Creating an end function
- How to do it...
- How it works...
- Creating attributes to store the event details
- How to do it...
- How it works...
- Assigning the start event details
- How to do it...
- How it works...
- Saving a workflow to the database
- How to do it...
- How it works...
- Creating a new workflow
- Creating a business event
- Setting up the workflow administrator responsibility
- How to do it...
- How it works...
- Creating an agent
- How to do it...
- How it works...
- Creating an agent listener
- How to do it...
- How it works...
- Defining a business event
- How to do it...
- How it works...
- Subscribing to a business event
- How to do it...
- How it works...
- Setting up the workflow administrator responsibility
- Viewing a workflow status and monitoring progress
- Adding a message to an advanced queue
- How to do it...
- How it works...
- Viewing a workflow in status monitor
- How to do it...
- How it works...
- Viewing the workflow status diagram
- How to do it...
- How it works...
- Viewing workflow attributes and event messages
- How to do it...
- How it works...
- Adding a message to an advanced queue
- Adding a function
- Updating an employee record for testing
- How to do it...
- How it works...
- Adding attributes
- How to do it...
- How it works...
- Adding a function
- How to do it...
- How it works...
- There's more...
- Testing the workflow
- How to do it...
- How it works...
- Updating an employee record for testing
- Creating a lookup
- Creating a Success/Fail lookup
- How to do it...
- How it works...
- See also
- Adding an error message attribute
- How to do it...
- How it works...
- Creating a Success/Fail lookup
- Creating a subprocess
- Creating a subprocess
- How to do it...
- How it works...
- Adding a validate employee function
- How to do it...
- How it works...
- Adding a validate absence type function
- How to do it...
- How it works...
- Adding a validate absence dates function
- How to do it...
- How it works...
- Creating end functions
- How to do it...
- How it works...
- Joining the functions
- How to do it...
- How it works...
- Adding a subprocess to a parent process
- How to do it...
- How it works...
- Testing the workflow
- How to do it...
- How it works...
- There's more...
- Creating a subprocess
- Creating messages
- Creating an absence approval message
- How to do it...
- How it works...
- Adding attributes to our approval message
- How to do it...
- How it works...
- Creating a rejection message
- How to do it...
- How it works...
- Adding attributes to our rejection message
- How to do it...
- How it works...
- Creating an invalid XML message
- How to do it...
- How it works...
- Adding invalid XML message attributes
- How to do it...
- How it works...
- Creating an absence approval message
- Sending notifications and processing responses
- Creating an absence approval notification
- How to do it...
- How it works...
- Creating an absence rejection notification
- How to do it...
- How it works...
- Creating invalid XML notification
- How to do it...
- How it works...
- Adding notifications to the process diagram
- How to do it...
- How it works...
- Mapping the notifications
- How to do it...
- How it works...
- Testing the workflow
- How to do it...
- How it works...
- Viewing the notifications and workflow diagrams
- How to do it...
- How it works...
- Creating an absence approval notification
- Calling an API
- Creating a function to call the database package
- How to do it...
- How it works...
- Adding a function to a process
- How to do it...
- How it works...
- Testing the workflow
- How to do it...
- How it works...
- Creating a function to call the database package
- 6. Utilities
- Introduction
- Setting the environment variables
- Setting the environment on the application server
- How to do it...
- How it works...
- Setting the environment on the database server
- How to do it...
- How it works...
- Setting the environment on the application server
- Starting and stopping an environment
- Starting an environment
- How to do it...
- How it works...
- Stopping an environment
- How to do it...
- How it works...
- Starting an environment
- Creating a custom schema
- Making a new environment parameter
- How to do it...
- Running AutoConfig (adautocfg.sh)
- How to do it...
- How it works...
- There's more...
- Creating a CUSTOM schema directory structure
- How to do it...
- How it works...
- Creating a new tablespace
- How to do it...
- How it works...
- Creating a database user
- How to do it...
- How it works...
- Registering an Oracle schema
- How to do it...
- How it works...
- Registering an Oracle user
- How to do it...
- How it works...
- There's more...
- Making a new environment parameter
- Extracting data using FNDLOAD
- Extracting a lookup using FNDLOAD
- How to do it...
- How it works...
- Extracting a Descriptive Flexfield using FNDLOAD
- How to do it...
- How it works...
- Extracting a concurrent program using FNDLOAD
- How to do it...
- How it works...
- Extracting a request set using FNDLOAD
- How to do it...
- How it works...
- Extracting a profile option using FNDLOAD
- How to do it...
- How it works...
- Extracting a form and function using FNDLOAD
- How to do it...
- How it works...
- There's more...
- Extracting a menu using FNDLOAD
- How to do it...
- How it works...
- Extracting a request group using FNDLOAD
- How to do it...
- How it works...
- Extracting a responsibility using FNDLOAD
- How to do it...
- How it works...
- Extracting a personalization using FNDLOAD
- How to do it...
- How it works...
- Extracting a message using FNDLOAD
- How to do it...
- How it works...
- Downloading multiple objects
- How to do it...
- How it works...
- Extracting a lookup using FNDLOAD
- Uploading using FNDLOAD
- Uploading a lookup using FNDLOAD
- How to do it...
- How it works...
- Uploading a Descriptive Flexfield using FNDLOAD
- How to do it...
- How it works...
- Uploading a concurrent program using FNDLOAD
- How to do it...
- How it works...
- Uploading a request set using FNDLOAD
- How to do it...
- How it works...
- Uploading a profile option using FNDLOAD
- How to do it...
- How it works...
- Uploading a form and function using FNDLOAD
- How to do it...
- How it works...
- Uploading a menu using FNDLOAD
- How to do it...
- How it works...
- Uploading a request group using FNDLOAD
- How to do it...
- How it works...
- Uploading a responsibility using FNDLOAD
- How to do it...
- How it works...
- Uploading a personalization using FNDLOAD
- How to do it...
- How it works...
- Uploading a message using FNDLOAD
- How to do it...
- How it works...
- Modifying the LDT file
- How to do it...
- How it works...
- Uploading a lookup using FNDLOAD
- Using a script for FNDLOAD
- How to do it...
- How it works...
- Using a script for migrating objects
- How to do it...
- How it works...
- Index
- Title: Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots
- Author: Andy Penver
- Original title: Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots.
- ISBN: 9781849684859, 9781849684859
- Date of issue: 2012-05-11
- Format: Ebook
- Item ID: e_3d1x
- Publisher: Packt Publishing