Query and Solution

Interface Programs in Oracle Apps

noreply@blogger.com (Umang Saini) — Wed, 03 Jul 2019 07:13:00 +0000

Interface/Conversion examples and details:

The below list of interfaces/conversions are covered in this section. Details like pre-requisites required, interface tables, interface program, base tables, validations that need to be performed after inserting the details into the interface tables and required columns that need to be populated in the interface table are discussed for each interface.

Order Import Interface (Sales Order Conversion)
Customer conversion
Item import (Item conversion)
Inventory On-hand quantity Interface
Customer conversion
Auto Invoice Interface
AR Receipts
Lockbox Interface
AP Invoices
Vendor
Purchase Orders
Requisition
Receiving
Journal import
Budget import
Daily Conversion Rates

Order Import Interface (Sales Order Conversion)
Order Import enables you to import Sales Orders into Oracle Applications instead of manually entering them.
Pre-requisites:
Order Type
Line Type
Items
Customers
Ship Method/ Freight Carrier
Sales Person
Sales Territories
Customer Order Holds
Sub Inventory/ Locations
On hand Quantity

Interface tables:
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_ACTIONS_IFACE_ALL
OE_ORDER_CUST_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL

Base tables:
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
Pricing tables: QP_PRICING_ATTRIBUTES

Concurrent Program:
Order Import
Validations:
Check for sold_to_org_id. If does not exist, create new customer by calling create_new_cust_info API.
Check for sales_rep_id. Should exist for a booked order.
Ordered_date should exist (header level)
Delivery_lead_time should exist (line level)
Earliest_acceptable_date should exist.
Freight_terms should exist

Notes:
During import of orders, shipping tables are not populated.
If importing customers together with the order, OE_ORDER_CUST_IFACE_ALL has to be populated and the base tables are HZ_PARTIES, HZ_LOCATIONS.
Orders can be categorized based on their status:
1. Entered orders
2. Booked orders
3. Closed orders
Order Import API OE_ORDER_PUB.GET_ORDER and PROCESS_ORDER can also be used to import orders.

Some important columns that need to populated in the interface tables:
OE_HEADERS_IFACE_ALL:
ORIG_SYS_DOCUMENT_REF
ORDER_SOURCE
CONVERSION_RATE
ORG_ID
ORDER_TYPE_ID
PRICE_LIST
SOLD_FROM_ORG_ID
SOLD_TO_ORG_ID
SHIP_TO_ORG_ID
SHIP_FROM_ORG_ID
CUSTOMER_NAME
INVOICE_TO_ORG_ID
OPERATION_CODE

OE_LINES_IFACE_ALL
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
ORIG_SYS_SHIPMENT_REF
INVENTORY_ITEM_ID
LINK_TO_LINE_REF
REQUEST_DATE
DELIVERY_LEAD_TIME
DELIVERY_ID
ORDERED_QUANTITY
ORDER_QUANTITY_UOM
SHIPPING_QUANTITY
PRICING_QUANTITY
PRICING_QUANTITY_UOM
SOLD_FROM_ORG_ID
SOLD_TO_ORG_ID
INVOICE_TO_ ORG_ID
SHIP_TO_ORG_ID
PRICE_LIST_ID
PAYMENT_TERM_ID

Item import (Item conversion)

The Item Interface lets you import items into Oracle Inventory.
Pre-requisites:
Creating an Organization
Code Combinations
Templates
Defining Item Status Codes
Defining Item Types

Interface tables:
MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE (If importing revisions)
MTL_ITEM_CATEGORIES_INTERFACE (If importing categories)
MTL_INTERFACE_ERRORS (View errors after import)

Concurrent Program:
Item import
In the item import parameters form, for the parameter ‘set process id’, specify
the ‘set process id’ value given in the mtl_item_categories_interface table. The
parameter ‘Create or Update’ can have any value. Through the import process, we
can only create item category assignment(s). Updating or Deletion of item category assignment is not supported.

Base tables:
MTL_SYSTEM_ITEMS_B
MTL_ITEM_REVISIONS_B
MTL_CATEGORIES_B
MTL_CATEGORY_SETS_B
MTL_ITEM_STATUS
MTL_ITEM_TEMPLATES

Validations:
Check for valid item type.
Check for valid part_id/segment of the source table.
Validate part_id/segment1 for master org.
Validate and translate template id of the source table.
Check for valid template id. (Attributes are already set for items, default attributes for
that template, i.e., purchasable, stockable, etc)
Check for valid item status.
Validate primary uom of the source table.
Validate attribute values.
Validate other UOMs of the source table.
Check for unique item type. Discard the item, if part has non-unique item type.
Check for description, inv_um uniqueness
Validate organization id.
Load master records and category records only if all validations are passed.
Load child record if no error found.

Some important columns that need to populated in the interface tables:
MTL_SYSTEM_ITEMS_INTERFACE:
PROCESS_FLAG = 1 (1= Pending, 2= Assign Complete,
3= Assign/Validation Failed, 4= Validation succeeded; Import failed, 5 = Import in Process,
7 = Import succeeded)
TRANSACTION_TYPE = ‘CREATE’, ‘UPDATE’
SET_PROCESS_ID = 1
ORGANIZATION_ID
DESCRIPTION
ITEM_NUMBER and/or SEGMENT (n)
MATERIAL_COST
REVISION
TEMPLATE_ID
SUMMARY_FLAG
ENABLED_FLAG
PURCHASING_ITEM_FLAG
SALES_ACCOUNT (defaulted from
MTL_PARAMETERS.SALES_ACCOUNT)
COST_OF_SALES_ACCOUNT (defaulted from MTL_PARAMETERS.
COST_OF_SALES_ACCOUNT)

MTL_ITEM_CATEGORIES_INTERFACE:

INVENTORY_ITEM_ID or ITEM_NUMBER.
ORGANIZATION_ID or ORGANIZATION_CODE or both.
TRANSACTION_TYPE = ‘CREATE’ (‘UPDATE’ or ‘DELETE’ is not
possible through Item Import).
CATEGORY_SET_ID or CATEGORY_SET_NAME or both.
CATEGORY_ID or CATEGORY_NAME or both.
PROCESS_FLAG = 1
SET_PROCESS_ID (The item and category interface records should have the
same set_process_id, if you are importing item and category assignment together)

MTL_ITEM_REVISIONS_INTERFACE:
INVENTORY_ITEM_ID or ITEM_NUMBER (Must match the item_number in mtl_system_items_interface table)
ORGANIZATION_ID or ORGANIZATION_CODE or both
REVISION
CHANGE_NOTICE
ECN_INITIATION_DATE
IMPLEMENTATION_DATE
IMPLEMENTED_SERIAL_NUMBER
EFFECTIVITY_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTEn
REVISED_ITEM_SEQUENCE_ID
DESCRIPTION
PROCESS_FLAG = 1
TRANSACTION_TYPE = ‘CREATE’
SET_PROCESS_ID = 1
Each row in the mtl_item_revisions_interface table must have the REVISION
and EFFECTIVITY_DATE in alphabetical (ASCII sort) and chronological
order.

Inventory On-hand quantity Interface

This interface lets you import the on hand inventory into Oracle.

Interface tables:
MTL_TRANSACTIONS_INTERFACE
MTL_MTL_TRANSACTION_LOTS_INTERFACE (If the item is Lot controlled)
MTL_SERIAL_NUMBERS_INTERFACE (If the item is Serial controlled)

Concurrent Program:
Launch the Transaction Manager through Interface Manager or explicitly call the API – INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS () to launch a dedicated transaction worker to process them.
The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, and PROCESS_FLAG. Only records with TRANSACTION_MODE of 3, LOCK_FLAG of ‘2’, and PROCESS_FLAG of ‘1’ will be picked up by the Transaction Manager and assigned to a Transaction Worker. If a record fails to process completely, then PROCESS_FLAG will be set to ‘3’ and ERROR_CODE and ERROR_EXPLANATION will be populated with the cause for the error.
Base Tables:
MTL_ON_HAND_QUANTITIES
MTL_LOT_NUMBERS
MTL_SERIAL_NUMBERS

Validations:
Validate organization_id
Check if item is assigned to organization
Validate disposition_id
Check if the item for the org is lot controlled before inserting into the Lots interface table.
Check if the item for the org is serial controlled before inserting into Serial interface table.
Check if inventory already exists for that item in that org and for a lot.
Validate organization_id, organization_code.
Validate inventory item id.
Transaction period must be open.

Some important columns that need to be populated in the interface tables:
MTL_TRANSACTIONS_INTERFACE:
TRANSACTION_SOURCE_NAME (ANY USER DEFINED VALUE),
TRANSACTION_HEADER_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL)
TRANSACTION_INTERFACE_ID (MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL – If item is lot or serial controlled, use this field to link to mtl_transactions_interface otherwise leave it as NULL),
TRANSACTION_DATE,
TRANSACTION_TYPE_ID,
PROCESS_FLAG (1 = Yet to be processed, 2 = Processed, 3= Error)
TRANSACTION_MODE (2 = Concurrent – to launch a dedicated transaction worker
to explicitly process a set of transactions.
3 = Background – will be picked up by transaction manager
polling process and assigned to transaction
worker. These will not be picked up until the
transaction manager is running)
SOURCE_CODE,
SOURCE_HEADER_ID,
SOURCE_LINE_ID (Details about the source like Order Entry etc for tracking purposes)
TRANSACTION_SOURCE_ID

Source Type	Foreign Key Reference
Account	GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
Account Alias	MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
Job or schedule	WIP_ENTITIES.WIP_ENTITY_ID
Sales Order	MTL_SALES_ORDERS.SALES_ORDER_ID

ITEM_SEGMENT1 TO 20,
TRANSACTION_QTY,
TRANSACTION_UOM,
SUBINVENTORY_CODE,
ORGANIZATION_ID,
LOC_SEGMENT1 TO 20.

MTL_TRANSACTION_LOTS_INTERFACE:
TRANSACTION_INTERFACE_ID,
LOT_NUMBER,
LOT_EXPIRATION_DATE,
TRANSACTION_QUANTITY,
SERIAL_TRANSACTION_TEMP_ID (This is required for items under both lot and serial control to identify child records in mtl_serial_numbers_interface)

MTL_SERIAL_NUMBERS_INTERFACE:
TRANSACTION_INTERFACE_ID,
FM_SERIAL_NUMBER,
TO_SERIAL_NUMBER,
VENDOR_SERIAL_NUMBER

Customer conversion

Customer Interface helps you create customers in Oracle Applications.
Interface tables:
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_PROFILES_INT_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMER_BANKS_INT_ALL
RA_CUST_PAY_METHOD_INT_ALL

Base tables:
RA_CUSTOMERS
RA_ADDRESSES_ALL
RA_CUSTOMER_RELATIONSHIPS_ALL
RA_SITE_USES_ALL

Concurrent program:
Customer Interface
Validations:
Check if legacy values fetched are valid.
Check if customer address site is already created.
Check if customer site use is already created.
Check is customer header is already created.
Check whether the ship_to_site has associated bill_to_site
Check whether associated bill_to_site is created or not.
Profile amounts validation:
Validate cust_account_id, validate customer status.
Check if the location already exists in HZ_LOCATIONS. If does not exist, create new location.

Some important columns that need to be populated in the interface tables:
RA_CUSTOMERS_INTERFACE_ALL:
ORIG_SYSTEM_CUSTOMER_REF
SITE_USE_CODE
ORIG_SYSTEM_ADDRESS_REF
INSERT_UPDATE_FLAG (I = Insert, U = Update)
CUSTOMER_NAME
CUSTOMER_NUMBER
CUSTOMER_STATUS
PRIMARY_SITE_USE_FLAG
LOCATION
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
STATE
PROVINCE
COUNTY
POSTAL_CODE
COUNTRY
CUSTOMER_ATTRIBUTE1
CUSTOMER_ATTRIBUTE2
CUSTOMER_ATTRIBUTE3
CUSTOMER_ATTRIBUTE4
CUSTOMER_ATTRIBUTE5
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
ORG_ID
CUSTOMER_NAME_PHONETIC

RA_CUSTOMER_PROFILES_INT_ALL:
INSERT_UPDATE_FLAG
ORIG_SYSTEM_CUSTOMER_REF
ORIG_SYSTEM_ADDRESS_REF
CUSTOMER_PROFILE_CLASS_NAME
CREDIT_HOLD
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATION_DATE
CREATED_BY
ORG_ID

RA_CONTACT_PHONES_INT_ALL:
ORIG_SYSTEM_CONTACT_REF
ORIG_SYSTEM_TELEPHONE_REF
ORIG_SYSTEM_CUSTOMER_REF
ORIG_SYSTEM_ADDRESS_REF
INSERT_UPDATE_FLAG
CONTACT_FIRST_NAME
CONTACT_LAST_NAME
CONTACT_TITLE
CONTACT_JOB_TITLE
TELEPHONE
TELEPHONE_EXTENSION
TELEPHONE_TYPE
TELEPHONE_AREA_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
EMAIL_ADDRESS
ORG_ID

Customer API

Trading Community Architecture (TCA) is an architecture concept designed to support complex
trading communities. These APIs utilize the new TCA model, inserting directly to the HZ tables.

API Details:

Set the organization id
Exec dbms_application_info.set_client_info(‘204’);
Create a party and an account
HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT()
HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
Create a physical location
HZ_LOCATION_V2PUB.CREATE_LOCATION()
HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
Create a party site using party_id you get from step 2 and location_id from step 3.
HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE()
HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
Create an account site using account_id you get from step 2 and party_site_id from step 4.
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE()
HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
Create an account site use using cust_acct_site_id you get from step 5 ans site_use_code = ‘BILL_TO’.
HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE()
HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

Base table:
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCOUNTS
HZ_CUST_SITE_USES_ALL
HZ_CUST_ACCT_SITES_ALL
HZ_PARTY_SITE_USES

Validations:
Check if legacy values fetched are valid.
Check if customer address site is already created.
Check if customer site use is already created.
Check is customer header is already created.
Check whether the ship_to_site has associated bill_to_site
Check whether associated bill_to_site is created or not.
Profile amounts validation:
Validate cust_account_id, validate customer status.
Check if the location already exists in HZ_LOCATIONS. If does not exist, create new location.

Auto Invoice interface

This interface is used to import Customer invoices, Credit memos, Debit memos and On Account credits.
Pre-requisites:
Set of Books
Code combinations
Items
Sales representatives
Customers
Sales Tax rate
Payment Terms
Transaction Types
Freight Carriers
FOB
Batch Sources
Accounting Rules

Interface tables:
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS
RA_INTERFACE_DISTRIBUTIONS
RA_INTERFACE_ERRORS (details about the failed records)

Base tables:
RA_BATCHES
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
AR_PAYMENT_SCHEDULES_ALL RA_CUSTOMER_TRX_LINE_SALESREPS
RA_CUST_TRX_GL_DIST_ALL
RA_CUSTOMER_TRX_TYPES_ALL

Concurrent Program:
Auto invoice master program
Validations:
Check for amount, batch source name, conversion rate, conversion type.
Validate orig_system_bill_customer_id, orig_system_bill_address_id, quantity.
Validate if the amount includes tax flag.

Some important columns that need to be populated in the interface tables:
RA_INTERFACE_LINES_ALL:
AGREEMENT_ID
COMMENTS
CONVERSION_DATE
CONVERSION_RATE
CONVERSION_TYPE
CREDIT_METHOD_FOR_ACCT_RULE
CREDIT_METHOD_FOR_INSTALLMENTS
CURRENCY_CODE
CUSTOMER_BANK_ACCOUNT_ID
CUST_TRX_TYPE_ID
DOCUMENT_NUMBER
DOCUMENT_NUMBER_SEQUENCE_ID
GL_DATE
HEADER_ATTRIBUTE1–15
HEADER_ATTRIBUTE_CATEGORY
INITIAL_CUSTOMER_TRX_ID
INTERNAL_NOTES
INVOICING_RULE_ID
ORIG_SYSTEM_BILL_ADDRESS_ID
ORIG_SYSTEM_BILL_CONTACT_ID
ORIG_SYSTEM_BILL_CUSTOMER_ID
ORIG_SYSTEM_SHIP_ADDRESS_ID
ORIG_SYSTEM_SHIP_CONTACT_ID
ORIG_SYSTEM_SHIP_CUSTOMER_ID
ORIG_SYSTEM_SOLD_CUSTOMER_ID
ORIG_SYSTEM_BATCH_NAME
PAYMENT_SERVER_ORDER_ID
PREVIOUS_CUSTOMER_TRX_ID
PRIMARY_SALESREP_ID
PRINTING_OPTION
PURCHASE_ORDER
PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
REASON_CODE
RECEIPT_METHOD_ID
RELATED_CUSTOMER_TRX_ID
SET_OF_BOOKS_ID
TERM_ID
TERRITORY_ID
TRX_DATE
TRX_NUMBER

Receipt API

To bring in Unapplied Receipts and Conversion Receipts for Open Debit items to reduce the balance to the original amount due.
Pre-requisites:
Set of Books
Code combinations
Items
Quick Codes
Sales representatives
Customers
Sales Tax rate

API:
AR_RECEIPT_API_PUB.CREATE_CASH
AR_RECEIPT_API_PUB.CREATE_AND_APPLY

Base tables:
AR_CASH_RECEIPTS
Validations:
Check the currency and the exchange rate type to assign the exchange rate.
Validate bill to the customer.
Get bill to site use id.
Get the customer trx id for this particular transaction number.
Get payment schedule date for the customer trx id.

Lockbox interface

AutoLockbox lets us automatically process receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.

AutoLockbox is a three step process:
1. Import: During this step, Lockbox reads and formats the data from your bank file
into interface table AR_PAYMENTS_INTERFACE_ALL using a SQL *Loader
script.
2. Validation: The validation program checks data in this interface table for
compatibility with Receivables. Once validated, the data is transferred into
QuickCash tables (AR_INTERIM_CASH_RECEIPTS_ALL and
AR_INTERIM_CASH_RCPT_LINES_ALL).
3. Post QuickCash: This step applies the receipts and updates your customer’s
balances.

Pre-Requisites:
Banks
Receipt Class
Payment Method
Receipt Source
Lockbox
Transmission format
AutoCash Rule sets

Interface tables:
AR_PAYMENTS_INTERFACE_ALL (Import
data from bank file)
AR_INTERIM_CASH_RECEIPTS_ALL
AR_INTERIM_CASH_RCPT_LINES_ALL (Validate data in interface table and place in quick cash tables)

Base Tables:
AR_CASH_RECEIPTS
AR_RECEIVABLES_APPLICATIONS
AR_ADJUSTMENTS
AR_DISTRIBUTIONS_ALL
AR_PAYMENT_SCHEDULES_ALL

Concurrent program:
Lockbox

Validations:
Check for valid record type, transmission record id.
Validate sum of the payments within the transmission.
Identify the lockbox number (no given by a bank to identify a lockbox).

Some important columns that need to be populated in the interface tables:
AR_PAYMENTS_INTERFACE_ALL:
STATUS
RECORD_TYPE
LOCKBOX_NUMBER
BATCH_NAME
TRANSIT_ROUTING_NUMBER
ACCOUNT
CHECK_NUMBER
REMITTANCE_AMOUNT
DEPOSIT_DATE
ITEM_NUMBER
CURRENCY_CODE
DEPOSIT_TIME

AP invoice interface

This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications.
Pre-requisites:
Set of Books
Code combinations
Employees
Lookups

Interface tables:
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

Base tables:
AP_INVOICES_ALL – header information
AP_INVOICE_DISTRIBUTIONS_ALL – lines info

Concurrent program:
Payables Open Interface Import

Validations:
Check for valid vendor
Check for Source, Location, org_id, currency_code’s validity
Check for valid vendor site code.
Check if record already exists in payables interface table.

Some important columns that need to be populated in the interface tables:
AP_INVOICES_INTERFACE:
INVOICE_ID
INVOICE_NUM
INVOICE_DATE
VENDOR_NUM
VENDOR_SITE_ID
INVOICE_AMOUNT
INVOICE_CURRENCY_CODE
EXCHANGE_RATE
EXCHANGE_RATE_TYPE
EXCHANGE_DATE
DESCRIPTION
SOURCE
PO_NUMBER
PAYMENT_METHOD_LOOKUP_CODE
PAY_GROUP_LOOKUP_CODE
ATTRIBUTE1 TO 15
ORG_ID

AP_INVOICE_LINES_INTERFACE:

INVOICE_ID
INVOICE_LINE_ID
LINE_TYPE_LOOKUP_CODE
AMOUNT
DESCRIPTION
TAX_CODE
PO_NUMBER
PO_LINE_NUMBER
PO_SHIPMENT_NUM
PO_DISTRIBUTION_NUM
PO_UNIT_OF_MEASURE
QUANTITY_INVOICED
DIST_CODE_CONCATENATED
DIST_CODE_COMBINATION_ID
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ORG_ID

Vendor conversion/interface

This interface is used to import suppliers, supplier sites and site contacts into Oracle applications.

Pre-requisites setup’s required:
Payment terms
Pay Groups
CCID
Supplier classifications
Bank Accounts
Employees (if employees have to set up as vendors)

Interface tables:
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT

Base Tables:
PO_VENDORS
PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS

Interface programs:
Supplier Open Interface Import
Supplier Sites Open Interface Import
Supplier Site Contacts Open Interface Import

Validations:
Check if vendor already exists
Check if vendor site already exists
Check if site contact already exists
Check if term is defined.

Some important columns that need to be populated in the interface tables:
AP_SUPPLIERS_INT:
VENDOR_NUMBER, VENDOR_NAME, VENDOR_TYPE, STATE_REPORTABLE, FED_REPORTABLE, NUM_1099, TYPE_1099, PAY_GROUP_LOOKUP_CODE, VENDOR_ID is auto generated.

AP_SUPPLIER_SITES_INT:
VENDOR_SITE_ID, ORG_ID, VENDOR_SITE_CODE, INACTIVE_DATE, PAY_SITE, PURCHASING_SITE, SITE_PAYMENT_TERM, ADDRESS1, ADDRESS2.ADDRESS3, CITY, STATE, COUNTRY, ZIP, PH_NUM, FAX_NUMBER, TAX_REPORTING_SITE_FLAG.

AP_SUP_SITE_CONTACTS_INT:
VENDOR_ID, VENDOR_SITE_ID, FIRST_NAME, LAST_NAME, AREA_CODE, PHONE, EMAIL, ORG_ID

Purchase Order conversion:

The Purchasing Document Open Interface concurrent program was replaced by two new concurrent programs Import Price Catalogs and Import Standard Purchase Orders. Import Price Catalogs concurrent program is used to import Catalog Quotations, Standard Quotations, and Blanket Purchase Agreements. Import Standard Purchase Orders concurrent program is used to import Unapproved or Approved Standard Purchase Orders.

Import Standard Purchase Orders
Pre-requisites:
Suppliers, sites and contacts
Buyers
Line Types
Items
PO Charge account setup

Interface Tables:
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_DISTRIBUTIONS_INTERFACE
PO_INTERFACE_ERRORS (Fallouts)

Interface Program:
Import Standard Purchase Orders.

Base Tables:
PO_HEADERS_ALL
PO_LINES_ALL
PO_DISTRIBUTIONS_ALL
PO_LINE_LOCATIONS_ALL

Validations:
Header:
Check if OU name is valid
Check if Supplier is valid
Check if Supplier site is valid
Check if buyer is valid
Check if Payment term is valid
Check if Bill to and ship to are valid
Check if FOB, freight terms are valid

Lines:
Check if Line_type, ship_to_org, item, uom, ship_to_location_id, requestor, charge_account, deliver_to_location are valid

General:
Check for duplicate records in interface tables
Check if the record already exists in base tables.

Some important columns that need to be populated in the interface tables:

PO_HEADERS_INTERFACE:
INTERFACE_HEADER_ID (PO_HEADERS_INTERFACE_S.NEXTVAL), BATCH_ID, ORG_ID, INTERFACE_SOURCE_CODE, ACTION (‘ORIGINAL’,’UPDATE’,’REPLACE’), GROUP_CODE, DOCUMENT_TYPE_CODE, PO_HEADER_ID (NULL), RELEASE_ID, RELEASE_NUM, CURRENCY_CODE, RATE, AGENT_NAME, VENDOR_ID, VENDOR_SITE_ID, SHIP_TO_LOCATION, BILL_TO_LOCATION, PAYMENT_TERMS

PO_LINES_INTERFACE:
INTERFACE_LINE_ID, INTERFACE_HEADER_ID, LINE_NUM, SHIPMENT_NUM, ITEM, REQUISITION_LINE_ID, UOM, UNIT_PRICE, FREIGHT_TERMS, FOB

PO_DISTRIBUTIONS_INTERFACE:
INTERFACE_LINE_ID, INTERFACE_HEADER_ID, INTERFACE_DISTRIBUTION_ID, DISTRIBUTION_NUM, QUANTITY_ORDERED, QTY_DELIVERED, QTY_BILLED, QTY_CANCELLED, DELIVER_TO_LOCATION_ID, DELIVER_TO_PERSON_ID, SET_OF_BOOKS, CHARGE_ACCT, AMOUNT_BILLED.

Import Blanket Purchase Agreements:
Interface Tables:
PO_HEADERS_INTERFACE
PO_LINES_INTERFACE

Interface program:
Import Price Catalogs

Base tables:
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL

Example:
Suppose you want to create a blanket with one line and two price breaks and the details for the price break are as below:
1) Quantity = 500, price = 10, effective date from ’01-JAN-2006′ to
’31-JUN-2006′
2) Quantity = 500, price = 11, effective date from ’01-JUL-2006′ to
’01-JAN-2007′
To create the above the BPA, you would create ONE record in PO_HEADERS_INTERFACE and THREE records in PO_LINES_INTERFACE
LINE1: It will have only the line information. LINE NUM would be 1.

LINE2: For the first Price Break details, LINE NUM will be the same as above i.e. 1. SHIPMENT_NUM would be 1 and SHIPMENT_TYPE would be ‘PRICE BREAK’

LINE3: For the second Price Break details, LINE NUM will be the same as above i.e. 1. SHIPMENT_NUM would be 2 and SHIPMENT_TYPE would be ‘PRICE BREAK’

All the line-level records above must have the same INTERFACE_HEADER_ID.

Requisition import

You can automatically import requisitions into Oracle Applications using the Requisitions Open Interface
Pre-requisites:
Set of Books
Code combinations
Employees
Items
Define a Requisition Import Group-By method in the Default region of the Purchasing
Options window.
Associate a customer with your deliver-to location using the Customer Addresses
window for internally sourced requisitions.

Interface tables:
PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL

Base tables:
PO_REQUISITIONS_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQ_DISTRIBUTIONS_ALL

Concurrent program:
REQUISITION IMPORT

Validations:
Check for interface transaction source code, requisition destination type.
Check for quantity ordered, authorization status type.

Some important columns that need to be populated in the interface tables:
PO_REQUISITIONS_INTERFACE_ALL:
INTERFACE_SOURCE_CODE (to identify the source of your imported
Requisitions)
DESTINATION_TYPE_CODE
AUTHORIZATION_STATUS
PREPARER_ID or PREPARER_NAME
QUANTITY
CHARGE_ACCOUNT_ID or charge account segment values
DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_
CODE
DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE
DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME
ORG_ID
ITEM_ID or item segment values (values if the SOURCE_TYPE_CODE or
DESTINATION_TYPE_CODE is ‘INVENTORY’)

PO_REQ_DIST_INTERFACE_ALL:
CHARGE_ACCOUNT_ID or charge account segment values
DISTRIBUTION_NUMBER
DESTINATION_ORGANIZATION_ID
DESTINATION_TYPE_CODE
INTERFACE_SOURCE_CODE
ORG_ID
DIST_SEQUENCE_ID (if MULTI_DISTRIBUTIONS is set to Y)

PO Receipts Interface
The Receiving Open Interface is used for processing and validating receipt data that
comes from sources other than the Receipts window in Purchasing.

Pre-requisites:
Set of Books
Code combinations
Employees
Items

Interface tables:
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE
PO_INTERFACE_ERRORS

Concurrent program:
RECEIVING OPEN INTERFACE

Base tables:
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS

Validations:
Check that SHIPPED_DATE should not be later than today.
Check if vendor is valid.
If Invoice number is passed, check for its validity
Check if Item is valid

Some important columns that need to be populated in the interface tables:

RCV_HEADERS_INTERFACE:
HEADER_INTERFACE_ID
GROUP_ID
PROCESSING_STATUS_
CODE
RECEIPT_SOURCE_CODE
TRANSACTION_TYPE
SHIPMENT_NUM
RECEIPT_NUM
VENDOR_NAME
SHIP_TO_
ORGANIZATION_CODE
SHIPPED_DATE
INVOICE_NUM
INVOICE_DATE
TOTAL_INVOICE_
AMOUNT
PAYMENT_TERMS_ID
EMPLOYEE_NAME
VALIDATION_FLAG (Indicates whether to validate a row or not, values ‘Y’, ‘N’)

RCV_TRANSACTIONS_INTERFACE:
INTERFACE_TRANSACTION_ID
GROUP_ID
TRANSACTION_TYPE (‘SHIP’ for a standard shipment (an ASN or ASBN)
or ‘RECEIVE’ for a standard receipt)
TRANSACTION_DATE
PROCESSING_STATUS_CODE =’PENDING’
CATEGORY_ID
QUANTITY
UNIT_OF_MEASURE
ITEM_DESCRIPTION
ITEM_REVISION
EMPLOYEE_ID
AUTO_TRANSACT_CODE
SHIP_TO_LOCATION_ID
RECEIPT_SOURCE_CODE
TO_ORGANIZATION_CODE
SOURCE_DOCUMENT_CODE
PO_HEADER_ID
PO_RELEASE_ID
PO_LINE_ID
PO_LINE_LOCATION_ID
PO_DISTRIBUTION_ID
SUBINVENTORY
HEADER_INTERFACE_ID
DELIVER_TO_PERSON_NAME
DELIVER_TO_LOCATION_CODE
VALIDATION_FLAG
ITEM_NUM
VENDOR_ITEM_NUM
VENDOR_ID
VENDOR_SITE_ID
ITEM_ID
ITEM_DESCRIPTION
SHIP_TO_LOCATION_ID

GL Journal interface

This interface lets you import journals from other applications like Receivables, Payables etc to integrate the information with General Ledger.
Pre-requisites:
Set of Books
Flex field Value sets
Code Combinations
Currencies
Categories
Journal Sources

Interface tables:
GL_INTERFACE

Base tables:
GL_JE_HEADERS
GL_JE_LINES
GL_JE_BACTHES

Concurrent Program:
Journal Import
Journal Posting — populates GL_BALANCES

Validations:
Validate SOB, journal source name, journal category name, actual flag
A – Actual amounts
B – Budget amounts
E – Encumbrance amount
If you enter E in the interface table, then enter appropriate encumbrance ID, if
B enter budget id.
Check if accounting date or GL date based period name is valid (i.e., not closed).
Check if accounting date falls in open or future open period status.
Check chart of accounts id based on Sob id.
Check if code combination is valid and enabled.
Check if record already exists in GL interface table.
Check if already journal exists in GL application.

Some important columns that need to be populated in the interface tables:
GL_INTERFACE:
STATUS
SET_OF_BOOKS_ID
ACCOUNTING_DATE
CURRENCY_CODE
DATE_CREATED
CREATED_BY
ACTUAL_FLAG
USER_JE_CATEGORY_NAME
USER_JE_SOURCE_NAME
CURRENCY_CONVERSION_DATE
ENCUMBRANCE_TYPE_ID
BUDGET_VERSION_ID
USER_CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_RATE
SEGMENT1 to
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
TRANSACTION_DATE
PERIOD_NAME
JE_LINE_NUM
CHART_OF_ACCOUNTS_ID
FUNCTIONAL_CURRENCY_CODE
CODE_COMBINATION_ID
DATE_CREATED_IN_GL
GROUP_ID

GL budget interface

Budget interface lets you load budget data from external sources into Oracle Applications.

Pre-requisites:
Set of Books
Flex field Value sets
Code Combinations

Interface tables:
GL_BUDGET_INTERFACE

Base tables:
GL_BUDGETS
GL_BUDGET_ASSIGNMENTS
GL_BUDGET_TYPES

Concurrent program:
Budget Upload

Validations:
Check if CURRENCY_CODE is valid.
Check if SET_OF_BOOKS_ID is valid.
Check if BUDGET_ENTITY_NAME (budget organization) is valid.

Some important columns that need to be populated in the interface tables:

GL_BUDGET_INTERFACE:

BUDGET_NAME NOT
BUDGET_ENTITY_NAME
CURRENCY_CODE
FISCAL_YEAR
UPDATE_LOGIC_TYPE
BUDGET_ENTITY_ID
SET_OF_BOOKS_ID
CODE_COMBINATION_ID
BUDGET_VERSION_ID
PERIOD_TYPE
DR_FLAG
STATUS
ACCOUNT_TYPE
PERIOD1_AMOUNT through PERIOD60_AMOUNT
SEGMENT1 through SEGMENT30

GL daily conversion rates
This interface lets you load the rates automatically into General Ledger.
Pre-requisites:
Currencies
Conversion rate Types

Interface tables:
GL_DAILY_RATES_INTERFACE

Base tables:
GL_DAILY_RATES
GL_DAILY_CONVERSION_TYPES

Concurrent Program:
You do not need to run any import programs. The insert, update, or deletion of rates in GL_DAILY_RATES is done automatically by database triggers on the GL_DAILY_RATES_INTERFACE. All that is required is to develop program to populate the interface table with daily rates information.

Validations:
Check if
FROM_CURRENCY and TO_CURRENCY are valid.
Check if USER_CONVERSION_TYPE is valid.

Some important columns that need to be populated in the interface tables:

GL_DAILY_RATES_INTERFACE:

FROM_CURRENCY
TO_CURRENCY
FROM_CONVERSION_DATE
TO_CONVERSION_DATE
USER_CONVERSION_TYPE
CONVERSION_RATE
MODE_FLAG (D= Delete, I = Insert, U = Update)
INVERSE_CONVERSION_RATE

Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 6.1

noreply@blogger.com (Umang Saini) — Mon, 05 Mar 2018 11:32:00 +0000

Error showing during installation of Oracle DevsuiteHome (Form & Reports)
Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 6.1

Solution:
1) Find oraparam.ini file in DevsuiteHome Folder
2) Add value 6.0, 6.1 in Windows under [Certified Versions]
3) Save & Continue at DevsuiteHome Installation.

Next Screen could be shown a virtual memory error.
Soultion :
1) Right Click on My Computer
2) Advance System Setting
3) Advance
4) Setting under Performance block
5) Again "Advance" & click on change
6) Uncheck Automatically managing paging...
7) Select C drive, Custom Size radio button & Enter Recommended Value as mentioned below
8) Set & Ok
9) Continue to DevsuiteHome Installation.

Best of luck...

Create Entry in Host File for Application

noreply@blogger.com (Umang Saini) — Tue, 27 Feb 2018 06:39:00 +0000

Facing problem when we create new entry in Host file, it save as with a .txt file instead of its original extension.

Follow the below steps:

Go to Start > run Notepad.
Right click on the Notepad icon and select Run as a administrator.
Select Open from the File menu option.
Browse to c:\windows\system32\drivers\etc\hosts.
Add the host name and IP address to the bottom of the host file.
Save the host file.

Integrator not showing in list in WebADI

noreply@blogger.com (Umang Saini) — Fri, 16 Feb 2018 12:24:00 +0000

First of all ensure that you have check on "Create document page" during creation on integrator.

After that If your are not able to view the Custom Integrator in Create Document then follow the below steps :
1) Manage Integrator from Desktop Integrator Manager Responsibility
2) Query your integrator name & click on Update (Pencil)
3) Click on Next
4) Click on Add Functions
5) Search By Code & Enter BNE_ADI_CREATE_DOCUMENT & Select
6) Again Search By Code & Enter BNE_CREATE_DOCUMENT & Select

Although I suggest you to create your objects (Integrator / Layout) with starting alphabets not by 'XX%'

BNE_UIX_PHYSICAL_DIRECTORY is not configured in WebADI

noreply@blogger.com (Umang Saini) — Thu, 11 Jan 2018 05:18:00 +0000

Solution:

1. Navigate to System Administrator responsibility > Profile > System

2. Search for Profile ‘BNE UIX Physical Directory’.

3. Delete the value setup at the ‘Site’ level. Save your changes.

4. Bounce Application Server (or Apache) services.

5. Now go back and retry launching the Web ADI. The error will not appear any more.

If point 1 to 3 does not work, then try resetting the profile from SQLPLUS through the following command:

Begin
value := fnd_profile.save(‘BNE_UIX_PHYSICAL_DIRECTORY’,”,’SITE’);
commit;
End
----------------

SET PROFILE
----------
BNE Allow No Security Rule - YES

WebADI Settings for Excel & Internet Explorer

noreply@blogger.com (Umang Saini) — Thu, 11 Jan 2018 05:01:00 +0000

When we are working with WEBAdi, we face macro setting issue in Excel.
Below are the steps to resolve it.

Excel Settings

1) Open excel

2) File - Option - Trust Center - Trust Center Setting - Enable all macro & click on below check box (Trust center to the VBA project)

3) File - Option - Trust Center - Trust Center Setting - External Content - Prompt user about data & Prompt user on automatic update

Internet Explorer Settings

Tools - Internet Options - Custom Level - Allow Status Bar via script - Enable

Download RTF Template from Database

noreply@blogger.com (Umang Saini) — Wed, 10 Jan 2018 11:09:00 +0000

1 BY 1

========

SELECT file_name, file_content_type, file_data FROM XDO_LOBS

WHERE xdo_file_type = 'RTF'

AND application_short_name = 'XXTEST'

ONCE IN A WHILE (Not guarntee to download all files)

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

DECLARE

l_file UTL_FILE.FILE_TYPE;

l_buffer RAW(32767);

l_amount BINARY_INTEGER := 32767;

l_pos INTEGER := 1;

l_blob BLOB;

l_blob_len INTEGER;

v_directory VARCHAR2(20) := 'ECX_UTL_LOG_DIR_OBJ';

CURSOR c1 IS

SELECT file_name, file_content_type, file_data

FROM xdo_lobs

WHERE xdo_file_type = 'RTF'

AND application_short_name = 'XXTEST';

BEGIN

FOR r1 IN c1 LOOP

IF UTL_FILE.is_open(l_file) THEN

UTL_FILE.fclose(l_file);

END IF;

l_blob_len := DBMS_LOB.getlength(r1.file_data);

l_file := UTL_FILE.fopen(v_directory,r1.file_name,'wb', 32767);

-- Read chunks of the BLOB and write them to the file until complete.

WHILE l_pos < l_blob_len LOOP

DBMS_LOB.read(r1.file_data, l_amount, l_pos, l_buffer);

UTL_FILE.put_raw(l_file, l_buffer);

l_pos := l_pos + l_amount;

END LOOP;

UTL_FILE.fclose(l_file);

END LOOP;

EXCEPTION

WHEN OTHERS THEN

-- Close the file if something goes wrong.

DBMS_OUTPUT.PUT_LINE ( SQLERRM );

IF UTL_FILE.is_open(l_file) THEN

UTL_FILE.fclose(l_file);

END IF;

END;

GL Account Description

noreply@blogger.com (Umang Saini) — Wed, 10 Jan 2018 11:06:00 +0000

Below is the query for getting description of GL Account, change your Org_ID, Account_Code, Segment & CCID accordingly.

select gcc1.segment2||'.'||
(select gl_flexfields_pkg.get_description_sql
                                     ((select distinct ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id = 141),--- chart of account id
                                      2,----- Position of segment
                                      '404007'--gcc.segment2 ---- Segment value
                                     )
from gl_code_combinations gcc
where gcc.code_combination_id = 1013)
from gl_code_combinations gcc1
where gcc1.code_combination_id = 1013

Ge the value of DFF

noreply@blogger.com (Umang Saini) — Wed, 10 Jan 2018 10:57:00 +0000

Flex field value and Description

select v.flex_value, v.flex_value_meaning, v.description
from FND_FLEX_VALUE_SETS s, fnd_flex_values_vl v
where s.flex_value_set_name = 'DEPARTMENT'
and s.flex_value_set_id = v.flex_value_set_id;

(ref:) tag in xml publisher template

noreply@blogger.com (Umang Saini) — Wed, 10 Jan 2018 10:49:00 +0000

Hi Friends,

When I was using MS Office 2010 for xml template, I face (ref:) tag issue in my template field, due to which my concurrent request are going into warning.

Here are the solution for this problem.

1) Open your report template

2) At the above right corner, go to Option button

3) On the Build tab click the Backward Compatible radio button

4) Upload your template at XML Publisher Template

5) Run your request

Oracle Report Builder Temporary Error

noreply@blogger.com (Umang Saini) — Wed, 10 Jan 2018 10:20:00 +0000

Sometime when we use Oracle Report Builder, a popup of temporary occurs, we can solve it through some changes in registry edit.
Below are the steps :

run --- regedit --- hk_current_user_machine --- software --- oracle --- devsuitehome1 ---- report_temp.

Change the value of report_temp from (C:\users\Admin~1\AppData\Local\Temp) to (C:\users\support1\AppData\Local\Temp)

Here support1 is my windows user login A/c.

How professional you are?

noreply@blogger.com (Umang Saini) — Thu, 21 Jul 2011 05:46:00 +0000

The following short quiz consists of 4 questions and will tell you wheather you are qualified to be a professional. The question are not soo difficult.

Ques.1: How do you put a giraffe into a refrigerator?

Correct Answer :

Open the refrigerator, put the giraffe and close the door.

This question tests weather you tend to do simple things in an overly complicated way.

Ques.2 : How do you put an elephant into a refrigerator?

Did you say, Open the refrigerator, put in the elephant, and close the refrigerator?

Wrong Answer.

Correct Answer:

Open the refrigerator, take out the giraffe, put in the elephant and close the door.

This tests your ability to think through the repercussions of your previous actions.

Ques.3 : The Lion King is hosting an animal conference. All the animals attend.... except one. Which animal does not attend?

Correct Answer:

The Elephant. The elephant is in the refrigerator. You just put him in there.

This tests your memory.

Okay, even if you did not answer the first three questions correctly, you still have one more chance to show your true abilities.

Ques.4 : There is a river you must cross but it is used by crocodiles, and you do not have
a boat. How do you manage it?

Correct Answer:

You jump into the river and swim across. Have you not been listening? All the crocodiles are attending the Animal Meeting.

This tests whether you learn quickly from your mistakes.

Tips after an interview

noreply@blogger.com (Umang Saini) — Wed, 15 Jun 2011 11:08:00 +0000

Right after a job interview, you could either be supremely confident or faintly worried. Either way, we feel pretty relieved when it is all over. Perceptions about interviews usually depend on the interviewer's likeability and first impressions. It is, therefore, important to remember some statutory courtesies in order to have a positive interaction and favourable result.

After an interview shoot a thank you email or letter
Many interviewees think that once the face-to-face interview is over, the interview process is complete. However, this is not the case. The job interview is just the beginning. Once the personal interview is done, the company mulls, evaluates and decides the best candidate who would best suit the job profile and company.
Therefore, it is a good idea to remain in touch with the interviewer and the company in general. One of the best ways to do so is to drop them a ?Thank You? note. If you have been in touch with company or interviewer via e-mail, then one should email such a note within 24 hours after the interview. Interviewers have short memories. So, this is your final chance to stand apart from all of the others who want the same position.

Follow up after the interview if there is no any response
How long should you wait before you call the company or interviewer? Usually, if there is no response within sometime, you will start worrying about whether it is appropriate to call back and check hiring status.

When to call
Post-interview it is best to give a gap of two to three days before you make the first follow up call. One of the most important things to keep in mind during the call is that one should be succinct and brief. Another important aspect is to chalk out a time when to call. The best time to call the interviewer is after lunch or an hour before closing time. This will ensure that you have a comfortable time frame to speak to the interviewer.

Whom to call
Interviewees are sometimes confused about who to follow up with after the interview?the human resource team or the interviewer directly. This situation is more confusing if there was more than one interviewer. In such circumstances, it is best to first check with the human resource team on the hiring status.

What to say
Begin the conversation by thanking the person for the opportunity to interview with the company. Recap some of the conversational highlights and clarify any information you need to check on. Use the last paragraph as the chance to state, ?The job is a good fit for me because of XYZ, and my past experience in XYZ?

Continue your job search
While waiting to hear from the company after the job interview, you should not ignore other interview calls because you are waiting to hear back from the current interview. Even if you are convinced that you have got the job, there can be many slips between the cup and the lip. It is also a good idea to critique your previous performance and use the experience to polish your interviewing skills.

FRM 10142 : HTTP Listner is not running at port 8889.

noreply@blogger.com (Umang Saini) — Mon, 04 Apr 2011 12:24:00 +0000

Hi Friends, It is a common problem when we are working with Form, oftenly every newbie user face these type of prob. and ofcourse I was also one of you, I also got rid of to face the same, now can't see you bother anymore, so here we go for the solution :-
Click on start - All programs - Oracle Developer Suite - Form Developer - Start OC4J Instatnce.

Okay, Best of Luck.

Get rid of from slow speed of PC

noreply@blogger.com (Umang Saini) — Thu, 03 Mar 2011 07:24:00 +0000

Hi guys if your PC is working slowly and you have installed many heavy softwares then you can use "services.msc via start- run" and some of softwares which are not being use, you can stop their services.
For example I have installed Oracle and whenever I don't need to work with it, I use this solution and stop the OracleServicesORCL (Start-Run-Services.msc-OracleServicesORCL). and one more thing don't forget to set the startup type as manually.

Moreover we should delete our temporary/unused file via "disk cleanup" and can use defragment tool.

ORA-12154: TNS:could not resolve connect identifer specified during Toad

noreply@blogger.com (Umang Saini) — Thu, 03 Mar 2011 06:47:00 +0000

Hi friends,
First of all thnx for visit us to find the solution of your problem.
I also got rid off this problem, after a long r&d period I got the simplest solution. If this ORA-12154: TNS:could not resolve connect identifer specified error is making you worried then here is the solutin of your prob.
U have to find the file tnsnames.ora perhaps this file will be in this directory "oracle\product\10.2.0\db_1\NETWORK\ADMI\tnsnames.ora" copy the file (tnsnames.ora) and then paste it in the Toad folder.

Sometime this error may be cause due to stop any oracle services from (Start-Run-services.msc) and just make start the OracleServiceORCL.

I hope you get your right solution. Thanks.

Interveiw : Question and Answer - 1

noreply@blogger.com (Umang Saini) — Sat, 03 Jul 2010 12:38:00 +0000

Ques: Name of company, position title and description, dates of employment.

Ans : Interviewers expect a candidate for employment to be able to review their work history in detail. Be prepared to tell the interviewer the names of the companies you worked for, your job title, your starting and ending dates of employment, how much you earned and what your job entailed.

You'd be surprised how many job applicants fumble when asked about prior employment. Don't be one of them! Refresh your memory prior to the interview by reviewing your resume, so, you can speak about your prior work history in detail and accurately.

Ques : What were your expectations for the job and to what extent were they met?

Ans : In many cases, interviewers will want to know what you expected from your last job when you were hired, so, be be prepared to answer the interview question "What were your expectations for the job and to what extent were they met?"

There isn't a right or wrong answer to this question. The best way to respond is to discuss what you expected when you took the job and give examples of how the position worked out for you. If the job wasn't exactly what you expected, it's fine to mention that. However, you should focus on the job itself, not the company, your boss, or your co-workers (if they were a problem). Do be careful how you answer and don't focus too much on the negative. Instead, address the highlights of the job.

When responding, be specific. Prepare some examples to share with the interviewer in advance. For example, if your job involved creating web applications using Cold Fusion, discuss the specific programs you developed and the responsibilities you were given. If you were provided training and opportunities for professional development to help you achieve your goals, mention that, as well.

Ques : What were your starting and final levels of compensation?

Ans : Interviewers expect a candidate for employment to be able to provide the details of their compensation history. Be prepared to tell the interviewer how much you earned at each of your prior positions.

Make sure that what you tell the interviewer matches what you listed on your job application. Refresh your memory prior to the interview by reviewing your compensation history, so, you can speak in detail and accurately. Don't exaggerate or inflate your earnings. Many employers will check references and confirm your salary history prior to making a job offer. A discrepancy between what you reported and what the employer says could knock you out of contention for the job.

The best way to prepare is to download a sample job application ahead of time. Complete the sample application and review it prior to the interview.

Ques : What Was it Like Working for Your Supervisor?

Ans : A typical interview question is "What Was it Like Working for Your Supervisor?" The reason it's asked it to find out how you got along with your boss. Be careful how your answer. Interviewers don't like to hear too much (or much at all) about bad bosses because it could be someone from their company that you're talking about next time around.

I once had a job applicant who spent 10 minutes responding to this question. She told me how awful her boss was and how her company was a terrible place to work. It so happened that her boss was a good friend and golfing buddy of my boss - our company's CEO - and the company was one of our biggest clients. Of course, she didn't get the job.

Don't make the same mistake she did. Instead, accentuate the positive and minimize any difficult situations. Discuss the strengths your past supervisors had and how they helped you succeed in your positions.

Ques : What major challenges and problems did you face? How did you handle them?

Ans : When asked the job interview question "How did you handle a challenge?" Be sure to include specific examples of how you handled a particular difficult situation. Discuss how you researched the issue and contributed to finding a solution. Examples of good responses include:
- During a difficult financial period, I was able to satisfactorily negotiate repayment schedules with multiple vendors.
- When the software development of our new product stalled, I coordinated the team which managed to get the schedule back on track. We were able to successfully troubleshoot the issues and solve the problems, within a very short period of time.
- A long-term client was about to take their business to a competitor. I met with the customer and was able to change how we handled the account on a day-to-day basis, in order to keep the business.

Ques : Why are you leaving your job?
Ans : One of the questions that is typically asked in an interview is "Why are you leaving your job?" or "Why did you leave your job?" if you have already moved on. If you were fired from your job, use these answers to respond. If you left of your own accord, review these suggestions on how best to answer and tailor your response to meet your particular situation. Be direct and focus your interview answer on the future, especially if your leaving wasn't under the best of circumstances.
Don't Badmouth Your Boss
Regardless of why you left, don't speak badly about your previous employer. The interviewer may wonder if you will be bad-mouthing his company next time you're looking for work. I once interviewed a person who told me that her last employer was terrible. They didn't pay her enough, the hours were awful and she hated the job. That company happened to be my company's biggest, and most important, customer. And there is no way I would have hired someone who felt that way, justified or not, about our valuable client. So, she gave up any opportunity of getting the job as soon as she answered the "Why did you leave?" question.

Prepare answers to typical job interview questions, like this one, in advance. Practice your responses so you sound positive, and clear, about your circumstances and your goals for the future.

Ques : What is your greatest weakness?
Ans : When you're asked what your greatest weakness is, try to turn a negative into a positive. For example, a sense of urgency to get projects completed or wanting to triple-check every item in a spreadsheet can be turned into a strength i.e. you are a candidate who will make sure that the project is done on time and your work will be close to perfect.
Note that the term "weakness" isn't used in the sample answers - you always want to focus on the positive when interviewing.

Sample Answers :

1. When I'm working on a project, I don't want just to meet deadlines. Rather, I prefer to complete the project well ahead of schedule.
2. Being organized wasn't my strongest point, but I implemented a time management system that really helped my organization skills.
3. I like to make sure that my work is perfect, so I tend to perhaps spend a little too much time checking it. However, I've come to a good balance by setting up a system to ensure everything is done correctly the first time.
4. I used to wait until the last minute to set appointments for the coming week, but I realized that scheduling in advance makes much more sense.

Ques : What is your greatest strength?

Ans : This is one of the easier interview questions you'll be asked. When you are asked questions about your strengths, it's important to discuss attributes that will qualify you for the job. The best way to respond is to describe the skills and experience that directly correlate with the job you are applying for.

Sample Answers :

1. When I'm working on a project, I don't want just to meet deadlines. Rather, I prefer to complete the project well ahead of schedule.
2. I have exceeded my sales goals every quarter and I've earned a bonus each year since I started with my current employer.
3. My time management skills are excellent and I'm organized, efficient, and take pride in excelling at my work.
4. I pride myself on my customer service skills and my ability to resolve what could be difficult situations.

How to prepare for Interview

noreply@blogger.com (Umang Saini) — Sat, 03 Jul 2010 07:51:00 +0000

Good communication is the key to a good interview; you need to know what you want and why you are there, and be able to convey that to the employer. You are trying to convince the employer that you would be a positive and beneficial addition to their company or business.

Know yourself. Know what your personal and career goals are, and how they fit with the company’s goals. It can be a good idea to do some research on the company beforehand, to get an idea of what it does, what it believes in and even who the company works with or competes against.

You should also study the job description carefully, and be able to talk about the skills you have that are listed in that description, as well as other skills that may apply to the position. Be able to discuss where or how you acquired these skills, and how you might best put them to use for the company.

Practice answering questions. While this may seem silly, it will go a long way to preparing you for an interview. Nerves and adrenaline make people inclined to rush or babble, two things that should be avoided during an interview. Practicing beforehand will help to combat this.

Most interviews will consist of fairly similar questions. Some will, of course, be specific to the job and company, but you will likely always be asked about past jobs, past projects, hobbies and interests, your ability to work as part of a team and/or to be a leader. Keep your answers brief and to the point, without leaving out any important information. Always focus on the positive.

Dress well. Regardless of a winning personality or stunning intelligence, much of a first impression is based on physical appearance. Follow the old adage to “dress for success” and demonstrate by your attire and how you carry yourself that you
are professional, organized and confident.
During the Interview
The first few minutes are crucial; studies have shown that interviewers form their overall impression of applicants within the first four minutes of the interview. Be sure to keep in mind the following basic things:
1. Calm, confident and professional.
2. Stand tall.
3. Make eye contact.
4. Shake hands firmly.
5. Be polite; use the formal address of Mr., Ms., unless invited to do otherwise.
6. Wait for invitation; do not sit until invited to do so. Sit straight and tall and look attentive and enthusiastic.
All of these things indicate that you want to be there and that you are What to Expect
All interviews have certain basic elements in common. When you first arrive, the interviewer will likely try to put you at your ease with some small talk. This may include discussion of the weather or current events, or questions about your interests and hobbies.

Respond appropriately. Be warm and conversational, but don’t ramble. Remember that your hobbies, your life in general, will reflect to the employer who you are and what kind of employee you might be.

The body of the interview will likely begin with the interviewer giving a detailed description of the job. This is an opportunity for you to ask intelligent questions and demonstrate what you know about the position and the company.

The main portion of the interview is all about you, the applicant. You will be asked to answer questions about yourself: your skills, applicable studies and training, past work experience, etc.

Remember to make eye contact, keep your answers succinct but thorough, and focus on the positive. Be enthusiastic and use good grammar; do your best to avoid too many “um”s, “ah”s, “you know”s and other such fillers.
Don’t fidget or exhibit other distracting nervous mannerisms, and don’t offer any negative information about yourself or criticize previous employers.

Remember, this is your chance to make a great impression in person and get the job you want. Make sure you are well prepared and practice answering questions before the interview. During the interview be sure to make eye contact, shake hands firmly, sit up straight and show enthusiasm. Be confident and give it your best.

"Best of luck"

LETS LEARN HTML

noreply@blogger.com (Umang Saini) — Thu, 01 Jul 2010 16:44:00 +0000

The language used to develop web pages is called Hyper Text Markup Language(HTML). HTML is the language interpreted by a browser. Web pages are also called HTML documents. HTML is a set of special codes that can be embedded in text to add formating and linking information. HTML is specified as TAGS in an HTML documents (i.e the web pages).

HTML is a case insensitive language. We can use our tags in capital or small word.

Now we are going to learn step by step :

Examination Results

noreply@blogger.com (Umang Saini) — Sat, 29 May 2010 11:33:00 +0000

Dear Friends,
Best of luck for your exam's result. We wish you for a bright future.

Board Results

CBSE - Secondary School Examination (Class X) Results May 2010 :-http://cbseresults.nic.in/class10/cbse10.htm
U.P Board - Inter Mediate (Class XII) Examination Result May 2010 :-http://upresults.nic.in/In2010/InterGetRoll.htm
U. P. Board High School (Class X) Examination - 2010 Results to be announced on 1st June 2010.
Rajashthan Board (12th class) Examination Result (Science, Commerce & Art) June 2010 :- http://rajresults.nic.in/

2. University Results

BANARAS HINDU UNIVERSITY(PMT Examination Results-2010) announced on 17 May :-http://upresults.nic.in/bhuresults/bhupmtresult.htm
Uttar Pradesh Technical University (UPTU)- SEE-UPTU-2010 Results is going to announced soon.

Welcome to the Query Solution

noreply@blogger.com (Umang Saini) — Fri, 28 May 2010 19:37:00 +0000

Hi Friends, first of all you are most welcome.
This blog is about your query's solution, we welcome your every query and try to give our best solution to make you one more step forward towards your goal.
"Best of luck" --- Thanks

Query and Solution

Interface Programs in Oracle Apps

Item import (Item conversion)

Inventory On-hand quantity Interface

Customer conversion

Auto Invoice interface

Receipt API

Lockbox interface

AP invoice interface

Vendor conversion/interface

Purchase Order conversion:

Requisition import

GL Journal interface

GL budget interface

Checking operating system version: must be 5.0, 5.1 or 5.2 . Actual 6.1

Create Entry in Host File for Application

Integrator not showing in list in WebADI

BNE_UIX_PHYSICAL_DIRECTORY is not configured in WebADI

WebADI Settings for Excel & Internet Explorer

Download RTF Template from Database

GL Account Description

Ge the value of DFF

(ref:) tag in xml publisher template

Oracle Report Builder Temporary Error

How professional you are?

Tips after an interview

FRM 10142 : HTTP Listner is not running at port 8889.

Get rid of from slow speed of PC

ORA-12154: TNS:could not resolve connect identifer specified during Toad

Interveiw : Question and Answer - 1

How to prepare for Interview

LETS LEARN HTML

Examination Results

Welcome to the Query Solution