How to open multiple forms at a time in Oracle ERP

Here i am going to discuss about how we can open multiple forms at a time. Here is a requirement that i want  to open journal entry form as well as currency definition form at a time. Normally we can open one form at a time but by doing below changes we can get this functionality.

After accessing to the application go to Tools, You can observe that their is a check box checked against "Close Other Forms".

Uncheck the check box

After unchecking the check box i am trying to open the journal entry form and currency definition form. You can observe that both forms open parallel. for opening both forms click on respective navigation separately.

Create Accounting Completed in Warning with Error Message "The application accounting definition Multi-Fund Account Receivables Accrual - Balancing Method owned by Oracle is not validated. Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Encumbrance Accrual."

After setting up of Accounts Receivable (AR) Module. Create Accounting some times completes with warning message "The application accounting definition Multi-Fund Account Receivables Accrual - Balancing Method owned by Oracle is not validated. Please validate the application accounting definition or update the application accounting definitions contained in the subledger accounting method Encumbrance Accrual."

This warning message we can find in Log file of the concurrent program

Solution

To overcome this issue go to AR Resposibility and Run Concurrent Program "Validate Application Accounting Definitions".

You can identify that all the Application Accounting Definition Validated by checking the Out put file of the concurrent program.

Go to AR Invoice and try to do create accounting. Now Create Accounting concurrent program gets Completes Normal.

Accounting Entries Generated for Various Events for Manually Created Asset (Addition) In R12

In R12 Assets can be created in two ways i.e Mass Additions and Manual Addition. In Manual Addition we can add asset through Addition and Quick Addition. Here i am discussing about the Accounting entries generated out of Manual addition (Addition), After performing Depreciated as well as after Retiring.

Here i am taking an example that i created an Asset worth Rs.1200, Life of Asset is 1 Year and Date Place in Service is 01 April 2013.

1st Entry created out of Addition is

Asset Cost A/c Dr       Rs.1200/-

   To Asset Clearing A/c                Rs.1200/-

Note: Here Asset Cost Account and Asset Clearing Account (Natural Account Segment Value) is picked from Asset Categories assigned to the asset.

Note: Asset Clearing A/c Balance has to be knocked off Manually by passing Manual Adjustment Entry as it is an control account.

2nd Entry generated out of Depreciation

Depreciation Expense A/c Dr  Rs.100

   To Accumulated Depreciation A/c     Rs.100

 Note: Here Depreciation Account and Accumulated Depreciation Account (Natural Account Segment Value) is picked from Asset Categories assigned to the Asset.

Here i am Retiring the Asset on 01st May 2013. After Retiring the Asset Accounting entries generated are

3rd Entry generated out of Retirement

Net Book Value Retired (Gain or Loss) A/c Dr 1100/-

Accumulated Depreciation A/c DR 100/-

     To Asset Cost A/c   1200/-

 Note: Here Net Book Value Retired Account (Gain or Loss) is picked from Book Controls and Accumulated Depreciation Account, Asset Cost Account (Natural Account Segment Value) is picked from Asset Categories assigned to the Asset.

Note: Here i am retiring the Asset for Total Cost and Proceeds of Sale, Cost of Removal are Nill.

Final Conclusion if Asset is Live

1. Asset Cost is shown in Balance Sheet (FSG Report) on Asset Side

2. Accumulated Depreciation is shown on Liability Side or Asset Side (-ve Amount) in Balance Sheet (FSG Report).

3. Depreciation is shown on Debit side of P&L Statement (FSG Report) as it is an expenditure.

4. Asset Clearing Account Balance is knocked off by passing manual entry.

 Final Conclusion if Asset is Retired

1.Upon Retiring, Asset Cost of the Asset gets Knocked off and Asset cost get reduced to the extend of Asset retired.

2. Accumulated Depreciation gets knocked off and Accumulated Depreciation get reduced to the extend of Retired Asset Accumulated Depreciation.

3. Depreciation is shown on Debit side of P&L Statement (FSG Report) as it is an expenditure.

4.Asset Clearing Account Balance is knocked off by passing manual entry.

5. Net Book Value Retired Amount is shown on the Debit side if it is loss or shown on Credit side if it is profit in P&L Statement (FSG Report).

4th Entry generated out of Retirement where Proceeds of Sale is Rs.1,00,000/- (Loss)

Net Book Value Retired (Loss) A/c Dr 491,666.67
Accumulated Depreciation A/c Dr             8,333.33
Proceeds of sale Clearing A/c Dr              1,00,000
       To Asset Cost A/c                                              500,000

        To Proceeds of Sale (Loss) A/c                         1,00,000 

Note: Here Net Book Value Retired Account (Loss), Proceeds of sale Clearing , Proceeds of sale (Loss) is picked from Book Controls and Accumulated Depreciation Account, Asset Cost Account (Natural Account Segment Value) is picked from Asset Categories assigned to the Asset.

Final Accounting Effect

1.Upon Retiring, Asset Cost of the Asset gets Knocked off and Asset cost get reduced to the extend of Asset retired.

2. Accumulated Depreciation gets knocked off and Accumulated Depreciation get reduced to the extend of Retired Asset Accumulated Depreciation.

3. Net Book Value Retired (Loss) Amount is shown on the Debit side of P&L Statement (FSG Report).
4. Proceeds of Sale Clearing Account gets knocks off on booking of AR Transaction where Proceeds of Sale Clearing Account is entered in Revenue Account. We book AR Transaction for Sale proceeds to capture sale proceeds in the system.
5. Proceeds of Sale (Loss) Account is shown on the Credit Side of P&L Statement (FSG Report)

Entry generated out of Retirement where Proceeds of Sale is Rs.6,00,000/- (Gain)

Net Book Value Retired (Gain) A/c Dr 491,666.67
Accumulated Depreciation A/c Dr             8,333.33
Proceeds of sale Clearing A/c Dr              6,00,000
       To Asset Cost A/c                                              500,000

        To Proceeds of Sale (Loss) A/c                         6,00,000 

Note: Here Net Book Value Retired Account (Gain), Proceeds of sale Clearing , Proceeds of sale (Gain) is picked from Book Controls and Accumulated Depreciation Account, Asset Cost Account (Natural Account Segment Value) is picked from Asset Categories assigned to the Asset.

Entry Generated out of AR Transaction for Sale Proceeds

Receivable A/c DR  XXXXX
     To Revenue A/c        XXXXX

Note: Proceeds of Sale Clearing to be taken in Revenue Account

Entry Generated when Receipt is applied to Transaction.

Remitted Cash A/c DR  XXXXX
   To Receivables A/c          XXXXX

Entry Generated when Receipt is Cleared. 

Cash A/c Dr   XXXXX
     To Remitted Cash A/c XXXXX

Final Accounting Effect

1.Upon Retiring, Asset Cost of the Asset gets Knocked off and Asset cost get reduced to the extend of Asset retired.

2. Accumulated Depreciation gets knocked off and Accumulated Depreciation get reduced to the extend of Retired Asset Accumulated Depreciation.

3. Net Book Value Retired (Gain) Amount is shown on the Debit side of P&L Statement (FSG Report).
4. Proceeds of Sale Clearing Account gets knocks off on booking of AR Transaction where Proceeds of Sale Clearing Account is entered in Revenue Account. We book AR Transaction for Sale proceeds to capture sale proceeds in the system.
5. Proceeds of Sale (Gain) Account is shown on the Debit Side of P&L Statement (FSG Report)
6. Revenue account (Proceeds of Sale Clearing) Gets knocked off
7. Receivable Account gets knocks off when Receipt is applied against the Transaction
8. Remitted Cash Account gets knocked off once receipt gets cleared.
9. Cash Account is shown in Balance Sheet (FSG Report) on Asset Side.

While Creating BG in Vision Instance facing error "the procedure init_forms has created an error"

While creating BUSINESS GROUP & GRE/LEGAL ENTITY in the Respnosibility "Payables Responsibility" 

Payables: Setup > Organizations

I am facing the following Error

"APP-PAY-06153: System Error: Procedure INIT_FORMS at Step 1

Cause: The Procedure INIT_FORMS has created an error at Step 1.

Action: Contact your system administrator quoting the procedure INIT_FORMS and Step 1"

Solution

Go to System Administrator Responsibility

Navigation : Profile > System

Check the Profile Option "HR Business Group". You will observe BG is having Null Value.

Assign the BG as here it is "Vision Corporation" and Save the Work.

Go to System Administrator Responsibility

Navigation : Profile > System

Check the Profile Option "HR Security Profile". You will observe profile option is having Null Value.

Assign the Security Profile as here it is "FA:Vision Corporation" and Save the Work.

Retest the Issue and you will observe Page open with out error.

Third Party Control Segment Qualifier its Options and Usage

In General Ledger. When we define values in Natural Account. We assign segment qualifiers. Among Segment Qualifiers. "Third Party Control" Segment Qualifier is one of the Qualifier. Today i am sharing the information on Third Party Qualifier.

1. What is meant by "Third Party Control"?

Ans. When we assign or enable "Third Party Control Segment Qualifier". Here assigning or enabling means select option as "Yes" or "Supplier" or "Customer". By using that natural account if journal is created then journal should contain "Party Information". Party Information will be available for a journal when it is created from Sub-Ledgers. Incase Party information is missing for that natural account then the Accounting Program completes in error stating " Party Information missing". Normally for manual journals party information will not be available.

2. Who are all parties?

Ans. In R12 as per TCA all the suppliers and customers are treated as Parties.


3. What all the options available in "Third Party Control Segment Qualifiers"?

Ans. Prior to R12.1.3 version there are 4 options. They are

a. No (Default Value)
b. Yes
c. Supplier
d. Customer

In R12.1.3 one additional option is included it is

e. Restrict Manual Journals.

4. What is the Importance of the options available in "Third Party Control Segment Qualifiers"?

Ans.

Value "NO"

If we select option "No" means we are not using Third Party Control Segment Qualifier.

Value "Yes"

If we select option as "Yes" it means that value can be used in AP Sub Ledger (Supplier information is Available) and as well as in AR (Customer Information is available)

Value "Supplier"

If we select option as "Supplier" it means we are going to use this value in AP (Where Supplier information is available)

Value "Customer"

If we select option as "Customer" it means we are going to use this value in AR (Where Customer information is available)

Value " Restrict Manual Journals"

If we select option as " Restrict Manual Journals" where we can use this value in sub-ledger (With or with out party information ). But we can not use this value in General Ledger for Manual Journals.

5. Why  in R12.1.3 version New Option "Restrict Manual Journals" Option introduced?

Ans. Before R12.1.3 if we enabling Third Party Control for the value (Unidentified Cash) and by using the same value if we book Unidentified Receipt. We face issue while performing Create Accounting with error message (party information missing). Which is a bug because we book unidentified receipt where party information is not available. To over come this issue Oracle introduced new value called "Restrict Manual Journals". By enabling this option we can create journals from sub ledger with out party information but we cannot book manual journal from General Ledger (GL) for the same value.

6. What is the use of "Third Party Control Segment Qualifier"

Ans If we are not enabling or not using "Third Party Control Segment Qualifier" for Control Accounts then we face issues while performing Reconciliation from Sub ledger to GL. Normally we perform periodical reconciliation for control accounts from sub ledger to GL. Due to non enabling "Third Party Control Segment Qualifier" user may pass manual journal entries using control account which will cause difference from Sub ledger to GL. To over come these issue it is suggested to enable "Third Party Control Segment Qualifier" for control Accounts.

7. In which all sub ledgers we can use "Third Party Control Segment Qualifier" for control accounts?

Ans. Prior to R12.1.3 we can use "Third Party Control Segment Qualifier" for control accounts related to Accounts Payables (AP) and Accounts Receivables (AR). But after R12.1.3 due to new option "Restrict Manual Journals" option we can use in all sub ledgers.