Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML” , ORA-06512: at “HR.DR$HR_LOCATIONS_N1TC - Oracle EBS R12

https://generalledger-gl.blogspot.com/2017/11/unable-to-create-new-legal-entities-ora.html

ERROR

Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML” , ORA-06512: at “HR.DR$HR_LOCATIONS_N1TC

SOLUTION

Run The Following Query

SELECT TRIGGER_NAME, STATUS
FROM all_triggers
WHERE TABLE_NAME in (‘PER_ADDRESSES’, ‘HR_LOCATIONS_ALL’)
ORDER BY table_name;

If you see triggers with name DR$HR_LOCATIONS_N1TC or DR$PER_ADDRESSES_N4TC please drop these, then see if you can now create the Legal Entity.


Disable Trigger DR$HR_LOCATIONS_N1TC
Disable Trigger DR$PER_ADDRESSES_N4TC


Reference Note: Doc ID 1516486.1

Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10 - Oracle EBS R12

https://generalledger-gl.blogspot.com/2017/11/description-for-journal-entry-line-not.html

ERROR

Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10

SOLUTION

Run Journal Import in detail mode.

Step 1. Go to Responsibility General Ledger Super User

Step 2. Go to Navigation Path : Journal>Import>Run

Step 3. Make sure Create Summary Journals checkbox is blank.

FSG Last Used PLSQL Query - Oracle EBS R12

https://generalledger-gl.blogspot.com/2017/11/fsg-last-used.html

Query to Get FSG Last Used in Oracle EBS R12

select max(a.REQUEST_DATE) Last_Request_Date, c.REPORT_TITLE
  from FND_CONCURRENT_PROGRAMS_VL b,
       fnd_concurrent_requests    a,
       RG_REPORTS_V               c,
       fnd_user                   d --67156

 where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID
     
   and a.PROGRAM_APPLICATION_ID = b.APPLICATION_ID
     
   and c.REPORT_ID = a.ARGUMENT7
     
   and d.USER_ID = a.REQUESTED_BY
     
      --and c.APPLICATION_ID=b.APPLICATION_ID
     
   and b.USER_CONCURRENT_PROGRAM_NAME like '%Program%Publish%FSG%'

 group by c.REPORT_TITLE

--order by a.REQUEST_DATE