Open Interface PO

Preview:

Citation preview

Copyright Ó Oracle Corporation, 1998. All rights reserved.

Oracle ApplicationsRelease 11.5.10

Oracle ApplicationsRelease 11.5.10

Interfaces dans POInterfaces dans PO

Présentation techniqueConsultant: Hamid KHALAF

16 juin 2005

Présentation techniqueConsultant: Hamid KHALAF

16 juin 2005

1-1-22 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Rappel : Reprises prévues dans PORappel : Reprises prévues dans PO

• Demande d’achats :

• Commandes (commande stand, cmde ouverte, prop. Prix)

• Catégories d’achats : Code catégorie (par data load)

• Employés (création + affectation au poste,…)

• Fournisseurs (A priori manuel) : Nvlle Interface stnd en 11.5.10

• Affectation des fournisseurs aux catégories / articles

• Demande d’achats :

• Commandes (commande stand, cmde ouverte, prop. Prix)

• Catégories d’achats : Code catégorie (par data load)

• Employés (création + affectation au poste,…)

• Fournisseurs (A priori manuel) : Nvlle Interface stnd en 11.5.10

• Affectation des fournisseurs aux catégories / articles

1-1-33 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Tables de production : POTables de production : PO

• PO_REQUISITION_HEADERS_ALL : Demandes d’achats

• PO_REQUISITION_LINES_ALL : Lignes des DA

• PO_REQ_DISTIRIBUTIONS_ALL : Lignes d’imputations

• PO_HEADERS_ALL : Entêtes de commandes

• PO_LINES_ALL : Lignes de commandes

• PO_LINE_LOCATIONS_ALL : Lieux de livraisons

• PO_DISTRIBUTIONS_ALL : lignes d’imputations

• PO_REQUISITION_HEADERS_ALL : Demandes d’achats

• PO_REQUISITION_LINES_ALL : Lignes des DA

• PO_REQ_DISTIRIBUTIONS_ALL : Lignes d’imputations

• PO_HEADERS_ALL : Entêtes de commandes

• PO_LINES_ALL : Lignes de commandes

• PO_LINE_LOCATIONS_ALL : Lieux de livraisons

• PO_DISTRIBUTIONS_ALL : lignes d’imputations

1-1-44 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Tables d’interface: POTables d’interface: PO

• PO_REQUISITIONS_INTERFACE_ALL

• PO_REQ_DIST_INTERFACE_ALL

• PO_HEADERS_INTERFACE

• PO_LINES_INTERFACE

• PO_DISTRIBUTIONS_INTERFACE

• PO_INTERFACE_ERRORS

• PO_REQUISITIONS_INTERFACE_ALL

• PO_REQ_DIST_INTERFACE_ALL

• PO_HEADERS_INTERFACE

• PO_LINES_INTERFACE

• PO_DISTRIBUTIONS_INTERFACE

• PO_INTERFACE_ERRORS

1-1-55 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Demandes d’achats (PO)Demandes d’achats (PO)PO_REQUISITION_HEADERS_ALL#* REQUISITION_HEADER_ID* PREPARER_ID* ORG_IDo SEGMENT1

PO_REQUISITION_LINES_ALL#* REQUISITION_LINE_ID* REQUISITION_HEADER_ID* LINE_NUM* ORG_IDo

PO_REQ_DISTRIBUTIONS_ALL#* DISTRIBUTION_ID* REQUISITION_LINE_IDo CODE_COMBINATION_IDo ORG_ID

1-1-66 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes (PO)Commandes (PO)PO_HEADERS_ALL#* PO_HEADER_ID* AGENT_ID* TYPE_LOOKUP_CODEo VENDOR_ID

PO_LINES_ALL#* PO_LINE_ID* PO_HEADER_ID* LINE_NUM* ORG_IDo

PO_LINE_LOCATIONS_ALL#* LINE_LOCATION_ID* PO_LINE_IDo PO_HEADER_IDo ORG_ID

SEGMENT1o

PO_DISTRIBUTIONS_ALL#* PO_DISTRIBUTION_ID* PO_LINE_IDo PO_HEADER_IDo LINE_LICATION_ID

1-1-77 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Demandes d’achats : required dataDemandes d’achats : required data

Table PO_REQUISITIONS_INTERFACE_ALL

• INTERFACE_SOURCE_CODE

• DESTINATION_TYPE_CODE

• AUTHORIZATION_STATUS

• PREPARER_ID or PREPARER_NAME

• QUANTITY

• CHARGE_ACCOUNT_ID or charge account segment values

• DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE

• DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE

• DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME

Table PO_REQUISITIONS_INTERFACE_ALL

• INTERFACE_SOURCE_CODE

• DESTINATION_TYPE_CODE

• AUTHORIZATION_STATUS

• PREPARER_ID or PREPARER_NAME

• QUANTITY

• CHARGE_ACCOUNT_ID or charge account segment values

• DESTINATION_ORGANIZATION_ID or DESTINATION_ORGANIZATION_CODE

• DELIVER_TO_LOCATION_ID or DELIVER_TO_LOCATION_CODE

• DELIVER_TO_REQUESTOR_ID or DELIVER_TO_REQUESTOR_NAME

1-1-88 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’insertion de DAExemple d’insertion de DA

Table PO_REQUISITIONS_INTERFACE_ALL

insert into po_requisitions_interface_all (

interface_source_code,

source_type_code, -- origine

destination_type_code, -- type de destination

authorization_status,

preparer_name,

header_description,

item_description,

item_id

category_segment1, category_segment2,

category_segment3, category_segment4,

Table PO_REQUISITIONS_INTERFACE_ALL

insert into po_requisitions_interface_all (

interface_source_code,

source_type_code, -- origine

destination_type_code, -- type de destination

authorization_status,

preparer_name,

header_description,

item_description,

item_id

category_segment1, category_segment2,

category_segment3, category_segment4,

1-1-99 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’insertion de DAExemple d’insertion de DAquantity,

unit_price,

charge_account_segment1, -- ou bien charge_account_id

charge_account_segment2,

charge_account_segment3,

charge_account_segment4,

charge_account_segment5,…11

unit_of_measure,

destination_organization_code, -- ou bien passer l’ID

deliver_to_location_code, -- ou bien ID

deliver_to_requestor_name, -- ou bien ID

autosource_flag,

org_id)

quantity,

unit_price,

charge_account_segment1, -- ou bien charge_account_id

charge_account_segment2,

charge_account_segment3,

charge_account_segment4,

charge_account_segment5,…11

unit_of_measure,

destination_organization_code, -- ou bien passer l’ID

deliver_to_location_code, -- ou bien ID

deliver_to_requestor_name, -- ou bien ID

autosource_flag,

org_id)

1-1-1010 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’insertion de DAExemple d’insertion de DAvalues (

'Demonstration of Import', -- interface_source_code

'VENDOR', -- source_type_code

'EXPENSE', -- destination_type_code

'APPROVED', -- authorization_status

‘KHALAF, Hamid', -- preparer_name

'Imported Requisition', -- header_description

'Imported Item', -- item_description

‘-', -- category_segment1

‘-', -- category_segment2

‘’ , ‘’ , -- category_segment3 , -- category_segment4

1, -- quantity

20, -- unit_price

'0010', -- charge_account_segment1

values (

'Demonstration of Import', -- interface_source_code

'VENDOR', -- source_type_code

'EXPENSE', -- destination_type_code

'APPROVED', -- authorization_status

‘KHALAF, Hamid', -- preparer_name

'Imported Requisition', -- header_description

'Imported Item', -- item_description

‘-', -- category_segment1

‘-', -- category_segment2

‘’ , ‘’ , -- category_segment3 , -- category_segment4

1, -- quantity

20, -- unit_price

'0010', -- charge_account_segment1

1-1-1111 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’insertion de DAExemple d’insertion de DA

‘3121100', -- charge_account_segment2

‘S4114', -- charge_account_segment3

‘K01SAM', -- charge_account_segment4

‘0', -- charge_account_segment5,…segment11

‘KILOGRAMME', -- unit_of_measure

‘PFM_OL', -- destination_organization_code

‘OCP', -- deliver_to_location_code

‘KHALAF, Hamid', -- deliver_to_requestor_name

'',

14);  -- org_id

commit;

‘3121100', -- charge_account_segment2

‘S4114', -- charge_account_segment3

‘K01SAM', -- charge_account_segment4

‘0', -- charge_account_segment5,…segment11

‘KILOGRAMME', -- unit_of_measure

‘PFM_OL', -- destination_organization_code

‘OCP', -- deliver_to_location_code

‘KHALAF, Hamid', -- deliver_to_requestor_name

'',

14);  -- org_id

commit;

1-1-1212 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Lancement de l’open interface standardLancement de l’open interface standard

Importer des demandes d’approvisionnementsImporter des demandes d’approvisionnements

Erreurs de chargementErreurs de chargement

État exception d’importation des demandes État exception d’importation des demandes d’approvisionnementd’approvisionnement

1-1-1313 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

INSERT INTO PO_HEADERS_INTERFACE

( batch_id

, interface_header_id -- séquence standard

, interface_source_code

, action -- ORIGINAL pour cmde standard

, document_type_code

-- STANDARD,

-- BLANKET (cmde ouverte), or

-- QUOTATION (prop. De prix).

, document_num

, vendor_doc_num

, currency_code

, agent_id

, vendor_id ,

, vendor_site_id

INSERT INTO PO_HEADERS_INTERFACE

( batch_id

, interface_header_id -- séquence standard

, interface_source_code

, action -- ORIGINAL pour cmde standard

, document_type_code

-- STANDARD,

-- BLANKET (cmde ouverte), or

-- QUOTATION (prop. De prix).

, document_num

, vendor_doc_num

, currency_code

, agent_id

, vendor_id ,

, vendor_site_id

1-1-1414 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

INSERT INTO PO_HEADERS_INTERFACE

ship_to_location_id

, bill_to_location_id

, org_id

, note_to_vendor

, comments

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login)

INSERT INTO PO_HEADERS_INTERFACE

ship_to_location_id

, bill_to_location_id

, org_id

, note_to_vendor

, comments

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login)

1-1-1515 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

-- interface_header_id

SELECT po_headers_interface_s.NEXTVAL

INTO gv_interface_header_id

FROM DUAL ;

-- interface_header_id

SELECT po_headers_interface_s.NEXTVAL

INTO gv_interface_header_id

FROM DUAL ;

1-1-1616 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

INSERT INTO PO_LINES_INTERFACE

( interface_header_id -- lien avec l’entête

, interface_line_id -- identifiant unique ligne

, line_num

, shipment_type

, shipment_num

, ship_to_organization_id

, ship_to_location_id

, item

, item_description

, vendor_product_num

, promised_date

, uom_code

INSERT INTO PO_LINES_INTERFACE

( interface_header_id -- lien avec l’entête

, interface_line_id -- identifiant unique ligne

, line_num

, shipment_type

, shipment_num

, ship_to_organization_id

, ship_to_location_id

, item

, item_description

, vendor_product_num

, promised_date

, uom_code

1-1-1717 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

INSERT INTO PO_LINES_INTERFACE

, quantity

, unit_price

, note_to_vendor

, organization_id

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login

INSERT INTO PO_LINES_INTERFACE

, quantity

, unit_price

, note_to_vendor

, organization_id

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login

1-1-1818 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement

-- interface_line_id

SELECT po_lines_interface_s.NEXTVAL

INTO gv_interface_line_id

FROM DUAL ;

-- interface_line_id

SELECT po_lines_interface_s.NEXTVAL

INTO gv_interface_line_id

FROM DUAL ;

1-1-1919 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Commandes : chargementCommandes : chargement INSERT INTO PO_DISTRIBUTIONS_INTERFACE

( interface_header_id

, interface_line_id

, interface_distribution_id

, distribution_num

, quantity_ordered

, deliver_to_location_id

, deliver_to_person_id

, charge_account_id

, destination_organization_id

, org_id

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login)

INSERT INTO PO_DISTRIBUTIONS_INTERFACE

( interface_header_id

, interface_line_id

, interface_distribution_id

, distribution_num

, quantity_ordered

, deliver_to_location_id

, deliver_to_person_id

, charge_account_id

, destination_organization_id

, org_id

, last_update_date

, last_updated_by

, creation_date

, created_by

, last_update_login)

1-1-2020 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Lancement de l’open interfaceLancement de l’open interface

• Lancement :

Importer des commandes standard

• Erreurs de chargement : (dans PO_INTERFACE_ERRORS)

État des erreurs de l’interface des achats

On peut corriger les données, mettre la colonne process_code = Null dans les tables d’interface, et lancer ensuite l’interface standard d’importation.

update po_headers_interface

set process_code = null

where process_code = 'REJECTED';

update po_lines_interface

set process_code = null

where process_code = 'REJECTED'; 

• Lancement :

Importer des commandes standard

• Erreurs de chargement : (dans PO_INTERFACE_ERRORS)

État des erreurs de l’interface des achats

On peut corriger les données, mettre la colonne process_code = Null dans les tables d’interface, et lancer ensuite l’interface standard d’importation.

update po_headers_interface

set process_code = null

where process_code = 'REJECTED';

update po_lines_interface

set process_code = null

where process_code = 'REJECTED'; 

1-1-2121 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Mise à jour d’une commandeMise à jour d’une commandev_update_status := PO_CHANGE_API1_S.update_po

( v_latest_po -- PO Number

, NULL -- Release Number

, v_revision_num -- Revision Number

, v_line_num -- Line Number

, 1 -- Shipment Number

, v_quantity -- Quantity

, v_unit_price -- Price

, v_promised_date -- Date

, 'Y' -- Launch Approvals

, NULL -- Update Source

, 'PO_UPDATE' -- Interface Type

, NULL -- Transaction ID

, '1.0' -- API Version

);

v_update_status := PO_CHANGE_API1_S.update_po

( v_latest_po -- PO Number

, NULL -- Release Number

, v_revision_num -- Revision Number

, v_line_num -- Line Number

, 1 -- Shipment Number

, v_quantity -- Quantity

, v_unit_price -- Price

, v_promised_date -- Date

, 'Y' -- Launch Approvals

, NULL -- Update Source

, 'PO_UPDATE' -- Interface Type

, NULL -- Transaction ID

, '1.0' -- API Version

);

1-1-2222 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Mise à jour d’une commandeMise à jour d’une commandeExemple de mise à jour de unit_price et expiration_date

pour la commande ouverte / prop. prix existante :

Besoin d’alimenter la table : PO_HEADERS_INTERFACE

INTERFACE_HEADER_ID = po_headers_interface_s.nextval

ACTION = 'UPDATE'

ORG_ID

DOCUMENT_TYPE_CODE = 'BLANKET' or 'QUOTATION‘

VENDOR_ID, VENDOR_SITE_CODE, VENDOR_SITE_ID

PO_HEADER_ID or DOCUMENT_NUM

EFFECTIVE_DATE, EXPIRATION_DATE

VENDOR_DOC_NUM –

for blanket, it should be VENDOR_ORDER_NUM in po_headers_all table

for quotation, it should be QUOTE_VENDOR_QUOTE_NUMBER in the po_headers_all table

Exemple de mise à jour de unit_price et expiration_date

pour la commande ouverte / prop. prix existante :

Besoin d’alimenter la table : PO_HEADERS_INTERFACE

INTERFACE_HEADER_ID = po_headers_interface_s.nextval

ACTION = 'UPDATE'

ORG_ID

DOCUMENT_TYPE_CODE = 'BLANKET' or 'QUOTATION‘

VENDOR_ID, VENDOR_SITE_CODE, VENDOR_SITE_ID

PO_HEADER_ID or DOCUMENT_NUM

EFFECTIVE_DATE, EXPIRATION_DATE

VENDOR_DOC_NUM –

for blanket, it should be VENDOR_ORDER_NUM in po_headers_all table

for quotation, it should be QUOTE_VENDOR_QUOTE_NUMBER in the po_headers_all table

1-1-2323 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Mise à jour d’une commandeMise à jour d’une commandeBesoin d’alimenter la table : PO_LINES_INTERFACE

PO_LINES_INTERFACE

INTERFACE_LINE_ID = po_lines_interface_s.nextval

INTERFACE_HEADER_ID - same value as in the po_headers_interface.

ACTION = 'UPDATE'

ORG_ID

PO_LINE_ID or LINE_NUM

PO_HEADER_ID or DOCUMENT_NUM

ITEM

TEM_DESCRIPTION –

make sure the item description is populated right.

UNIT_PRICE if you want to change

UNIT_OF_MEASURE

EXPIRATION_DATE if you want to change –

has to be <= EXPIRATION_DATE in the header.

Besoin d’alimenter la table : PO_LINES_INTERFACE

PO_LINES_INTERFACE

INTERFACE_LINE_ID = po_lines_interface_s.nextval

INTERFACE_HEADER_ID - same value as in the po_headers_interface.

ACTION = 'UPDATE'

ORG_ID

PO_LINE_ID or LINE_NUM

PO_HEADER_ID or DOCUMENT_NUM

ITEM

TEM_DESCRIPTION –

make sure the item description is populated right.

UNIT_PRICE if you want to change

UNIT_OF_MEASURE

EXPIRATION_DATE if you want to change –

has to be <= EXPIRATION_DATE in the header.

1-1-2424 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’ajout d’une nouvelle ligneExemple d’ajout d’une nouvelle lignePour la commande ouverte / prop. prix existante :

Besoin d’alimenter la table : PO_HEADERS_INTERFACE

INTERFACE_HEADER_ID = po_headers_interface_s.nextval

ACTION = 'UPDATE'

ORG_ID

DOCUMENT_TYPE_CODE = 'BLANKET' or 'QUOTATION‘

VENDOR_ID, VENDOR_SITE_CODE, VENDOR_SITE_ID

PO_HEADER_ID or DOCUMENT_NUM

-- the existing blanket / quotation number

EFFECTIVE_DATE-- existing

EXPIRATION_DATE -- existing

VENDOR_DOC_NUM –

for blanket, it should be VENDOR_ORDER_NUM of the existing blanket

for quotation, it should be QUOTE_VENDOR_QUOTE_NUMBER of the existing quotation

Pour la commande ouverte / prop. prix existante :

Besoin d’alimenter la table : PO_HEADERS_INTERFACE

INTERFACE_HEADER_ID = po_headers_interface_s.nextval

ACTION = 'UPDATE'

ORG_ID

DOCUMENT_TYPE_CODE = 'BLANKET' or 'QUOTATION‘

VENDOR_ID, VENDOR_SITE_CODE, VENDOR_SITE_ID

PO_HEADER_ID or DOCUMENT_NUM

-- the existing blanket / quotation number

EFFECTIVE_DATE-- existing

EXPIRATION_DATE -- existing

VENDOR_DOC_NUM –

for blanket, it should be VENDOR_ORDER_NUM of the existing blanket

for quotation, it should be QUOTE_VENDOR_QUOTE_NUMBER of the existing quotation

1-1-2525 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple d’ajout d’une nouvelle ligneExemple d’ajout d’une nouvelle ligneBesoin d’alimenter la table : PO_LINES_INTERFACE

PO_LINES_INTERFACE

INTERFACE_LINE_ID = po_lines_interface_s.nextval

INTERFACE_HEADER_ID - same value as in the po_headers_interface.

ACTION = ‘ADD'

PO_HEADER_ID or DOCUMENT_NUM

-- existing quotation / blanket number

ITEM_ID or ITEM

UNIT_PRICE if you want to change

UNIT_OF_MEASURE

EFFECTIVE_DATE

EXPIRATION_DATE

Besoin d’alimenter la table : PO_LINES_INTERFACE

PO_LINES_INTERFACE

INTERFACE_LINE_ID = po_lines_interface_s.nextval

INTERFACE_HEADER_ID - same value as in the po_headers_interface.

ACTION = ‘ADD'

PO_HEADER_ID or DOCUMENT_NUM

-- existing quotation / blanket number

ITEM_ID or ITEM

UNIT_PRICE if you want to change

UNIT_OF_MEASURE

EFFECTIVE_DATE

EXPIRATION_DATE

1-1-2626 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple de chargement d’une nouvelle commande ouverte

Exemple de chargement d’une nouvelle commande ouverte

insert into po_headers_interface (interface_header_id, action, org_id, document_type_code, vendor_id, vendor_site_code, vendor_site_id, effective_date, expiration_date, Vendor_doc_num, load_sourcing_rules_flag)

values (po_headers_interface_s.nextval, 'ORIGINAL', 204, 'BLANKET', 21, 'SANTA CLARA', 41, '01-JAN-2001', '01-JAN-2002', 'VENDOR02', 'Y');

insert into po_headers_interface (interface_header_id, action, org_id, document_type_code, vendor_id, vendor_site_code, vendor_site_id, effective_date, expiration_date, Vendor_doc_num, load_sourcing_rules_flag)

values (po_headers_interface_s.nextval, 'ORIGINAL', 204, 'BLANKET', 21, 'SANTA CLARA', 41, '01-JAN-2001', '01-JAN-2002', 'VENDOR02', 'Y');

1-1-2727 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Exemple de chargement d’une nouvelle commande ouverte

Exemple de chargement d’une nouvelle commande ouverte

insert into po_lines_interface (interface_line_id, interface_header_id, action, item, item_description, unit_price, unit_of_measure, effective_date, expiration_date, template_name)

values (po_lines_interface_s.nextval, po_headers_interface_s.currval, 'ORIGINAL', 'BB54888', 'BB54888 Description', 10, 'Each', '01-JAN-2001', '01-JAN-2002', 'Purchased Item');

insert into po_lines_interface (interface_line_id, interface_header_id, action, item, item_description, unit_price, unit_of_measure, effective_date, expiration_date, template_name)

values (po_lines_interface_s.nextval, po_headers_interface_s.currval, 'ORIGINAL', 'BB54888', 'BB54888 Description', 10, 'Each', '01-JAN-2001', '01-JAN-2002', 'Purchased Item');

1-1-2828 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Programme de purgeProgramme de purge

Après le chargement réussi dans les tables Oracle, les données restent dans les tables d’interface avec process_code = ‘ACCEPTED’.

Nom du traitement :

Purger données traitées par interface coopérative Oracle Purchasing

Après le chargement réussi dans les tables Oracle, les données restent dans les tables d’interface avec process_code = ‘ACCEPTED’.

Nom du traitement :

Purger données traitées par interface coopérative Oracle Purchasing

1-1-2929 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : nouvelle interface de la 11.5.10

Fournisseurs : nouvelle interface de la 11.5.10

PO_VENDOR_SITES_ALL

PO_VENDOR_CONTACTS

PO_VENDORSSuppliers window

Supplier Sites window

Contacts tab

of the Supplier Sites window

1-1-3030 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : (suite)Fournisseurs : (suite)

PO_VENDOR_SITES_ALL

PO_VENDOR_CONTACTS

PO_VENDORS

AP_SUPPLIER_SITES_INT

AP_SUP_SITE_CONTACT_INT

AP_SUPPLIERS_INTSupplier Open Interface

Import (APXSUIMP)

Supplier Sites Open Interface

Import (APXSSIMP)

Supplier Site Contacts Open

Interface Import (APXSCIMP)

1-1-3131 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : (suite)Fournisseurs : (suite)

Supplier Open Interface

Import

Supplier Site Contacts Open

Interface Import

Supplier Sites Open Interface

Import

Suppliers Open Interface

Import Execution

Report

Supplier Sites Open Interface Import

Execution Report

Supplier Site Contacts Open

Interface Import Execution Report

Three new reports were added:

1-1-3232 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : ExempleFournisseurs : Exemple

insert into AP_SUPPLIERS_INT

(vendor_interface_id,

vendor_name,

allow_awt_flag,

awt_group_name)

values

(AP_SUPPLIERS_INT_S.nextval,

‘OCP Test',

'Y',

'1099')

/

insert into AP_SUPPLIERS_INT

(vendor_interface_id,

vendor_name,

allow_awt_flag,

awt_group_name)

values

(AP_SUPPLIERS_INT_S.nextval,

‘OCP Test',

'Y',

'1099')

/

1-1-3333 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : ExempleFournisseurs : Exemple

insert into AP_SUPPLIER_SITES_INT

(vendor_interface_id,

vendor_site_code,

address_line1,

city, state,

zip, pay_site_flag,

org_id)

Values (11000,

'SITE1',

'12233 Oracle Boulevard',

‘Aix en provence',

‘FR',

13100,

'Y',

14)

/

1-1-3434 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : ExempleFournisseurs : Exemple

insert into AP_SUP_SITE_CONTACT_INT

(vendor_site_id,

vendor_site_code,

org_id,

first_name,

last_name,

phone)

values

(4597,

'SITE1',

204,

'HAROLD',

'JOHNSON',

'800-555-1212')

/

1-1-3535 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Fournisseurs : lancement de l’interfaceFournisseurs : lancement de l’interface

• Importation de l’interface coopérative fournisseur

• Importation de l’interface coopérative des sites fournisseurs

• Importation de l’interface coopérative des contacts du site fournisseur

1-1-3636 Copyright Ó Oracle Corporation, 1998. All rights reserved.

EmployésEmployés

• HR_EMPLOYEE_API• HR_PERSON_API• HR_ASSIGNMENT_API

• Voir Note Metalink : 152028.1

1-1-3737 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Employés : exempleEmployés : exempledeclare

l_emp_num varchar2(30) := '55555';

l_person_id NUMBER;

l_assignment_id NUMBER;

l_per_object_version_number NUMBER;

l_asg_object_version_number NUMBER;

l_per_effective_start_date DATE;

l_per_effective_end_date DATE;

l_full_name VARCHAR2(240);

l_per_comment_id NUMBER;

l_assignment_sequence NUMBER;

l_assignment_number VARCHAR2(30);

l_name_combination_warning BOOLEAN;

l_assign_payroll_warning BOOLEAN;

l_orig_hire_warning BOOLEAN;

1-1-3838 Copyright Ó Oracle Corporation, 1998. All rights reserved.

EmployésEmployésbegin

HR_EMPLOYEE_API.CREATE_EMPLOYEE(

p_hire_date => TO_DATE('01-01-1966','DD-MM-YYYY'),

p_business_group_id => 1,

p_last_name => 'PERNET',

p_sex => 'M',

p_employee_number => l_emp_num,

p_person_id => l_person_id,

p_assignment_id => l_assignment_id,

p_per_object_version_number => l_per_object_version_number,

p_asg_object_version_number => l_asg_object_version_number,

p_per_effective_start_date => l_per_effective_start_date,

p_per_effective_end_date => l_per_effective_end_date,

p_full_name => l_full_name,

p_per_comment_id => l_per_comment_id,

1-1-3939 Copyright Ó Oracle Corporation, 1998. All rights reserved.

EmployésEmployés

begin

HR_EMPLOYEE_API.CREATE_EMPLOYEE(

p_assignment_sequence => l_assignment_sequence,

p_assignment_number => l_assignment_number,

p_name_combination_warning => l_name_combination_warning,

p_assign_payroll_warning => l_assign_payroll_warning,

p_orig_hire_warning => l_orig_hire_warning

);

end;

1-1-4040 Copyright Ó Oracle Corporation, 1998. All rights reserved.

Affectation des fournisseurs aux articles / catégories

Affectation des fournisseurs aux articles / catégories

Aucune interface standardAucune interface standard

Étudier la possibilité offerte en standard : Étudier la possibilité offerte en standard :

« Liste des fournisseurs approuvés »« Liste des fournisseurs approuvés »

1-1-4141 Copyright Ó Oracle Corporation, 1998. All rights reserved.

DocumentationDocumentation

• Oracle Manufacturing APIs and Open Interfaces Manual, Release 11i

• Oracle Manufacturing APIs and Open Interfaces Manual, Release 11i

Recommended