Incase of data migaration point to be remebered for Fixed Asset Data Upload

Note: Any value entered in Accumulated depreciation Field system will calcualted depreciation for Current Period only. If no value entered in depreciation Field system will calculate depreciation from beginning of the asset.

Case Study 1: Create a new asset, With Accumulated Depreciation(let's say X)  and YTD Depreciation.    

Run Depreciation to Calculate current Method Depreciation. In Accumulated Deprecation , system will calculated current method Depreciation
and add to accumulated deprecation as entered while creating asset(X Value + current Period Depreciation)
while running create Accounting. System will Generated accounting
Entry for Asset addition and Current month Depreciation but no accounting entry will be created for accumulated Depreciation entered while Creating Asset..
If Accumulated Depreciation is entered, System will calculated Depreciation for current Period only.

Illustration:

Asset Cost: 10000
Accumulated Depreciation: 500
Date Place in Service : 01-JAN-2013
Depreciation Method Life: 40 Yrs.   (480 Months)
After Running Depreciation for MAR-16
Deprecation calculate for the period= Asset Cost/ Life in months=  10000/480= 20.83
Now
Accumulated Depreciation will be 500+ 20.83=   520.83.

Accounting entry will be generated for Asset Addition as below

Asset Cost A/c............Dr   10000
      To Asset Clearing A/c.......................Cr   10000

Accounting entry will be generated for Depreciation as below

Depreciation A/c..............Dr   20.83
                   To Accumulated Depreciation A/c....20.83
Note: No Accounting will be generated for Accumulated Deprecation entered before running Depreciation.

Case Study 2: Create a new asset, With Accumulated Depreciation as null and YTD Depreciation as null and when you save record. System will create YTD Deprecation and
accumulated Depreciation till Previous Period.
Run Depreciation to Calculate current Method Depreciation.   
while running create Accounting. System will Generated accounting
Entry for Asset addition and Current month Depreciation but no accounting entry will be created for accumulated Depreciation.
If Accumulated Depreciation is entered, System will calculated Depreciation for currrent Period only.

Illustration:

Asset Cost: 10000
Accumulated Depreciation:  NULL
YTD Depreciation: NULL
Date Place in Service : 01-JAN-2013
Depreciation Method Life: 40 Yrs.
after Running Depreciation for MAR-16
Deprecation calculate from Date place in Service: 20.83 (Dep per Month)* 39(Till Current Month)= 812.5
Now
Accumulated Depreciation will be = 812.5
YTD Depreciation will be=812.5.


Accounting entry will be generated for Asset Addition as below

Asset Cost A/c............Dr   10000
      To Asset Clearing A/c.......................Cr   10000

Accounting entry will be generated for Depreciation as below

Depreciation A/c..............Dr   812.5
                   To Accumulated Depreciation A/c....812.5
Note: Depreciation Accounting will be generated from Date place in service to till Date

Not able to update the TAX Calendar in TDS Regime. Error Appears - "FRM-40654 : Record has been updated. Requery block to see change"

UPDATE jai_regimes
      SET creation_date = TRUNC(creation_date) ,
             last_update_date = TRUNC(last_update_date),
             effective_from = TRUNC(effective_from)
WHERE REGIME_NAME = 'TDS'
/
COMMIT;

Error while Incomplete AR Invoice, APP-AR-11526: ENCOUNTERED AN ERROR IN JAI_AR_TAX_DEP_PKG. dETERMINE_MANUAL_ar_tax

Download & Apply the following Patch: 26410637:R12.JAI.B and Test it.

How to set the customer number in Oracle apps / Customer Number Sequence updation in AR

Note: Refer Doc ID 265315.1)

Switch to the Application Developer responsibility,
In the Navigator window select Application, then Database, and finally Sequence.

To automatically assign a unique number to every new customer, check the Automatic Customer Numbering box. Do not check this box if you want to manually assign customer numbers. Oracle Applications system administrator or developer can specify the initial number to be used for Automatic Customer Numbering.

Switch to the Application Developer responsibility.

In the Navigator window select Application, then Database, and finally Sequence.

In the Name field of the Sequences window, query for HZ_ACCOUNT_NUM_S.

In the Start Value field of the Sequences window, enter the initial number to be used for Automatic Customer Numbering.

You were previously entering customer numbers manually. Now you want to generate the number automatically but you want to specify the value the sequence should start from. How can this be done? The database sequence that handles the creation of customer numbers is defined in HZ_ACCOUNT_NUM_S.

Care should be taken to ensure that you do not define a number which will cause duplicate customer numbers to exist in your system. you can run the following to identify the highest number currently in use within your system: Select max(account_number) from hz_cust_accounts_all; Then using the number returned above, define the sequence to start with a higher value. If for example the above returns 20000, then you can do the following to ensure the sequence will not create overlapping account numbers:

DROP SEQUENCE AR.HZ_ACCOUNT_NUM_S;

CREATE SEQUENCE AR.HZ_ACCOUNT_NUM_S START WITH 20000 INCREMENT BY 1 MAXVALUE 999999 CACHE 20;

Auto Invoicing Setup Steps

1) In OM System Parameters Window, For item Validation Organisation assign Master Inventory(MI) or Actual Inventory (AI).

2) Create Transaction Type for line and order.
3) Define Document Sequence for the transaction type.
4) Assign Document Sequence and Document Category in Document Assignment window
5) For OM Responsibility assign " QP Item Validation Organisation".
6) Assign you item in advance pricing form.
7) Define Carrier Method.
8) Define Release Sequence Rule.
9) Define Pick Slip Grouping Rule.
10) Define Release Rules.
11) Define Document Set for Pick Release.
12) Define Document Set for Ship Confirmation.
13) Define Ship Confirmation Rules.
14) Shipping Parameters.
15) Define Picker Role.
16) Define Shipper Role.
17) Define grants to shipper and picker
18) Open Periods in Inventory, Purchasing and General Ledger Modules.
19) Create Receivables Transaction Type
20) Create Imported Transaction Source
21) Assign Receivable transaction type and sources to Transaction type create in OM.

You have encountered an unexpected error. Please contact the System Administrator for assistance. Unable to Open Supplier OAF Page

Solution: Need to Set MO: Operating Unit at Site Level(Specify your Operating Unit)

Unable to make payment for the Invoice. Due to Invoice Status: 'Selected for Payment'. But no Payment Batches created by selecting this invoice.

Run the below SQL Query. The invoice Status will be changed automatically to "Validated"

update ap.ap_payment_schedules_all 
set checkrun_id =''
where invoice_id ='57553'-- Give your Invoice_ID
and checkrun_id ='34564'--- Give your Checkrun_ID

Now you cancel the invoice or You can make the Payment for the invoice.

AP invoice accounting status not updated to ‘yes’ still it is showing ‘no’ for one invoice

Analysis: We are able to see JE for invoice when we checked view accounting from invoice screen, so the problem with only status

Solution: As it seems data corruption issues, we logged a ‘SR’ with oracle, they have provided data fix. The issue has been resolved.

2 Journals are not getting posted when auto post program run

Analysis: Journals are created after program completion that is at 11.00 pm

Solution: We asked user to wait until next run so that it will get posted

Not able to account payment document when I tried from action window of payment work bench

Analysis: Associated invoice not accounted hence payment not getting accounted

Solution: Account the invoice and then account payment