0 Replies Latest reply: Jun 22, 2009 11:55 PM by 707730 RSS

    Self Service page for PO summary

    707730
      Dear All
      I have created an object PO_HEADERS_CUSTOMER_V and and object PO_LINES_CUSTOMER_V

      unique key for PO_HEADERS_CUSTOMER_V is PO_HEADER_UK:PO HEADER ID

      In foreign key tab for PO_HEADERS_CUSTOMER_V I have given

      Foreign key: po_header_fk
      Parent Object: PO_HEADERS_CUSTOMER_V
      Referenced Key: PO_HEADER_UK
      Relationship: Object to itself

      In Foreign key column Tab

      Foreign key column: PO HEADER ID
      Referenced key column: PO HEADER ID

      unique key for PO_LINES_CUSTOMER_V is PO_LINES_UK-1)PO_HEADER_ID
      2)PO_LINE_ID

      In foreign key tab for PO_LINES_CUSTOMER_V i have given

      Foreign Key: PO_LINES_FK
      Parent Object:PO_HEADERS_CUSTOMER_V
      referenced key:PO_HEADER_UK
      Relationship:Order Header To Lines

      In Foreign key column Tab

      Foreign Key Column: PO_HEADER_ID
      Referenced key column: PO HEADER ID

      For PO_HEADERS_CUSTOMER_V I have defined region PO_HEADER_REGION
      For PO_LINES_CUSTOMER_V I have defined region PO_LINE_REGION

      In the flow I have defined a flow PO_HEADER_FLOW_ID where i have defined two flow pages
      PO HEADER PAGE and PO LINE PAGE

      In the Page Region for PO HEADER PAGE I have defined region PO_HEADER_REGION, defining this as the primary region.
      In the Link tab I have defined
      Attribute Name: PO HEADER ID
      Target Page Name: PO LINE PAGE

      In the Page Region for PO LINE PAGE I have defined region PO_HEADER_REGION as the primary region
      and PO_LINE_REGION with parent region PO_HEADER_REGION relationship as Order Header To Lines.

      I want that the first page shoul consist of PO number and it's header details. when click on the po_header_id it would show the line details. Till po header details it's coming fine but when clicked on the header id link it shows error

      'unexpected end of SQL command '

      Please help me with this problem