Concurrent program Registration with Oracle Application.   Leave a comment

Creating a Sample program and Registering with Oracle Application.

Step-1

1

STEP-2

Create Table in XXERP schema

2

create table xxerp_emp as select * from scott.emp;

STEP-3

Create sql file in XXERP_TOP under  sql folder

3

4

Step-4

Register The EXECUTABLE with Oracle Application

Navigation

Concurrent—>Program—>Executable

5

Step-5

Create Program for Executable

6

Step-6

Add the program to Request Group.

7

Logout from sysadmin and login with the Responsibility who own the above created Request Group and run the program

8

9

The error is  due to the absence of synonym for xxerp_emp table in apps schema (schema which got created when we create custom schema during custom application registration)

[oracle@rao3 ~]$ sqlplus apps/apps

SQL*Plus: Release 11.1.0.7.0 – Production on Wed Apr 17 10:12:16 2013

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create public synonym xxerp_emp for xxerp.xxerp_emp;

Synonym created.

TRY RUNNING THE CONCURRENT PROGRAM AGAIN………………….

Advertisements

Posted October 30, 2013 by balaoracledba.com in OracleAppsR12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: