Wednesday, November 28, 2012

The chosen installation conflicts with software already installed

The chosen installation conflicts with software already installed


This Sunday when I was trying to install Oracle 11g Database I was facing following problem while installing the database.

[INS-32025] The chosen installation conflicts with software already installed in the given Oracle home
INS-32025 The chosen installation conflicts with software already installed
INS-32025 The chosen installation conflicts with software already installed

This error occurs because I have already installed the Oracle 11g Database and later I have remove the Oracle 11g Database and restored my registry. But when I again try to install the database, installer found any traces of previous installation somehow and show the error.

Solution:

I have just change the dbhome_1 to dbhome_2 and problem solved. :)

Reason:

Installer found the entry of dbhome_1 from anywhere in my system and when again I tried to installed the same home installer showed the error. So I just change the home name.

Suppose:

If you install this and later you uninstall the db then next time when you will try to install the Oracle 11g Database you will have to use the "dbhome_3". Hope you got the point. :)
INS-32025 The chosen installation conflicts with software already installed
INS-32025 The chosen installation conflicts with software already installed


Tuesday, November 27, 2012

file not found em.ear oracle 11g

file not found em.ear oracle 11g


This Sunday I was trying to install Oracle 11g Database but at 60% it showed error:

file not found em.ear oracle 11g
file not found em.ear oracle 11g

"Oracle Database 11g Release 2 Installer
file not found
d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2eoc4j_applications\applications\em.ear"

When we download Oracle 11g Database it contains 2 files win32_11gR2_database_1of2.zip and win32_11gR2_database_2of2.zip.
What I was doing wrong is, I just unzipped the first file and assumed it automatically will extract the second one too but actually it won't. That is why I was getting this error.


I have googled a lot and found the solution:

Solution:

Extract first file ( win32_11gR2_database_1of2.zip) and then second (win32_11gR2_database_2of2.zip) too. win32_11gR2_database_2of2.zip automatically placed its files in Components directory if you still facing this error then extract the 2nd file (win32_11gR2_database_2of2.zip) and place the extracted folders (oracle.ctx, oracle.rdbms.install.seeddb, oracle.sysman.console.db) into database\stage\Components.
I am confident it will solve your problem.
If you still facing the problem then please comment below.





Thursday, November 15, 2012

Oracle/PLSQL: ORA-01843 Error

Oracle/PLSQL: ORA-01843 Error

Today when I was developing Oracle Form in Oracle Form Builder I got the error

"Oracle/PLSQL: ORA-01843 Error" when I googled this error I found the following solution on www.techonthenet.com

Actually I was assigning the string value to date type column as illustrated below:

Oracle PLSQL ORA 01843
Oracle/PLSQL: ORA-01843 Error

:MS_HEADER.CREATION_DATE := '11/15/2012 15:03:34';

but it should be as follows:

:MS_HEADER.CREATION_DATE := to_date('11/15/2012 15:03:34','mm/dd/rrrr hh24:mi:ss');

solution is below:

Oracle/PLSQL: ORA-01843 Error

Error Message

ORA-01843: not a valid month

Cause of Error

You entered a date, but the month portion of the date was not a valid month.

Resolution

The option(s) to resolve this Oracle error are:
  1. Re-enter the date value using either a MONTH format mask.
The valid values for month are:
January, February, March, April, May, June, July, August, September, October, November, December.
Or you could use the MON format mask and use one of the following values:
Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
If all else fails, you may want to consider using the to_date function and specifying the date format mask.

ref:http://www.techonthenet.com/oracle/errors/ora01843.php

Thursday, November 8, 2012

FRM-92050 failed to connect to Server

FRM-92050 failed to connect to Server


I was facing this problem and found solution from following link:
 http://focusthread.com/blog/oracletraining/funcional/frm-92050-failed-to-connect-to-server-formsservlet-1-applet-forms-not-opening-on-ie8/

above link contains following material.

FRM-92050 failed to connect to Server /forms/servlet -1



If you are trying to connect to Apps 11i/R12 instance from IE 8 and hitting error “FRM-92050 failed to connect to Server /forms/servlet -1“  while opening forms (as shown in figure below)

FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1

Then check version of IE

FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1


FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1


If version of IE is 8 then disable XSS filter
FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1

Steps to disable XSS filter
FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1

FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1

FRM-92050 failed to connect to Server /forms/servlet -1
FRM-92050 failed to connect to Server /forms/servlet -1



frm-92191 there was a failure in the form server during startup

frm-92191 there was a failure in the form server during startup


I was facing following problem when I was trying to run form from Oracle Form Builder 10g.

frm-92191 there was a failure in the form server during startup
frm-92191 there was a failure in the form server during startup

I have googled this and found some useful tips to remove this error which I am sharing below.

First of all I have followed the below link

https://sites.google.com/site/craigsoraclestuff/oracle-forms---how-to-s/forms-how-to-configure-forms-builder-to-run-forms-locally

and made changes accordingly in forms configuration (as explained in above link).

Secondly, I also found the metalink note for this too which is  604633.1 (please visit this on support.oracle.com for latest version).

Master Note For Known Causes of FRM-92101 Error In Forms [ID 604633.1]


In this Document
Purpose
Troubleshooting Steps
I. Forms Configuration issues.
II. Specific form related issues.
II. a) RUN_REPORT_OBJECT related issues
II. b) WEBUTIL related issues
II. c) Other issues
III. Platform configuration issues.
References

Applies to:

Oracle Forms - Version 10.1.2 to 10.1.2.3.0 [Release 10.1.2 to 10.1.2.3]
Information in this document applies to any platform.

Purpose

Checked for Version Accuracy- 07-Feb-2011
This note provides the most famous and popular situations where the error "FRM-92101: There was a failure in the Forms Server during startup.  " can be encountered.

Troubleshooting Steps



I. Forms Configuration issues.

1) Form is not compiled using the option COMPILE_ALL=YES
Solution
-----------
Compile the form using COMPILE_ALL=YES
e.g. frmcmp.sh module=[FormName] type=FORM userid=[user/pwd@db] COMPILE_ALL=YES....

Note 444690.1 Forms FRM-92050, FRM-92100, FRM-92101, FRM-92102 Reference Guide
2) Load balancer is used, but session binding mechanism is not correctly set.
Note 268830.1 Webcache Won't Load Balance 2 Forms Instances
Note 465583.1 FRM-92102 When Using A Software Load Balancer With Forms
Note 563817.1 Using Apache 2 "mod_proxy_balancer" in Load Balancing Forms
3) Long Running Query prevents the Forms Runtime process from acknowledging the client that it is in a waiting state.
Note 271611.1 Long Running Query / Procedure Causes Web Deployed Forms to Disconnect?
Note 415758.1 FRM-92101- HTTP Server Timeout at Long Running Queries
4) WorkingDirectory is incorrectly set in the formsweb.cfg file
Note 313050.1 Form Fails With FRM-92101 And Java.Lang.Numberformatexception: For input string ""
Note 334369.1 How To Set FORMS_PATH For Different Forms Applications Running in Static Mode
Note 432708.1 FRM-92101 Error in Application.log: Unable to Switch to Working Directory
5) FORMS_TIMEOUT is set to a value smaller than HEARTBEAT
Note 549735.1 Description List For Parameters Affect Timeout In Webforms
Note 375585.1 How To Avoid The Error Message FRM-92101 When Form Session Times Out
6) JVM Termination due to OS signals
Note 286584.1 - Getting Error FRM-92102 Intermittently with JVM Termination in Application.log
7) NLS related settings when activating Forms traces
Note 371444.1 FRM-92101 When Enabling Tracing In Webform For Any Tracegroup
8) NLS_LANG faulty settings
Note 433763.1 FRM-92101 and FRM-93000 when using Javabean on UNIX
9) Tracegroup is set in the URL
Note 434881.1 Form Hangs When Tracegroup Is Enabled
10) A log file grew more than 2GB (default-web-access.log)
Note 338805.1  OC4J_BI_Forms Instance Keeps Restarting Continuously


11) Formservlet is not deployed after installation of patch 9593176.

Note 1188127.1 Oracle Forms 10.1.2.3 Bundle Patch Frequently Asked Questions

Note 1058514.1 Forms Servlet (frmsrv.jar) Not Updated After Patching to 10.1.2.3


II. Specific form related issues.


II. a) RUN_REPORT_OBJECT related issues

Note 553840.1 How To Troubleshoot Frm-92101 When Using Run_Report_Object to Call Reports
1) Call RUN_REPORT_OBJECT when webutil is used
Note 365320.1 Webutil and Run_Report_Object Conflict, FRM-92101
2) Linux x86 RUN_REPORT_OBJECT
Note 342291.1 Forms 10g RUN_REPORT_OBJECT Fails With FRM-92101 / FRM-93000 on Red Hat Linux
3) Call RUN_REPORT_OBJECT while REPORT_FILENAME is set to NULL
 Note 795092.1  RUN_REPORT_OBJECT Fails with FRM-92101 When REPORT_FILENAME is NULL
4) Calling a report after setting REPORT_FILENAME property to a file with length > 75 characters

Note 444222.1 FRM-41203: Integration Error: Invalid parameterlist id Appears While Running Forms with Longer REPORT_FILENAME Parameter

5) Entering invalid password when running a form generated by Headstart

Note 392495.1 FRM-92101 When Wrong User Connection Instead Of ORA-1017 With Headstart Generated Form



II. b) WEBUTIL related issues

1) Using WEBUTIL.CLIENT_HOST in blocking mode

Note 452473.1 Webutil Clienthost Throws FRM-92102 Exception When Closing Notepad 15 Mins After Opening
2) Using Webutil_file.Directory_filtered_list on a Folder that Contains More than 1500 Files 
Note 465110.1 FRM-92101 or FRM-40735 When Using Webutil_file.Directory_filtered_list on a Folder that Contains More then 1500 Files
3) Webutil library is attached to another library on Vista
Note 736075.1  Running Forms Including Webutil on Vista causes "APPCRASH" error in the Browser, and FRM-92101
4) Writing more than 10922 Lines using CLIENT_TEXT_IO
Note 341899.1  WUC-14 And WUC-12 While Writing Many Lines by CLIENT_TEXT_IO
5) Uploading a file using Webutil upload functionality
Note 865610.1 Error FRM-92101 When Trying to Upload a File Using Webutil Upload Functionality

II. c) Other issues

1) Scroll bar issues after applying 10.1.2.2
Note 417048.1 Form Crashes With FRM-92101 After Applying 10.1.2.2 Patchset
2) Mouse Scroll Wheel issues after applying 10.1.2.2
Note 457919.1 After Updating To Forms 10.1.2.2 Mouse Scroll Wheel Crashes Forms: FRM-41839 FRM-92101
3) Background / Foreground Color is set and Fill Pattern is set to None
Note 359934.1 FRM-92101 When Forms Window Has Background / Foreground Color Set and Fill Pattern Set to None
Note 417693.1 FRM-92101 When Opening Forms Application that contains Block Scrollbar
4) Tree nodes and 10.1.2.0.2
Note 362442.1 Assertion Failed Error and FRM-92101 With Usage Of When-Mouse-Doubleclick Trigger For a Tree.
5) Using SET_VA_PROPERTY('Xx',Xx_color, NULL);
Note 356718.1 FRM-92101 Using Set_va_property('Xx',Xx_color, X); When X=Null
6) Canceling a query when Interactive Mode is set to Non-Blocking
Note 461586.1 ORA-12157, ORA-3114, FRM-92101 WHEN USING INTERACTION MODE NON-BLOCKING
7) Calling RDBMS package while not connected
Note 388106.1 FRM-92101 FRM-93000 When Forms Not Connected And A Stored Program unit is called (eg DBMS Package)
8) Using PLSQL_TABLE.* functions in the Forms trigger
Note 271249.1 FRM-92101 When Running A Form Based On Stored Procedure
9) Calling a DB package with nested table
Note 271412.1 form Crashes If Passing Record Type Variable With Nested Table From The Database
10) Stack Overflow
Note 405057.1 FRM-92101,FRM-93000 While Using Javabean to Export Data From RDBMS to Excel
11) Bean Area CANVAS property is set to NULL
Note 580337.1 How To Avoid FRM-92101 If no Canvas is Attached to a Java Bean Item
12) Using TO_VARIANT  built-in
Note 422024.1 Forms 9.0.x OR 10.1.2.x Fail With FRM-92101 When Using TO_VARIANT
13) Modifying a form with attached libraries in the builder before connecting to Database
Note 330497.1 Form With WebUtil.pll Attached Unexpectedly Crashes At Runtime With FRM-92101
14)  Modifying the expired password, but the new password does not meet the conditions defined in PASSWORD_VERIFY_FUNCTION
Note 755377.1 Frm-92101 While Changing Password During Logon

III. Platform configuration issues.

1) Windows heapsize
Note 187455.1 FRM-92101, FRM-92050 and FRM-93000 Error When Running Forms After a Number of Concurrent Connections and No New Connection Possible
Note 393163.1 How To Check Utilization of "Desktop Heap" on MS Windows Platforms Using "dheapmon"
2) Windows updates have been installed on the client
Note 362085.1 Getting FRM-92101 If Windows Client Using Sun JDK plug-in 1.4.x Has MS KB912945 Patch Installed
3) Maximum number of processes per user (maxuprc) is small.
Note 565774.1 FRM-92101 occurs when more than 200 sessions connect to Forms on HP-UX
4) Using Windows WLBS Drainstop
Note 559703.1 Forms Sessions Being Terminated When Using WLBS Drainstop
5) Improper replacing of forms run time files on the fly
Note 286762.1 How to Replace Forms Runtime Files in Production Environments 'On The Fly'
Note 151618.1 "Unable to Replace .fmx Files 'On The Fly' During Forms Runtime"
6) kernel.threads-max is set to a low value
Note 375478.1 FRM-92101 And Internal Server Error When Creating A New Session
7) LD_ASSUME_KERNEL is not set in the default.env
Note 304781.1 Forms Hangs Intermittently On Redhat AS 3 with FRM-92100
8) openmotif is of higher version
Note 312276.1 FRM-92101 Starting Test Module in a Fresh Installed Oracle Applicationserver
9) Too Many Open Files fs.file-max
Note 415448.1 FRM-92101 Formsweb: Java.Io.Ioexception: Too Many Open Files on Linux
Note 422143.1 How To Find The Number Of Open Files For a Process Name and Process pid?
10) Installing new JDK version on AIX
Note 417208.1 REP-0132: COULD NOT START A JVM AFTER UPGRADE OF JDK TO 142 CA142-200604 (SR5)
Note 417075.1 Getting FRM-92101 / Frmweb_dump after installing new jdk version on AIX
11) Forms MAKEFILE error when upgrading to 10.1.2.3
Note 564747.1 FORMS MAKEFILE ERROR WHEN UPGRADING TO 10.1.2.3 ON LINUX 64BIT SERVER
12) No swap devices configured
Solution
-----------
- Terminate some processes (preferably ones that are using a lot of virtual memory)
- Add swap space to your system. The method for adding swap space to a system varies
between UNIX variants: consult your operating system documentation or vendor for details.
You can use the commands listed below for adding, deleting, and monitoring the system swap areas for the associated operating system:

SUN Solaris                       #/usr/sbin/swap -l
HP 9000 Series HP-UX     # /etc/swapinfo
Digital UNIX                      % /usr/sbin/swapon -s
IBM RS/6000 AIX            % /etc/lsps -a
Note 17094.1 TECH: Unix Virtual Memory, Paging & Swapping explained
Note 69083.1 Common UNIX Commands Available on Most UNIX Platforms
13) Solaris 10 installation is missing some packages and patches
Note 554628.1 Running Test Form on Fresh Installation of Application Server on Solaris 10 Gives Error: FRM-92101
14) Using RUN_REPORT_OBJECT on SolarisNote 846950.1 Forms 10g RUN_REPORT_OBJECT Fails With FRM-92101 / FRM-93000 on Solaris

15) EXECUTE_QUERY or Scrolling on Solaris
Note: 888244.1 FRM-92101 When Executing EXECUTE_QUERY Built-in Concurrently or Scrolling in a Master-Detail Block

References

NOTE:1058514.1 - Forms Servlet (frmsrv.jar) Not Updated After Patching to 10.1.2.3
NOTE:1188127.1 - Oracle Forms 10.1.2.3 Bundle Patch Frequently Asked Questions (FAQ)
NOTE:151618.1 - Unable to Replace .fmx Files 'On The Fly' During Forms Runtime
NOTE:17094.1 - TECH: Unix Virtual Memory, Paging & Swapping explained
NOTE:187455.1 - FRM-92101, FRM-92050, FRM-93552 and FRM-93000 Error When Running Forms After a Relatively Small Number (50 - 80) of Concurrent Connections and No New Connection Possible
NOTE:268830.1 - Webcache Won't Load Balance 2 Forms Instances
NOTE:271249.1 - FRM-92101 When Running A Form Based On Stored Procedure and using PLSQL_TABLE
NOTE:271412.1 - Form Crashes If Passing Record Type Variable With Nested Table From The Database
NOTE:271611.1 - Long Running Query / Procedure Causes Web Deployed Forms to Disconnect?
NOTE:286584.1 - Getting Error FRM-92102 Intermittently with JVM Termination in Application.log
NOTE:286762.1 - How to Replace Forms Runtime Files in Production Environments 'On The Fly'
NOTE:304781.1 - Forms Hangs Intermittently On Redhat AS 3 With FRM-92100
NOTE:312276.1 - FRM-92101 Starting Test Module in a Fresh Installed Oracle Applicationserver
NOTE:313050.1 - Form Fails With FRM-92101 And Java.Lang.Numberformatexception: For input string ""
NOTE:330497.1 - Form With WebUtil.pll Attached Unexpectedly Crashes At Runtime With FRM-92101
NOTE:334369.1 - How To Set FORMS_PATH For Different Forms Applications Running in Static Mode
NOTE:338805.1 - OC4J_BI_Forms Instance Keeps Restarting Repeatedly
NOTE:341899.1 - WUC-14 And WUC-12 While Writing Many Lines by CLIENT_TEXT_IO
NOTE:342291.1 - Forms 10g RUN_REPORT_OBJECT Fails With FRM-92101 / FRM-93000 on Red Hat Linux
NOTE:356718.1 - FRM-92101 Using Set_va_property('Xx',Xx_color, X); When X=Null
NOTE:359934.1 - FRM-92101 When Forms Window Has Background / Foreground Color Set and Fill Pattern Set to None
NOTE:362085.1 - Getting FRM-92101 If Windows Client Using Sun JDK plug-in 1.4.x Has MS KB912945 Patch Installed
NOTE:362442.1 - Assertion Failed Error and FRM-92101 With Usage Of When-Mouse-Doubleclick Trigger For a Tree.
NOTE:365320.1 - Webutil and Run_Report_Object Conflict, FRM-92101
NOTE:371444.1 - FRM-92101 When Enabling Tracing In Webform For Any Tracegroup
NOTE:375478.1 - FRM-92101 And Internal Server Error When Creating A New Session
NOTE:375585.1 - How To Avoid The Error Message FRM-92101 When Form Session Times Out
NOTE:388106.1 - FRM-92101 FRM-93000 When Forms Not Connected And A Stored Programunit called (eg DBMS Package)
NOTE:392495.1 - FRM-92101 When Wrong User Connection Instead Of ORA-1017 With Headstart Generated Form
NOTE:393163.1 - How To Check Utilization of "Desktop Heap" on MS Windows Platforms Using "dheapmon"
NOTE:405057.1 - FRM-92101,FRM-93000 While Using Javabean to Export Data From RDBMS to Excel
NOTE:415448.1 - FRM-92101 Formsweb: Java.Io.Ioexception: Too Many Open Files on Linux
NOTE:415758.1 - FRM-92101- HTTP Server Timeout at Long Running Queries
NOTE:417048.1 - Form Crashes With FRM-92101 After Applying 10.1.2.2 Patchset
NOTE:417075.1 - Getting FRM-92101 / frmweb_dump After Installing New JDK Version on AIX
NOTE:417208.1 - REP-0132: COULD NOT START A JVM AFTER UPGRADE OF JDK TO 142 CA142-200604 (SR5)
NOTE:417693.1 - FRM-92101 When Opening Forms Application That Contains Block Scrollbar
NOTE:422024.1 - Forms 9i or 10g Prior To 10.1.2.3 Fail With FRM-92101 When Using TO_VARIANT
NOTE:422143.1 - How To Find The Number Of Open Files For a Process Name and Process pid?
NOTE:432708.1 - FRM-92101 Error in Application.log: Unable to Switch to Working Directory
NOTE:433763.1 - FRM-92101 and FRM-93000 when using Javabean on UNIX
NOTE:434881.1 - Form Hangs When Tracegroup Is Enabled
NOTE:444222.1 - FRM-41203: Integration Error: Invalid parameterlist id Appears While Running Forms with Longer REPORT_FILENAME Parameter
NOTE:444690.1 - Master Note for Forms FRM-92050, FRM-92100, FRM-92101, FRM-92102 Reference Guide
NOTE:452473.1 - Webutil Clienthost Throws FRM-92102 Exception When Closing Notepad 15 Mins After Opening
NOTE:457919.1 - After Updating To Forms 10.1.2.2 Mouse Scroll Wheel Crashes Forms: FRM-41839 FRM-92101
NOTE:461586.1 - ORA-12157, ORA-3114, FRM-92101 WHEN USING INTERACTION MODE NON-BLOCKING
NOTE:465110.1 - FRM-92101 or FRM-40735 When Using Webutil_file.Directory_filtered_list on a Folder that Contains More than 1500 Files
NOTE:465583.1 - FRM-92102 When Using A Software Load Balancer With Forms
NOTE:549735.1 - Description List For Parameters Affect Timeout In Webforms
NOTE:553840.1 - How To Troubleshoot Frm-92101 When Using Run_Report_Object to Call Reports
NOTE:554628.1 - Running Test Form on Fresh Installation of Application Server on Solaris 10 Gives Error: FRM-92101
NOTE:559703.1 - Forms Sessions Being Terminated When Using WLBS Drainstop.
NOTE:563817.1 - Using Apache 2 "mod_proxy_balancer" in Load Balancing Forms
NOTE:564747.1 - FORMS MAKEFILE ERROR WHEN UPGRADING TO 10.1.2.3 ON LINUX 64BIT SERVER
NOTE:565774.1 - FRM-92101 occurs when more than 200 sessions connect to Forms on HP-UX
NOTE:580337.1 - How To Avoid FRM-92101 If no Canvas is Attached to a Java Bean Item
NOTE:69083.1 - Common UNIX Commands Available on Most UNIX Platforms
NOTE:736075.1 - Running Forms Including Webutil on Vista causes "APPCRASH" error in the Browser, and FRM-92101
NOTE:755377.1 - Frm-92101 WHILE CHANGING PASSWORD DURING LOGON
NOTE:795092.1 - RUN_REPORT_OBJECT Fails with FRM-92101 When REPORT_FILENAME is NULL
NOTE:846950.1 - Forms 10g RUN_REPORT_OBJECT Fails With FRM-92101 / FRM-93000 on Solaris
NOTE:865610.1 - Error FRM-92101 When Trying to Upload a File Using Webutil Upload Functionality
NOTE:888244.1 - FRM-92101 When Executing EXECUTE_QUERY Built-in Concurrently or Scrolling in a Master-Detail Block



Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions

app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries

app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries


When I try to close AR periods I was facing following errors.

app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries
app-ar-294571 the period cannot be closed due to some unprocessed accounting events or untransferred journal entries


Solution can be find from the Oracle Note: 1479975.1

I am pasting Note detail below but it is highly recomended to check this note from support.oracle.com for updated version (if any).

Create Accounting APP-AR-294571 : The Period Cannot Be Closed Due to Some Unprocessed Accounting Events or Untransferred Journal Entries [ID 1479975.1]

In this Document
Symptoms
Cause
Solution




Applies to:

Oracle Receivables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

Attempting to run Create Accounting and receive the following error:
APP-AR-294571 : The PERIOD cannot be closed due to some unprocessed accounting events or un-transferred journal entries.

Cause

Found that Un-Approved Adjustments were present.
Adjustments are not Approved or Rejected.  Two adjustments were in Pending status and need to be processed by users.
In Release 12, Pending adjustments have to be processed.

Solution

Run the following to find the offending Entries.
select     et.source_id_int_1, et.entity_code, et.entity_id,
    ev.event_id, ev.entity_id, ev.event_type_code,
    ev.event_status_code, ev.event_date,
     et.SECURITY_ID_INT_1, et.ledger_id, et.transaction_number
from    XLA.XLA_TRANSACTION_ENTITIES et,
    XLA.XLA_EVENTS ev
where    ev.event_date between to_date('&startdate', 'dd-mon-yyyy') AND
        to_date('&enddate', 'dd-mon-yyyy')
and    ev.event_status_code not in ('P','N')
and     ev.application_id = 222
and     et.entity_id = ev.entity_id;
Check the following Things for the Adjustment in question
1. Status is in W (Pending) or R (Rejected)
2. Event Status Code for Pendng (W) or N for (Rejected).  These statuses then need to be resolved.

Pending Adjustments (W) need to be processed by Users.

Responsibility:  Receivables Manager
Navigation:  Control > Adjustments > Approve Adjustments
Process the adjustments and run Create Accounting with the period open in AR and GL in question
 

Related

Errors

APP-AR-294571




Your feedback/comment is quite important for improving this blog so feel free to leave your comments & suggestions