Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

TECH

Join the https://t.me/OracleApps88 group or message me at @apps88 (https://t.me/apps88) or (+91) 9059574321 in Telegram, to get more information on Oracle EBS R12/Cloud (Fusion) applications.


Topic
Link
Oracle Reports
XXAA_ACCT_FLEXFIELD_REP - XXAA Account Flex Field Report
AOL - Dynamically enabling and disabling Parameters in Oracle Concurrent Program
Barcode Integration in Oracle
AOL - Creating a Custom Account Flex Field Parameter for Concurrent Program in Oracle
AOL - Dynamically Enabling and Disabling Concurrent Program Parameters
AOL - Creating Custom Account Flex Field Parameter in Concurrent Programs
How to make the Oracle report concurrent program ends with warning?
SRW (Sql Report Writer) Package in Oracle Reports Builder
How to create the Dependent and independent values set and how to fetch the relevant details list from parameter 1 to parameter2
Viewer Options LOV setup for taking Text format output in 'EXCEL'
Oracle Order Management FlexFields, Reports Metalink Ids
Oracle Financials List Of Standard Report Details
SRW.USER_EXIT in Oracle Reports
how to run one report from another report
For Displaying concurrent program dynamically In Reports
Formula Column in Oracle Reports
Oracle Reports 6i
Oracle Reports - Lexical Paramaeters
Life Cycle of a Concurrent Request in Oracle Applications
Create a Report that Executes a Query
Account Payables Reports
Track and Trace E-Business Suite Concurrent Request - EBS Logs, O/S Process IDs, Locks
Send e mail through PL SQL code
Oracle Reports-Frequently Use SRW Functions
Sending EMail After Report Code
Different Report Queries...
Data Model Interface - Formula/Summ Columns
Report Registration Steps:
Report Navigation Explanations
Oracle Reports With Parameters:
To Check Module Wise Reports
Interview Questions and Answers - FAQS
Oracle Reports Interview Questions and Answers (FAQS)
Oracle Reports Interview Questions
Documents
 Report Customization 
 Reports 
XML Publisher Reports
How to Develop XML Publisher Report (XMLP) or BI Publisher Reports
How To Create/Install (Register) a New Font Using XML Publisher
SEPA - How To Customize XSL Template For Oracle SEPA Payments
MICR and BARCODE Font Setup in Oracle XML Publisher
How To Insert Images and Logo in the XML Publisher Reports and Documents
Setting the Password for PDF File sent through XML Publisher
Creating Reports in Oracle E-Business Suite Using XML Publisher
XMLPublisher Bursting in Oracle Applications
Compile error in Hidden module: Module_editFF in Oracle BI Publisher
Oracle XML Publisher Tags
Setting Default Output Type for BI Publisher Report
Advance BI Publisher Concepts - Sorting in RTF Template
View Barcode in BI Publisher Report when run from Application
Image Display In XML Publisher Excel Output
How to Find OPP Log File - XML Publisher
Oracle Report Registration Script
Moving Templates and Data Definitions Between E-Business Suite Instances
RTF Registration
RTF Template Tips
RTF Template- IF Conditions
RTF Template - Variables
RTF Template- Signature Printing
RTF Template- PageBreak
Create XML Publisher Report(With out RDF file)
Create XML Publisher Report Using Oracle Reports( RDF )
Master Detail Report with Oracle BI Publisher
Oracle XML Publisher Queries
Useful Tags in Xml Publisher Publisher Reports
Oracle XML Publisher Moving Templates and Data Definintions between EBS Instances
Creating a XML Publisher Template in Oracle
Oracle Apps XML Reports in Excel
XMLP Tags
Multile Queries in XML Publisher Data Template
Oracle XML Publisher Commands
Logical (and , or) Parameters in XMLP Reports
How to Format Oracle output with HTML/XML
Extended Function Support in RTF Templates
Formating Date From 'YYYY/MM/DD' to 'DD-MON-YYYY' in XMLP(RTF)
To Verify that the MICR font has been installed
Printing Page Number code in Oracle XMLP RTF templlate
Oracle XML Report - Using Data Source as PL/SQL Stored Procedure
Oracle PL/SQL Report
Submitting the XMLP Report with Attachment from Backend
Submiting XMLP Report From Backend
Oracle XML Operations XMLType, UPDATEXML, EXISTSNODE, XMLELEMENT, XMLATTRIBUTES, XMLFOREST, XMLAGG, XMLROOT and Basic XML Parsing via PL/SQL
Script for getting XML tags in SQL
Delete Template and Data defination from Backend
How to Delete XML Publisher Definition and Template
Example of DBMS_XMLGEN.getxml to generate XML Tag using oracle query
Oracle XML Publisher Queries
XML File Creation Thru PL/SQL
Submitting BI Publisher Concurrent Program from PL/SQL
Documents
 XMLP - Creating Reports in Oracle E-Business Suite Using XML Publisher 
 XMLP - Font (MICR or BARCODE) Font Registration From Application 
 XMLP - XML Publisher 
 XMLP - XML Publisher Documents  
 XMLP - XML Publisher Training Document 
Discoverer Reports
Oracle Discoverer Administration and Desktop
Oracle Discoverer
Discoverer Query to find BA, BA_DESC, FOLDER_NAME, FOLDER_NAME_DESC
To Improve Discoverer performance
Oracle DISCOVERER
Developing Reports with Advanced Functionality using Discoverer Plus
To Find Oracle Discoverer Reprt Name
Not Required Parameter in Discoverer
Dependent Value Parameter in Discoverer
Oracle Discoverer Administration and Desktop
To Set the Org Context in R12 Discoverer(10g) Reports
 Oracle Discoverer 4i Plus
Registering Disco Workbook in Apps R12
ORACLE DISCOVERER PLUS
ORACLE DISCOVEROR VIEWER
ORACLE DISCOVERER DESKTOP
ORACLE DISCOVERER ADMINISTRATOR
Discoverer Reports
Documenting EUL, Discoverer Workbook, Worksheet
Tip to Save Discoverer Administrators Time and Frustration
Documents
 Discoverer 
 Discoverer 4i Plus 
 Discoverer Administration and Desktop 
 Discoverer Document 
 Discoverer Plus - Creating Custom Reports 
 Discoverer10g 
Oracle Forms
Oracle 10g Forms Development Training Guide
READ ONLY RESPONSIBILITIES in ORACLE
Creating Oracle Form With TEMPLATE.fmb
Setting Oracle 10g forms Environment FORMS_PATH in REGEDIT(Registry Editor)
Triggers in Oracle Forms
Oracle Form Triggers
Oracle Forms
FORM DEPLOYMENT PROCESS IN ORACLE APPS
Compilation Forms Process in 11i and R12
Save Images in Database From Forms
Registration of a Custom Form in Oracle Applications(11i and R12)
Oracle FORM Parameteres
Oracle Forms Material
Move Objects, Layout Appearances
Forms, Libraries and Menus
FND MESSAGE – Message handling in Oracle Application
Forms Built-in Routines
Oracle Form Template Setups
Calling Another Form Parameters
Oracle Forms Process
Formas Global and system variables
ORACLE FORMS 6i
Return which functions a user can access
Returns the Query for the forms used by a user in the last number of days
Manuval Form(6i) Development
Forms 6i Process
01/23 - Introduction to From Builder
02/23 FORMS - Form Builder (Hands-On)
03/23 FORMS - Tab canvas, Master-Detail relationship
04/23 FORMS - Help, Hint, format mask, properties
05/23 FORMS - LOVs, Record Group
06/23 FORMS - Radio Buttons
07/23 FORMS - Display items, Summary and function columns
08/23 FORMS - Triggers
09/23 FORMS - Horizontal Toolbar, Push Button, Trigger
10/23 FORMS - Sizing, Layout appearances
11/23 FORMS - Trigger (PRE-QUERY), Set dynamically properties
12/23 FORMS - Sequence object, Trigger (PRE-INSERT)
13/23 FORMS - Call FORMS
14/23 FORMS - Global Variable
15/23 FORMS - Main Menu
16/23 FORMS - Pop up menu
17/23 FORMS - Move Objects, Layout Appearances
19/23 FORMS - Viewing a picture using BLOB datatype
20/23 FORMS - REF CURSOR
21/23 FORMS - FORM BLOCK and TRANSACTIONAL TRIGGERS
22/23 FORMS - Parameters between FORMS
23/23 FORMS - Parameter List
Forms Personalization and Customization
Oracle CUSTOM.PLL Scripts
Forms Personalization and CUSTOM.pll introduction
How To Customize Standard Oracle Application Using Custom Library – Custom.pll
Form Personalization CUSTOM.PLL Examples
CUSTOM.pll versus Forms Personalization
CUSTOM.pll Code for Fields
CUSTOM.pll in Oracle Forms(6i)
CUSTOM.pll Code for Tabs/Buttons
Oracle Forms Customizations
Oracle FORMS Customization And Personalizations
Calculation in Oracle Personalization
Oracle Forms Personalization
Oracle Form Personalization
How to Know Who Personalized The Oracle Form
How to Delete Responsibility From User
Query To Get Form Personalizations
Case Insensitive Query in Forms
It will automate the transfer of one or more form personalization from an environment to another
Form Personalization: Restrict the Responsibilities LoV on the form FNDSCAUS
Form Personalization: Restrict the Responsibilities LoV without Disabling the End-Date Field on the form FNDSCAUS
Form Personalization: Limit Site Level Profile Options Access on the form FNDPOMPV
Customizing transaction type LOV – Form Personalization
Attachment Functionality in Oracle Applications
Descriptive Flex Fields in Custom Forms
Folder Options in Custom Forms
Symantec SHS Additional Data Elements Form
Oracle FORMS Customization And Personalizations
Implementing Oracle Forms Customizations
Oracle Forms Customization and Personalization
How To Pass Function Parameters(Forms Pers)
Form Personalization Submit Request Delivery Options Button – Removing the Button
Change displayed data in LOV using Forms Personalization
Oracle 11i (6i)Forms Personalization
Forms Customization Steps and Registration Process
Forms Customization in Oracle
ZOOM Form In Oracle Form Personalization
Sales Order Booking, Picking and Shipping Made Easy – Using Oracle Forms Personalization
Interview Questions and Answers - FAQS
Oracle Forms Interview Questions and Answers (FAQS)
Oracle Forms Personalization Interview Questions
Oracle Form Customization (FAQs) Interview Questions and Answers
Documents
 Form Customization 
 Form Personalization 
 FORMS - 10g Forms Development 
 FORMS - 10g Forms Development Training Manual 
 FORMS - How to get value from a Form Value bean in Controller 
 FORMS Customization and Personalizations  
 Forms Customizations 
 Forms Material 
 Forms Personalization 
Workflows
 Oracle Workflow Details
 Oracle Workflow Technical Details
 Query to get the Workflow Status
 Workflow Sample Tutorial
 Oracle Workflow Queries
 The below script will launch or kickoff the desired workflow from PL/SQL code
http://oracleapps88.blogspot.com/2013/11/the-below-script-will-launch-or-kickoff.html
 Creating WF Local Roles: Script to Create an Adhoc Roles
 How to Launch Workflow from PL SQL
 Parameters for a PL/SQL in Workflow API
Oracle Workflow - 11i
Oracle Workflow Basics
Oracle Workflow Sample Tutorial
Oracle Workflow Process
Oracle Workflow Query
Workflow Tables
WORKFLOW
Troubleshooting: Responsibility not Visible by User After unendate
Designing Simple Master/Deatil Oracle workflow
Oracle Workflow - Concept
Define a Document Type Attribute in Oracle workflow
Oracle Workflow and Workflow Components
Script to Add #WFM_CC Attribute to the orders
Unix
Unix Commands
UNIX Tutorial
Oracle Unix System Administrator Scripts
Loading XML Documents Into an Oracle Database with External Tables
Installation of Oracle Application (R12)
Day To Day UNIX Commands
Unix/Linux Commands
UNIX COMMANDS
UNIX Commands
XDOLoader Utility to upload XML Templates
Restart or Bounce Apache Server
It will create/update the file tnsnames.ora and it will create a test page that will try to connect the Oracle DB
It will automate the transfer of one or more form personalization from an environment to another
Basic VI Editor Commands
FNDLOAD Commands in Unix
UNIX Commands
UNIX Concepts
Useful UNIX Commands
How to SUDO in Unix
Interview Questions and Answers - FAQS
Oracle UNIX Interview Questions and Answers (FAQs)
Oracle UNIX Interview Questions and Answers
Documents
 UNIX Shell-Scripting Basics 
 UNIX Shell-Scripting Basics 
 UNIX-LINUX Training Material 
Conversions and Interfaces
Oracle Interfaces and Conversion
Oracle Data & Migration (Interface, API)
Oracle Applications Conversion Process Diagram
Oracle Data Migration(Conversion)
Oracle Application Conversion Process
Conversions Depedency with Other Modules
GL, AP, AR, QOH and PO Interface Tables and Conversion Process
Auto Invoice Interface Tables
Oracle Interface Tables
http://oracleapps88.blogspot.com/2013/04/oracle-interface-tables.html
Oracle Base Tables and Interface Tables
Oracle Data & Migration (Interface, API)
Oracle Interfaces(ITEMS,QOH,PO,PO REQ,AP,SO) and APIs(HRMS)
Oracle Interface Tables
Script To find Oracle API's for any module
Interfaces and Conversions in Oracle Applications
Oracle Interfaces and Conversion
Oracle Interfaces
Interfaces in Oracle Application
Oracle Interface Details
Oracle Apps
Oracle Order Management EDI, API and Order Import Metalink Ids
SQL LOADER IN Oracle Apps
XML Parsing - Loading the XML data into Staging Table with SQL *Loader
Loading XML Documents Into an Oracle Database with External Tables
IMPLEMENTING CONCURRENT PROGRAM FOR SQL LOADER
Export or Save as Excel Files with Pipe (or Other) Delimiters Instead of Commas
Export data from Excel to Table using custom Web ADI Integrator
UTL_FILE - Script to Read Data From a Flat File and Insert into a Table
Outbound Interface Process in Oracle
Fianancials
AP - Payables Open Interface Tables Details
Oracle R12 Supplier Bank, Bank Branch and Bank Account Creation Scripts
Oracle Custom WEB ADI - Supplier Creation
Oracle Supplier Creation with API
Update R12 Supplier Contact details Using API
Oracle Custom WEB ADI Setups and Process for AP Invoice Interface
Oracle Supplier Creation with API
R12 Oracle Supplier Conversions
Creating a R12 Supplier Bank accounts Using API
Supplier & Supplier Site creation using API
Single Insertion scripts for R12 Supplier Banks
Oracle 11i Suppliers Single Insertion Scripts
Oracle GL Daily Conversion Rates Details
Oracle GL Journal interface Details
AR - Oracle Apps Auto Invoice
API to Delete Receivables invoice from Backend
Oracle R12 Account Receivable (AR) Invoice Creation throw API
Oracle Auto Invoice Interface Tables
AR Customer Interface R12
AR INTERFACES Conversion
Create AR Invoice using API
AR Cash Receipt using API
Create a Party site in oracle customers
Create a Location in Oracle Customers
Create an Organization in oracle Customers
Customer Conversion In Oracle 11i Steps
SCM
Oracle Inventory Item Creation With API
Oracle Inventory Item Interface Details
Oracle Inventory Process Move Order API
Oracle Bills Of Material (BOM) Interfaces
Oracle API For Assign the Item to catalog
Oracle API For Item Process
Oracle Item Conversions
PO - Script to Create Oracle Purchase Order Receipt from Backend
Oracle Purchase Order Single Insert Script Process
Script to Cancel the Purchase Order with API
Oracle Purchase Order Single Insertion Script
Blancket Purchase Order(Invoice) Single Insert In Oracle 11i
OM - Oracle API Script for Ship Confirm Process in Order Management
Oracle API Script for Pick Release in OM
Assign delivery detail to delivery Through API Script in Order Mangement
Create Deliver Through API script in Order Management
Create Order, Order Line and Book the Order through API Script in Oracle Applications
Oracle Order Creation With API
HRMS
HRMS - Loading Competency Profile for Employees
Script to Update the Employee(per_all_people_f) and User(fnd_user) Email address through API
Oracle HRMS API's
HR EMPLOYEE SALARY UPDATE API
HR EMPLOYEE SUPERVISOR UPDATE API
HR EMPLOYEE ORGANIZATION UPDATE API
CRM
CRM - Create Oracle Service Contract Lines Through API
Create Template From Oracle Service Contract Header Through API
Create Oracle Service Contract Header From Template Through API
Update Oracle Service Contract Header Through API
Create Oracle Service Contract Header Through API
Install Base creation for all the Sales Order for which it is missing
PA - Project Accounting
PA - PA_PROJECT_PUB.CREATE_PROJECT - Creating Project, Task and ChildTask with API
To update the Project Task through API - PA_PROJECT_PUB.UPDATE_TASK
TO Update the Oracle Project Budget Line and Baseline Project Through API
Single Insert for Oracle Projects





2 comments:

Ravichandran.S said...

Great collection! Very useful informations. Hats off to you.

Jayakrishna said...

very useful, good work. all in one place. Thanks a lot

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect