OAF VO Binding Styles

Following are the binding styles that can be used in the OAF screens.

Oracle Positional: This style represents parameters as colons followed by numbers, as in the following code fragment:WHERE bar = :1 AND foo = :2 In this style, the numbers are just for easier readability: Parameters are passed into the view object in the order in which the numbers occur. The above fragment, for example, is equivalent to WHERE bar = :70 AND foo = :3

Oracle Named: This style represents parameters as colons followed by identifiers, as in the following code fragment:WHERE bar = :barparam AND foo = :fooparam Unlike the positional styles, the names of the parameters are actually used when the application fills the parameter values

JDBC Positional: This style represents parameters as question marks, as in the following code fragment:WHERE foo = ? AND bar = ?. This should be used only if you are working with non-oracle database.

How to check import errors from Order Import R12

Use the below Select statement to verify.

SELECT OPT.*

  FROM OE_PROCESSING_MSGS OPM,

       OE_PROCESSING_MSGS_TL OPT

WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID

   AND ORIGINAL_SYS_DOCUMENT_REF = '4347358'; -- This is Req Number