AP Check Printing R12

From Scratch:

1. Create XML Template
Payables Manager>Setup>Payment>Payment Administrator>Formats>XML Publisher Format Templates
Click on 'Create Template'
Enter the name,Code,Application is Payments
Type=RTF
Data Definition=Oracle Payments FUnds Disbursement Payment Instruction Extract 1.0
Lanuguage:English
File Territoru:US
Upload your RTF File
2.Create Payment Format:
Payables Manager>Setup>Payment>Payment Administrator>Formats>Formats
Select Type=Disbursement Payment Instruction
Click On create
Enter Code,NameType:Same as above we have created for template
Data Extract=Oracle Payments FUnds Disbursement Payment Instruction Extract 1.0
XML PUblisher Extract=XML Template Name Created in Step1

3.Create Payments Document:
Payment Manager>Setup>Payment>Bank Accounts

Query The Bank Name(Assuming bank setup has been done already)
Select The Bank Account and Click on manage Payment Documents.
Click on create,Enter name as 'Sample Check Payment Document'
Paper Stock Type:Blank Stock or Pernumbered Stock
Check the box for attached Remittance stub if Available.(A new filed no.of lines per Remittance Stub' Will be shown up.)-error may occur in printing so adjust the nuber while testing
Format:Enter the Format Defined in Step 2
First Avilable document number:Last available document Number
Enter any other additional field if needed.Click Apply

4.Create Payment Profile:
Payables Manager>Setup>Payment>Payment Administrator>Payment Process Profiles:
Click on create>Enter Code Name
Payment Instruction Format:As defined in step 2
Processing type: Printed
Payment Completion Point:when the payment Instruction is formatted
Default Payment Document:Document Created in step3
Payment file:Send to printer
Check the box 'Automatically Print After Formatting'
Default Printer:Printer name
Click Apply

Now create a invoice in Payable superuser, validate, create account and pay in full,check the payment document in request 'Format Payment Instruction'
set output format as xml if u need to extract the xml file.
Set as pdf by default

R12 AP Check Printing

Check Printing Concepts in R12:
1.Check Data moved to Payments from Payables.
2.Can Update the RTF to change the template of check Printing.
3.No of lines to be printed can be set in Payment Process Profile.


How to download Check Printing RTF:
Download standard oracle template
Payables Manager>Setup>Payment>Payment Administrator>Formats>XML Publisher Format Templates>Query and downloa 'Standard Check Format' IBYDC_STD1.rtf


Generating XML Is Little Difficult.
Can Refer to metalink Note ID:457539.1
Go to Payables>Setup>Payment Administrator

Click on go task of Formats>XML Publisher Formats

Select Data Extract as Oracle Payment Funds Disburesement Payment Instruction Extract,Version 1.

And XML Publisher Type as data Extract Identity In format

Update in Bank Account Documents and in Pay Process request

Go to Payable Super user Responsibility and Create a batch process and submit  the SRS as below with required parameters.

PGM:Create printed Payment Instruction

XML Extract will be in the output file.

R12 Migration Check points:

Migrating a Report:

1.Check The model query for obsolete tables and view.
2. Replace the obsolete tables and view with corresponding joints.
3.Check the program units for the same as mentioned above.
4.Run the query in sql developer and verify the output in 11i and R12 Instances.
5.Recompile and load to location after changes and compare the application outputs.


Happy Reading !!!
Comments are invited.......

Table Changes in R12

po_accrual_reconcile_temp_all:- is a temp table in 11i will get populated while running the Accrual Reconciliation report.

In R12 it has been defined as CST_AP_PO_RECONCILIATION,CST_RECONCILIATION_SUMMARY tables...

Kindly leave your comments on this..? if we are using the report in R12 after migartion????

Setting Organisation in R12

Begin

Mo_global.set_policy_context('S',101);
End;

Can execute this command to set the organisation.

R12 XML Reports Migration From 11i

XML Report Conversion Steps:

Note: Ref to Oracle Document
http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e10416/convertrpts.htm
Required Jar Files:
xdocore.jar
aolj.jar
xdoparser.jar
xmlparserv2-904.jar
versioninfo.jar
collections.jar
j5472959_xdo.zip
These jar files will be installed in the JAVA_TOP ($JAVA_TOP/oracle/apps/fnd/jar) in the application.

Or else we can get this Jar files by installing the patch 5472959

Conversion Process:
Note: I have taken the RDF in my local directory and did the conversion.( E:\Meera_Project).We can perform in Application by placing the RDF in any custom_top directory.
Taken a sample report XXXX.RDF

1. Convert RDF report to XML report. : Create output folder for the report .(I created a Output folder in my local directory.( E:\Meera_Project\Output)

 Run rwconverter from command prompt, to create xml version of oracle report.

Syntax:-

Rwconverter batch=yes source= E:\Meera_Project\LACPRDSPC.rdf dest= E:\Meera_Project\ OUTPUT\ xxxx.xml dtype=xmlfile overwrite=yes

This creates xxxx.xml in output folder.   

2. Creating Data template from Oracle Report using DataTemplateGenerator:

I have kept the required jar files in the local host Directory, Need to run the command in command prompt from the java-Jar files directory location. In Instance we need to run from the Java_top, jar file location

The command is:-

java.exe -verbose -cp aolj.jar;xdoparser.jar;collections.jar;j5472959_xdo.zip;versioninfo.jar;xmlparserv2-904.jar oracle.apps.xdo.rdfparser.DataTemplateGenerator E:\Meera_Project\ \OUTPUT\ xxxxx.xml

The output lists the data template name and any PL/SQL packaged code created.

Common errors here would be missing of the required jar files. This step generated the Data Template (xxxx_template.xml) and PL/SQL package (xxxx.pls and xxxx.pls) for any report trigger code.

Upload PL/SQL Package to the Database


Many converted Oracle Reports will generate a PL/SQL package specification file and a PL/SQL package body file as follows:
• S.pls
• B.pls

Run the PL/SQL package files against your Oracle Database as follows. This will create the PL/SQL package specification and body.

SQL> @E:\Meera_Project\PMC\R12\OUTPUT\ xxxx.pls

SQL> @E:\Meera_Project\PMC\R12\OUTPUT\ xxxx.pls

3. Creating RTF template from Oracle Report using RTFTemplateGenerator.

I have kept the required jar files in the local host Directory, Need to run the command in command prompt from the java-Jar files directory location. In Instance we need to run from the Java_top, jar file location

The command is:-

java.exe -verbose -cp aolj.jar;xdoparser.jar;collections.jar;j5472959_xdo.zip;versioninfo.jar;xmlparserv2-904.jar oracle.apps.xdo.rdfparser.RTFTemplateGenerator E:\Meera_Project\ OUTPUT\xxxx.xml

The output lists the rtf template name and log created.

This step generated the RTF Template (xxxx.rtf)
Once the output files are generated, follow the below steps to register and run the BI Publisher report:



 Upload PL/SQL package to the database.

 In XML Publisher Administrator responsibility, create data definition and assign the data template file.

 Create RTF template and assign rtf template file.

 Create concurrent program with short name same as above data definition name and assign xxxx as executable.

 Run the concurrent program and test the output with the original oracle report output.

Functional flow

Purchasing Responsibility:Purchase Order->Purchase Order
Supplier: *************
Type: Standard Purchase Order
Item: Expense Items
Item No: 10131
Quamtity: 5
Amount 200
Total:1000

Check Shipment tab before saving for ->Receiveing Control:Recepit Routing: Direct delivery

 

In distrubutions Tab can locate the sub-inventory.

Click on Approve Buttom
The status of PO will be Approved

 

Create Receipts:

Purchasing: Receiving->Receipts
In Find Expected receipts window search using PO number:Click on Find button
Tick the checkbox in Lines tab
Fill The sub Inventory Information

 

Hit on Save..Open the header and note the receipt Number

Now In Inventory Responsibility and check on On Hand Quantity

Inventory->On-hand Quantity
 

Search Using receipt number
Check Material transaction in inventory itself
Transaction->Material Transaction
Query the item With date
Now can create Invoice in payables responsibility for the receipt

Fill the Invoice Number,Supplier Info and Match with the receipt

Match with full amount with receipt number and validate the invoice

Click on Actions And Validate the Invoice

For Full payment we have done:-
Matching Receipts : Half Payment
Two Receipts Matching for a single invoice
Create two receipts for a Single PO,
Match the receipts with different invoice numbers.