Mass Addition Create program ending in error -ORA-30926: unable to get a stable set of rows in the s
Hi,
Create Mass Addition program is ending in error. (Ran this program from Payables) We are on Oracle R12.1.3
Already SR was logged for this issue. Oracle is saying that this issue is because of Custom JLT.
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle's reply as below:
''Invoice has two events, Invoice Validation 5934276 and Adjustment event
5942550, for each event there are three headers generated although there is
no secondary ledger or encumbrance.
The primary headers have correct accounting.
As for the other headers, only last distribution is picked up in XDL
generation and no liability line exists for these distributions''
--------------------------------------------------------------------------------------------------------------------------------------------------------------
As one of the step/solution provided by Oracle - We also tried to mass addition by adding the self assessed tax liability,self assessed non-rec tax, self assessed rec tax in Post Accounting Program under Mass Addition Create program. It did not work. Still the Create Mass Addition is ending in error.