Skip to content
Advertisements

Posts from the ‘EBS’ Category

REST API Record Type Example

Goal :

Multi data insert into table of EBS 12.1 or 12.2 Enviornment

Follow the procedure :

Steps 1:

Create a package using with record type

 

CREATE OR REPLACE PACKAGE APPS.xxace_ap_restapi
AS
/* $Header: xxace_ap_restapi$ */
/*#
* This custom PL/SQL package can be used to load AP Invoices from restapi test.
* @rep:scope public
* @rep:product AP
* @rep:displayname AP Invoice Interface for restapi test
* @rep:category BUSINESS_ENTITY XXAPTEST_INT
*/
type xx_invoice_rec_test is record
(p_invoice_type VARCHAR2(30)
,p_invoice_number VARCHAR2(30)

);
type xx_invoice_tbl_test is table of xx_invoice_rec_test INDEX BY BINARY_INTEGER;
PROCEDURE xxace_ap
(
p_invoice_tbl1 in xx_invoice_tbl_test
,p_out_success_1 out VARCHAR2
,p_out_failure_2 out VARCHAR2
)
/*#
* Procedure to Load AP Invoice
* @param p_invoice_tbl1 in parameter 1
* @param p_out_success_1 out parameter 1
* @param p_out_failure_2 out parameter 2
* @rep:displayname AP Invoice Interface for restapi test
* @rep:category BUSINESS_ENTITY XXAPTEST_INT
* @rep:scope public
* @rep:lifecycle active
*/
;
end xxace_ap_restapi;
/

 

Package Body

CREATE OR REPLACE PACKAGE BODY APPS.xxace_ap_restapi
AS
PROCEDURE xxace_ap (p_invoice_tbl1 IN xx_invoice_tbl_test,
p_out_success_1 OUT VARCHAR2,
p_out_failure_2 OUT VARCHAR2)
IS
l_count NUMBER := 0;
–l_inv_seq NUMBER:= AP_INVOICES_INTERFACE_S.NEXTVAL;
excp EXCEPTION;

v_count NUMBER := 0;

V_PRE NUMBER;
V_AMT NUMBER;
v_cur VARCHAR2 (100);
BEGIN
FOR i IN p_invoice_tbl1.FIRST .. p_invoice_tbl1.LAST
LOOP
p_out_success_1 := NULL;
p_out_failure_2 := NULL;
v_count := v_count + 1;

p_out_success_1 :=
p_invoice_tbl1(i).p_invoice_number|| ‘no data’
|| ‘ ‘
|| v_count;

IF p_invoice_tbl1(i).p_invoice_number IS NULL
THEN
p_out_failure_2 := ‘Invoice Number is Missing.’;
— RAISE EXCP;
ELSIF p_invoice_tbl1(i).p_invoice_type IS NULL
THEN
p_out_failure_2 := ‘Invocie Type is Missing.’;
— RAISE EXCP;
END IF;

BEGIN
INSERT
INTO xxace.XXACE_CMS_AP_INV_STG (staging_id,
invoice_type,
invoice_number)
VALUES (
xxace_ap_stg_seq.NEXTVAL,
CASE
WHEN UPPER (p_invoice_tbl1(i).p_invoice_type) LIKE
‘CREDIT NOTE%’
THEN
‘Standard’
WHEN UPPER (p_invoice_tbl1(i).p_invoice_type) LIKE
‘DEBIT NOTE%’
THEN
‘Debit Memo’
ELSE
p_invoice_tbl1(i).p_invoice_type
END,
p_invoice_tbl1(i).p_invoice_number);
EXCEPTION
WHEN EXCP
THEN
ROLLBACK;
END;
END LOOP;

COMMIT;

END xxace_ap;
END xxace_ap_restapi;
/

 

Pls File : xxace_ap_restapi.pls

CREATE OR REPLACE PACKAGE xxace_ap_restapi
AS
/* $Header: xxace_ap_restapi $ */
/*#
* This custom PL/SQL package can be used to load AP Invoices from restapitest.
* @rep:scope public
* @rep:product AP
* @rep:displayname AP Invoice Interface for restapi test
* @rep:category BUSINESS_ENTITY XXAPTEST_INT
*/
type xx_invoice_rec_test is record
(p_invoice_type VARCHAR2(30)
,p_invoice_number VARCHAR2(30)

);
type xx_invoice_tbl_test is table of xx_invoice_rec_test INDEX BY BINARY_INTEGER;
PROCEDURE xxace_ap
(
p_invoice_tbl1 in xx_invoice_tbl_test
,p_out_success_1 out VARCHAR2
,p_out_failure_2 out VARCHAR2
)
/*#
* Procedure to Load AP Invoice
* @param p_invoice_tbl1 in parameter 1
* @param p_out_success_1 out parameter 1
* @param p_out_failure_2 out parameter 2
* @rep:displayname AP Invoice Interface for restapi test
* @rep:category BUSINESS_ENTITY XXAPTEST_INT
* @rep:scope public
* @rep:lifecycle active
*/
;
end xxace_ap_restapi;

 

 

Step 2:

create Business Entity using Application Developer

Business Entity : XXAPTEST_INT

Step 3: PLS File Upload

copy xxace_ap_restapi.pls to /tmp & $AP_TOP/patch/115/sql

cd $AP_TOP/patch/115/sql

$IAS_ORACLE_HOME/perl/bin/perl $FND_TOP/bin/irep_parser.pl -g -v -username=intuser ap:patch/115/sql:xxace_ap_restapi.pls:12.0=/tmp/xxace_ap_restapi.pls -outdir=$AP_TOP/patch/115/irep/patch/115/sql/

cd $AP_TOP/patch/115/irep/patch/115/sql/

$FND_TOP/bin/FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/wfirep.lct xxace_ap_restapi_pls.ildt

Step 4:

Deploy REST Service using Integrated SOA Gateway

Internal name : xxace_ap_restapi

and give grant

 

Step 5: Testing the REST API (REST API Chrome Client )

 

 

Body :

 

{
“xxace_ap”: {
“@xmlns”: “http://XXXXXXX.com:8065/webservices/rest/xxace_ap_restapi/xxace_ap/”,
“RESTHeader”: {
“@xmlns”: “http://xxxxxxxxxcom:8065/webservices/rest/xxace_ap_restapi/xxace_ap/”,
“Responsibility”: “20-***_**_USER”,
“RespApplication”: “SQLAP”,
“SecurityGroup”: “STANDARD”,
“NLSLanguage”: “AMERICAN”
},
“inputParameters”: {
“P_INVOICE_TBL1”:
{
“attributes1” : {“P_INVOICE_TYPE”: “CREDIT NOTE”,
“P_INVOICE_NUMBER”: “12345test” },
“attributes2” : {“P_INVOICE_TYPE”: “DEBIT NOTE”,
“P_INVOICE_NUMBER”: “12345testnew” },
“attributes3” : {“P_INVOICE_TYPE”: “DEBIT NOTE”,
“P_INVOICE_NUMBER”: “12345testnewAPI” }
}
}
}
}

 

POST Data Send

Output :

 

Check the tables inserted or not

 

 

NOTE :

  1. Parsing parameter should be “RECORD TYPE SEQUENCE” which  you written the query RECORD TYPE  in Packages
  2. Parsing the VALUE in REST API Client , you should send like ” attribute1,attribute2,attribute3… this is common name”

Manual Checking :

 

DECLARE

l_out_success_1   varchar2 (30);

l_out_failure_2   varchar2 (30);

l_invoice_data    xxace_ap_restapi.xx_invoice_tbl_test;

BEGIN

l_invoice_data (1).p_invoice_type := ‘Type1’;

l_invoice_data (1).p_invoice_number := ‘Inv001’;

xxace_ap_restapi.xxace_ap (p_invoice_tbl1    => l_invoice_data,

p_out_success_1   => l_out_success_1,

p_out_failure_2   => l_out_failure_2);

 

DBMS_OUTPUT.put_line (‘ l_out_success_1 ‘ || l_out_success_1);

DBMS_OUTPUT.put_line (‘ l_out_failure_2 ‘ || l_out_failure_2);

END;

 

Advertisements

Enable SOA Log for EBS 12.1 and 12.2

EBS 12.1

$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties

Add the lines

SOA_ENABLE_STANDALONE_LOGGING=TRUE

 

Bounce the adoafmctl.sh

and then log file will generate $INST_TOP/soa/SOALog.log

 

EBS 12.2 :

How to Generate File ISGLog.log for SOAP Services in Release 12.2.X? (Doc ID 2008707.1)

Please be note, you need to see the logfile when the transaction are incoming to server

/u01/EBSLEBUAT/fs2/FMW_Home/user_projects/domains/EBS_domain_LEBDEV/servers/oafm_server1/logs

 

 

ORACLE E-BUSINESS SUITE 12.2.8 RELEASE UPDATE

Oracle is pleased to announce the availability of Oracle E-Business Suite 2018 innovations, which include Oracle E-Business Suite 12.2.8 and other 2018 updates delivered prior to 12.2.8

Refer  :

http://www.oracle.com/us/products/applications/ebs-2018-innovations-5119373.pdf

https://community.oracle.com/thread/4176619

http://learn.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:243,objectId:22957

 

ons port connection refused

When I try to open forms, I am getting the below issue

 

FRM-92102: A network error has occurred.
The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success.
Please check the network connection and try again later.

Details…
Java Exception:
java.io.FileNotFoundException: http://ebsuat.xxx.xx:8005/foms/x

 

So I checked the logfile in opmn.log, it shows

” [ons-connect] Connection e5e,ebsuat.xxxx.xxx,6265 connect (Connection refused) ‘

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:6265 0.0.0.0:* LISTEN 1213/opmn

 

Solution :

Please check the hostname entry with localhost, If its, Please remove the hostname entry line on localhost

restart application

[appluat@ebsuat scripts]$ netstat -anp | grep 6265
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 10.1.xxx.xx:6265 0.0.0.0:* LISTEN 1213/opmn

 

Now I can able to open the forms

libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′

When we try to rebuild the forms or reports, you may get the below issues

“[appluat@ebsuat lib]$ make -f ins_reports.mk install
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so; \
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.so
rm -f rwsutil.o rwspid.o ; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.a rwsutil.o rwspid.o ; \
(LD_OPTIONS=”-z muldefs”; \
/usr/bin/gcc -m32 -o /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so -shared -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ rwsutil.o rwspid.o \
-lm /u01/EBSUAT/apps/tech_st/10.1.2/lib/libclntsh.so -lpthread -Wl,-rpath,/usr/X11R6/lib -L/usr/X11R6/lib -lXm -lXt -lX11 -lm -lXp -lXext `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -lc )
rm -f zrhitem.o zrhcursor.o; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a zrhitem.o zrhcursor.o
rm -f rwbuilder
gcc -m32 -o rwbuilder -L/u01/EBSUAT/apps/tech_st/10.1.2//lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib//stubs -rdynamic -Bdynamic -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386 -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386/server -L/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads -ljvm rxmasb.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/ui10.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/uiicxd.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwsng.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwscl.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwssc.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwssc0.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwsdt.o /u01/EBSUAT/apps/tech_st/10.1.2/reports/lib/rwscr.o -lrw /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a -lobx -lnn -lrws -lde /u01/EBSUAT/apps/tech_st/10.1.2/lib//libzrc.a -lrws -lucol -luicc -lca -lmma -lmmiw -lmmov -lmma -lmmos -lmmoi -lmmia -lmmft -lmmcm -lvgs -luihx -luc -luipr -luimotif -lot -lrem -lree -lrec -luiimg -luimotif -luipr -luiimg -luc -lrem -luimotif -luia -ltknqap -luipr -luimotif -lutt -lix -lixd -lrod -lror -lros -lrod -lror -lros -lrod -luat -ldfc -lutc -lutj -lutl -lutsl -lpls10 -lplp10 /u01/EBSUAT/apps/tech_st/10.1.2/lib/libplc10.a -lpls10 -lplp10 -lslax10 -lsql10 -lclntsh `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -Wl,-rpath,/u01/EBSUAT/apps/tech_st/10.1.2/lib,-rpath,/u01/EBSUAT/apps/tech_st/10.1.2/jdk/jre/lib/i386:/lib:/usr/lib -lm `cat /u01/EBSUAT/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lpthread -lm -L/u01/EBSUAT/apps/tech_st/10.1.2/lib -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ -lsnls10 -lpthread -ljvm -lhpi -Wl,-rpath,/usr/X11R6/lib -L/usr/X11R6/lib -lXm -lXt -lX11 -lm -lXp -lXext /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.a -lnsl
/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′
/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4′
/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4′
collect2: ld returned 1 exit status
make: *** [rwbuilder] Error 1″

 

Solution :

Oracle Forms Upgrade to 10.1.2.3 fails with error /usr/lib/libXtst.so.6: undefined reference (Doc ID 1120527.1)

 

 

OUI to the latest version on EBS 12.1.3

you must required to upgrade OUI to latest version on EBS Version while Deploying JRE native for Windows Client, Here If you need to execute runInstaller like below

 

./runInstaller -ignoreSysPrereqs -invPtrLoc /u01/EBSUAT/apps/tech_st/10.1.2/oraInst.loc

 

 

Deploying JRE for Windows Clients in Oracle E-Business Suite Release 12

Deploying JRE for windows clients in Oracle E-Business suite release 12.1.3 Follow the document

  1. Follow the document
Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1) . 

 

Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 (Doc ID 437878.1)

 

2. Steps

Upgrade latest OUI 6640838 and then applying below patches use by opatch 6880880 with 10.1.0.0.0

Upgrade Patch :

Apply patch  14825718

Apply overlay patch 26825525

and follow post installation steps on 437878.1

Integrated SOA gateway page loading long time no response

When you try to open ‘Integrated SOA gateway page in EBS and loading  long time with no response”

 

Solution :

Run Gather schema statistics

exec fnd_stats.gather_schema_statistics(‘ALL’);

 

 

How to test REST Service (POST) for EBS 12.1/12.2

Step 1: Deployed rest service in EBS

(Create package & body for inserting data into table & Create Business entity, then you create pls & upload it & Deployed)

Give grant to specific user, That particular responsibility should be assigned to user.

Note the “Responsibility Key”

Step 2: Install Chrome Rest Service Client

Step 3:  Now you have WADL file for you deployed service

Step 4:  Example POST Data

Granted user credentials

POST Data

 

Parameter :

{

“xxace_main”: {

“@xmlns”: “http://ebsdevxxxx/webservices/rest/XXACETESTNEW/xxace_main/“,

“RESTHeader”: {

“Responsibility”: “20-LEBANON_AR”,

“RespApplication”: “AR”,

“SecurityGroup”: “STANDARD”,

“NLSLanguage”: “AMERICAN”

},

“inputParameters”: {

“P_CUSTOMER_NAME_1”: “Testing Done31”

}

}

}

 

 

oracle.apps.fnd.isg.common.error.ISGException: Could not find the package.

When you’re trying to deploy rest service , you might be get the below issue

 

Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: Error in the generating PLSQL package at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:494) at oracle.apps.fnd.isg.app.ebs.designer.db.DBRestDesigner.generateService(DBRestDesigner.java:52) at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(AbstractServiceDesigner.java:34) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateService_Internal(ServiceAdministrator.java:453) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateNdeployService(ServiceAdministrator.java:154) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:971) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:953) at oracle.apps.fnd.isg.mgmt.server.ISGServerMBean$ThreadedTaskRunner.run(ISGServerMBean.java:114) at java.lang.Thread.run(Thread.java:745) Caused by: oracle.apps.fnd.isg.common.error.ISGException: Could not find the package. at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.currentSchemaName(DBServiceDesigner.java:677) at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.getSchemaName(DBServiceDesigner.java:616) at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:127) … 8 more

Solution :

Please check your internal name, the internal should be a package name, it should not be an “apps.packagename”. remove apps from your pls file and upload again.