Monthly Archives: September 2015

Oracle EBS: Concurrent Program – GL Code Combination Parameter

http://www.negocioseninternetrentables.com/flomance/317 Scenario

The requirement is to pass code combination as an input parameter to the concurrent program report.

 

http://educatedangler.com/dwonwik/nired/2784 Case 1 – To pass the code combination segment values as-is based on the code combination passed as a parameter. The requirement is not to validate the input combination and no dynamic insert

Create a ValueSet – Special Validation Type

Create Event useful link Edit

FND POPID
APPL_SHORT_NAME=SQLGL
CODE=”GL#”
NUM=:$FLEX$.GL_SRS_CHART_OF_ACCOUNTS_ID
REQUIRED=N
VALIDATE=NONE
SEG=:!VALUE
DESC=:!MEANING
DATA_FIELD=:!ID
DINSERT=N

Create Event visit homepage Load

FND LOADID
APPL_SHORT_NAME=SQLGL
CODE=”GL#”
NUM=:$FLEX$.GL_SRS_CHART_OF_ACCOUNTS_ID
REQUIRED=N
VALIDATE=NONE
SEG=:!VALUE
DESC=:!MEANING
DATA_FIELD=:!ID
DINSERT=N

Special_Validation_Routine

pop over here Case 2 – To pass the code combination ID based on the code combination passed as a parameter

Refer to Standard Concurrent Program Report – GL Cash Clearing Account Analysis Report

Value Set – GL_SRS_FLEXFIELD

Oracle EBS: OAF VO Extension of Java File – oracle.jbo.SQLStmtException: JBO-27122: SQL error


Scenario

In a situation where the iProcurement page has been extended to display the requisitions to preparer, the following error has occurred:

Error Page

Exception Details.
click for more oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select
requisition_header_id,
segment1,
description,
creation_date,
POR_VIEW_REQS_PKG.GET_REQ_TOTAL(REQUISITION_HEADER_ID) req_total,
POR_RCV_POST_QUERY_PKG.getOrderNumber(REQUISITION_HEADER_ID) order_num_release_num,
POR_RCV_POST_QUERY_PKG.getSupplier(REQUISITION_HEADER_ID) supplier,
ORG_ID OPERATING_UNIT
from
po_requisition_headers) QRSLT WHERE (requisition_header_id in (select requisition_header_id from por_rcv_reqs_all_v where ( to_person_id = :1 or preparer_id = :1 ) ))

http://www.hikmahasiabatamtours.com/660-dte42246-senior-christian-dating-site.html ## Detail 0 ##
questions to ask online dating message java.sql.SQLException: Missing IN or OUT parameter at index:: 2

Receiving_Tab

Cause

Ensure the bind variables have a different name when Oracle Positional is chosen as a binding style while extending the standard View Object

( to_person_id = :1 or preparer_id = :1 )

Fix

The binding name needs to unique when used in a query. Although the value to be provided is same to the SQL, use a different binding name to resolve the above error.