NorCal OAUG Training Day, Pres 5.12课件.ppt

Create an Integrator (5 of 5) The Importer identifies what the Integrator should do with data that has been uploaded to the I/F tables, typically submit a process to import the data into the base E-Business Suite Importer Type: Asynchronous concurrent request Importer Name: JP_RA_IF_NN 精品文档 Create an Integrator (5 of 5) 精品文档 Integrators and I/F Tables An Integrator can only insert records into one table. Oracle does not support inserts into multiple tables at this time. So how do you perform Header and Line I/F Table Inserts? There is a way around this using a PL/SQL Procedure Procedure must take header/line level data For each record query for header record If it exists reference it If it does not exist insert it 精品文档 PL/SQL API Integrators The same steps we used to create an Integrator to an I/F table can be used to create an Integrator to a PL/SQL API The parameters for the PL/SQL API Procedure are identified as columns in the Integrator and hence the Excel Document 精品文档 Define a Layout The Layout identifies what columns from the Integrator are available for the users to use, defaulting, prompts, etc., as you saw with the Integrator You can create many different interfaces using unique Layouts all linked to one Integrator In my clients case we have one SubLedger Accounting JE Integrator but the Layouts allow me to have very specific interfactes: AP Accrual JE’s AR Accrual JE’s An interface for each separate feeder system 精品文档 Define a Layout Can be performed by users as opposed to technical team Instance: Userid/Password: JP_USER / welcome123 Responsibility: Desktop Integration Navigation Path:  Desktop Integration = Define Layout You can follow along with these steps. 精品文档 Define Layout (1 of 5) Integrator: General Ledger – Journals Go Create (or Duplicate) Layout Name: JP_GL_JE_IF_NN Number of Headers: 1 These are blocks of Header fields that are place across the top of the Excel Document 精品文档 Define Layout (1 of 5) 精品文档 Presentation Please downl