Payables - FAQs

[m.a.raju1981]

Can anyone send payble FAQs ? as many as possible

[raja_rthiyagu]

hi ,

<b>Payables Report FAQs</b>
1. Q: Where do I find information on correcting alignment issues for my printed reports?

A: You will need to refer to Oracle Payables Printing information rather than to Oracle Payables Report information. Alignment issues are resolved by modifying your printer setup rather than by modifying the report format.

2. Q: How do I determine the short name of my report?

A: You can determine the short name of the report by viewing the Request Log for the report, or you can query the report name in the System Administrator responsibility: Concurrent -> Program -> Define.
You will want to note the executable name as well.

3. Q: How do I determine the version of my report?

A: The report version can be determined from the operating system by
running the following commands:
UNIX:
--------------
Release 10.7:
cd $AP_TOP/srw
strings #65533;a APXT7F99.rdf | grep Header
Release 11:
cd $AP_TOP/reports
strings -a AP7T7F99.rdf | grep Header
WinNT:
--------------
Release 10.7:
cd %AP_TOP/srw
find /I "Header" APXT7F99.rdf
Release 11:
cd %AP_TOP/reports
find /I "Header" APXT7F99.rdf

4. Q: I am looking for a specific report for Payables but am not certain if it is included with the standard product. Where can a list of available reports with detailed descriptions be found?
A: There is a complete listing of available reports included in the Payables User's Guide. For releases 10.7 and 11, chapter 8 covers this topic. Each report description includes an overview, detailed explanation of the report headings, instructions on submitting the report and parameter details.

5. Q: Which reports can only be generated by submitting a program rather than simply submitting a request for the report?

A: The following reports and listings will only print if you submit the following program Program or Action Submits Report or Listing Always Prints?
Payables Transfer to General Ledger Accounts Payable Journal Entry
Audit Report Yes
Accounts Payable Journal Entry
Exceptions No
Payables Approval Program Payables Approval Report Yes
Purge Preliminary Purged Listings Yes
Final Purged Listings Yes
Rejected Purged Listings No
Final Purge Statistics Report Yes
Supplier Merge Program Supplier Merge Report Yes
Purchase Order Headers Report Yes
Payables Invoice Import Invoice Import Report Yes
Invoice Import Exceptions Report No
Payment Batch Selection or
Formatting Preliminary Payments Report No
Apply Advances to imported expense
Reports Undistributed Payments Report No
Payment Batch confirmation Final Payment Register Yes
Undistributed Payments Report No
AutoRate Undistributed Payments Report No
Payments Distributions Report Yes

6. Q: How to I locate my output file from my report?

A: Perform the following steps:
1. Determine the Concurrent Request Number
The first step to determining the file name is to locate the concurrent
request number.
Navigate: Help=>View My Requests.
The Request ID field contains the concurrent request number.
2. Open a Telnet Session
a. You will need to open an MS-Dos prompt.
b. Select the Start button
c. Select Programs
d. Select Command Prompt
e. At the Dos prompt, enter the following command:
telnet <your server name>
3. Log into the Server
You will be prompted for your login and password for the Server. Enter
these values.
4. Set your environment variables if necessary. You may need to have
your System Administrator perform this function for you.
5. Determine the Output File Directory
There are two environment variables that may be used to set the
default output directory:
APPLCSF
APPLOUT
You can determine which is being used by #65533;echoing#65533; the above variables.
One of these will return a value.
APPLCSF is Applications Commonly Shared Files.
a. echo $APPLCSF
b. You MAY see a returned value, for example:
/oraclelogs/f1070161/app
c. There is usually an associated /out directory located off of
the particular directory. In that case, the output directory
would be:
/oraclelogs/f1070161/app/out
d. You may access this directory by typing the following command:
cd $APPLCSF/out
e. Verify the directory name by typing:
pwd
f. Result:
/oraclelogs/f1070161/app/out
Next, try using APPLOUT. This variable assumes that the value
will be associated with a product top directory.
a. echo $APPLOUT
b. You MAY see a returned value:
out
c. In this instance, the directory /out is located off of the
Product top (AP_TOP). To access this directory, type the following
command:
cd $AP_TOP/out
d. Verify the directory name by typing:
pwd
e. Result:
/u13/appl/f1070161/ap/8.0.159/out
If a variable did not return a value when echoed, it is not being
used.
6. Determine the File Name
There are two basic file naming protocols for output files. The first
is a concatenation of the letter #65533;o#65533;, the concurrent request number
and the extension of .out.
Example:
Concurrent Request Number 12345
File name: o12345.out
The second protocol consists of your user name for the Application
plus the concurrent request number as an extension.
Example:
User Name: JOEBOB
Concurrent Request Number 12345
File name: JOEBOB.12345
Simply use the 'ls' command to determine which naming convention is
being used, then verify that your output is still in the directory.

7. Q: What articles, white papers, or manuals should I read for more information on Payables report issues?

A:
Payables User's Guide release 10.7
Payables User's Guide release 11
Payables User's Guide release 11i
Payable Printing FAQ Note 110408.1
Payables Check Printing FAQ Note 110406.1
AP News Volume 4 Note 131494.1
Common 1099 Alignment Issues
Initialization Strings
Note: Users Guides can be found on MetaLink in the associated product's
Self-Service Toolkit Documentation link Note 67215.1

8. Q: What are the MetaLink keywords I should use when searching for Payables report issues on MetaLink?

A: Use the short name of your report along with the any of the following key words: alignment, printer, style, APXPBFEG for check printing, APXT7F99 for 1099 forms.

9. Q: Which reports have been obsoleted in Payables?
A: Check the Product Update Notes for each Release:
Oracle Applications Product Update Note Release 11i, p. 21-23
Volume 1, Part #A85298-01
Volume 2, Part #A85299-01
Autoclear Code Listing (APXACACL)
Autoclear Detail Report (APXAXPRR)
Automatic Clearing For Future Dated Payments (APZACS)
Accounts Payable Journal Entry Audit Report and
Accounts Payable Journal Entry Exceptions Report (APPPST)
Expense Distribution Detail Report (APXEDSRS)
Journal With GL Details (APXJEHIS)
Payment Distribution Report (APXINVAR)
Posting Holds Report (APXINVAR)
Transaction Reconciliation Report (APXTRXRN)
Undistributed Payments Report (APXXTR)
Oracle Applications Product Update Note Release 11, p. 18-9
Part #A57984-02
No Obsoleted Reports listed, see Changed Reports and Processes
Oracle Applications Product Update Note Release 10, Ch. 15
Part #A52639-02
No Obsoleted Reports listed

10. Q: How do I check for invalid objects and regenerate (recompile) reports?
A: Check for Invalids using the below script and recompile
Checking for Invalids:
SELECT owner, object_name, object_type
FROM all_objects
WHERE status = 'INVALID';
Compiling Invalid Objects:
? Use adadmin to run 'Compile Apps Schema'. Good to use if there is a very
large number of invalids, because it compiles all products.
? $AD_TOP/sql/adcompsc.pls. This is a script that development will sometimes
include as one of the jobs run by the 'd' driver. This script allows you to
compile invalid objects in a given schema.
? To run the script use the syntax
SQL> @adcompsc.pls <schema_username> <schema_password>
<objects starting with>
Examples:
SQL> @adcompsc.pls apps apps PA (This will compile all the objects in Apps
starting with PA%)
SQL> @adcompsc.pls ap ap % (This will compile all objects in the AP schema)
? Recompile and recompile.sql. These are custom scripts created by a support
analyst at Oracle. The script selects all invalid objects and dynamically creates
'alter' scripts to compile each of these invalid objects, then runs the scripts.
For examples of these scripts look in the reference section.
? Use alter command in sql:
ex: alter package ARP_STANARD compile body;
alter view TABLE_V compile;
How to recompile a report for Release 11i applications
NOTE: Substitute your report shortname where POXKISUM is specified in this example.
If you need to regenerate a report because you suspect you have a corrupted file,
you can follow the instructions below to convert the .rdf to a .rex file and back
to an .rdf file.
The short name or module name of the report is required to regenerate the report
and can be obtained from the top of the log file.
In this example we will use the ARBARL report.
1) Navigate to the <$PROD_TOP>/reports/US directory in UNIX
cd $AP_TOP/reports/US
2) From the directory where the report is located, convert the binary form (.rdf)
to a readable format (.rex)
a) Convert the report from .rdf to .rex
Rwcon60 userid=apps/apps source=POXKISUM.rdf stype=rdffile dtype=rexfile
dest=POXKISUM.rex overwrite=yes batch=yes
This creates POXKISUM.rex in directory from where you ran the command.
You must have write permissions on this directory.
The .rex file is the readable (text) version of the report.
You can perform only the first part of the instructions (change to a .rex)
if your report is returning no or incorrect data and you wish to see the SQL
that the report is performing.
b) Then convert the report back to the binary format (.rdf)
Rwcon60 userid=apps/apps source=POXKISUM.rex stype=rexfile dtype=rdffile
dest=POXKISUM.rdf overwrite=yes batch=yes
How to recompile a report for Release 10.7 applications
For Applications release 10.7, you must use the r25convm command
In this example we will use the ARBARL report.
1) Navigate to the <$PROD_TOP>/srw directory
e.g. cd $AR_TOP/srw
2) From the directory where the report is located, convert the binary form (.rdf) to a
readable format (.rex)
Example:
r25convm userid=<apps/password> stype=rdffile source=X dtype=rexfile dest=Y
dunit=character batch=yes
r25convm userid=apps_appdemo/apps stype=rdffile source=ARBARL.rdf dtype=rexfile
dest=ARBARL.rex dunit=character batch=yes
This creates ARBARL.rex in directory from where you ran the command.
You must have write permissions on this directory.
The .rex file is the readable (text) version of the report.
You can perform only the first part of the instructions (change to a .rex) if your
report is returning no or incorrect data and you wish to see the SQL that the report is
performing.
3) Then convert the report back to the binary format (.rdf)
r25convm userid=<apps/password> stype=rexfile source=X dtype=rdffile dest=Y
dunit=character batch=yes
Example:
r25convm userid=apps_appdemo/apps stype=rexfile source=ARBARL.rex dtype=rdffile
dest=ARBARL.rdf dunit=character batch=yes
This will create ARBARL.rdf in the same directory.
This re-generation removes any corruption from the .rdf format.
Note: The r25convm utility is only available on 10.7
ADADMIN can be used as an alternative and is available on 10.7, 11.0 and 11.5.
From the ADADMIN Main Menu choose > Maintain Applications Files >
Generate Report Files

Just gothrough this

[raja_rthiyagu]

HI,

PAYABLES FAQ ---2
1. Q: How do I setup the supplier for electronic payment?


? goal: How to Setup a Supplier for Electronic Payment in Release 11i

? fact: Oracle Payables 11.5

? fact: APXVDMVD - Enter Vendor




fix:

In order to use Electronic Payment functionality in 11i, you will need to
perform the following steps:

1) Create your new supplier and supplier site.
You will need to leave the Payment Method under the Payment tab to something
other than ELECTRONIC. If you try to select ELECTRONIC, when saving, the
system will require you to enter the supplier bank account and at this point,
it would not have been created.

Navigation: Suppliers-Entry

2) Create your new bank account for this supplier/supplier site.
From the alternate region, select the Supplier Assignments tab and enter the
supplier and supplier site here.

Navigation: Setup-Payments-Banks

3) If you go back and re-query the supplier site, this bank account information
will appear in the Bank Accounts button, however, you will still need to change
the Payment Method under the Payments tab to ELECTRONIC.

Navigation: Suppliers-Entry

Your other option of creating and linking your bank account information is:

1) Create your new bank account for this supplier/supplier site.

Navigation: Setup-Payments-Banks

2) Create the supplier and supplier site and link this new bank account at the
supplier site level, under the Bank Account tab. You will also need to set the
Payment Method to ELECTRONIC under the Payments Tab.

Navigation: Suppliers-Entry

.



2. Q: How do I setup banks for suppliers?
A: Please review the following steps
1. In the Banks window query an existing Bank.
2. Choose the Bank Accounts button. Enter the Bank Account Name and Bank Account Number. Enter the EDI
ID number. Optionally enter an Account Type and Description. Optionally change the account currency, which
defaults from your functional currency. If you want to use Bank Account validation, enter Check Digits.
3. Select Supplier as the Account Use.
4. In the Supplier Assignments region list the supplier, and optionally list supplier sites, that use the account to
receive electronic payments.
5. Optionally enter account holder information in the Account Holder region. Optionally enter contact information
in the Account Contacts region.
6. Save your work.
7.all appropri In the Bank Accounts region of the Suppliers and Supplier Sites windows, verify for each supplier
and site thatall appropriate bank accounts are listed. For suppliers and supplier sites with multiple bank
accounts, designate as the primary bank account one bank account per period and per currency.




3. Q: How do I resolve the following error: AP_VEN_NUMERIC_NUM_REQ when creating a new supplier?



Problem Description
-------------------
In Oracle Payables, you try to create a new supplier. You navigate to
Suppliers -> Entry, create a new supplier, fill in the supplier name, supplier
number, and save it. You get the following message:

AP_VEN_NUMERIC_NUM_REQ

Solution Description
--------------------
This is a setup issue. You will get AP_VEN_NUMERIC_NUM_REQ, when you have set
Type = Numeric, but you have filled in some characters (rather than numbers) in
the Supplier Number field.

Navigate to Setup -> Options -> Financials, Supplier Entry region.

If Entry = Automatic, you can only set Type = Numeric, you do not
need to enter Supplier Number when you create a new supplier, when
you save the supplier, the system will automatically generate a
numeric number for you.

If Entry = Manual, you can set Type = Numeric or Alphanumeric.

If you set Type = Numeric, you should not fill in any character in
supplier number field, it should be a number.


Additional Search Words
-----------------------
APXVDMVD, SUPPLIER, VENDOR, AP_VEN_NUMERIC_NUM_REQ


4. Q: Why am I unable to view supplier bank information at the supplier site level?

In Oracle Accounts Payable, you attempt to view supplier bank information
at the supplier site level.
Navigation path is:
Suppliers -> Entry -> Alternate Region Site -> Alternate Region Bank Accounts
No bank information appears in this region even though a supplier bank has been
defined.
Navigation path is:
Setup -> Payment -> Banks -> Bank Accounts -> Alternate Region Supplier
Assignments
Solution Description
--------------------
When setting up the supplier bank you must populate the vendor site field in
order to see the supplier bank account information at the supplier site level.

5. Q: How Do I Identify Duplicate Suppliers?

Identifying Duplicate Suppliers
Although the system will not allow you to enter duplicate supplier names, you may
inadvertently define the same supplier using two different names. For example, you
might enter Oracle Corporation and Oracle Corp, or you might enter a contracter
under his name and his company name. You might also create duplicate suppliers if
you import suppliers from another accounts payable system.
If you want to know if a supplier exists, you can query the Supplier in the Suppliers
window or submit the Vendor Listing by Supplier Name. When you enter an invoice,
check the list of values for the Supplier field to see if your supplier exists
before you enter a new supplier.
Suggestion: To avoid entering duplicate suppliers in Payables, consider developing
and using standard naming conventions for suppliers, and restricting who can enter
new suppliers.
Submit the following reports periodically to review your suppliers and identify
duplicates:
Vendors Report. Lists detail supplier information. Report provides multiple selection
criteria and lists suppliers in alphabetical order.
Vendor Audit Report. Lists active suppliers whose names are the same up to a number
of characters which you specify, and ignores case, spaces, special characters,
etc. The report lists all sites of each possible duplicate supplier.
Then you can run the Supplier Merge Program and Merge the duplicates Suppliers.


6. Q: How do I merge Vendors/Suppliers?

Supplier Merge Program

Use Supplier Merge to combine two or more suppliers that you identify as duplicates.
You can update purchase orders and invoices for the old supplier to refer to the
new supplier. The Supplier Merge window also allows you to merge supplier sites
so that any sites assigned to an old supplier can be reassigned to the new supplier.
When you merge suppliers you transfer invoices, purchase orders, or both from
one supplier and site to another supplier and site. You can transfer to a new
supplier and site unpaid invoices only, or all invoices (including paid and partially
paid invoices). Payables will not transfer invoices if the merge would create a
duplicate invoice for a supplier.

For best auditing results, transfer both paid and unpaid invoices to a new supplier
and site so you can identify duplicate payments easily. Also, transfer both purchase
orders and invoices to a new supplier and site, so all invoice and purchase order
information refers to the same supplier.

After you have merged suppliers, Payables automatically prints the Purchase Order
Header Updates Report and the Vendor Merge Report as an audit trail of your supplier
merge activity. The Vendor Merge Report also lists duplicate invoices that it did
not merge, if you had any. You can then update the invoice number if the invoice
has not been paid or posted.


Prerequisites
Identify duplicate suppliers.
If you transfer invoices, the New Supplier Site must be a pay site.
If you transfer purchase orders, the New Supplier Site must be a purchasing site.
To merge suppliers using Supplier Merge:
1. In the Supplier Merge window, select which invoices to transfer from the Old
Supplier to the New Supplier: All, Unpaid, or None.
2. If you want to transfer all purchase orders from the Old Supplier to the New
Supplier, select PO.
3. Enter the Old Supplier Name and Site and the New Supplier Name. Payables will
transfer information from the Old Supplier to the New Supplier.
If you want to reassign the Old Supplier Site to the new Supplier, select Copy
Site and do not enter a New Supplier Site. During the Merge, Payables enters
the merge date as the inactive date for the Old Supplier Site and creates a new
site for the New Supplier with the information you selected to transfer.
If you want to merge the Old Supplier Site information with the New Supplier
Site information, do not select Copy Site, and enter one of the New Supplier's
existing sites in the Site field. During the merge, Payables enters the merge
date as the inactive date for the Old Supplier site and combines all of the
information you selected with the New Supplier Site information.
4. Choose Merge. Payables submits a concurrent request to run the Supplier Merge
Program, which transfers the information from the Old Supplier to the New
Supplier, and also runs the Purchase Order Header Updates Report and the
Vendor Merge Report.
5. Review the log file and reports after the request completes.


7. Q: How do I define Address Style default for Country or Territory?

? goal: Change Address Style used as default in Supplier Site Entry form
? fact: Oracle Payables
? fact: APXSUDCC - Maintain Countries and Territories
fix: To define Address Style default for Country or Territory: 1. Navigate to Payables->Setup->Countries 2. Query corresponding Country name. 3. Select desired Address Style. 4. Save changes. Important: Changing the Address Style may cause data loss if suppliers or other items dependent on this default have already been set up using the original value. If the original address style has data not referenced in the new style, this data will be lost.
































1. Q: Why can#65533;t I enable the Multiple Currency Payment check box?
A: You have not enabled the "Use Multiple Currencies" Payables Option and/or your bank account currency is not in your functional currency.
[top]

2. Q: Why are the Receivable Options and More Receivables Options choices not available from the alternate region drop down box?
A: Oracle Receivables is not fully installed. You will not see these choices if Oracle Receivables is not installed or is a shared install.
[top]

3. Q: Why doesn#65533;t "Supplier" show up in the list of values for "Account Use" in the Bank Account Form?
A: You have not enabled the #65533;Use Multiple Supplier Banks#65533; Payables Option in the Payments alternate region.
[top]

4. Q: Why do I get a #65533;Choose Valid Combination#65533; message when I attempt to select an account, and why is the List of Values button disabled for the GL Account fields for my new organization?
A: You need to select a set of books. Make sure you select the correct set of books for the System Profile Options GL:Set of Books Name and GL:Set of Books ID. And select the correct set of books in the Payables in the Set of Books screen (Setup -> Set of Books -> Choose).
[top]
5. Q: When creating a payment document, do I need to specify a #65533;Last Available#65533; number?
A: If you intend to only have one payment document, there is no need to specify a #65533;Last Available#65533; number, so you will never reach a maximum. You should specify a "Last Available" number only if you want to create another payment document for that bank account.
[top]

6. Q: Do Bank Branch Numbers have to be unique?
A: Yes, to allow BACs and funds transfers.
[top]

7. Q: Do Bank Account Numbers need to be unique?
A: Within a Bank Branch, Bank Accounts must have a unique number for the same currency and account use. They must also have a unique name for the same currency and account use.
[top]

8. Q: Why can#65533;t I update the Last Available field for the payment document?
A: Most likely, the document is in use by a payment batch or Quickcheck. Cancel any batches that are not confirmed or already canceled or Quickchecks that are not formatted, which are using this payment document.
[top]
9. Q: What are the MetaLink keywords I should use when searching for Bank Setup on MetaLink?
A: APXSUMBA

10. Q: The questions listed in this guide do not address my question
A: If the FAQ list for Bank Setup does not answer your question, please click here to log an iTAR.
Use the Bank Setup Template.

-------------------------------------------------------------------------------------------------------------------------------------------



Q: Can you account for a payment without accounting for an invoice?
A: You must account for the invoice prior to accounting for the payment. If you try to account for the payment you will receive the following error in the log file: Cannot Account for GENERIC bank account#65533;s check number XXXXXX because the Invoice that it pays, is NOT accounted.
[top]

Q: What does the Unaccounted Transaction Sweep Report do?
A: The Unaccounted Transaction Sweep Report shows which transactions will be re-dated to the next open period if you run the Unaccounted Transaction Sweep program. Please see the What does the Unaccounted Transactions Sweep Report Do? for a more detailed explanation.
[top]

Q: Which Tables are Updated by the Payables Aco****ing Process (APACCENG)?
Note 161341.1
A: The Payables Accounting Process APACCENG writes to the following tables:
ap_accounting_events_all
ap_ae_headers_all
ap_ae_lines_all
For invoices it updates the accounting_event_id in ap_invoice_distiributions_all
For payments it updates the accounting_event_id in ap_invoice_payments_all
For clearing events it updates the accounting_event_id in ap_payment_histroy_all
[top]

Q: Are there accounting entries created for payments and payment cancellation when they have the same accounting date?
Note 168542.1
A: If the payments is voided before accounting for the payment the system will change the payment and payment cancellation to accounted YES, however, the accounting entries are not viewable. The Payables Create Accounting process does not create entries in ap_ae_lines_all for these transactions. To prevent this you must account for the payment prior to voiding the transaction.
[top]

Q: How to do you run APACCENG - Payables Accounting Proces with Debug Flag on?
A: Please reference Note 190146.1 which provides the steps to turn on the debug flag if that parameter is not visible from the concurrent manager.
[top]

Q: How do I open the next payables accounting period?
A: Please review Note 202779.1 to assist in the resolution of this issue.
[top]

Q: Why is there an invalid account and how do I fix it?
A: Please review Note 167748.1 which explains this issue.
[top]

Q: What reports should I run before closing the period?
A: Run the following reports:
? Invoice On Hold Report - review holds and release any accounting holds
? Unaccounted Transactions Report - review the transactions that need to be posted or swept to the next period before closing
[top]

Q: What are the keywords I should use when searching for Accounting 11i on MetaLink?
A: Use the short name for the process, APACCENG, along with any words specific to your accounting issue, e.g. prepayment, cancel, invoice, fatal error.
[top]

Q: What articles, white papers, or manuals should I read for more information on creating accounting in 11i?
A: Please see the Create Accounting 11i Setup and Usage Guide for a complete list of available documents.













1. Q: What the difference between EDI Payment Outbound (820) and EFT payment program?
A: Both EDI Payment Outbound and EFT Payment program are used to pay invoices with payment method of Electronic Payments.
EDI Payment Outbound is using ECEPYO.sql. You will need to install the EDI product to use this outbound program. It provides several payment methods, like ACH and BACS, and several payment formats, like CCD and CCP.
EFT Payment program is using APXPBFBC.rdf. The Oracle Payables Application includes this program. This program formats and creates a BACS output file that is fitted for 1/2 inch tape media.
[top]
2. Q: What is EDI Invoice Inbound 810?
A: EDI Invoice Inbound 810 loads invoices from a flat file into open interface tables ap_invoices_interface and ap_invoice_lines_interface. You then use Payables Open Interface Import to import the invoices.You need to install the EDI product to have this functionality.
[top]
3. Q: What is EDI Payment Outbound 820?
A: EDI Payment Outbound 820 is used to make electronic (EFT) payments, but provides several payment methods, like ACH and BACS, and several payment formats, like CCD and CCP.
[top]
4. Q: What EDI processes does Oracle Payables use?
A: Oracle Payables has two EDI processes:
EDI Invoice Inbound 810 - ECEINI.sql - to import Invoices
EDI Payment Outbound 820 - ECEPYO.sql - to create electronic payments
[top]
5. Q: What are the setup steps for EDI Invoice Inbound 810?
A: 1) Check setup in UNIX
===================
cd $ORACLE_HOME/dbs
grep -i utl_file_dir init.ora
For Example, you get:
utl_file_dir=/sqlcom/inbound,/sqlcom/outbound,/sqlcom/log,/sqlcom/out
2) Check Profile Options
=====================
Using the System Administrator Responsibility navigate to Profile -> System
Set the following:
Site = Yes,
Profile Option "ECE:Inbound directory" = /sqlcom/inbound
Save
Note: (1) and (2) have to be the same directory (/sqlcom/inbound in this example).
3) Copy the Flatfile to the directory defined
==================================
For Example: Flatfile Name = ECEINI.dat
Copy ECEINI.dat into the directory which Profile Option "ECE:Inbound directory" is defined.
cp ECEINI.dat /sqlcom/inbound
4) Verify Flatfile (part 1)
========================
For Example: Your Flatfile = ECEINI.dat
a. Delete the 810 records from your ECE_OUTPUT file-
In SQL*Plus as the apps user:
delete from ECE_OUTPUT
where run_id = 810;
commit;
b. exec ECE_UTILITIES.verify_flatfile(810,'INI','/sqlcom/inbound', 'ECEINI.dat');
The exec should return: PL/SQL procedure successfully completed.
c. select text from ECE_OUTPUT
where run_id = 810;
Make sure all the lines are left adjusted.
5) EDI and Supplier form Setups
============================
a. Using the EDI Gateway Responsibility navigate to Trading Partners
Set the following where Supplier = GE_Capital, for example:
Group = ECEINI GE_Capital
Partner = GE_Capital
Document = Invoice Inbound
Document Type = Standard Invoice
Translator Code = TR_CODE
Save
b. Using the AP Manager Responsibility navigate to Suppliers -> Entry
Query on Supplier = GE Capital, go to Site,
Go to Electronic Data Interchange region, Set:
EDI Location = LOC_CODE1
6) Verify Flatfile (Part II)
=========================
Select text from ECE_OUTPUT
where text like '%0010%'
order by text;
For Example:
Rec: 0010 Pos: 10 Width: 2 Col: COMMUNICATION_METHOD Val= ED
Rec: 0010 Pos: 20 Width: 1 Col: TP_TEST_FLAG Val= P
Rec: 0010 Pos: 30 Width: 6 Col: TP_DOCUMENT_ID Val= INI
Rec: 0010 Pos: 40 Width: 5 Col: DOCUMENT_TYPE Val= INVOI
Rec: 0010 Pos: 50 Width: 2 Col: TP_PURPOSE_CODE Val=
Rec: 0010 Pos: 60 Width: 35 Col: TP_DOCUMENT_CODE Val= EDI_INV01
Rec: 0010 Pos: 70 Width: 30 Col: TRANSLATOR_CODE Val= TR_CODE
Rec: 0010 Pos: 80 Width: 35 Col: TP_LOCATION_CODE_EXT Val= LOC_CODE1
Rec: 0010 Pos: 90 Width: 74 Col: TP_DESCRIPTION Val=
Rec: 0010 Pos: 100 Width: 80 Col: TP_REFERENCE_EXT1 Val=
Rec: 0010 Pos: 110 Width: 80 Col: TP_REFERENCE_EXT2 Val=
Rec: 0010 Pos: 120 Width: 15 Col: TRANSACTION_DATE Val=
Rec: 0010 Pos: 130 Width: 15 Col: RUN_ID Val=
Rec: 0010 Pos: 140 Width: 10 Col: TRANSACTION_CONTROL1 Val=
Rec: 0010 Pos: 150 Width: 10 Col: TRANSACTION_CONTROL2 Val=
Rec: 0010 Pos: 160 Width: 10 Col: TRANSACTION_CONTROL3 Val=
Please make sure:
TRANSLATOR_CODE = TR_CODE
TP_LOCATION_CODE_TEXT = LOC_CODE1
7) Verify Flatfile (part III)
=============================
a) Load the flatfile ECEINI.dat into WordPad or NotePad.
b) Using the EDI Gateway Responsibility, Navigate to Output Definition
Query on Transaction = INI, Level = Invoice Header or Invoice Line
c) From SQL*Plus, run:
select text
from ECE_OUTPUT
order by text;
You will get the following, for example:
Rec: 0010 Pos: 20 Width: 1 Col: TP_TEST_FLAG Val=P
Rec: 0010 Pos: 30 Width: 6 Col: TP_DOCUMENT_ID Val=INI
Rec: 0010 Pos: 40 Width: 5 Col: DOCUMENT_TYPE Val=INVOI
Rec: 0010 Pos: 50 Width: 2 Col: TP_PURPOSE_CODE Val=
Rec: 0010 Pos: 60 Width: 35 Col: TP_DOCUMENT_CODE Val= EDI_INV01
Rec: 0010 Pos: 70 Width: 30 Col: TRANSLATOR_CODE Val=TR_CODE
Rec: 0010 Pos: 80 Width: 35 Col: TP_LOCATION_CODE_EXT Val= LOC_CODE1
Rec: 0010 Pos: 90 Width: 74 Col: TP_DESCRIPTION Val=
Rec: 0010 Pos: 100 Width: 80 Col: TP_REFERENCE_EXT1 Val=
Rec: 0010 Pos: 110 Width: 80 Col: TP_REFERENCE_EXT2 Val=
Rec: 0010 Pos: 120 Width: 15 Col: TRANSACTION_DATE Val=
Rec: 0010 Pos: 130 Width: 15 Col: RUN_ID Val=
Rec: 0010 Pos: 140 Width: 10 Col: TRANSACTION_CONTROL1 Val=
Rec: 0010 Pos: 150 Width: 10 Col: TRANSACTION_CONTROL2 Val=
Rec: 0010 Pos: 160 Width: 10 Col: TRANSACTION_CONTROL3 Val=
Rec: 1000 Pos: 10 Width: 10 Col: INVOICE_NUM Val= qtest1
Rec: 1000 Pos: 20 Width: 20 Col: INVOICE_DATE Val= 19991110000000
Rec: 1000 Pos: 30 Width: 10 Col: INVOICE_AMOUNT Val= 100.00
Rec: 1000 Pos: 40 Width: 10 Col: INVOICE_TYPE_LOOKUP_CODE_INT Val= STANDARD
Rec: 1000 Pos: 50 Width: 10 Col: TERMS_NAME_INT Val= Net30
Rec: 1010 Pos: 10 Width: 10 Col: INVOICE_CURRENCY_CODE Val=USD
Rec: 1010 Pos: 20 Width: 10 Col: VENDOR_NUM Val= 1001
Rec: 1010 Pos: 30 Width: 10 Col: VENDOR_SITE_CODE Val=ORLANDO
Rec: 3000 Pos: 10 Width: 10 Col: ITEM_LINE_TYPE_CODE+L270 Val=ITEM
Rec: 3000 Pos: 20 Width: 10 Col: INVOICE_LINE_NUMBER_EXT Val=1
Rec: 3000 Pos: 30 Width: 10 Col: QUANTITY_INVOICED Val=100
Rec: 3000 Pos: 40 Width: 10 Col: UNIT_PRICE Val=1
Rec: 3000 Pos: 50 Width: 10 Col: AMOUNT Val=100.00
Rec: 3010 Pos: 10 Width: 10 Col: PO_NUMBER Val=6363
Rec: 3010 Pos: 20 Width: 10 Col: PO_LINE_NUMBER Val= 1
Rec: 3010 Pos: 30 Width: 10 Col: PO_SHIPMENT_NUM Val= 1
Rec: 0010 Pos: 10 Width: 2 Col: COMMUNICATION_METHOD Val=ED
*** Compare (a), (b), (c), you can modify the flatfile ECEINI.dat in WordPad if any position is wrong.
Run ECEINI EDI Invoice Inbound
=================================
a. Using the EDI Gateway Responsibility, navigate to Import Programs
b. Set Name = EDI Invoice Inbound.
c. Submit the request.
[top]
6. Q: What is the setup steps for EDI Gateway Payment Outbound 820?
A: 1) Profile Options Setup
==================
Using the SysAdmin responsibility, Navigate to Profile -> System
Find Profile = ECE: Output file path
Set the Site = <Path for output file directory>
Example: Site = /u13/appl/f1070161/edi
2) init.ora setup
==============
Add an environment variable "utl_file_dir" in $ORACLE_HOME/dbs/init.ora
Example: utl_file_dir = /u13/appl/f1070161/edi
This path needs to be exactly same as the path you have defined in Profile Options.
3) Format Program Setup
====================
Using the Payables responsibility, navigate to Setup -> Payment -> Format
Payment Format = EDI Outbound Program
Payment Method = Electronic Payments
Currency = USD
Build Payments = Build Payments Program
Format Payments = EDI Outbound Program
4) Internal Bank Account Setup
===========================
Using the Payables responsibility, navigate to Setup -> Payment -> Banks
Set up a Bank Account as follows:
Bank Branch Type = (Select from LOV)
Account Use = Internal
Account Type = EDI
Create a new Payment Document to use where Payment Format = EDI Outbound Program
5) Supplier Bank Account Setup
===========================
Using the Payables responsibility, navigate to Setup -> Payment -> Banks
Create a new Bank Account, set:
Bank Branch Type = (Select from LOV)
Account Use = Supplier
Account Type = EDI
Go to Supplier Assignments region,
Fill in Supplier Name, Site, Effective Dates From, set Primary = Yes
Save it.
6) Supplier Site Setup
===================
Using the Payables responsibility, navigate to Supplier -> Entry
Query the supplier, go to Site.
a) Go to the Bank Account Region. Make sure that the Supplier Bank has been filled in here. Make sure that Primary is set to 'Yes'.
b) Go to Electronic Payment Region, set:
Payment Method
Payment Format
Remittance Method
Remittance Instruction
Transaction Handling
7) Trading Partner Setup
=====================
Using the EDI Gateway responsibility, Navigate to Trading Partners
Define a trading partner as follows:
Assignment Region: fill in Supplier, Site, EDI Location, Bank Branch, EDI Location.
Contact Region: fill in contact information.
Detail Region: set Document = Payment/Remittance Outbound, EDI = Yes.
Invoice for EDI 820
===================
For a test, create a payment batch that will pick up all invoices where Payment Method = Electronic Payments.
Set Payment Method to Electronic for all of the invoices you would like AutoSelect to select.





1. Q: How do I generate Draft Accounting in Global Accounting Engine (AX) Release 11i?
A: To generate accounting entries in Draft Mode in the Submit Posting Manager window :
1. Choose AX Payables Responsibility
2. (N) Accounting > Post Transactions
3. Translate events and transfer to GL should be checked
4. Check the Draft Mode check box
5. Press the Submit button to start the processing
Please note the following:
1.Before you can create draft accounting entries, you must define the AX Draft Accounting category and draft
accounting sequence for draft accounting entries.
2.You cannot transfer draft accounting entries to General Ledger.
For further info please reference the Global Accounting Engine User's Guide Release 11i page 3-2.
[top]
2. Q: How do I create Entries and Adjustments in Global Accounting Engine (AX) Release 11i?
A: Navigation :
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments
[top]
3. Q: How do I review Draft Accounting Entries in Global Accounting Engine (AX) Release 11i?
A: You can review and modify as many times as desired Draft Accounting Entries until you are ready to finalize the accounting.
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments
Refer to Global Accounting Engine User's Guide Release 11i page 3-3.
[top]
4. Q: How do I change AX Accounting entries from draft to permanent in Global Accounting Engine (AX) Release 11i?
A: Once you change the status of an accounting entry to permanent, you cannot change the accounting entry's status back to
draft.
1. For accounting entries created through the AX Posting Manager, run the Posting Manager in Permanent Mode
2. For manually-entered adjustments in the Journal Entries window while the Journal entry check box was unchecked, check the
Journal entry check box
Refer to Global Accounting User's Guide Release 11i pages 3-4 and 3-12.
[top]
5. Q: How do I generate Permanent Accounting in Global Accounting Engine (AX) Release 11i?
A: For accounting entries created through the AX Posting Manager :
1. Choose AX Payables Responsibility
2. (N) Accounting > Post Transactions
3. Translate events and transfer to GL should be checked
3. Do not check the Draft Mode check box
4. Hit the Submit button to run the Posting Manager
For manually-entered adjustments in the Journal Entries window :
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments by checking the Journal Entry Complete check box
Refer to Global Accounting User's Guide Release 11i pages 3-4 and 3-8.
[top]
6. Q: Is there a diagnostic script available to track an AP invoice through AX to GL for Release 11i?
A: Please reference note 198354.1 to assist in the resolution of this issue.
[top]
7. Q: Is there a diagnostic script available to track an AP payment through AX to GL for Release 11i?
A: Please reference note 198413.1 to assist in the resolution of this issue.
[top]
8. Q: Is there a script that will collect data in AX and GL for a given event?
A: Please reference the Oracle Support Services Diagnostics Tests- Main Catalog and select Release 11i, Global Accounting Engine to locate the Event Data Collection script. Whenever there is an issue with an event in AX that doesn't get translated or posted this test can be used to collect the relevant data for that particular event in AX and GL. The outcome of the test can help support and /or development to diagnose the cause and provide a solution. The test focuses on AX events originating from Accounts Receivables ( such as transactions, receipts, adjustments, customer merge ) and Accounts Payables ( such as invoices, checks and supplier merge ).
Data is collected from following tables :
AX_SETUP_GLOBAL
AX_SETUP_POSTING_BOOKS
AX_TRANS_PROGRAMS
AX_EVENTS
AX_DOCUMENT_STATUSES
AX_SLE_HEADERS
AX_SLE_LINES
AX_BALANCES
GL_INTERFACE
GL_JE_LINES
This test only gathers info from AX and GL. It does not show data from AP, AR. To be complete an additional data collection test should be run to collect data from AP or AR depending on the nature of the event. Your support representative will ask for that if needed.
[top]

[anu_uma]

Hi Raju,

Check the Below link

http://erpstuff.com/topic.asp?TOPIC_ID=1174



Regards

[quote]can anyone send payble FAQs ? as many as possible

<i><div align="right">Originally posted by m.a.raju1981