PERF0005: Oracle error detected in glpsqs() - ORA-20001:An active swquence assignment is required. ORA-06512

Issue:
PERF0005: Oracle error detected in glpsqs()  - ORA-20001:An active swquence assignment is required. ORA-06512

Fix:

Accounting sequence has been wrongly defined in the Accounting Set Up.

Accounting sequences are not required or used for the ledger, but this is enabled by checking the "Require Assignment" box in the processing options in the accounting set up.

However, assignments have not been defined or enabled. When posting is submitted, it will search for an active sequence assignment. Since it has not been defined for the ledger, posting will fail with the above error.

To check if the sequence is assigned and active for categories, run the following sql

SELECT led.name,

      app.application_name,

      jct.user_je_category_name,

      dsa.category_code,

      dsa.doc_sequence_id,

      ds.db_sequence_name,

      dsa.method_code,

      dsa.start_date Assgn_St_date,

      dsa.end_date Assgn_End_date,

      ds.start_date Seq_st_Date,

      ds.end_date Seq_End_Date,

      ds.type

 FROM fnd_doc_sequence_assignments dsa,

      fnd_document_sequences ds,

      gl_je_categories_tl jct,

      gl_ledgers led,

  fnd_application_tl app

WHERE dsa.doc_sequence_id = ds.doc_sequence_id

  AND jct.je_category_name = dsa.category_code

  AND app.application_id = ds.application_id

  AND led.ledger_id = dsa.set_of_books_id

  AND dsa.end_date < (sysdate - 30) -- Shows seq assignments which ended less than 30 days before the current date

  AND led.ledger_id = &LedgerId;

To disable the accounting sequence required check box as follows :-

1. Go to GL > Accounting Set Up Manager > Sequencing (Update)

2. Uncheck the option for "Require Assignment.

3. This will disable the requirement for assignment.

4. Re-submit posting.

device eth0 does not exist Virtualbox

 

Error when pinging in Linux while its running on VirtualBox:

“device eth0 does not exist Virtualbox”

 

 

Solution:

When you install others VMs the change in the MAC address forces a Linux feature which sets up the new eth1 instead of eth0
edit the /etc/udev/rules.d/70-persistent-net.rules or you can delete the rules and Linux will configure it on the next boot
On Solaris you would need to setup the network again

Now we can able to ping the IP, IP mac address will be configured automatically when Linux next time

Definitions Used in Intercompany Accounting

Intercompany Accounting Basics:

Intercompany Journal
This is a journal entry which has transactions for at least 
two different companies (or balancing segment values).

Intercompany Journal Out of Balance
An out of balance intercompany journal is one which does not have equal
credit and debit totals for each group of lines by company.

Balancing Segment
This is the accounting flexfield segment that has the balancing segment 
qualifier assigned to it. Typically the balancing segment stores the company 
values. However, it could represent the cost center, the department or some
other values.
The terms balancing segment and company segment are usually interchangeable. 
It is mandatory that one segment of your accounting flexfield be designated
as the balancing segment.

Intercompany Segment
The intercompany segment is the accounting flexfield segment that has 
the intercompany segment qualifier assigned to it. This qualifier is only 
available in release 11i and is optional.  This segment shares the same
value set as the balancing segment.

Clearing Account
A clearing account is a temporary account that holds amounts to be 
transferred to another account. 

Clearing Company 
This is the company value used to clear payables or receivables transactions. 
General Ledger uses this company to balance intercompany transactions.

Trading Partner
Trading partner is the company against which the line transaction is made.

Transaction Types
Transactions types are the classifications for journal entries based on
the number of companies involved in the credit and debit side
of the transaction.

The different transaction types are:

One to One: Two different companies in the journal. One company 
has the net debit balance and the other has a net credit balance.

Many to One: Different companies have net debit balance and one 
company has net credit balance.

One to Many: One Company has net debit balance and more than one 
companies have net credit balance.

Many to Many: Two or more companies have net debit balance and 
two or more companies have net credit balance.