• No results found

Oracle Apps

N/A
N/A
Protected

Academic year: 2021

Share "Oracle Apps"

Copied!
122
0
0

Loading.... (view fulltext now)

Full text

(1)

Free Oracle Application Servers availble in INTERNET

Free Oracle Application Servers availble in INTERNET

1)https://testexchange.oracle.com/home.jsp

for username/passcode register your self

2)http://www.solutionbeacon.com/tools_vision.htm username/passcode RA1691/1691RA.

XML Gateway Overview

XML Gateway

HI, today i will talk briefly about Oracle XML Gateway as component of Oracle Applications. This is only indented to be a conceptual introduction and for the complete details you must refer to the user guide or appropriate metalink note. XML Gateway is a tool that facilitates the communication between the Oracle E business suite and third party applications or trading partners in the form of well formatted XML messages. XML Gateway ensures that both business to business (B2B) and Application to Application(A2A)

requirements are met. Further XML Gateway ensures that the messages that are generated or consumed are compliant with the standards set by the OpenApplications Group. You can find more information on these standards at http://www.openapplications.org Oracle XML Gateway works with Oracle Workflow to consume events raised and generate XML messages. These messages are further propagated using Oracle Advanced queuing technology and Oracle Transport agent(OTA). Inbound and outbound messages are managed in queue table using Oracle Advanced Queuing. The OTA is used to deliver messages to a trading partner over HTTP or HTTPs. An OTA servlet running with Oracle Applications is also responsible for receiving inbound documents sent by the trading partner.Oracle XML gateway can be considered as a form of EDI, whereas in a normal EDI transaction the operation happens in a batch in case of XML gateway the message are more real time as they are based of events.

Oracle XML gateway makes use of the uses Web Services Description Language (WSDL) to facilitate trading partners to communicate with Oracle Applications. Trading partners can use third party web service tools to call the web services publish by your Oracle Applications.It also uses the Java Messaging Service(JMS) to send messages between Oracle Applications and trading partners.

At the core of Oracle XML Gateway lies the execution engine, this is responsible for interacting with other oracle technologies like Oracle Workflow etc to consume and generate messages between trading partners as in the case of a B2B communication.

Oracle XML Gateway supports the SMTP, HTTP, HTTPS, JMS transport protocols for message delivery and consumption.

Oracle XML Gateway uses the Message Designer to define message maps, message maps are required to specify the data source and data target for the document. You can also use Map creation wizards that are provided for this purpose.

The message designer and wizard is a client software which is required to be installed separately on the client PCs.

Message map files have a .xgm extension. Message maps that are created on the loacle /client system have to be loaded to the middle tier APPL_TOP.

The java LoadMap and java DeleteMap are used to load and delet message maps on the middle tier server. Its important to note that before you crate your message maps for your document you must ensure that the

(2)

document conforms to the Document Type Definition(DTD).Pre defined DTD are installed and loaded in the $APPLTOP of the middle Tier. You can however load custom DTD that you can define using the Oracle Message Designer to the middle tier as well as modify existing DTD and delete existing DTD.

The DTD files are created with the .dtd extension.

The java DeleteDTDFromClob and java LoadDTDToClob are used for deleting and loading DTDs

respectively.For complete syntax and example to load and delet DTDs refer to the Oracle XML Gateway users guide.

You can use the Oracle Applications responsibility 'XML Gateway Responsibility' to define trading partners and transactions.

In releases 11.5.7 onwards XML gateway is distributed as a part of AOL and does not require to be licensed or installed separately. For prior releases XML Gateway can be installed by applying patch 2440710.

The metalink note 152775.1 contains full instructions for installing and configuring Oracle XML Gateway. You can verify your XML gateway installation byu executing the following sql script

SQL> $ECX_TOP/patch/115/sql/ECXTEST.sql

this will create a OUTnnn.xml if the installation and configuration of XML Gateway is successful.

Overview of OA Frame work.

Oracle Applications Framework (OA Framework) is the Oracle Applications development and deployment platform for HTML-based business applications.OA Framework consists of a set of middle-tier runtime services and a design-time extension to Oracle9i JDeveloper called Oracle Applications Extension. Oracle9i JDeveloper with OA Extension (OA Extension) is a world class J2EE-based integrated development

environment

OA Framework is designed around the simple Model-View-Controller (MVC) architecture The MVC architecture is a component-based design pattern.OA Framework technologies has driven several industry standards and has adopted several others.OA Framework is J2EE based and features several industry standards such as XML, HTML, Java, JSP, SQL and Web Services.OA Extension provides features such as easy-to-use wizards, a hierarchy navigator, and a property sheet. These features enable developers to populate the

metadata for declarative application business logic and user interfaces.

what JDeveloper version should be used for OAF development Current JDeveloper patches:

Patch 4045639 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H Patch 4141787 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1

(3)

Patch 4573517 - Oracle9i JDeveloper with OA Extension for 11.5.10 CU2

Patch 4725670 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3

To determine which patch to use, you can simply check the framework version in your instance by using

http://host:port/OA_HTML/OAInfo.jsp

then choose the matched one.

11.5.10K = patch 4045639

11.5.101CU = patch 4141787

(4)

11.5.103CU = patch 4725670

Architecture

OA Framework Architecuture is based on the industry-standard J2EE MVC design pattern.So Developers manipulate the application's metadata using Oracle 9i JDeveloper OA Extension .

How to Remove personalization

1. Login to application

2. Select Responsibility Functional Administrator 3. Click Personalization Tab ( Upper Right)

(5)

5. Click on the Personalized Checkbox 6. Click Go

7. Remove or De-activate your personalization that is causing the issue by selecting the personalization level at which you made that particular persanolization . Because if you made some personalizations at

responsibility level and some at site level and if you made mistake whenever you are making personalization at site then you need to select the personalization level at site level rather than responsibility , so that you eventhough you deactivate personalizations at site level by usingthis action plan , you can protect your personalizations which were made at responsibility level .8 Re-test your login.

Method-2

by setting the profile option "Disable Self-Service Personal" to "Yes Method -3

Use the JDR_UTILS package

Use sqlplus and this comand examples set serveroutput on;

execute jdr_utils.listDocuments('//', TRUE); Example: To DELETE ---Begin executejdr_utils.deleteDocument('/oracle/apps/icx/por/reqmgmt/server/customizations/site/0/GroupReqsPublic VO'); commit; End;

then refer the follwoing tbales JDR_COMPONENTS. JDR_ATTRIBUTES

JDR_ATTRIBUTES_TRANS JDR_PATHS

what is EO ( Entity Object ) ,View Object (ViewImpl) and View Row ( ViewRowImpl )?

Entity Object :BC4J entity objects encapsulate the business rules like validations, actions associated with a row in a database table, view or synonym .

View Object (ViewImpl):In the simplest terms, a BC4J view object encapsulates a database query and provides iteration over and access to the view rows in its result set

View Row ( ViewRowImpl ) :Represents a single row in a view object.

Customization of Information Template in iProc

information templates to gather additional information in Oracle iProcurement to pass necessary order processing information to suppliers.When an information template is assigned to a category or item, the application prompts requesters to provide the information specified in the template when the item is added to the shopping cart.Each information template must be associated with an Oracle Purchasing item or item category.If an information template is associated with an item category, all items belonging to that category are also associated with the template.

Create an information template:

1.From the Oracle Purchasing menu, select Setup > Information Templates. Give your Template a name.

2.Select Available in All Organizations if you want the template to be available to requesters in all operating units. 3.Select an Attachment Category of To Supplier or To Buyer.

(6)

4.Enter an Attribute Name and Description as shown in figure.

You can create pop-list and attch to the attribute.

Createing pop-list

Navigate From the Oracle Purchasing menu setup->flex fields->Validation->sets

create value set name as TRVL_AIR_DROP

List type List of values validation type inpedendent

2. Create values for TRVL_AIR_DROP

(7)

3.finally Attach the Poplist to information template attributes.

4.Next Go to iProcurement Catalog Adminstration .Navigate Non catalog Request Templates

Click on create button and pass the necessary inputs and click on add template button pass the information template which we customized in PO.

Template name : Test Travel Req Organization : select your orgnization.

(8)

5. Click on stores link under Manage Content link

click on edit under Non-Catalog Request Store then Click on Add template Button

select template name which we made in previous screen (ie Test Travel Req) And Submit. 6.Finally you can see the result at iProcurement Page

select the Request Type : Test Travel Req

(9)

you can see above information in following table select * from POR_TEMPLATE_INFO

REALMS

Oracle iProcurement, securing attributes called realms are used to restrict requester access to the catalog. or

Realms are securing attributes used to control access to the catalog as an additional layer for application security

ICX_POR_REALM_ID -->Use this attribute to secure the responsibility for category or item source realms.

Once you create a realm, you assign it to a responsibility or user. The requester associated with that responsibility or user can see whatever categories or item source catalogs are contained in that realm.

STEPS:

1. Create the realm. 2. Assign the realm to a responsibility. 3. Optionally assign realms to individual users if desired.

Create the Realm:

1.Log in to Oracle Purchasing And Navigate Setup > E-Catalog Admin > Realms. 2.in window enter your own Name and Description for the realm.

component Type : Category

components: select any existing Category.

3. Save your work Realm Id Generated automatically.

Assign the Realm to a Responsibility:

1.Log on to Sysadmin

2.Open the Responsiblities window

3.Query the responsibility to which you will assign the realm.(Ex: iProcurement) 4.n the Name field, use the LOV to select ICX_POR_REALM_ID.

5. Click on Values Button In the Values Button Select the Relam ID 6. And Save your Changes.

(10)

Assign the Realm to Users (Optional):

1.Log on to Sysadmin.

2.Navigation path: Security > User >Define.

3.Query the user (person) to whom you want to assign the realm.

4.In the Securing Attributes tabbed region,in the Attribute field, use the LOV to select

5.In the Securing Attributes tabbed region, create a line for each realm you want to assign to the user. Select ICX_POR_REALM_ID in the Name field and the Realm ID for each realm. 6. Save your work.

RESULT.

Categories restricted by realms display to requesters when browsing categories;however, the items in those categories do not display.

How to Get Debug XML Publisher

How to Get Debug XML Publisher ?

Setting up the debug mode for the program .In the program definition there is a debug flag Parameter, set this to 'Y'. To do this • Login as 'System Adminstrator'

• Navigate to: Concurrent -> Program -> Define • Query up the program shortname XDOREPPB • Click on Parameters

• Scroll down for "Debug Flag

• Enable this by clicking on the check option. • In the Validation block, set the Default Value = Y

Create a xdodebug.cfg Under following Dir $AF_JRE_TOP/lib on concurrent manager node add following 2 lines

LogLevel=STATEMENT

LogDir=/tmp/xdodebug.err (Dir must exist in the file system) run the concurrent program again

There will be a bunch of files in the 'LogDir' specified in the xdodebug.cfg file Please delete the xdodebug.cfg file afterwards

(11)

Why XML Publisher and what are the advantages of XML Publisher?

In simple words, for easy generation of reports. The following are the advantages of XML Publisher: 1.Main advantage is Data separation and Presentation.

2.Rapid development of Report 3.Cost reduction

4.Control over Report Layout and High customization 5.Different presentation tools.

6.Output in the format of one’s choice. posted by Rama at 3:04 PM | 0 Comments

How to make the column title needs to be on each page

How to make the column title needs to be on each page?

Highlight the table header rowRight click and select table propertiesOn the Row tab, specify that the header row should be repeated on every pageSave your work.

Multiple Headers and Footers

Microsoft Word does not allow form fields in the header and footer regions of a document. If you require many or complex objects in the header or footer of your report create a template within your template, simply wrap the contents of the internal template with the following tags:

internaltemplate name is the name you assign to the header/footer template. posted by Rama at 2:54 PM | 0 Comments

Calling a XML Publisher report from FND_SUBMIT_REQUEST

Calling a XML Publisher report from FND_SUBMIT_REQUEST

Here is the code that you can used for submiting XML Report Publisher from within my Oracle Report's AfterReport trigger

Syntax:

a:=FND_REQUEST.SUBMIT_REQUEST('XDO', 'XDOREPPB','Rama XML Test Report Printing', NULL, FALSE, :P_CONC_REQUEST_ID , 'MYONT','MY_PREPACK_XML','en-US' ,'N', 'RTF',

:p_output_format,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL );

(12)

posted by Rama at 2:30 PM | 0 Comments

Common Problems in XML Publisher

Common Problems in XML Publisher 1) R U New to XML Publisher

You have two different types of XML Publisher:- the one integrated with ORacle eBS- the standalone version, see link

Go thru ,XML guide provided by Oracle,It will be sufficient

Link: http://www.oracle.com/technology/products/xml-publisher/index.html

How to install a font using XML Publisher Administrator?

In XML Publisher 5.6 has a new tab: Administration fonts can be uploaded and stored in the database instead of stored on the file system.

To install a font requires only a few steps 1. Log in as XML Publisher Administrator.

2. Navigate to Administration->Font Files->Create Font File.

3. Fields are Font Name and File. For Font Name choose any descriptive name. File will browse your PC to locate the font file.

4. Navigate to Font Mappings->Create Font Mapping Set. 5. Mapping name is the name you will give to a set of fonts. 6. Mapping code is the internal name you will give to this set.

7. Type: 'PDF Form' for PDF templates. 'FO to PDF' for all other template types. 8. Create Font Mapping (this allows you to add multiple fonts to a set).

9. 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 runtime.

10. Style and weight must also match how you use the font in windows.Normal and Normal are good defaults. 12. Navigate to Configuration General-> FO Processing->Font Mapping Set. Can also be done at data def and template level under Edit Configuration. Hierarchy is Site-> Data Def -> Template.

13. Select your new mapping set.

14. Make sure the font is not referenced under File->Properties->Custom in the RTF template file. 15. Upload a template that uses your special font and test using preview.

posted by Rama at 12:37 PM | 0 Comments

Common Problems in XML Publisher

(13)

Creating Data Definition Example: Creating Template Example:

posted by Rama at 12:18 PM | 0 Comments

Registering RTF Template in Oracle applications

How to Registering RTF Template in Oracle applications. 1)Register your Template in the Template Manager.

2)Register your Data Definition In Data Definition Manager.

a)Creating Data Definition.

log on to Oracle apps Xml Publisher Responsibily. click on Home ->Data Definitions then click on create Date Definition. and fill the all mandatory fields

Name : Name of the Report (XML Publisher Test Report) code : Concurrent prof Short Name (XX_XML_TEST_RP) Application: Name of the Application.(Order Management) Start date: today date (09-Oct-2006)

(14)

Then Click on Apply Button. b)Creating Template

Select the Templates Tab click on Create Template Tab Name : Name of the Report (XML Publisher Test Report) code : Concurrent prof Short Name (XX_XML_TEST_RP) Data Definition:Name of the Report (Data Definition name) Type:RTF

Application: Name of the Application.(Order Management) Start date: today date (09-Oct-2006)

Description:XML Publisher Test Report

File: click on browse Tab update your RTF file here. Language:English

Territory:United States

Then Go to OM responsibiliy Run the XML Publisher Test Report see the PDF out put.

Note :Before Runing XML Publisher Report Assign XML Publisher prog into OM responsibily. Commonly Used XML Tags in Template

1) Holds the opening for-each loop for the item element. 2) Closing tag of the for-each loop.

3) The opening of the if statement to test for the attribute value "PRIVATE". 4) Ends the if statement.

5) sort a group by any element within the group. 6) Sort Multiple Group of elements

7) To establish nested groupings within the already defined group

8)mailto:?for-each-group@cell:currentgroup(); Uses the regrouping syntax to group the data by YEAR 9)

10) date format mask:

Variable Declaration

Use this element to declare a local or global variable. XSL Syntax:

XML Publisher Tag: Example:

(15)

Assigns the value "red" to the "color" variable. The variable can then be referenced in the template.

Cell Highlighting

1000?> -->

• The above tag embeds native XSL code

• The "attribute" element allows you to modify properties in the XSL.

• The xdo:ctx component is an XML Publisher feature that allows you to adjust XSL attributes at any level in the template

• To change the color attribute, you can use either the standard HTML names (for example, red, white, green) or you can use the hexadecimal color definition (for example, #FFFFF).

posted by Rama at 10:24 AM | 0 Comments

(16)

Thursday, October 12, 2006

posted by Rama at 3:25 PM | 0 Comments

XML Publisher supports two methods for creating RTF templates:

1)Basic RTF Method 2)Form Field Method

Creating an RTF template file consists of two basic steps: Design your template layout.

Use the formatting features of your word processing application and save the file as RTF. Mark up your template layout.

Insert the XML Publisher simplified tags.

The Template Builder is an extension to Microsoft Word that simplifies the development of RTF

templates.XML Publisher converts the formatting that you apply in your word processing application to XSL-FO.

Enter placeholders in your document using the following syntax:

There are two ways to insert placeholders in your template:

Basic RTF Method: Insert the placeholder syntax directly into your template document.

Form Field Method: (Requires Microsoft Word) Insert the placeholder syntax in Microsoft Word’s Text Form Field Options window.

(17)

Use Microsoft Word’s Text Form Field Options window to insert the placeholder tags: 1. Enable the Forms toolbar in your Microsoft Word application.

2. Position your cursor in the place you want to create a placeholder.

3. Select the Text Form Field toolbar icon. This action inserts a form field area in your document.

4. Double-click the form field area to invoke the Text Form Field Options dialog box. 5. (Optional) Enter a description of the field in the Default text field. The entry in this field will populate the placeholder’s position on the template.

For the example, enter "Supplier 1". 6. Select the Add Help Text button.

7. In the help text entry field, enter the XML element’s tag name using the syntax:

Oracle XML Publisher

What is Oracle XML Publisher?

Oracle XML Publisher is a template-based publishing.It provides a new approach to report design.The flexibility of XML Publisher is a result of the separation of the presentation of the report from its data structure. XML Publisher provides the Template Manager to register and maintain report templates and their data sources. The Template Manager is the repository for your templates and data sources. Creating customized reports using XML Publisher can be divided into two

phases:

Design Time and Runtime.

Design Time

Register the E-Business Suite report as a Data Definition in the Template Manager.Design your template.

Register your Template in the Template Manager.Add desired translations of your RTF template. posted by Rama at 11:42 AM | 0 Comments

Wednesday, October 11, 2006

Oracle Applications Technical Articles

How to Restart or Bounce Apache in Oracle Apps 11i

Please find the two commands that I use for bouncing the Apache

1)$COMMON_TOP/admin/scripts/$TWO_TASK*/adapcctl.sh stop2)$COMMON_TOP/admin/scripts/$TWO_TASK*/adapcctl.sh start

(18)

In case you have modified any java or class file in OAF ,XML Document and AK Developer then Apache bounce becomes mandatory.

How to find Report Belongs to particular Request Group use the following query.

SELECT frg.request_group_name ,frt.description ,frg.request_group_code ,frg.description FROM fnd_request_groups frg, fnd_concurrent_programs_tl frt WHERE frg.application_id=frt.application_id

AND frt.user_concurrent_program_name='Process Pending Payments' this will give Request Group name and description.

Overview of Concurrent Manager

A concurrent manager is itself a concurrent program that starts other concurrent programs. This document explains how to start up, define, and configure concurrent managers.. Concurrent Managers are defined and assigned one or more work shifts .You can issue commands to start, verify, shut down, or reset concurrent managers individually or use the ICM to control every manager at once .It is recommended that you restart an individual concurrent manager every time

Starting the ICM:

Follow the steps outlined below to start the ICM during installation of Oracle Applications, after shutdown of concurrent managers, or after restarting your operating system or database.

· Log in to the UNIX server as applmgr

· Select the appropriate database environment · Use the following command: Startmgr

By default, the ICM periodically monitors each concurrent manager’s processes. You can force this monitoring activity, also known as PMON by selecting the ICM and choosing the Verify button. Below is a summary listing of the concurrent managers and their functions

1.Internal Concurrent Manager (ICM)

Starts up, verifies the status of, resets, and shuts down theIndividual managers. Settings for the ICM cannot be altered.

2.Standard Manager

Runs 365 days a year, 24 hours a day and accepts any and all requests. It has no specialization and should NOT be altered

Note: If the Standard manager is altered in any way, some programs may not run. We recommend that you define additional managers to handle client-specific needs.

3.Conflict Resolution Manager

The Conflict Resolution Manager resolves conflicts, such as request incompatibilities. The Conflict Resolution Manager checks concurrent program definitions for incompatibility rules. If a program is identified as Run Alone, then the Conflict Resolution Manager prevents the concurrent managers from starting other programs in the same conflict domain. When a program lists other programs as being incompatible with it, the Conflict Resolution Manager prevents the program from starting until any incompatible programs in the same domain have completed running.

(19)

Scheduler/Prereleaser manager.

5.Transaction Manager for diagnostics only Transaction Manager for diagnostics only.

---REALMS

Oracle iProcurement, securing attributes called realms are used to restrict requester access to the catalog.

or

Realms are securing attributes used to control access to the catalog as an additional layer for application security

ICX_POR_REALM_ID -->Use this attribute to secure the responsibility for category or item source realms.

Once you create a realm, you assign it to a responsibility or user. The requester associated with that responsibility or user can see whatever categories or item source catalogs are contained in that realm. STEPS:

1. Create the realm.

2. Assign the realm to a responsibility.

3. Optionally assign realms to individual users if desired. Create the Realm:

1.Log in to Oracle Purchasing And Navigate Setup > E-Catalog Admin > Realms. 2.in window enter your own Name and Description for the realm.

component Type : Category

components: select any existing Category.

3. Save your work Realm Id Generated automatically. Assign the Realm to a Responsibility:

1.Log on to Sysadmin

2.Open the Responsiblities window

3.Query the responsibility to which you will assign the realm.(Ex: iProcurement)

4.n the Name field, use the LOV to select ICX_POR_REALM_ID. 5. Click on Values Button In the Values Button Select the Relam ID 6. And Save your Changes.

(20)

Assign the Realm to Users (Optional): 1.Log on to Sysadmin.

2.Navigation path: Security > User >Define.

3.Query the user (person) to whom you want to assign the realm.

4.In the Securing Attributes tabbed region,in the Attribute field, use the LOV to select ICX_POR_REALM_ID.

5.In the Securing Attributes tabbed region, create a line for each realm you want to assign to the user. Select ICX_POR_REALM_ID in the Name field and the Realm ID for each realm.

6. Save your work. RESULT.

Categories restricted by realms display to requesters when browsing categories;however, the items in those categories do not display.

Concept of Oracle Workflow

A workflow consists of numerous processes reprents business process flows and information.Each workflow process contains a set of activities,notifications,PL/SQL stored procedures or another sub process

Workflow Components

it contains 6 major components. 1.workflow Builder

provides a graphical user interface for creating and maintaing definations. 2.workflow Engine

is the component that executes and enforces the defined workflow process 3.workflow Monitor

Component of oracle workflow that allows you to review the state or status 4.workflow Definitions Loader

is the component that allows you to download or load workflow definitions to and from the date base or test files.

5.Notification System.

the notification mailer is a program that concurrently sends emails and receive responses. 6. workflow Directory Services

work flow Dir services is the component that identifies the directory repository.

(21)

function variables.

Itemtype -->A category of items that share the same set of attributes.

itemkey--> A unique key identifier within the same item type for specific item passing actid ---> the unique identifier of the activity that calls this stored procedure.

Result--> the result of the stored procedure can be Complete:Result_code

DEFERRED:date ERROR:Error_code Notified:notification_Id Waiting

The format of stored procedure declaration will be PROCEDURE your_procedure(

itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, result out varchar2) Is

in funcmode variable to execute codes that correspond to the RUN,CANCEL and TIMEOUT modes. APIs

inside the stored procedure you must use workflow Engine APIs to communicate with workflow engine. All workflow Engine APIs present inside the WF_ENGINE package.

API'S inside the WF_ENGINE

SetItemAttrText set the value of a text item attribute.

SetItemAttrNumber set the value of a number Item attribute. SetItemAttrDate set the value if a date item attribute

GetItemAttrInfo Get type information about an item attribute CreateProcess create a new rntime process for an item StartProcess Begins execution of the process.

Remain I will Update soon

Oracle Forms Personalization

Oracle has introduced a mechanism which revolutionizes the way the forms can be customized to fulfill the customer needs.Oracle Applications has provided a custom library using which the look and behavior of the standard forms can be altered, but the custom library modifications require extensive work on SQL and PL/SQL.Oracle Applications release 11.5.10 has provided a user interface “Personalization form” which will be used to define the personalization rules.

By default the “Personalize” menu is visible to all the users; this can be controlled with help of profile options.By setting up the below profile options,access to the Personalize menu can be limited for the authorized users.

Utilities: Diagnostics = Yes/No Hide Diagnostics = Yes/No

(22)

invoking the Personalization form click on “Help -> Diagnostics -> Custom Code -> Personalize”

The form mainly contains four sections.

• Rules • Conditions • Context • Actions

Rules:

Each rule contains a sequence number and the description. The rule can be activated or de-activated using the “Enabled” checkbox.

Conditions

Conditions decide the event the rule to be executed. Each condition mainly contains three sections i.e. Trigger Event, Trigger Object and Condition..

Context

Context manages to whom the personalization should apply. This is similar to the concept of using profile options in Oracle Application

Actions

Actions decide the exact operation to be performed when the conditions and context return true during the runtime.

(23)

3.Enter the sequence number as 10 and description as “Change the Order Type Prompt to Claim Type”

4.Select the Trigger Event as “WHEN-NEW-FORM-INSTANCE” 5.Select or enter the following values under Context section • Level = Responsibility

• Value = Order Management Super User

On Actions tab, enter or select the following values • Sequence = 10

• Type = Property

• Description = Order Type to Claim Type • Language = All

(24)

Click on “Apply Now” button

Close both the forms and reopen the Sales Order form

The Order Number label should reflect as Claim Number

(25)

Forms Personalization-Moving to another instance

Download for a specific form:

FNDLOAD / 0 Y DOWNLOAD FND_TOP/patch/115/import/affrmcus.lct FND_FORM_CUSTOM_RULES form_name=

Download all personalizations

FNDLOAD / 0 Y DOWNLOAD FND_TOP/patch/115/import/affrmcus.lct FND_FORM_CUSTOM_RULES

Upload

FNDLOAD / 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct

OM Tables

Order Management Tables. Entered

oe_order_headers_all 1 record created in header table oe_order_lines_all Lines for particular records oe_price_adjustments When discount gets applied

oe_order_price_attribs If line has price attributes then populated

oe_order_holds_all If any hold applied for order like credit check etc. Booked

oe_order_headers_all Booked_flag=Y Order booked.

wsh_delivery_details Released_status Ready to release

Pick Released

wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)

wsh_picking_batches After batch is created for pick release.

mtl_reservations This is only soft reservations. No physical movement of stock

Full Transaction

mtl_material_transactions No records in mtl_material_transactions

mtl_txn_request_headers mtl_txn_request_lines

wsh_delivery_details Released to warehouse.

wsh_new_deliveries if Auto-Create is Yes then data populated.

wsh_delivery_assignments deliveries get assigned

Pick Confirmed

wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock

(26)

wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged

mtl_material_transactions On the ship confirm form, check Ship all box

wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped

oe_order_lines_all Shipped_quantity get populated.

wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip. oe_order_headers_all If all the lines get shipped then only flag N

Autoinvoice

wsh_delivery_details Released_status=I Need to run workflow background process. ra_interface_lines_all Data will be populated after wkfw process.

ra_customer_trx_all After running Autoinvoice Master Program for ra_customer_trx_lines_all specific batch transaction tables get populated

Price Details

qp_list_headers_b To Get Item Price Details. qp_list_lines

Items On Hand Qty

mtl_onhand_quantities TO check On Hand Qty Items.

Payment Terms

ra_terms Payment terms

AutoMatic Numbering System

ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.

Customer Information

hz_parties Get Customer information include name,contacts,Address and Phone hz_party_sites hz_locations hz_cust_accounts hz_cust_account_sites_all hz_cust_site_uses_all ra_customers Document Sequence

fnd_document_sequences Document Sequence Numbers

fnd_doc_sequence_categories fnd_doc_sequence_assignments Default rules for Price List

oe_def_attr_def_rules Price List Default Rules oe_def_attr_condns

(27)

End User Details

csi_t_party_details To capture End user Details

Sales Credit Sales Credit Information(How much credit can get)

oe_sales_credits

Attaching Documents

fnd_attached_documents Attched Documents and Text information

fnd_documents_tl

fnd_documents_short_text Blanket Sales Order

oe_blanket_headers_all Blanket Sales Order Information. oe_blanket_lines_all

Processing Constraints

oe_pc_assignments Sales order Shipment schedule Processing Constratins

oe_pc_exclusions Sales Order Holds

oe_hold_definitions Order Hold and Managing Details.

oe_hold_authorizations oe_hold_sources_all oe_order_holds_all Hold Relaese

oe_hold_releases_all Hold released Sales Order.

Credit Chk Details

oe_credit_check_rules To get the Credit Check Againt Customer. Cancel Orders

oe_order_lines_all Cancel Order Details.

How to Use Hint

Select /*+ HINT */ Ename from emp where empid=7856

Where HINT is replaced by the hint text.When the syntax of the hint text is incorrect, the hint text is ignored and will not be used

ALL_ROWS

The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a statement block with a goal of best throughput (that is, minimum total resource consumption).

FIRST_ROWS

(28)

of best response time (minimum resource usage to return first row). In newer Oracle version you should give a parameter with this hint: FIRST_ROWS(n) means that the optimizer will determine an executionplan to give a fast response for returning the first n rows.

CHOOSE

The CHOOSE hint causes the optimizer to choose between the rule-based approach and the cost-based approach for a SQL statement based on the presence of statistics for the tables accessed by the statement RULE

The RULE hint explicitly chooses rule-based optimization for a statement block. This hint also causes the optimizer to ignore any other hints specified for the statement block. The RULE hint does not work any more in Oracle 10g.

Hints for Access Paths

FULL

The FULL hint explicitly chooses a full table scan for the specified table. The syntax of the FULL hint is FULL(table) where table specifies the alias of the table (or table name if alias does not exist) on which the full table scan is to be performed.

ROWID

The ROWID hint explicitly chooses a table scan by ROWID for the specified table. The syntax of the ROWID hint is ROWID(table) where table specifies the name or alias of the table on which the table access by

ROWID is to be performed. (This hint depricated in Oracle 10g) CLUSTER

The CLUSTER hint explicitly chooses a cluster scan to access the specified table. The syntax of the CLUSTER hint is CLUSTER(table) where table specifies the name or alias of the table to be accessed by a cluster scan.

HASH

The HASH hint explicitly chooses a hash scan to access the specified table. The syntax of the HASH hint is HASH(table) where table specifies the name or alias of the table to be accessed by a hash scan.

HASH_AJ

The HASH_AJ hint transforms a NOT IN subquery into a hash anti-join to access the specified table. The syntax of the HASH_AJ hint is HASH_AJ(table) where table specifies the name or alias of the table to be accessed.(depricated in Oracle 10g)

INDEX

The INDEX hint explicitly chooses an index scan for the specified table. The syntax of the INDEX hint is INDEX(table index) where:table specifies the name or alias of the table associated with the index to be scanned and index specifies an index on which an index scan is to be performed. This hint may optionally specify one or more indexes:

NO_INDEX

The NO_INDEX hint explicitly disallows a set of indexes for the specified table. The syntax of the NO_INDEX hint is NO_INDEX(table index)

INDEX_ASC

The INDEX_ASC hint explicitly chooses an index scan for the specified table. If the statement uses an index range scan, Oracle scans the index entries in ascending order of their indexed values.

INDEX_COMBINE

If no indexes are given as arguments for the INDEX_COMBINE hint, the optimizer will use on the table whatever boolean combination of bitmap indexes has the best cost estimate. If certain indexes are given as arguments, the optimizer will try to use some boolean combination of those particular bitmap indexes. The syntax of INDEX_COMBINE is INDEX_COMBINE(table index).

(29)

INDEX_JOIN

Explicitly instructs the optimizer to use an index join as an access path. For the hint to have a positive effect, a sufficiently small number of indexes must exist that contain all the columns required to resolve the query. INDEX_DESC

The INDEX_DESC hint explicitly chooses an index scan for the specified table. If the statement uses an index range scan, Oracle scans the index entries in descending order of their indexed values.

INDEX_FFS

This hint causes a fast full index scan to be performed rather than a full table. NO_INDEX_FFS

Do not use fast full index scan (from Oracle 10g) INDEX_SS

Exclude range scan from query plan (from Oracle 10g) INDEX_SS_ASC

Exclude range scan from query plan (from Oracle 10g) INDEX_SS_DESC

Exclude range scan from query plan (from Oracle 10g) NO_INDEX_SS

The NO_INDEX_SS hint causes the optimizer to exclude a skip scan of the specified indexes on the specified table. (from Oracle 10g)

posted by Rama at 1:06 PM | 0 Comments

Display Module Wise Reports

Display Module Wise Reports

SELECT fa.application_short_name, fcpv.user_concurrent_program_name, description,

DECODE (fcpv.execution_method_code, 'B', 'Request Set Stage Function',

'Q', 'SQL*Plus', 'H', 'Host',

'L', 'SQL*Loader', 'A', 'Spawned',

'I', 'PL/SQL Stored Procedure', 'P', 'Oracle Reports',

'S', 'Immediate',

fcpv.execution_method_code ) exe_method,

output_file_type, program_type, printer_name, minimum_width, minimum_length, concurrent_program_name, concurrent_program_id FROM fnd_concurrent_programs_vl fcpv, fnd_application fa

WHERE fcpv.application_id = fa.application_id ORDER BY 1

SELECT fa.application_short_name,DECODE (fcpv.execution_method_code,'B', 'Request Set Stage

(30)

Reports','S', 'Immediate',fcpv.execution_method_code) exe_method,COUNT (concurrent_program_id) COUNT

FROM fnd_concurrent_programs_vl fcpv, fnd_application fa WHERE fcpv.application_id = fa.application_id

GROUP BY fa.application_short_name, fcpv.execution_method_code ORDER BY 1;

(31)

Purchase Order

Purchase Order Tables

1.PO_REQUISITION_HEADESR_ALL 2.PO_REQUISITION_LINES_ALL

When you raise the Requisition these tables effected (PO_REQUISITION_HEADER_ID) is the join between the tables

4.PO_REQ_DISTRIBUTION_ALL

It distribute the Requisition Account information.

5.PO_HEADERS_ALL (PO_HEADER_ID) 6.PO_LINES_ALL

When PO Created PO# stores in tables(PO_HEADER_ID) is the join for tables

7.PO_DISTRIBUTIONS_ALL

It will distribute the PO# Account information

8.PO_ACTION_HISTORY

Here you can get Approvals notification Status

9.PO_VENDORS_ALL(VENDOR_ID)

10.PO_VENDOR_SITES_ALL(VENDOR_SITE_ID)

11.PO_VENDOR_CONTACTS_ALL(VENDOR_CONTACT_ID)

Contacts Vendor ,Vendor site and conatct information

(Vendor_id,Vendor_contact_id,VEDNOR_SITE_ID)

12.RCV_SHIPMENT_HEADERS_ALL(SHIPMENT_HEADER_ID)

common information about the source of your receipts or expected receipts 13.RCV_SHPMENT_LINES_ALL

when you issue the recept The recepent number , Shipment location stores in the table. 14.RCV_TRANSACTIONS(TRANSACTION_ID)

15.MTL_MATERIAL_TRANSACTIONS(TRANSACTION_ID)

Stores material transaction information (Transaction_id)

16.PO_Release_all

TO see the which purchase order is released.

17.PO_AGENTS

contains information about buyers and purchasing managers.

18.PO_NOTIFICATION_CONTROLS

contains information about the notification control rules for blanket, planned, and contract purchase orders.

19.PO_APPROVAL_LIST_HEADERS

list of approvers for the purchasing document used for requisition approvals only

20.PO_APPROVAL_LIST_LINES

approval list lines for the requisition approval list.

21.PO_POSITION_CONTROLS_ALL

assignment of control groups to jobs and/or positions

22.PO_DOCUMENT_TYPES_ALL_B

default, control, and option information you provide to customize

23.PO_CONTROL_GROUPS_ALL

control groups you use in your business

(32)

Information about the set of suppliers assigned to a request for quotation (RFQ)

25.PO_VENDOR_LIST_HEADERS(VENDOR_LIST_HEADER_ID)

stores information about supplier quotation lists you create.

26.FINANCIALS_SYSTEM_PARAMS_ALL

This Tables stores common and default information between AP and PO

OM Flow and table level Information

Steps in Order Cycle:

1) Order Entry 2) Booking 3) Pick release :

For this we have to go to

Shipping Responsibilty Release sales order

Here In this form , In the ORDER tab, we have to enter ORDER Number And delete the Scheduled shipped Dates To & Requested Dates To.

In SHIPPING tab, set AUTO CREATE DELIVERY to YES. In INVENTORY tab enter WAREHOUSE, set AUTO ALLOCATE to YES and AUTO PICK CONFIRM to YES. IF we set AUTO PICK CONFIRM to NO, then We have to go for the following steps

1. go to Inventory Resp

Move order à Transact Move Order then it will ask for warehouse information. Give the same name as before [M2] In this form, In the HEADER tab, enter the BATCH NUMBER of the order that is picked .Then Click FIND Button. Click on VIEW/UPDATE Allocation, then Click TRANSACT button. Then Transact button will be deactivated then just close it and go to next step.

4) Shipping :

For this we need to go to Shipping Transaction Give the order Number, and click find Then we can see the order status.

Then we have to click DELIVERY Tab Button, in the Action LOV We have to choose, SHIP CONFIRM.

Then four concurrent program will run in the background.

Such As::

1.) INTERFACE TRIP Stop 2.) Commercial Invoice 3.) Packing Slip Report 4.) Bill of Lading

After this concurrent program will complete successfully, we have to run One more WORKFLOW BACKGROUND PROGRAM.

· If we don’t want to ship all the items, that are PICKED, then we have to click LINE/LPN tab , then click DETAIL button . Now, in that form , in the SHIPPING field, we have to enter how Much quantity of items, we want to ship . The rest remain quantity, that are Ordered will become backorder quantity .

5) Interfacing with AR :

After WORKFLOW BACKGROUND PROGRAM

(33)

AUTO INVOICE MASTER PROGRAM from

RECEIVABLE RESPONSIBILTY. After this program will complete successfully , we can the invoice details in

RECEIVALE à TRANSACTIONS à TRANSACTIONS. Here in This Form, we have to give our order number in reference field And query for the invoice details .Then we can see the invoice details.

Table Level Information:

==========================

Order Entry

• At the header level a record gets inserted into the header table OE_ORDER_HEADERS_ALL.

• At the line level, record(s) get inserted into the Line table OE_ORDER_LINES_ALL.

Order Booking

• This will update FLOW_STATUS_CODE value in the table OE_ORDER_HEADERS_ALL to “BOOKED”

• The FLOW_STATUS_CODE in OE_ORDER_LINES_ALL will change to AWAITING_SHIPPING.

• Record(s) will be created into the table WSH_DELIVERY_DETAILS with RELEASED_STATUS=’R’ (Ready to Release)

OE_INTERFACED_FLAG=’N’ (Not interfaced to OM) INV_INTERFACED_FLAG=’N’ (Not interfaced to Inv)

• Record(s) will be created into WSH_DELIVERY_ASSIGNMENTS but with DELIVERY_ID null.

Pick Release

---IF “Autocreate Delivery” option = “Yes” THEN

• ) Create a record into the table WSH_NEW_DELIVERIES

• ) Update WSH_DELIVERY_ASSIGNMENTS with DELIVERY_ID, thus • ) Update WSH_DELIVERY_DETAILS with RELEASED_STATUS=’Y

Auto Invoicing

---Before running “Autoinvoice Program”, record(s) will exist into the table RA_INTERFACE_LINES_ALL with

INTERFACE_LINE_CONTEXT = ’ORDER ENTRY’ INTERFACE_LINE_ATTRIBUTE1 = &Order_number INTERFACE_LINE_ATTRIBUTE3 = &Delivery_id SALES_ORDER = &Order_number

After running the “Auto invoice Program” for the order:

Records will be deleted from the table RA_INTERFACE_LINES_ALL and new details will be created into the following RA transaction tables. >RA_CUSTOMER_TRX_ALL with INTERFACE_HEADER_ATTRIBUTE1=&Order_number RA_CUSTOMER_TRX_LINES_ALL with INTERFACE_LINE_ATTRIBUTE1 = &Order_number SALES_ORDER = &Order_number

(34)

posted by Rama at 1:21 PM | 1 Comments

Know Current APPS Current Versions.

1)select product_version,patch_level from fnd_product_installations

Get current version ana Patch level information.

2)select * FROM V$VERSION Database Version infomation. 3)select * from v$instance

Instance details

4)select WF_EVENT_XML.XMLVersion() XML_VERSION from sys.dual;

Current XML Parser Version info.

5)select TEXT from WF_RESOURCES where TYPE = 'WFTKN' and NAME = 'WF_VERSION' Workflow version Number.

6)select home_url from icx_parameters

Oracle applications front end URL

7)SELECT VALUE FROM V$PARAMETER WHERE NAME=’USER_DUMP_DEST’

Get the Trace file location. 8) XML Publisher Vesion info.

$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class. Forward Declaration

PL/SQL allows for a special subprogram declaration called a forward declaration. It consists of the subprogram

specification in the package body terminated by a semicolon. You can use forward declarations to do the

following:

• Define subprograms in logical or alphabetical order.

• Define mutually recursive subprograms.(both calling each other). • Group subprograms in a package

Example of forward Declaration:

CREATE OR REPLACE PACKAGE BODY forward_pack IS

PROCEDURE calc_rating(. . .); -- forward declaration PROCEDURE award_bonus(. . .)

IS -- subprograms defined BEGIN -- in alphabetical order calc_rating(. . .); . . . END; PROCEDURE calc_rating(. . .) IS BEGIN . . . END; END forward_pack;

(35)

BIND Vs LEXICAL

BIND VARIABLE :

-- are used to replace a single value in sql, pl/sql

-- bind variable may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.

-- bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses.

LEXICAL REFERENCE:

-- you can use lexical reference to replace the clauses appearing AFTER select, from, group by, having, connect by, start with.

-- you can’t make lexical reference in a pl/sql statmetns. Flex mode and Confine mode

Confine mode

On: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects.

Flex mode:

On: parent borders "stretch" when child objects are moved against them. Off: parent borders remain fixed when child objects are moved against them.

Diff Between Implicit and Explicit Cursors

1) Implicit: declared for all DML and pl/sql statements. By default it selects one row only.

2) Explicit:Declared and named by the programmer.Use explicit cursor to individually process each row returned by a Multiple statements, is called ACTIVE SET. Allows the programmer to manually control explicit cursor in the

Pl/sql block

Execution Sequences of sql clauses.

a)Select….. b)Group by… c)Having… d)Orderby..

posted by Rama at 3:09 PM | 0 Comments performance problem in a Report Tune the Report Main Query

Create indexes on columns used in where condition (eliminate full table scan) set trace on in before report and set trace off in after report

(36)

srw.do_sql('alter session set sql_trace=true'); After Report:

srw.do_sql('alter session set sql_trace=false'); Trace file will be generated at location:

select value from v$parameter where name = 'user_dump_dest'; Get the trace file location path

see execution plans in a trace file, you need to format the generated trace file with tkprof statement.

Store Code statics in local drive.

posted by Rama at 2:58 PM | 0 Comments

Tuesday, July 10, 2007

APPS Key Concepts

a) None of GL module table contain "ORG_ID" Column. b) FND ->Oracle application foundations

c)ICX: Discoverer Launcher Get the discover Launcher URL

posted by Rama at 10:29 AM | 0 Comments

Wednesday, July 04, 2007

Account Receivables

Account Receivables 1)Payment Tables in AR

The following tables stores cash and misc information

a)AR_CASH_RECEIPTS_ALL(CASH_RECEIPT_ID) Stores 1 record for each receipt Entry

b)AR_CASH_RECEIPTS_HISTORY_ALL(CASH_RECEIPT_HISTORY_ID)

Stores all activities that is life cycle of receipt

c)AR_RECEIVABLES_APPLICATIONS_ALL(RECEIVABLES_APPLICATION_ID)

Stores Accounting information

D)AR_PAYMENT_SCHEDULES_ALL F)AR_DISTRIBUTIONS_ALL(SOURCE_ID) Stroes Account Distribution information Setup Tables

a)AR_RECEIPTS_CLASSES(RECEIPT_CLASS_ID)

Contains Receipt class information.

(37)

Stores Receipt information ,Automatic and manually created receipts c)AR_RECEIPTS_METHOD_ACCOUNTS

posted by Rama at 11:08 AM | 0 Comments

Tuesday, July 03, 2007

HRMS Date Track

Date Tracking

Date Tracking is a special feature in HRMS.important dynamic information in IS HRMS is date-tracked, including information about people, assignments, payrolls, compensation, and benefits.

When you log on to IS HRMS, your effective date is always today’s date.

To view information from another date or to make future-dated changes you must change your effective date.

The two DateTrack command icons on your window toolbar are:

• Alter Effective Date • View DateTrack History

When you update date-tracked information, you are prompted to choose between Update and Correction options. If you select Update, IS HRMS changes the record as of your effective date but preserves the previous information.

If you select Correction, IS HRMS overrides the previous information with your new changes.You cannot create a record and then update it on the same day. If you try to do this, IS HRMS warns you that the old record will be overridden, and then changes Update to Correction. This occurs because DateTrack maintains records for a minimum of a day at a time.

View DateTrack History

To see all the changes made to a datetracked record over time, use DateTrack History. Click on [Full History] if you want to open a DateTrack History folder showing the value of each field between the from and to dates.

posted by Rama at 11:47 AM | 0 Comments

Monday, July 02, 2007

Account Paybles Tables

Account Paybles Tables

1)Invoice Details.

a)Ap_invoices_all(INVOICE_ID)

You can see the approved Invoices.

(38)

To get Distributed Invoices information.

2)Invoice Transactions

a)ap_ae_headers_all(AE_HEADER_ID) b)ap_ae_lines_all

Stores Distributed Accounting information. 3)Payment Schedule Information

a)ap_payment_schedules_all(INVOICE_ID)

Stores Amount remaing information and schedule payments for an invoice. b)ap_invoice_payments_all(INVOICE_ID,CHECK_ID)

After compleing invoice payment information stores here.

4) Check Information.

a)ap_checks_all(CHECK_ID)

if you done the payment via check this information stores here. b)AP_CHECK_FORMATS(Check_format_id)

When you create the invoice ie assciated with accouting infomation that information stores in this table. c)AP_MC_INVOICES(invoice_id,set_of_book_id)

Contains Multiple invoice Currency information as well as Exchange Information. d)AP_HOLDS_ALL

Holds invoice information you places

f)AP_CHRG_ALLOCATIONS_ALL

Used for AP links with the appropriate invoice distributins. 5)Approval information

a)AP_INV_APRVL_HIST_ALL(Approval history id,invoice_id) Invoice approval information

b)AP_HISTORY_INVOICES_ALL(Invoice_id,VENDOR_iD) All invoice history information stores here

c)AP_INVOICE_TRANSMISSIONS(JE_BATCH_ID) When you post the invoice to GL This table will effected.

6)Terms

a)AP_TERMS_TL(TERMS_ID) Contains Term information.

b)AP_INTERFACE_REJECTIONS

which could not be processed by Payables Open Interface Import c)AP_BANK_ACCOUNTS_ALL

information about bank accounts

What is the interface?

Interface Table is a table which is used as medium for transfer of data between two systems. What is INBOUND and OUT BOUND? (Different types of interfaces)

Inbound Interface:

For inbound interfaces, where these products are the destination, interface tables as well as supporting validation, processing, and maintenance programs are provided.

Outbound Interface:

For outbound interfaces, where these products are the source, database views are provided and the destination application should provide the validation, processing, and maintenance programs What is multi org?

(39)

“Legal entity has more than one operating unit is called as multi org” a) Business group --- Human resources information is secured by Business group

b) Legal entity. --- inter-company and fiscal/tax reporting. Security responsibility operating unit.

c) Operating unit --- secures AR, OE, AP, PA and PO Information. d) Organizations --- is a specialize unit of work at particular locations

What are the User PARAMETERS in the Reports? P_CONC_REQUEST_ID

P_FLEX_VALUE FND USER

EXITS:-FND SRWINIT sets your profile option values, multiple organizations and allows Oracle Application Object

Library user exits to detect that they have been called by an Oracle Reports program.

FND SRWEXIT ensures that all the memory allocated for AOL user exits have been freed up properly.

FND FLEXIDVAL are used to display flex field information like prompt, value etc

FND FLEXSQL these user exits allow you to use flex fields in your reports

FND FORMAT_CURRENCY is used to print currency in various formats by using formula column

What are the requests groups?

a) Single request: - this allows you to submit an individual request. b) Request set : - this allows you to submit a pre-defined set of requests.

Difference between Bind and Lexical parameters?

BIND VARIABLE :

are used to replace a single value in sql, pl/sql bind variable may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.

bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses. LEXICAL REFERENCE:

you can use lexical reference to replace the clauses appearing AFTER select,

from, group by, having, connect by, start with. you can’t make lexical reference in a pl/sql statmetns. update clause:

1) use explicit locking to deny access for the duration of a transaction 2) lock the rows before update or delete

Ex : select ……. From…….

For update[ of column ref] [no_wait] where current of clause?

1) use cursor to update or delete the current row Where current of <>

What is the package?

Group logically related pl/sql types, items and subprograms. 1. package specification

2. package body

(40)

A. Modularity

B. Easier Application Design C.Information Hiding

Overloading

You cannot overload:

•Two subprograms if their formal parameters differ only in name or parameter mode. (datatype and their

total number is same).

•Two subprograms if their formal parameters differ only in datatype and the different datatypes are in the

same family (number and decimal belong to the same family)

•Two subprograms if their formal parameters differ only in subtype and the different subtypes are based

on types in the same family (VARCHAR and STRING are subtypes of VARCHAR2) •Two functions that differ only in return type, even if the types are in different families.

What are triggers?

triggers are similar to procedures, in that they are the named pl/sql blocks with declarative,executable and exception-handling sections, how ever a procedure is executed explicitly from another block via a procedure call, which can also pass arguments.

A trigger is executed implicitly when ever a particular event task places. And is nothing but a event. The triggering event is a DML (insert, update, delete) operations on a data base table

fires whenever a data event(such as DML) or system event(such as login or shutdown) occurs on a schema or database

Trigger timing : 1) before

2) after

3) instead of ( this is used for views)

events : 1) insert 2)update 3) delete Trigger type : 1) statement level 2) row level.

Firing sequence of database triggers

1. before statement trigger 2. before row trigger 3. after row trigger 4. after statement trigger

LOCKS?

Is to reduce concurrency 1) share lock

it allows the other users for only reading not to insert 2) exclusive lock

only one user can have the privileges of insert or others can only read.

(41)

multiple user can read, update delete Lock levels :

1) table level 2) table space 3) data base level. What are ad-hoc reports?

Ans.: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query

posted by Rama at 10:07 AM | 5 Comments

Tuesday, August 28, 2007

AOL features in OM

Order Management uses the following AOL features

Document Sequences - Order Entry used Order Number Sources for order numbering. It let you define sequences that were used to automatically number Orders and Returns. You assigned an Order Number source to an Order Type.

Order Management uses the AOL Document Sequences feature to meet Order Numbering requirements. This lets you number Order and Returns

using Manual, Automatic or Gapless sequences.You can define Document Sequences using the AOL Define Document Sequences form. When you define an Order Transaction Type, the application automatically creates a Document Sequence Category of the same name. You can assign a pre-defined sequence to one or more Document Sequence Categories, using the AOL Sequence Assignments

form. When an Order is created, Order Management calls AOL Document Sequence APIs to number the Order.

Attachments - In Order Entry you could define Notes and addition rules regarding when they were attached to an Order or Line. You had to manually choose to add the eligible Notes to the Order or Line. You could also define how the Notes were printed on various Reports. Database triggers were used to duplicate Note definition data in AOL.

Order Management drives off the AOL Attachment functionality enabling you to attach images and web pages (in addition to short or long text). It also offers multi-lingual Document capability.

Attachment definition and usage data is stored only in AOL. Automatic Addition rule definitions are stored in Order Management

(OE_ATTACHMENT_RULES,OE_ATTACHMENT_RULE_ELEMENTS). In addition to the attributes

(Customer, Ship-to, Invoice-to, Order Type, Item, PO #) that were previously available, you can now define rules based on the Order Category,Line Category and Line Type.

Oracle Order Management - Sales Order

The Profile Option ‘OM: Apply Automatic Attachments’ determines whether rule based attachments are automatically applied

(42)

How to Download Etrm PDF format files

Use the following :

http://appsre.us.oracle.com/11idoc/11.5.1/html/trmset.html

posted by Rama at 10:54 AM | 0 Comments

Tuesday, August 21, 2007

Information Templates In PO

Oracle Internet Procurement 11i uses information templates to pass necessary order processing

information to suppliers. You may set up information templatesto gather additional informationWhen an information template is assigned to a category or item, Internet Procurement 11i prompts users to provide the information specified in the template

To define an information template:

1. Navigate to the Define Information Template window. From the Oracle Purchasing menu, select Setup>Information Templates.

2. Enter an attribute name and description. The attribute name is the actual field prompt that is displayed in Internet Procurement 11i.

3. Optionally, enter a default value to automatically appear in the field.

4. Indicate whether the field is mandatory for Internet Procurement 11i users. If the field is mandatory, users will be prompted to enter a value in the field before proceeding to complete the requisition.

5. Indicate whether to activate the attribute to actually display on Self

Service Purchasing pages. In certain circumstances, you may want to define an attribute, but delay enabling it for display to Internet Procurement 11i users.

6. Choose Associate Template to associate the template with an item or an item category. The Information Template Association window appears.

7. Select the type of association (item number or item category) you want to associate with the template.

8. If you selected Item Number in the previous step, enter the number. If you selected Item Category, enter the category.

posted by Rama at 7:41 PM | 0 Comments

General Ledger FAQ

What is Journal Import?

A)Journal import is an interface used to bring journal entries from legacy systems and other modules into the General Ledger.(Specifically Journal Import gets entries from legacy data into the GL base tables.

(43)

The tables populated during journal Import are

GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES,

GL_IMPORT_REFERENCES

What is the use of GL_Interface?

A) Gl_Interface is the primary interface table of General ledger. It acts as an interface between data originating from other modules such as AP,AR, Legacy data and the Gl Base tables.

What is Actual Flag?

A)Actual flag represents the Journal type.

A-Actual B-Budget

E- Encumbrance.

What is Encumbrance?

A)It is a process of Reservation of funds for anticipated expenditure from a budget. Encumbrance integrates GL, Purchasing and Payables modules.

How many Key Flex Fields are there in General Ledger?

A)One. Accounting Key Flex Field.

How many types of Budgets are there?

A)Two Types.

Expenditure Budgets Revenue Budgets.

What are Spot Rate, Corporate Rate, Transaction Calendar and Accounting Calendar?

Spot Rate:

An exchange rate which you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of currency.

Corporate Rate:

An Exchange rate that we define to standardize rates for our company. This rate is the standard market rate determined by the senior financial management for use through out the organization.

User Rate:

Conversion rate that is defined by the user.

EMU Fixed Rate: An exchange rate that is provided automatically by the General Ledger while entering journals. It uses a foreign currency that has a fixed relationship with the euro.

Transaction Calendar: Defines the business days and holidays for any calendar.

Accounting Calendar: Defines different types of calendars namely Fiscal, Federal Fiscal, Month etc.

What is Security Rule?

References

Related documents

Whoever, having coin in his possession with respect to which the offence defined in section 246 or 248 has been committed, and having known at the time when he became possessed of

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions.. Start

 The latent image is formed in the silver halide emulsion of the negative sheet.. And the positive image formed due to migration of Ag ions from the negative

SAVINGS: 1,200 pounds of carbon dioxide per 10% garbage reduced 6 Switch to green power – switch to energy generated by.. clean, renewable sources such as wind and solar

• The only femtosecond laser commercialized to date for cataract surgery indication..

International SOS shall not provide services enumerated if the coverage is sought as a result of: participation in any war, invasion, acts of foreign enemies, hostilities

From a consumer perspective we have our Growth and Specialist Brands – these are the key assets in our portfolio and we’ll continue to focus on building the contribution they make

In case the new tile size does not exceed the maximum size, the state vector is added to the tile, and the original state in the global hash table is marked old.. As mentioned,