Search found 615 matches

by ahmadbilal
Wed Jul 29, 2009 9:48 am
Forum: Purchasing & Inventory
Topic: Population of Quantity and Charge a/c in a PO
Replies: 5
Views: 1616

Have at look at the following metalink Notes


Setup and Defaulting of Accounts in a Purchasing Encumbrance Environment
Doc ID: 245096.1

FAQ: Account Generator
Doc ID: 216831.1
by ahmadbilal
Tue Jul 21, 2009 10:01 am
Forum: Oracle Forms & Reports
Topic: REP-51002: Bind to Reports Server repsrv01 failed
Replies: 2
Views: 10909

Cause 1: multiple network cards (NICs), use of VPN software, missing Gateway configuration for the network definitions in the NIC can cause this behaviour, and/or use of VMware Solution 1: If your machine setup uses multiple network cards and/or you are using software VPN (e.g. cisco) and/or you hav...
by ahmadbilal
Wed Apr 15, 2009 11:19 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: AR Period Close and Reconciliation in R12
Replies: 0
Views: 1036

AR Period Close and Reconciliation in R12

As requested by some of reader , Here are steps and checklist for R12 AR Month End Close and Reconciliation. 1. Complete All Transactions for the Period Being Closed 2. Complete and review your unapplied receipts 3. Reconcile Receipts to Bank Statement Activity for the Period 4. Change period status...
by ahmadbilal
Wed Apr 15, 2009 11:18 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Cash Management Period Closure in R12
Replies: 0
Views: 775

Cash Management Period Closure in R12

Here with providing the generic period close process for Cash managment for R12. 1.Make sure you have Loaded & reconciled all bank statements for month * You must verified Auto-Reconciliation Execution Report 2.If there any , resolve all exceptions 3.Create miscellaneous transactions This step e...
by ahmadbilal
Wed Apr 15, 2009 11:17 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: FA Period Close process In R12
Replies: 0
Views: 1107

FA Period Close process In R12

If you are coming from 11i, there is slightly change in FA Period Closure process because of SLA. Here are steps & procedures for performing period-end processing in Oracle Assets Release 12. In FA, at period end, we require to run depreciation for depreciation books set up for the organization,...
by ahmadbilal
Mon Apr 13, 2009 6:52 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Account Payable Period Close Checklist
Replies: 0
Views: 867

Account Payable Period Close Checklist

Attached is Document


[img]/images/icon_zip.gif[/img] <b>Attachment:</b> AP_Period_Close_Checklist.zip <i>( 43949bytes )</i>
by ahmadbilal
Mon Apr 13, 2009 6:40 am
Forum: Purchasing & Inventory
Topic: Notification as an email alert
Replies: 5
Views: 2095

Setup Notification Mailer for approval by using email only you need to setup both inbound and outbound
by ahmadbilal
Sun Mar 08, 2009 6:21 am
Forum: Purchasing & Inventory
Topic: Multiple Approval Hierarchy - Feasibility
Replies: 1
Views: 1037

It's Very Common Business Process. If any organization have two departments public relation and communication (PRC) and purchasing (PO). PRC department deals with employee travel tickets and newspapers PO department deals with Purchase of Materials , Consulting Service etc. PRC lead by PRC head who ...
by ahmadbilal
Sun Feb 15, 2009 3:19 pm
Forum: Purchasing & Inventory
Topic: How to upload Inventory Items
Replies: 4
Views: 1896

Use following in Control File and Upload information MTL_SYSTEM_ITEMS_INTERFACE and go to inventory run the item upload request LOAD DATA INFILE 'item.csv' INSERT INTO TABLE MTL_SYSTEM_ITEMS_INTERFACE REPLACE FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( SEGMENT1 "trim(substr(:SEGMENT1,2))"...
by ahmadbilal
Fri Jan 30, 2009 6:48 am
Forum: Oracle Forms & Reports
Topic: HOW TO CHANGE THE COLOUR
Replies: 1
Views: 1510

Use Conditional Formatting feature
by ahmadbilal
Fri Jan 30, 2009 6:48 am
Forum: Reports (Only Oracle Apps Reports)
Topic: how to insert signature in oracle reports
Replies: 3
Views: 3459

Create a Table with with two columns id and image. store user id and signature in that table on report retrieve the specific signature against user id on report.
by ahmadbilal
Fri Jan 23, 2009 4:59 am
Forum: Purchasing & Inventory
Topic: Purchase requisition limits
Replies: 1
Views: 977

Sometime this happened when you mistakenly include that item or account category in hierarchy but exclude on any other line on same approval group.

Better to attach screen shots here.
by ahmadbilal
Fri Jan 23, 2009 4:55 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Payment is showing status ?Reconciled Unaccounted'
Replies: 4
Views: 4940

Go To Payable Option.
There will be two check box one Accounting when payment cleared and accounting when paid (i am not sure should be like this).

Check which options enable there and update us.
by ahmadbilal
Sat Jan 17, 2009 6:06 am
Forum: Purchasing & Inventory
Topic: Requisition approval notification 2 multiple users
Replies: 1
Views: 1104

by ahmadbilal
Mon Jan 12, 2009 4:09 am
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Open Interfaces
Replies: 11
Views: 12447

Verify the percent on the line receiving the error using the following statment: select interface_line_id, sales_credit_percent_split from ra_interface_salescredits_all where interface_line_id=&line_id; This should return one line at 100%. 2. If one line is returned, verify whether these sales c...