Payment Formats

Payment Formats


During the Release 12 Oracle Payments upgrade, one Oracle XML Publisher template is created and linked to one Oracle Payments format for each Oracle Payables (AP) payment program that is linked to a format definition. In Payables, you can create different format definitions linked to the same payment program. So for each AP format definition, the upgrade creates one Payment Process Profile linked to the Oracle Payments format.

The payment programs that controlled the building and formatting of payments and the programs that created the separate remittance advice documents are obsolete with Release 12 and the integration with Oracle Payments.

The following tables display the mapping from seeded 11i AP Payment Formats to the new Release 12 Oracle Payments XML Publisher Formats. Obsolete formats are so noted.

Source 11i Payment Format (Program)
Oracle Payables
Release 12 Oracle Payments Format Name (Code)
Long Check Format (APXPBFEG)
External Check Format
(IBY_PAY_CHK_STANDARD_2)
Long Check Format; stub after payment
(APXPBFEG)
External Check Format
(IBY_PAY_CHK_STANDARD_2A)
Long Laser Format (APXPBFEL)
Laser Check Format (IBY_PAY_CHK_LASER)
Long Laser Format; stub after payment
(APXPBFEL)
Laser Check Format (Stub After Payment)
(IBY_PAY_CHK_LASER_A)
Short Check Format (APXPBFEG)
External Check Format
(IBY_PAY_CHK_STANDARD_2A)
Short Form Feed Format (APXPBFEF)
External Form Feed Check Format
(IBY_PAY_CHK_FORM_FEED_2)
Short Form Feed Format; stub after payment
(APXPBFEF)
External Form Feed Check Format (Stub After
Payment) (IBY_PAY_CHK_FORM_FEED_2A)
Standard Check Format (APXPBFOR)
Standard Check Format
(IBY_PAY_CHK_STANDARD_1)
Standard Check Format; stub after payment
(APXPBFOR)
Standard Check Format (Stub After Payment)
(IBY_PAY_CHK_STANDARD_1A)
US Treasury Check (APXPBFUS)
US Treasury Format
(IBY_PAY_CHK_TREASURY)
BACS 1/2 Inch Tape (APXPBFBC)
UK BACS 1/2 Inch Tape Format
(IBY_PAY_EFT_BACS_UK)
EDI Outbound Program (APECEPYO)
Obsolete
NACHA Payment Format (APXNACHA)
US NACHA CCD Format
(IBY_PAY_EFT_NACHA_CCD_US)
XML Payment Format (APXMLPMT)
XML Payment Format (APXMLPMT) Obsolete

Source 11i Payment Format (Program)
Oracle Federal Payables
Release 12 Oracle Payments Format Name
(Code)
BD CCDP format (FVBLCCDP)
US Bulk CCDP Format
(IBY_PAY_EFT_FED_BULK_CCDP)
BD NCR Format (FVBLNCR)
US Bulk NCR Format
(IBY_PAY_EFT_FED_BULK_NCR_1)
Bulk PPDP format (FVBLPPDP)
US Bulk PPDP Format
(IBY_PAY_EFT_FED_BULK_PPDP)
BD Sal/Trv NCR Format (FVBLSLTR)
US Bulk Salary and Travel NCR Format
(IBY_PAY_EFT_FED_BULK_NCR_2)
Bulk Data CCD+ Consolidated Payment File
Program (FVCOCCDP)
US CCDP Consolidated Format
(IBY_PAY_EFT_FED_CCDP_CONSOL)
CTX Consolidated File Payment Program
(FVCONCTX)
US PPDP Consolidated Format
(IBY_PAY_EFT_FED_PPDP_CONSOL)
Bulk Data PPD+ Consolidated Payment File
Program (FVCOPPDP)
US CTX Consolidated Format
(IBY_PAY_EFT_FED_CTX_CONSOL)
SPS CCD Format (FVSPCCD)
US SPS CCD Format
(IBY_PAY_EFT_FED_SPS_CCD)
SPS CCDP Format (FVSPCCDP)
US SPS CCDP Format
(IBY_PAY_EFT_FED_SPS_CCDP)
SPS Check NCR Format (FVSPNCR)
US SPS NCR Format
(IBY_PAY_EFT_FED_SPS_NCR)
SPS PPD Format (FVSPPPD)
US SPS PPD Format
(IBY_PAY_EFT_FED_SPS_PPD)
SPS PPDP Format (FVSPPPDP)
US SPS PPDP Format
(IBY_PAY_EFT_FED_SPS_PPDP)
ECS Check NCR Format (FVTIACHB)
US ECS NCR Check Format
(IBY_PAY_EFT_FED_ECS_NCR)
ECS CCDP Format (FVTIACHP)
US ECS CCDP Format
(IBY_PAY_EFT_FED_ECS_CCDP)
CTX Vendor Format (FVTICTX)
US CTX Format (IBY_PAY_EFT_FED_CTX)
ECS CCD Format (FVTPCCD)
US ECS CCD Format
(IBY_PAY_EFT_FED_ECS_CCD)
ECS PPD Format (FVTPPPD)
US ECS PPD Format
(IBY_PAY_EFT_FED_ECS_PPD)
ECS PPDP Format (FVTPPPDP)
US ECS PPDP Format
(IBY_PAY_EFT_FED_ECS_PPDP)
Summary Schedules (FVSUMSCH)
Obsolete
ECS and SPS Summary Schedules
IBY_PAY_EFT_FED_ECS_SUM_SCHED and
IBY_PAY_EFT_FED_SPS_SUM_SCHED
Source 11i Payment Format (Program)
Argentina
Release 12 Oracle Payments Format Name
(Code)
Argentine Check Format (JLARPCFP)
Argentine Check Format
(IBY_PAY_CHK_AR)

Source 11i Payment Format (Program)
Austria
Release 12 Oracle Payments Format Name
(Code)
Austrian Foreign EFT (JEATIEFT)
Obsolete
Austrian Domestic (JEATREFD)
Obsolete
Austrian Transferral 1 (JEATPPF1)
Obsolete
Austrian Transferral 2 (JEATPPF2)
Obsolete
Austrian Check with Remittance Advice
(JEATPPF3)
Obsolete
Austrian Check with Remittance Advice FWG
(JEATPPF4)
Obsolete
Austrian Foreign Transfer Order (JEATPPF5)
Obsolete

Source 11i Payment Format (Program)
Belgium
Release 12 Oracle Payments Format Name
(Code)
Belgian Format 1 (JEBEEF01)
Belgian EFT Format
(IBY_PAY_EFT_DOMESTIC_BE)
Belgian Format 2 (JEBEEF02)
Belgian EFT Format
(IBY_PAY_EFT_DOMESTIC_BE)

Source 11i Payment Format (Program)
Brazil
Release 12 Oracle Payments Format Name
(Code)
Brazilian Check Format (JLBRPCFP)
Brazilian Check Format (IBY_PAY_CHK_BR)
Brazilian Bordero (JLBRPBOR)
Brazilian Bordero Format
(IBY_PAY_CHK_OBRDERO_BR)

Source 11i Payment Format (Program)
Chile
Release 12 Oracle Payments Format Name
(Code)
Chilean Check Format (JLCLPCFP)
Chilean Check Format (IBY_PAY_CHK_CL)

Source 11i Payment Format (Program)
Colombia
Release 12 Oracle Payments Format Name
(Code)
Colombian Check 1 (JLCOPCF1)
Colombian Check 1 Format
(IBY_PAY_CHK_1_CO)
Colombian Check 2 (JLCOPCF2)
Colombian Check 2 Format
(IBY_PAY_CHK_2_CO)
Source 11i Payment Format (Program)
Denmark
Release 12 Oracle Payments Format Name
(Code)
Danish GiroBank Domestic (JEDKEIGO)
Obsolete
Danish GiroBank Foreign (JEDKEUGO)
Obsolete
Danish Unitel (JEDKEUNI)
Obsolete

Source 11i Payment Format (Program)
Finland
Release 12 Oracle Payments Format Name
(Code)
Finnish LMP2 Payment Format (JEFILLMP)
Finnish LMP2 EFT Format
(IBY_PAY_EFT_LMP2_FI)
Finnish LUM Payment Format (JEFILLUM)
Finnish LUM EFT Format
(IBY_PAY_EFT_LUM_FI)
Finnish LMP3 Payment Format (JEFILLMP3)
Finnish LMP3 EFT Format
(IBY_PAY_EFT_LMP3_FI)
Finnish ULMP Payment Format (JEFILULM)
Obsolete
Source 11i Payment Format (Program)
France
Release 12 Oracle Payments Format Name
(Code)
Billet a Ordre France (JEFRAP02) (Also
referred to as: French PRMSRY Note EUR,
French Bill Of Exchange, French Bill of EXCH
EUR)
French Promissory Note Format
(IBY_PAY_PROMISSORY_NOTE_FR)
Cheque Francais (JEFRAP01)
French Check Format (IBY_PAY_CHK_FR)
Cheque Francais; stub after payment
(JEFRAP01)
French Check Format (Stub After Payment)
(IBY_PAY_CHK_FR_A)
Virement Francais (AFB) (JEFRAP03)
French EFT Format (IBY_PAY_EFT_FR)


Source 11i Payment Format (Program)
Norway
Release 12 Oracle Payments Format Name
(Code)
Norwegian BBS (JENOPBDR)
Norwegian BBS Format
(IBY_PAY_EFT_BBS_NO)
Norwegian Telepay (JENOPTGN)
Forwegian Telepay EFT Format
(IBY_PAY_EFT_TELPAY_NO)
Norwegian Datadialog Payment Format
(JENOPDDG)
Obsolete
Source 11i Payment Format (Program)
Poland
Release 12 Oracle Payments Format Name
(Code)
Polish Pekao Credit Transfers Format
(JEPLEFT1)
Polish Pekao Credit Transfers Format
(IBY_PAY_EFT_CREDIT_TRANS_PL)
Polish Pekao Payments (JEPLEFT2)
Polish Pekao Payment Order Format
(IBY_PAY_EFT_PAY_ORDER_PL)
Polish Citibank MTMS EFT Format
(JEPLEFT3)
Polish Citibank MTMS EFT Format
(IBY_PAY_EFT_CITI_MTMS_PL)
Source 11i Payment Format (Program)
Portugal
Release 12 Oracle Payments Format Name
(Code)
Portuguese Check (JEPTBFOR)
Portuguese Check Format
(IBY_PAY_CHK_PT)
Portuguese EFT (JEPTPEFT)
Portuguese EFT Format (IBY_PAY_EFT_PT)
Source 11i Payment Format (Program)
Spain
Release 12 Oracle Payments Format Name
(Code)
Spanish EFT (JEESPEFT)
Spanish Magnetic Format (IBY_PAY_EFT_ES)
Spanish Cheque (JEESAPCP)
Spanish Check Format (IBY_PAY_CHK_ES)
Spanish PRMSRY Note EUR (JEESAPLC)
Spanish Bill of Exchange Format
(IBY_PAY_CHK_BOE_ES)
Source 11i Payment Format (Program)
Sweden
Release 12 Oracle Payments Format Name
(Code)
Swedish Bankgiro Inland (JESEPBAI)
Swedish Domestic Bankgiro Format
(IBY_PAY_EFT_BANKGIRO_SE)
Swedish Bankgiro SISU (JESEPBSI)
Swedish SISU Bankgiro Format
(IBY_PAY_EFT_SISU_BANKGIRO_SE)
Swedish Bankgiro UTLI (JESEPBUT)
Swedish UTLI Bankgiro Format
(IBY_PAY_EFT_UTLI_BANKGIRO_SE)
Swedish Postgiro Inland (JESEPPOI)
Swedish Domestic Postgiro Format
(IBY_PAY_EFT_POSTGIRO_SE)
Swedish Postgiro Utland (JESEPPOU)
Swedish Foreign Postgiro Format
(IBY_PAY_EFT_FOR_POSTGIRO_SE)

*/