Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

EDIFACT Inbound

EDIFACT Inbound Single Partner Data File to Oracle Adv Positional file including Acknowledgement generation scenario with Data Mapping Rules, Test with sample Files and Test Cases.

 

Problem Statement:

Here XYZ Company is the receiver and it is receiving the Invoice/Bill from its Vendor/Partner through EDI (Electronic Data Exchange) and wants to convert it into the format in which it can process it in its system (here the format is Position (fixed length flat file)).

 

Solution Architecture:

An EDIFACT INVOIC is typically sent by a seller, such as a manufacturer or distributor, to a buyer, like a retailer, after an order has been shipped. This document confirms that the order has been delivered and requests payment from the buyer to finalize the transaction.

  • Design a Transaction using an EDI Inbound Pre-built template.

  • Create a UNB Envelope

  • Create Source Schema- EDI INVOIC

  • Create Target Schema - Advance positional

  • Create a File Event activity

  • Create Target folder Location (LAN)

  • Create Mapping activity

 

Solution:

Define Transaction

image-20240614-064247.png

Select Network and Partner

 

image-20240614-065820.png

EDI Configuration

 

image-20240614-070059.pngimage-20240614-070151.png

Transaction Settings

 

image-20240614-070300.png

Select Source

 

image-20240614-070358.png

 

Create a File Event

image-20240614-091646.png

Select Destination

 

image-20240614-092221.png

 

Select File Target/Select Mode type/Give File Name/Add File Extension

image-20240614-092100.png

Select Target Data Format/Target Layout

 

image-20240614-092733.png

Select Layout

image-20240614-092844.png

Create a Mapping

Firstly we create variables

  1. varTP_Code

Condition applied : "WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-EDIP' } VALUE=['HELLA_EU' ]
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-HER' } VALUE=['HELLA_EU_HER' ]
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-BHTC' } VALUE=[ 'HELLA_EU_BHTC']
WHEN CONDITION{$Input_EDIFACT_D07A_INVOIC/EDIRoot/UNB/UNB02/UNB0201='O0013000023HELLA-KG-HIS' } VALUE=[ 'HELLA_EU_HIS']
OTHERWISE VALUE=['ERROR' ]"

image-20240614-094708.png

  1. varNAD_ST_0201

Condition applied: “$Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop2_NAD/NAD[NAD01='ST']/NAD02/NAD0201"

image-20240614-095027.png

  1. varTp_loc

Condition applied: WHEN CONDITION{ $varNAD_ST_0201='1014'} VALUE=['SBI1014' ]
WHEN CONDITION{ $varNAD_ST_0201='1015'} VALUE=[ 'SBI1015']
WHEN CONDITION{ $varNAD_ST_0201='1000'} VALUE=['SBI1000' ]
WHEN CONDITION{ $varNAD_ST_0201='1025'} VALUE=[ 'SBI1025']
WHEN CONDITION{ $varNAD_ST_0201='1263'} VALUE=['SBI1263' ]
OTHERWISE VALUE=[ 'ERROR']

image-20240614-100059.png

  1. varLANtax_amt

Condition applied: round( $Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop26_LIN/Loop27_MOA/MOA/MOA01/MOA0102 * 0.19,2)

image-20240614-100327.png

  1. varNAD_BY

Condition applied: $Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop2_NAD/NAD[NAD01='BY']/NAD02/NAD0201

image-20240614-100608.png

  1. varTP_BILL_LOC

Condition applied: WHEN CONDITION{ $varNAD_BY='317050'} VALUE=[ 'SBI1014']
WHEN CONDITION{ $varNAD_BY='317051'} VALUE=['SBI1015' ]
WHEN CONDITION{ $varNAD_BY='317052'} VALUE=['SBI1000' ]
WHEN CONDITION{ $varNAD_BY='317053'} VALUE=[ 'SBI1025']
WHEN CONDITION{ $varNAD_BY='317054'} VALUE=['SBI1263' ]
OTHERWISE VALUE=[ 'ERROR']

image-20240614-100800.png

We apply For Each at the Root level at the Destination end.

$Input_EDIFACT_D07A_INVOIC/EDIRoot/TS_INVOIC/Loop26_LIN

image-20240614-113339.png

Check for the data input.

image-20240614-114212.png

 

  • No labels