Oracle Blogs

Charts Of Accounts Structure, query is given below. The query here will fetch you following list of columns: 1. Business Unit Name 2. Ledger Name 3. Charts Of Accounts Name 4. Segment Name 5. Value Set Code 6. Value Set Description Charts Of Accounts Structure Query select hou.name BU_NAME, led.NAME Ledger_Name, Str.STRUCTURE_CODE CHART_OF_ACCOUNTS_Name, SegInSt.SEGMENT_CODE COA_SEGMENT_NAME, vs.value_set_code, vs.description value_set_desc from hr_operating_units hou, xla_gl_ledgers led , fnd_kf_structures_b Str, fnd_kf_str_instances_b StrInSt, fnd_kf_segment_instances SegInSt, fnd_vs_value_sets vs where 1=1 and led.ledger_id = hou.set_of_books_id AND led.CHART_OF_ACCOUNTS_ID = Str.Structure_id AND Str.KEY_FLEXFIELD_CODE = ‘GL#’ AND Str.Structure_id = StrInSt.Structure_id and SegInSt.Structure_inStance_id = StrInSt.Structure_inStance_id and vs.VALUE_SET_ID = SegInSt.VALUE_SET_ID If you look at the query above, you will see that every Business Unit has something called “Set of Book...

 opaque schema xsd (standard file used in OIC) You can use an opaque schema in a stage file action Read File or Write File operation without concern for a schema for the file.   The only condition is that whatever is sent to the opaque element in the opaque schema must be base64-encoded data.  or in other words  it is used to decode base64 files Save the below xml as  opaqueschema.xsd  file and then you can use it in the integration. <?xml version = '1.0' encoding = 'UTF-8'?> <schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/" xmlns="http://www.w3.org/2001/XMLSchema" > <element name="opaqueElement" type="base64Binary" /> </schema>