Wednesday, September 8, 2010

Setup an Invoice Batch

Advantages of Invoices Batches

1. Enter invoice defaults at the batch level that override system or supplier site defaults for all invoices in the batch.

2. Maximize accuracy by tracking variances between the control invoice count and total and the actual invoice count and total resulting from your invoice entry.

3. Easily locate a batch online and review the name of the person who created the batch and the date it was created.

Responsibility: Payables, Vision Operations (USA)
Navigation: Invoices > Entry > Invoice Batches

APP-SQLAP-10199: You cannot navigate to the Invoice Batches window because batch control is not enabled for your system.

If you want to enable invoice batch control for your system, then ask your system administrator to enable the profile option AP: Use Invoice Batch Controls in the System Profile Options window.

Profile Option

AP: Use Invoice Batch Controls

YES -> Create the Invoice with batch
NO  -> Create the Invoice without batch.

To enter an Invoice Batch

1. In the Invoice Batches window enter a unique value in the Invoice Batch Name field. This name will appear on your reports and will help you locate the batch online.

2. Enter the number of invoices in the batch in the Control Count field.

Enter the sum of invoice amounts in the batch in the Control Total field. Payables tracks variances between the Control Count and Total and the Actual Count and Total as you enter invoices.

Note: If there is a discrepancy between the invoice amount and batch amount, Payables warns you when you exit a batch but it does not prevent Invoice Validation and payment of the individual invoices within a batch. You can make a correction immediately, or you can adjust the invoice batch later.

3. Enter any Invoice Defaults you want for the invoices. Defaults include: Currency, Type, Document Category, Hold Name, Liability Account, Payment Terms, Pay Group, GL Date, and Hold Reason.

These values you enter for defaults override any system and supplier site defaults for the invoices. For example, if you want the purchase order to provide the default value for Payment Terms on the invoice, then leave the Payment Terms field here blank. When you enter individual invoices you can override any values that default from the batch.

4. Choose the Invoices button and enter the invoices.

Responsibility: Payables, Vision Operations (USA)
Navigation: Invoices > Entry > Invoice Batches
Batch Name: ABC Batch

Invoice Batch Created Successfully.

Tuesday, September 7, 2010

Create a 1099 Supplier

Responsibility: Purchasing, Vision Operations (USA)
Navigation: Supply Base > Suppliers > Entry > Create Supplier

Type : Standard Supplier
Organization Name : Computer Consulting Services
Taxpayer ID : 555-22-1560


Navigate to Organization

Type : Supplier


Navigate to Tax Details

Reportable : Federal [CHECK]


Navigate to Invoice Management

Invoice Currency : US dollar
Hold from Payment : All Invoices [CHECK]
Payment Hold Reason : Enter any valid Hold Reason [1099 Supplier]
Payment Currency : US dollar
Terms : 30 Net
Terms Date Basis : Invoice
Pay Group : ABC PAY (Which you created on earlier session)

Create a Supplier Site (for Income Tax Reporting)

Navigate to Address Book


Address Line 1 : 1st Main Road
City : Half Moon Bay
County : San Mateo
State : CA
Postal Code : 94019
Address Name : Half Moon Bay
Phone Area Code : 650
Phone Number : 555-1234
Address Purpose : Payment [CHECK]


Created Supplier site successfully.

Navigate to Tax and Reporting

Main Information

Allow Tax Applicability [CHECK]

Income Tax Reporting Site [CHECK]


Remove the Payment Hold for 1099 Supplier

Remove the Payment Hold for 1099 supplier while the 1099 supplier has returned a complete 1099 tax verification letter.

Responsibility: Payables, Vision Operations (USA)
Navigation: Suppliers > Entry > Search: Supplier Name = Computer Consulting Services

Navigate to Invoice Management

Hold from Payment, All Invoices [UNCHECK]


A 1099 Supplier created successfully.

Monday, September 6, 2010

Create a Supplier

a) Create a New Pay Group

Pay Group: A feature you use to select invoices for payment in a payment batch.

When you create a payment batch, you can choose a Pay Group to pay a category of suppliers or invoices at the same time. You define Pay Groups for suppliers and supplier sites in the Payables QuickCodes window. Examples of Pay Groups you may define are employees, merchandise, non-merchandise, government, domestic, and international.

Responsibility: Purchasing, Vision Operations (USA)
Navigation: Setup > Purchasing > Lookup Codes

Query the pay group lookup code "PAY GROUP"

Enter the new pay group code

Code : ABC PAY
Meaning : ABC PAY
Description : ABC Paygroup

b) Create a Supplier

Responsibility: Payables, Vision Operations (USA)
Navigation: Suppliers > Entry

Create a Supplier

Organization Name: ABC Corporation


Navigate to Company Profile > Organization

Type : Manufacturing


Navigate to Terms and Control > Tax and Reporting

Allow Tax Applicability : Check


Navigate to Purchasing

Create Debit Memo from RTS Transaction : Check

NOTE: Enable the Create Debit Memo From RTS Transaction option if you want the system to automatically create a Debit Memo in Payables when you enter a Return to Supplier (RTS) in Purchasing. The value for supplier site defaults from the purchasing options window.


Navigate to Receiving

Receipt Routing : Standard Receipt (Requires: Standard receipt, Deliver)
Match Approval Level : 3-Way
Allow Substitute Receipts : Check


Navigate to Invoice Management

Invoice Currency : USD (US dollar)
Invoice Match Option : Purchase Order

Payment Currency : USD (US dollar)
Terms : Immediate
Pay Group : ABC PAY (Which you created on earlier)
Always Take Discount : Check


Navigate to Payment Details

Payment Method: Electronic : Check


This creates the basic supplier.

c) Create a Supplier Sites

Navigate to Address Book

Enter the valid Address details.

Address Line1 : 1st Main Road
State : CA
Postal Code : 94109
Address Name : SAN FRAN
Addressee : SAN FRAN
Phone Area Code : 415
Phone Number : 555-1234
Address Purpose : [Check] Payment



This creates the basic supplier site.

To UPDATE the supplier site attributes to click "MANAGE SITES"

[Check] Pay, Primary Pay


Notification Method : Print


PAY SITE Successfully created.

Create a Purchasing Site

Navigate to Address Book [Click to Create]

Address Line1 : 520 Madison Avenue
County : NEW YORK
State : NY
Postal Code : 10022
Address Name : NEW YORK
Addressee : NEW YORK
Phone Area Code : 212
Phone Number : 555-7703
Address Purpose : [Check] Purchasing



Address and Site Creation - Unable to create address and sites because of the following error when trying to create the site in operating unit [Vision Operations]: [ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site]. Either resolve this issue and try again or deselect the operating unit with the error and continue. Note: any new address requires at least one site in order to be created.

Cause: Addressee

Dealing with "Addressee"

Addressee field is potentially used to assist with the interface with iStore.A ddressee is used when an order is made by a customer and is shipped somewhere else. It is just like you purchase a book and have it shipped to your friend . Your friend becomes the addressee at the address that the book is sent to. Therefore you can use ADDRESSEE column to store an alternative displayed name which can be used in place of the party name on mailing labels or other external documents.

The usage of this column may vary in different applications within Oracle EBS.

Oacle Shipping

Oracle Shipping will display the column on mailing label for ship to customer when the customer account owning party is a party of party type PERSON.

Oracle OM

Order Management may display the column in a sales order along with the customer name (from party name), ship to org name (from customer site use simplifying the process of creating the on-time ship to address.

Oracle CRM Product

CRM iStore will use the column to display the person name in a personal address book since CRM consider that it is a huge overhead to create a party record for each person in a personal address book.

Technical Reference

TCA table HZ_PARTY_SITES parking the column data in ADDRESSEE field.


Remove Addressee / Enter Valid one.



Successfully created a Supplier with Sites. (Purchasing & Pay)

Sunday, September 5, 2010

Employee Hierarchy Process

Run the Fill Employee Hierarchy process to add people to the position hierarchy. This is necessary for approvals to work correctly when using a position hierarchy.

Responsibility: Purchasing, Vision Operations
Navigation: Requests > Submit a single request

Name: Fill Employee Hierarchy

Check the LOG file (If any error occurs.)

Saturday, September 4, 2010

Buyer Setup

Responsibility: Purchasing, Vision Operations (USA)
Navigation: Setup > Personner > Buyer

Add Buyer


Quick select your employee (Which you have created on earlier)
Ship To : M1 - Seattle


Buyer setup successfully done.

Friday, September 3, 2010

Create a New User

Responsibility: System Administrator
Navigation: Security > User > Define

Enter user name, password (2 times), person (Which you have created on earlier)

Add responsibilities ...

1. Application Developer
2. System Administrator

and etc ...

A New user created successfully.

Thursday, September 2, 2010

Create a New Employee

Responsibility : Human Resources, Vision Enterprises
Navigation : People > Enter and Maintain


Enter the Last, First Names, Title, Gender.
Choose the Action : Create Employment
Social Security Number : [XXX-XX-XXXX]

If you get "This social security number already exists. Continue?"
Click OK or enter other SSN.

Date of Birth : DD-MON-YYYY


If you get this, Choose No Match


Click "Assignment" Button

Organization : Vision Operations

If POP-UP window appears choose the CORRECTION 

People Group : Finance.
Job : MGR500.Manager
Position : MM400.Materials Manager

[YES] accept the Default Values

Location : M1 - Seattle


Name : Brown, Ms. Casey

[Purchase Order Information] Tab Page

Ledger : Vision Operations (USA)
A/C Alias : Employee Expanse
Default Exp A/c : 01-110-6100-0000-000
(Or) Accept the Default Expense Account Values


If the below note appears. Just CANCEL it, otherwise the location will change M1 -> HR

A new EMPLOYEE created successfully.

Wednesday, September 1, 2010

R12 Oracle Payables Management Fundamentals

1. Create a New Employee
(Create the new employee and assigning the assignment, etc.)
more @

2. Create a New User
(Create the new application user and link with employee, buyer info, assing responsibnility, etc.)
more @

3. Buyer Setup
(Set yourself as a buyer)
more @

4. Employee Hierarchy Process
(Run the Fill Employee Hierarchy process to add people to the position hierarchy. This is necessary for approvals to work correctly when using a position hierarchy.)
more @

5. Create a Supplier
(Create a Pay Group, Supplier, Supplier Sites, Site Contacts, etc)
more @

6. Create a 1099 Supplier
(Create a 1099 Supplier, etc)
more @

7. Setup an Invoice Batch
(Batch all invoices for this Supplier in this batch)
more @

Friday, April 23, 2010

How to change the order/arrangement of multi records block?

Normally, multi records are displaying in vertical navigation style. (Like from Left to Right)

How to change the arrangement into horizontal (like Top to bottom)?



Tuesday, February 16, 2010

How to invoke another form in oracle apps form?

In Oracle Applications, we can use FND_FUNCTION.EXECUTE instead of CALL_FORM / OPEN_FORM


                    (function_name  IN varchar2,
                     open_flag      IN varchar2 default ’Y’,
                     session_flag   IN varchar2 default ’SESSION’,
                     other_params   IN varchar2 default NULL,
                     activate       IN varchar2 default ’ACTIVATE’,
                     browser_target IN varchar2 default NULL);


Execute the specified form function; only executes functions that have a form attached.



Monday, February 15, 2010

How do use the same LOV for 2 form fields?

We can achieve by passing the return values in global values / parameters and using the values in the code.

in another way ... we can create the diff LOV with the same Record groups

Monday, January 11, 2010

How to submit the concurrent request from shell scripts?

CONCSUB utility used for submit the concurrent request from shell scripts. CONCSUB are described in the "System Administration User Guide" as follow:

$ CONCSUB {APPS username}/{APPS password} \
{responsibility application short name} \
{responsibility name} \
{username} \
[WAIT=N|Y{n seconds}] \
{program application short name} \
{program name} \
[PROGRAM_NAME={description}] \
[REPEAT_TIME={resubmission time}] \
[REPEAT_INTERVAL= {number}] \
[REPEAT_INTERVAL_UNIT={resubmission unit}] \
[REPEAT_INTERVAL_TYPE={resubmission type}] \
[REPEAT_END={resubmission end date and time}] \
[START={date}] \
[IMPLICIT={ type of concurrent request} \
[{parameter 1} ... {parameter n}]

For parameters that follow the CONCURRENT parameter and include spaces, enclose the parameter argument in double quotes, then again in single quotes.

More details @ Meta link ID 457519.1

Friday, January 8, 2010

Setting Organization Context in Oracle R12 and 11i

Release 12

apps.mo_global.set_policy_context ('S', org_id_value);

11i Releases

DBMS_APPLICATION_INFO.set_client_info (client_info => 'org_id_value');
--------------- or----------
fnd_global.initialize (NAME => 'ORG_ID', VALUE => 'org_id_value');

Meaning of table's suffix