DFF Customization

1)Open the form where DFF is Implemented. and Query the Data

2)find the DFF name from Help Menu =>Diagnastcs =>Examine
Select $DESCRIPTIVE_FLEXFIELD$ in the Block field
select DFF name in the "Field"
we will get the DFF Title in the Value field.
Copy the DFF title

3)goto Application Developer Responsibility.
flexfield=>Descriptive=>register

4)Query the records by using the DFF Title.
Select columns button and find wether Attribute
columns are enabled or disabled.

5)Goto Segments form and Query the records by using Title.

6)Uncheck the Check box called "freeze Flexfield Defination"

7)Select Segents button and enter the new fields and save transactions.

8)Check the check box called "freeze Flexfield Defination"
and click the Compile Button.

9)System will change the DFF structure and creates
a descriptive flexfield View.

chk

TABLE REGISTRATION

TABLE REGISTRATION:
NOTE: CONNECT TO CUSTOM Schema (WIP) --WIP/WIP@PROD

1)CREATE TABLE CUSTOM_VENDORS

2) GRANT ALL ON CUSTOM_VENDORS TO APPS;

3) CONN APPS/APPS@PROD

4) CREATE PUBLIC SYNONYM CUSTOM_VENDORS FOR PO.CUSTOM_VENDORS;

5) EXEC AD_DD.REGISTER_TABLE ('PO','CUSTOM_VENDORS','T', 8, 10, 90);

6) EXEC AD_DD.REGISTER_COLUMN ('PO','CUSTOM_VENDORS','VENDOR_ID', 1,'NUMBER', 10,'N','Y');

NOTE: REGISTER ALL COLUMNS

7)COMMIT;


VALUE SETS
WHO COLUMNS
FLEXFIELD (DFF,KFF)

SQL loader exexution

1)Connect to Scott schema create temp table
2)Prepare the data file having some sample records save in the local mechine.
3)Develop the control file like follows.

load data
infile 'C:\22\LOAD\EMP.txt'
INSERT INTO TABLE EMP_DETAILS22
fields terminated by ','
(empno ,
ename ,
sal ,
job ,
comm ,
tax ,
deptno ,
jdate)

Note: Save the file extension as ".ctl".

4)Goto Command Propmt through Start Menu = Run = > CMD
5)Connect to following path and execute the control file
D:\Oracle\Proddb\8.1.7\Bin\SQLLDR Scott/Tiger@PROD
Control = C:\22\LOAD\emp_details.ctl

6)test the data in the Table.

Report Registration Steps

Report Registration Steps:
--------------------------
1)Develop the report (.rdf)as per client Requirement by using reports 6i Builder

2)Move the report from Local mechine into Server
CUS_TOP\11.5.0\Reports\US\ .rdf
PO_TOP\11.5.0\Reports\US\ .rdf

3)Select System Administrator and create EXECUTABLE
1)Executable Name
2)ApplicationName
3)Execution Method
4)Report(.rdf) file Name

4)Create Concurrent Program and attach 1)EXECUTABLE
2)PARAMETERS
3)INCOMPATIBILITIES
5)Create Request Group and attach Concurrent Program

6)Create Responsibility 1)Request Group
2)Data Group
3)Menu
7)Create user, attach Responsibility to the user.

8)User will select the Responsibility and goto SRS(Standard Request Submission) Window
submit the Request.


Navigations:
============

Executable = Concurrent=>Program=>Executable
Concurrent Program = Concurrent=>Program=>Define
Request Group = Security=>Responsibility=>Request
Responsibility = Security=>responsibility=>Define
User = Security=>User=>Define
SRS Window = View Menu=>Request =>Submit New request=>Ok=>Select Program
=>Submit=>No=>Find=>View Output

Report navigation

EXECUTABLE Window:
=======================
Executable : We can enter any User Defined Name in this field
ShortName : This is Primary key we have to enter Unique value
ApplicationName : Enter The Applications Name where the (.rdf) file is located
Description :It is Optional we can enter any valid Information
Execution Method :we have total 11 types of Execution methods select
"Oracle Reports" for Report Development.
Execution File Name : Enter the (.rdf) File Name without extension Name.


If we know the Application Short Name we can find the Application name
by using following Navigation

Application =>Register=>Press F11=> Enter short Name => Press CTRL+F11

Concurrent Program Window:
=============================
Program : We can enter any User defined Program Name which is meaningful
Enabled Check Box : Once the Concurrent Program is created and saved We can not delete
Instead of delete we can disable by unchecking this check box.
ShortName : This is Primary key we have to enter Unique value
Application Name : We can enter Any Valid Application Name
Description : It is Optional we can enter any valid Information
EXECUTABLE : Enter the "Executable Short Name" whatever we have created
Method : System will automatically retrives the Execution MEthod.

Format : we can select whatever the format we would like to print

Ex: HTML (.html)Internet Explorer
pdf (.pdf) Acrobat Reader
Postscript (.ps) GhostView
text (.txt) Text Pad
PCL HP Printer Language
XML (.xml) XML Publisher

Save check Box : System will save the Output and Log file details in the server
COLUMNS : No of Columns to print per page in the Output file
ROWS : No of Rows to print per page in the Output file

SELECT LOGFILE_NAME,
OUTFILE_NAME
FROM FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID =1424277

Request Group :
================
Request group is nothing but collection of Concurrent Programs and Reports we can group
All concurrent Programs.
Group :Enter Any User Defined Name (This is Case sensitive we have to maintain Capital and
Small Letters)

Application Name :Enter Any Valid Application Name

Attach Concurrent Program by select type as Program.

Responsibility Window:
======================

Responsibility is nothing but Level of Authority which Combines Forms,Report and Application
User ID's.

Reponsibility Name : we can enter any meaningful Name
ApplicatioName :Enter any Valid Application Name
ResponsibilityKey :This is Primary enter the Unique Value

Data Group:
===========
data Group is nothing but Collection of Oracle Application UserID's.
it will be for Security purpose.(STANDARD will be used)
Application NAme :Enter any Valid Application Name

Request Group:
===============
Requset group is nothing but colletion of Concurrent Program
add the request group whatever we have created.
it will automatically retrieves the Application NAme.

MENU:
----
Menu : Menu is nothing but collection of Forms and Sub Menus
select any one of Existing Menu.

Note : Once we create the Responsibility we can not delete instead of that we can disable
by using Efective start Date and End date.

Default types

Current Date : Will be used to pass the Sysdate as default value
Current Time : Will be used to pass the Systime as default value
Constant : Will be used to pass the constant number or date or
string as default value
Segment : will be used to get the Previous parameter value as
default to the next parameter then we will use this.

Default type: segment Default Value :ParameterName

SQL Statement: We can pass the SELECT statement result as default
value
Default type : SQl Statement Default Value : SELECT MIN(USERID) FROM

Profile : This will be used to pass the user profile value as default
like userid ,username,respid,respname and so on.


Required ChekBox : This will be used to make the parameter as mandatory
or optional
Enabled CheckBox: will be used to enable or disable the parameter
Display CheckBox: will be used to hide or display the parameter.

SQL Loader

SQL * Loader :
==================
It is one of the Oracle Tool will be used to transfer the data from Flat files into
Oracle Base tables.
When we are developing the Interfaces or Conversion program in Oracle Applications
then we will be using the SQL Loader Programs.

while working with SQL * Loader we will come across 5 Files.

1)Flat File OR data File:

Data file contains the data in the specific format which we will receive from the
client. this file will be generated by the legacy system(Other Systems) program.
It may be either .txt format
.dat
.csv(Comma Separated View) Excell sheet.
Most of the times we will receive in the (.csv) format

2)Control File :
-----------------
Is nothing but a SQL*Loader Program will be used to load the data from file into table.
we will develop the control File
Execute the Control File.
While developing the Control file we will specify follwoing things.
1)Data File path
2)Database Table Name
3)Column Mapping.
Control file Extension is (.ctl)

3)Bad File:
-----------
when we execute the COntrol file if any records are rejected by SQL *Loader then we
will find those rejecteds record in the Bad file.
SQl loader recjects the records if there are any datatype mismatch
Internal Errors
Data file Format problem
Bad File Extension is (.bad)

4)Discard File:
---------------
when we execute the COntrol file if any records are rejected by Control File then we
will find those rejecteds record in the Discard file.
Control file Recjects the record when the record is not satisfying the record which
are not satisfied the condition specified in the Control file.
Discard File Extension is (.dis)

5)Log File :
-------------

It contains the Log information like Program start time,End Time
No of succesfully records upload
Rejected Records into the Bad file
Rejected records into the Discard file
Any errors are there in the Control file those error message details we will find.
Log file Extension is (.log)


Control File Syntax:
----------------------

LOAD DATA
INFILE 'Data File Path'
Insert into table
FIELDS TERMINATED by ',' OPTIONALLY ENCLOSED BY'"'
TRAILING NULLCOLS
(Column1 ,
column2 ,
column3 ,......)


Execution of Control File :
-----------------------------

Goto Command Prompt where the SQl loader is Installed.

D:Oracle\Proddb\8.1.7\bin\ SQLLDR Username/Password@PROD
Control = Control file Path.

PO -Setups

Item Creation:
====================
1)Attach the Responsibility called "Inventory Vision Operations (USA)"
2)Open the Items form
Items=>Master Item
3)Select the Organization name - Vision Operations
4)Enter the Item Name , Item Description
goto Inventory tab check the checkbox called Inventory
goto purchasing tab check the check box called Purchasing
5)Save
6)Goto Tools Menu => Organization Assignment option to assign for the multiple
organizations.


Supplier Creation:
========================
1)Attach the Responsibility called "Purchasing Vision Operations (USA)"
2)Goto the Supplier Form
Supply Base=>Suppliers
3)Enter the Supplier Name . Save supplier number will be created automatically.
4)Select the Sites button enter the supplier site address and other details
5)Goto the Contacts tab enter the Contact details
Name
Phno
Postion and so on.....


Buyer Creation:
==================

1)attach the Responsibility called "US HRMS Manager"
2)Create Employee
People => Enter and Maintain=>Select New button
3)Enter Emp name
select action option select "create Employement" select the optiona s "Buyer"
4)enter Data of Birth
save => Ok = > Empoyee number will be generated.
5)Goto System Administrator open the User form create or query user
select the Person field attach the emp name (Which we have created)
6)Save.
7)Goto Purchasing Responsibility
open the Buyers form
enter the employee name and save the transactions.
Setup => Personnal =>Buyers

Ex:


Suppliers Information Report

From Date FND_DATE
To Date FND_DATE
From Supplierno TABLE
To SupplierNo TABLE
Title 100 CHARACTERS

Sno Sname Cdate SiteCode Cdate ConctactPerson Phno
=== ==== ==== ======= ===== ============= ====


No of Sites : 2




Grand Totals : Total No of Suppliers
Total no of Sites
Toatl No of Contacts

Validation:

All parameters are optional if user not enter parameter then we have to retrieve all the
records.

PO Module

PO Application will be used to capture the purchasing information.
Oracle is developed pre defined forms and as well as Concurrent Programs and other
related programs.Client Directley can use those forms and Programs or client
can customize the existing objects(Forms,Reports,Programs)

During the PO application flow we can find the three types of people
1)Requestor : Employee who require the materials
2)Preparer : Employee who is going to prepare the Document
3)Buyer : Employee who is having the authority to purchase the materials from the
Suppliers.

Requisition: is one of the purchasing document will be prepared by the employee when
ever he required the materials or Services or Training and so on.
we have two types of Requisitions 1)Internal
2)Purchase

Internal requisition will be created if materials are receiving from another Inventory
inside of the organization.
Purchase requisition will be created while purchasing the materials from the Suppliers.

Requisitions=>Requisitions

We will enter the Requisition at three level 1)Header
2)Line
3)Distributions.

Open the Requisition form enter the Reqno and select the type at Header level
Enter the Items information at line level like Item name,qty,unitprice,tax and so on
select Distributions button enter the Distributions details.
Save
Select the Button called Approve button to go for approving the Requisition Document
Open the Requisition summary form.
Enter the Reqno select find button we can find the Requisition status wether it is
approved or not.
select Tools menu => View Action History to find the history details
Select Tools Menu =>Control option to Cancel the requisition.

RFQ Document:(Request For Quotation)
=============

Once the Requisition is Approved Buyer will prepare thre RFQ document which will be
delivered to the supplier. Supplier will respond for that with quotation.
we have Three types of RFQ documents

BID RFQ:This will be prepared for the secific fixed quantity and there won't be any
PriceBraeaks(Discounts).

catalog RFQ: This will be create for te materials which we will purchase from the
suppliers regularley , and large number of quantity. Here we can specify the
Price Breaks.

Standard RFQ: This will be prepared for the Items which we will purchase only once
not very often,Here we can include the Discounts information at different
auantity levels.
RFQ Information will be entered at 3 Level
1)Headers
2)Lines
3)Price Breaks(CATALOG,STANDARD) or Shippments (Only for Bid RFQ)

Terms And Conditions:
While creation of the RFQ documents we will select the Terms button and we will enter
the terms abd condition details.

Payment Terms: When Organization is going to make the payment and Interest rates
Fright Terms: Who is going to Bear the Tansportation chargers wether Buyer or Supplier
FOB(FreeOnBoard): If any materials damage or any missing quantity is there then the
the responsiboility of those materials.
Carrier : In which Transportation Company Organization Required Materials
Transportation company Name.

Open the RFQ Form

RFQ and Quotations=>RFQ's
select TYpe and Dates and so on
enter the Items details at line level
select terms button enter the Terms and Condition Details
Select the Price Braks button enter the Price break details
Save
Select the suppliers button enter the suplier details (Who are receiving this Document)
Select the Button called Add from List to Include the supplier list automatically.

Buyer Name : TABLE (Internally buyer ID should pass) - Optional



RFQNo Shipto
Type Billto
Due date Curr
Close date Total
creation date User(created_by)

Lineno Item UOM Price Shipno Qty Price Discount
-----

Quotations:
===========
Quotation is another purchasing document we will receive from the Supplier which
contains the supplier quote details , Price, Payment terms and so on.

Whatever the quotations we have received from the supplier we will enter in the system
through form.

We have three types of Quotations 1)Bid 2)Catalog 3)Standard

For Bid RFQ we will receive Bid quotation from the Supplier
For Catalog RFQ we will receive Catalog quotation from the Supplier
For Standard RFQ we will receive Standard quotation from the Supplier.

After enter all the quotations in the system management will do quote analysis as per
that one best quotation will be elected as Purchase Order.

Quotation Report

Item Name (Table Value set MTL_SYSTEM_ITEMS_B Segment1)

QuoteNo Type Cdate Supplier Site ContactPerson Buyer Created(UserName)



po_headers_all
po_lines_all
mtl_system_items_b
po_vendors
po_vendor_sites_all
po_vendor_contacts
per_all_people_f
fnd_user


Auto Create:
============
It is one of the Purchasing feature to create the RFQ and PO documents automatically
by using requisition lines.

1)Create Requisition and approve
2)Open the AutoCreate form
3)Select Clear button enter the RequisitionNO
4)Select find button which will shows all the requisition lines
select the lines whatever we want to include into the RFQ
5)select Action = Create to create new RFQ
AddTo to add lines to exisiting to RFQ
6)Select DocumentType = RFQ
7)select Automatic button which will create RFQ document automatically .

Purchase Order :
================
PO is one of the Main document which will be prepared and approved by the buyer and
send it to the supplier. which contains the following information
terms and Conditions
Items deails
Qty,Price
Distiribution and Shipment Details and so on.

We have four types of Purchase Order 1)STANDARD
2)PLANNED
3)BLANKET
4)CONTRACT

Purchase Orders=> Purchase Orders
Open the PO form enter the Inforamtion at header level select line level inforamtion
enter the items and quantity,price details
select shippments button enter the shippment details select the Distributions button
enter the Distribution Detauils.
Save
Select the Button called Approve (Uncheck Email Check Box) , Document will be submitted
for approval.
open the Purchase Order summary form enter PO number Select Find button we can find
the status of the Purchase order.
Goto Tools menu
Action History => We can find who hs submitted for Approve /Reject /Cancel details
Copy Document => To Create Another PO based on this PO
Control => To Close the Purchase Order or to cancel the Purchase Order.

Purchase Order Report
=====================

POno : Buyer:
Potype : Supplier:
ShipTo : Supplier Site:
BillTo : Contact :
Cdate : Status : POTotal :

payment Terms: Fright Charges: FOB: Carrier:

Lineno Item Desc Qty price Shipno ShiptoLoc ShipToOrg Qty Distno Distqty Requestor
----- ---- ---- --- ----- ------ -------- --------- --- ----- ------ ------





Receipt : Purchasing document will be created while receiving the items from the supplier

1)Direct Delivery
2)Standard
3)Inspection Required

Sunday, August 16, 2009

AP Module

1)Open the Invoice Form
Invoices => Enter=>Invoices

2)Enter the Supplier details,invoicetyps,data,amount
Save

3)Select Distributions button enter the Distribution Details.
Distamount and account and so on.
Save
Validate wether InvoiceAmount = Distribution Total Amount or not

4)Select Actions button check the Check box called Approve
press OK button for invoice approvals.

5)Select actions button again check the check box called Create Accounting to create
the accounting transaction

6)Select the Tools menu select the option called View Accounting option which will
displays the Accounting Transactions.

Transfer Invoice Data to GL:
============================

1)Once the Invoice is Validated
Approved
Accounted we can transfer to GL application

2)Goto SRS Window select the program called "Payables ransfer to General Ledger"
Enter Invoice From Date
To Date
Submit Journal Import = Yes
Transfer to GL interface = In Detail
PressOk

3)System will transfer the data from AP tables into GL Interface tables then
Journal Import program will be submitted automatically which will transfer the data
from Interface tables into the Base tables.

4)Copy the Request ID of Journal Import goto GL Application open the Journal form
Journal=>Entry
enter the %RequestID% in the Batch name field =>Selec Find button

5)Select the Review journal button will shows the Details Transactions
select MoreActions =>Post button to post the Journals.
Distrobution Set:
=================

Distribution set will be used to Distribute the Invoice amount automatically for the
different accounts .
1)Create the Distirbution Set
Setup=>Invoice=>Distribution Set

2)Goto Invoice form and create Invoice attach the Distribution set at header level
Save
Invoice amount will be distributed automatically to the diff accounts.

3)Select Distrtibutions button we can find the Transactions

4)Select Action button for Approval and For Create Accounting Transactions.



Payments:
=========

once the Invoice Create and Approved,Accounted are generated we can make
the Payments to the supplier by using Payments form

We have three types of Payments

Manuval
Quick
Refund


Manuval: If Organzation is going to pay the amount manuvally (by cheque or cash)
then it will be captured under the manuval payment type.

Quick : We will Give the Invoice number System will automatically genrate the
Payment transaction as per the Invoice number we have provided.
System will automatically generates the Cheque number also.

Refund : If any refundable amount we have to pay to the supplier or customer or emp
then those payments will be select as Refund method.


1)Copy the Invoice number

2)Goto the Payments form
Payments=>Entry=>Payments

3)Select Payment type,Bank Account number,Supplier details
select the button called Enter/Adjust Invoices
it will shows the invoices whcih are created for selected supplier
Select the Invoice number
Save

4)Select actions button check the check box called Create Accounting
will create Accountign transactions => Tools menu =View accounting

5)Select Actions button to print the Check as per the selecvted check Format.

6) We can cancel the payments by using the Check box called "Void".

Invoice Holds and Releases:
===========================

If Invoice is not approved (Ex : invoiceamt not equal to Distribution amount
Supplier Credit Limit is crossed)
then invoice will be on the hold

select Holds button which will shows the Invoice holds and release details

Subscribe to: Posts (Atom)

Followers

About Me

Amresh

View my complete profile

Blog Archive

• ►  2012 (2)
  • ►  May (2)

• ►  2010 (2)
  • ►  December (1)
  • ►  August (1)

• ▼  2009 (28)
  • ▼  August (11)
    • DFF Customization
    • chk
    • TABLE REGISTRATION
    • SQL loader exexution
    • Report Registration Steps
    • Report navigation
    • Default types
    • SQL Loader
    • PO -Setups
    • PO Module
    • AP Module
  • ►  July (17)

Weblinks

• Apps-Interview Questions
• Exforsys
• Anil Passi blog

Oracle Videos

• Accounting concepts
• Unix Shell Scripting
• SQL/PL-SQL
• Oracle performance tuning
• Oracle Architecture in 10 min

Labels

• AP Module (2)
• apps (1)
• chk (1)
• Context field (1)
• Default types (1)
• DFF Customization (1)
• DFF Process (1)
• flexfields (1)
• Interfaces (1)
• multiorg (1)
• Oracle (1)
• PO -Setups (1)
• PO Module (1)
• Procedure Registration (1)
• profile (3)
• profile Description (1)
• Qry Find (1)
• Report navigation (1)
• Reports with Perameters (1)
• request sets (1)
• Rollback Segment (1)
• SQL Loader (1)
• SQL loader exexution (1)
• TABLE REGISTRATION: (1)
• tablespace (1)
• User Creation (1)
• Value Set (1)