Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick, Simple and Absolutely Free.

Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 29,419
» Latest member: ahmadourkz
» Forum threads: 687
» Forum posts: 1,289

Full Statistics

Online Users
There are currently 15 online users.
» 0 Member(s) | 15 Guest(s)

Latest Threads
Looking for questionnaire...
Forum: Ask Kashif
Last Post: Kashif Manzoor
03-05-2017, 09:26 PM
» Replies: 1
» Views: 82
AME Approval Rules for Up...
Forum: Oracle Financials
Last Post: sadams01
02-25-2017, 12:30 AM
» Replies: 2
» Views: 155
Close Discrete Jobs
Forum: Manufacturing and Projects
Last Post: rofymarten
02-10-2017, 03:45 AM
» Replies: 1
» Views: 2,506
WIP Completion and Materi...
Forum: Manufacturing and Projects
Last Post: rofymarten
02-10-2017, 03:41 AM
» Replies: 2
» Views: 1,082
Oracle Purchasing
Forum: General Discussion
Last Post: Jaiky
02-07-2017, 05:07 PM
» Replies: 0
» Views: 154
Beginners Resources for O...
Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips
Last Post: Kashif Manzoor
02-04-2017, 10:07 PM
» Replies: 0
» Views: 433
Fix for FRM- and ORA- Err...
Forum: General Discussion
Last Post: Rashmi16
02-03-2017, 10:02 PM
» Replies: 1
» Views: 890
Oracle Payable Open Inter...
Forum: Oracle Financials
Last Post: Neha Majeed
01-30-2017, 04:28 PM
» Replies: 0
» Views: 387
SSO integration with Clou...
Forum: Ask Kashif
Last Post: Kashif Manzoor
01-29-2017, 04:52 PM
» Replies: 1
» Views: 192
Unpaid Invoice amount in ...
Forum: Ask Kashif
Last Post: Arshad Ch
01-27-2017, 08:45 PM
» Replies: 0
» Views: 239

 
  AME Approval Rules for Updates to Supplier Master?
Posted by: sadams01 - 02-24-2017, 12:08 AM - Forum: Oracle Financials - Replies (2)

Hi - can anyone tell me if it is possible to set up AME approval rules for updates to the supplier master? For instance, if a user tries to manually "Create Supplier", the new supplier is then routed to the user's supervisor for approval prior to being added to the supplier master. 

I have been stuck on this for some time - any help would be greatly appreciated. Thank you!

Print this item

  Oracle Payable Open Interface Import
Posted by: Neha Majeed - 01-30-2017, 04:28 PM - Forum: Oracle Financials - No Replies

AP Invoice Interface is used with the creation of payable invoices in the Oracle System through Oracle Payable Open Interface Import. Standard Payable invoices are created in the system for the PO sent across to the supplier and invoice details received for the same.

Payable invoices can be created manually by entering from the Invoice screen but in business having recurring transactions opt for auto invoice creation. This mechanism involves populating the interface tables with the invoice table and run the payables import program to create the invoice.

Table Details:
AP Invoice Interface tables
1.AP_INVOICES_INTERFACE
2.AP_INVOICE_LINES_INTERFACE

AP Invoice Base Tables:
1. AP_INVOICES_ALL
2.AP_INVOICE_DISTRIBUTIONS_ALL
3. AP_PAYMENT_SCHEDULES_ALL

Error table:
1.AP_INTERFACE_REJECTIONS
2.AP_INTERFACE_CONTROLS


Users can use the Payables Open Interface Import program to create Payables invoices from invoice data in the Payables Open Interface Tables.  Payables Open Interface Tables need to be populated with invoice data from the following sources:
    • Supplier EDI invoices (ASC X12 810/EDIFACT INVOIC) transferred through Oracle EDI Gateway
    • Invoices from other accounting systems with a custom SQL*Loader program 
    • Credit card transactions you have transferred using the Credit Card Invoice Interface Summary
[size=undefined]
After the interface tables are populated users need to submit 
[/size]

  1. The Payables import program to create payables invoices.Enter the report parameters.  In the Source field, select the source name from the list of values. If your records have a Group and you want to import invoices for only that group, enter the Group. This will allow you to import smaller sets of records concurrently for the same source, which will improve your performance. If you use batch control, enter a Batch Name.
[size=undefined]
Debugging Interface Errors

After the interface program completes invoices will be created in the system. For the records failing the validations no invoices will be created and the records will be errored out in the interface.
Some of the most fatal errors are
[/size]
  • No supplier or supplier site
  • The invoice number is a duplicate
[size=undefined][size=undefined]
If the invoice level information is correct, Payables will validate all values at the line level, and the rejections report will list all line level problems. If a distribution is rejected, the whole invoice is rejected.You can correct the data in one of the following ways:

[/size]
[/size]
  • Use the Open Interface Invoices window to correct problems directly in the Payables Open Interface tables.
[size=undefined][size=undefined]
Invoice Validation

Once the Invoices have been created invoice validation needs to be done so that invoices can be processed further to make payments and transfer to GL. For this we need to either manually validate individual invoices from the Invoice Screen or run the Invoice Validation Program. This activity will validate the invoices and allow further processing, In case invoices fail in validation then the invoices will be put on hold . the user can see the hold details by pressing the "HOLDS" button on the invoice screen. at the backend hold details will be stored in the table : ap_invoice_holds

This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications.

Interface tables: 
1] AP_INVOICES_INTERFACE
This is the open interface table for importing AP Invoices from external sources and stores header information about invoices. Invoice data comes from sources including:

[/size]
[/size]
  • EDI invoices from suppliers that are loaded through Oracle e-Commerce Gateway
  • Supplier invoices that are transferred through the Oracle XML Gateway
  • Invoices that are loaded using Oracle SQL*Loader
  • Lease invoices from Oracle Property Manager
  • Lease payments from Oracle Assets
  • Credit card transaction data that are loaded using the Credit Card Invoice Interface Summary
  • Expense Report invoices from Oracle Internet Expenses
  • Payment Requests from Receivables
  • Invoices that are entered through the Invoice Gateway.
[size=undefined][size=undefined]
There is one row for each invoice you import. Oracle Payables application uses this information to create invoice header information when Payables Open Interface program is submitted.
Data in the AP_INVOICES_INTERFACE table used in conjunction with AP_INVOICE_LINES_INTERFACE table to create Payables Invoice, Invoice lines, Distributions and Schedule payments. Data in this table can be viewed and edited using ‘Open Interface Invoices’ window. The Payables Open Interface program validates each record in this interface table selected for import, and if the record contains valid data then the program creates a Payables Invoice.

Important columns: 
INVOICE_ID (Required) : Unique identifier for this invoice within this batch. Same value should be populated in invoice’s lines in the AP_INVOICE_LINES_INTERFACE table to identify the data as belonging to the same invoice.
INVOICE_NUM (Required) :  Enter the invoice number that needs to be assigned to the invoice created in Payables from this record.
INVOICE_TYPE_LOOKUP_CODE (Optional) : Type of invoice: Credit or Standard.
INVOICE DATE (Optional) : Date of the invoice. If you do not enter a value, the system uses the date you submit Payables Open Interface Import as the invoice date.
PO_NUMBER (Optional)  : Purchase order number from PO_HEADERS.SEGMENT1. This column needs to be populated if invoice to be matched with an purchase order.
VENDOR_ID & VENDOR_SITE_ID (Required) : VENDOR_ID is unique identifier for a supplier and VENDOR_SITE_ID is Internal supplier site identifier. Supplier of the invoice to be derived by value in one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_NAME, VENDOR_SITE_ID or PO_NUMBER.
VENDOR_NUM & VENDOR_NAME (Optional) : Supplier number and name. You must identify the supplier by entering a value for one of the following columns in this table: VENDOR_ID, VENDOR_NUM, VENDOR_SITE_ID, VENDOR_SITE CODE, or PO_NUMBER.
INVOICE_AMOUNT (Required) : Amount of the invoice.
INVOICE_CURRENCY_CODE (Optional)  : Currency code for the invoice. If you want to create foreign currency invoices, enter a currency code that is different from your functional currency.
EXCHANGE_RATE (Optional) :  This column is required if you enter a foreign currency code in the INVOICE_CURRENCY_CODE column and you enter User as the EXCHANGE_RATE_TYPE.
TERMS_ID (Optional) : Internal identifier for the payment terms.
DESCRIPTION (Optional) : Enter the description that you want to assign to the invoice created from this record.
SOURCE (Required) : Source of the invoice data. If you import EDI invoices from the Oracle EDI Gateway, the source is EDI Gateway. For invoices you import using SQL*Loader, use a QuickCode with the type Source that you have defined in the QuickCodes window in Payables.
2] AP_INVOICE_LINES_INTERFACE
This is the lines interface table for the AP Invoice Open Interface and it is used in conjunction with AP_INVOICE_INTERFACE table. AP_INVOICE_LINES_INTERFACE stores information used to create one or more invoice distributions. Note that one row in this table may create, during the import process, more than one invoice distribution.
Important columns: 
INVOICE_ID (Required) :Enter the INVOICE_ID of the corresponding invoice in the AP_INVOICES_INTERFACE table. 
INVOICE_LINE_ID : This value is not required. You can enter a unique number for each invoice line of an invoice.
LINE_NUMBER (Optional) : You can enter a unique number to identify the line.
LINE_TYPE_LOOKUP_CODE (Required) : Enter the lookup code for the type of invoice distribution that you want Payables Open Interface Import to create from this record. The code you enter must be ITEM, TAX, MISCELLANEOUS, or FREIGHT. These lookup codes are stored in the AP_LOOKUP_CODES table.
AMOUNT (Required) : The invoice distribution amount. If you are matching to a purchase order, the AMOUNT = QUANTITY_INVOICED x UNIT PRICE. If the total amount of all the invoice distributions does not equal the amount of the invoice that has the same INVOICE_ID, then Payables Open Interface Import will reject the invoice.

Concurrent program:  
Payables Open Interface Import
Parameters:
Source: Choose the source of the invoices from the list of values. Use EDI Gateway, Credit Card, or a Source type QuickCode you defined in the Payables QuickCodes window.
Group: To limit the import to invoices with a particular Group ID, enter the Group ID. The Group must exactly match the GROUP_ID in the Payables Open Interface tables.
Batch Name: Payables groups the invoices created from the invoices you import and creates an invoice batch with the batch name you enter. You can enter a batch name only if you have enabled the Use Batch Control Payables option, and if you have enabled the Use Batch Control Payables option, you must enter a batch name. If you use a batch name and some invoices are rejected during the import process, you can import the corrected invoices into the same batch if you enter the exact batch name during the subsequent import.
Hold Name: If you want to place all invoices on hold at the time of import, enter an Invoice Hold Reason. You can define your own hold reasons in the Invoice Approvals window.
Hold Reason: Payables displays the Invoice Hold Reason Description.
GL Date: If you want to assign a specific GL Date to all invoices, enter a GL Date. If you do not enter a value here, the system will assign a GL Date based on the GL Date Payables option.
Purge: Enter Yes if you want Payables to delete all successfully imported invoice records that match the Source and Group ID of this import. Payables does not delete any invoice data for which it has not yet created invoices. If you want to purge later, you can use the Payables Open Interface Purge Program.
 Steps:
1] Firstly, let’s get a unique number to be used as INVOICE_ID to the invoice to be imported.  This method ensures that each invoice has a unique INVOICE_ID assignment.
 select ap_invoices_interface_s.nextval from dual;
NEXTVAL
-------------
132277


 2] Then, create records in the Invoice Open Interface tables through SQL queries.



insert into AP_INVOICES_INTERFACE (
            invoice_id,
            invoice_num,
            vendor_id,
            vendor_site_id,
            invoice_amount,
            INVOICE_CURRENCY_CODE,
            invoice_date,
            DESCRIPTION,
            PAY_GROUP_LOOKUP_CODE,
            source,
            org_id
                )
values (
            132277,
            'INV100',
            '7124',
            '11792',
            1200.00,
            'USD',
            to_date('01-31-2010','mm-dd-yyyy'),
            'This Invoice is created for test purpose',
            'WUFS SUPPLIER',
            'Manual Invoice Entry',
            81
);

insert into AP_INVOICE_LINES_INTERFACE (
            invoice_id,
            line_number,
            line_type_lookup_code,
            amount
            )
values     (
            132277,
            1,
            'ITEM',
            1200.00
);
3] You can go to Payables > Invoices > Entry > Open Interface Invoices to check the details of Invoice and Invoice Lines from the front end. If required you can do any modifications here. Alternatively you can use these forms to put invoice data in AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables.
4] Go to the front end and run the concurrent program “Payables Open Interface Import”  to submit a request for Invoice Import.

[/size]
[/size]

[Image: payables-open-interface-import-concurren...=500&h=151]
[size=undefined][size=undefined]
Output:
[/size]
[/size]

[Image: output-of-payables-open-interface-import...=500&h=261]

output of Payables Open Interface Import
[size=undefined][size=undefined]
5] The imported invoice becomes available for review in Invoices Workbench.

[/size]
[/size]

[Image: interface-invoice-through-invoice-banch.jpg?w=500&h=273]

Interface Invoice through Invoice Bench

AP_INTERFACE_REJECTIONS stores information about invoice data from the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables which could not be processed by Payables Open Interface Import.

SELECT * FROM AP_INTERFACE_REJECTIONS


1) Explain the Interface process.
Answer The interface process starts with uploading the legacy data, which is in the form of flat file to the temporary table, and validating the data in the temporary. After that the data to be transferred to the Interface tables. From there by running the Customer Open Interface concurrent program, the data that is in the interface tables are transferred to main tables.

2) What are the various tables involved in AP Interface?
Answer AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

3) What is the program used to import invoices from interface tables?
Answer   - Payables Open Interface Import

4) What the various validation to be done before transferring data from temporary table to interface tables?
Answer The various type of validations are:
Not null validation:

 few columns like 
- Invoice Number, 
- Invoice Date,
- Currency Code etc should not null

Data Type Validation:
- Invoice Amount
- Invoice Date

Business Validation:
- Is the GL date in open period? GL_PERIOD_STATUSES
- Invoice number is not repeating
- Invoice distribution total should match with Invoice header amount

Generation of CCID
GET_CCID

5)  What cases do you use Mapping? How did you achieve mapping functionality? Give some examples?

6) How can achieve that either complete files is inserted or complete file is rejected; while inserting into Open Interface tables?

7)  Can you give segment values or CCID while inserted records into AP_INVOICE_LINES_INTERFACE table?

8) Does the records in the Interface table get auto-purged after getting successfully imported into base tables?
Ans) No. We have run Payables Open Interface Purge

9) What are the errors encoutered while Importing Invoices?

Print this item

  International public sector accounting standards using Oracle EBS
Posted by: shaz.rashid@gmail.com - 12-27-2016, 09:14 PM - Forum: Oracle Financials - No Replies

Hi,

    I need to know if we can implement International Public Sector Accounting Standards (IPSAS) using standard Oracle Financials module or we need some specialized module for public sector accounting.

thanks.

Shaz

Print this item

  Payments to Financing House In Oracle R12
Posted by: nisarwangde - 12-11-2016, 07:34 PM - Forum: Oracle Financials - Replies (1)

Dear All, 

I have a case where I need to make payments to my supplier through a financing house. 
The financing house will make the actual transfer of payment to the supplier however I need to book them both in my ledger. 

The financing house is going to charge me an amount for this service payable monthly. 

Can someone help me in achieving this. 

The accounting entries should be as follows:

Invoice to Supplier1
Debit Expenses 1000
Credit Supplier1 1000

Upon Payment 
Debit  Supplier1 1000
Credit FinancingHouse 1000

Debit FinancingHouse 1000
Credit Bank 1000

Is this achievable in Oracle Payables R12?

Print this item

Photo When attempting to submit an expense report, i receive the following error "Message n
Posted by: sushantkatte - 12-03-2016, 09:23 AM - Forum: Oracle Financials - Replies (1)

Hi,
Can someone please help me with this issue. I am trying to create an expense report for testing purpose and in the general information page when I click on next to go to next section. i get this error -

  1. Message not found. Application: SQLAP, Message Name: AP_WEB_COST_CENTER_REQUIRED.  please help me in resolving the issue 
 
   

Print this item

  reconciliation of cheques issued on a previous instance
Posted by: RANDHIR KALLEECHURN - 10-17-2016, 07:04 PM - Forum: Oracle Financials - No Replies

I have just moved to a new instance of the financials.

Outstanding cheques at close of year has been brought to the new instance through a Journal.

The policy for reconciliation is daily basis.

BAnk statements for cheques cleared have been loaded on a daily basis.

However, when I select the option find and mark, it is selecting for the whole period instead of the specific date I have chosen.

Grateful for assistance please.

Regards

Randhir.

Print this item

  Supplier Creation R12 on Windows 10
Posted by: RANDHIR KALLEECHURN - 08-23-2016, 05:52 AM - Forum: Oracle Financials - Replies (2)

Hi.

I am unable to open the supplier creation/inquiry form on R12 using Internet Explorer on Pc's with Windows 10.

Grateful for your assistance, please.

Print this item

  Issues From multi org setups
Posted by: mahesh199 - 05-26-2016, 04:46 PM - Forum: Oracle Financials - Replies (1)

Can we assign one multiple legal entity's to one primary ledger?
Can we assign multiple inventory's to one Operating unit? IF YES How? IF No Why?

Thanks .

Print this item

  AP invoices: automatization
Posted by: PaulaC - 03-24-2016, 02:29 AM - Forum: Oracle Financials - Replies (1)

Hello,

I'm going to implement scanning process, and all invoices received are going to be registered by a file submited in Oracle.

Do you know how can match automatically also? the idea is to have all this process automatic, with no human intervention.

Thank you!

Print this item

  Duplicated entry in Oracle General Trial Balance
Posted by: eimis - 03-06-2016, 06:11 AM - Forum: Oracle Financials - No Replies

Hello Everyone,



I am new at oracle EBS 11i, I would appreciate if someone could tell me what is the correct thing to do as a technical support when you find a duplicate entry in the trial balance, in this case the user is asking me to look for the root of the issue, She said that the app is duplicating an entry in the trial balance for the same cost center. This entry is related to the the fixed asset depreciation, I am not so sure about the counterpart of the transaction.

Thank you very much for your help.

Regards

EimisPacheco@gmail.com

Print this item

Forum stats
Latest posts
Topic Date, time  Author Last Sender Forum
  Looking for questionnaire... 03-05, 21:26 scooterpie12345 Kashif Manzoor Ask Kashif
  AME Approval Rules for Up... 02-25, 00:30 sadams01 sadams01 Oracle Financ...
  Close Discrete Jobs 02-10, 03:45 admin rofymarten Manufacturing...
  WIP Completion and Materi... 02-10, 03:41 Anumeha Manish rofymarten Manufacturing...
  Oracle Purchasing 02-07, 17:07 Jaiky Jaiky General Discu...
  Beginners Resources for O... 02-04, 22:07 Kashif Manzoor Kashif Manzoor Oracle Tutori...
  Fix for FRM- and ORA- Err... 02-03, 22:02 Mukhtar Ali Rashmi16 General Discu...
  Oracle Payable Open Inter... 01-30, 16:28 Neha Majeed Neha Majeed Oracle Financ...
  SSO integration with Clou... 01-29, 16:52 Neha Majeed Kashif Manzoor Ask Kashif
  Unpaid Invoice amount in ... 01-27, 20:45 Arshad Ch Arshad Ch Ask Kashif
  Oracle EBS specialists ne... 01-25, 22:20 Gabriela Gabriela Jobs
Most views
  Oracle AIM - ... 109363
  Oracle Implem... 38716
  MEOUG Annual ... 34342
  Oracle E-Busi... 33228
  Oracle Financ... 32938
Most reputations
admin 4
M Irfan 3
shirfanarshad 2
Omer Ahmad 1
fanni339 1
Most replies
  Oracle AIM - ... 32
  R12.1.3 BR100... 16
  Oracle Implem... 15
  AIM - RD020 P... 7
  Encumbrance A... 6
Top posters
admin 211
Kashif Manzoor 172
fanni339 46
ajkhan80 34
Sara Khan 29
Most thanks
admin 173
Kashif Manzoor 88
Pryia Rai 7
rajkishoremokila@gmail.com 7
fanni339 3
Newest members
ahmadourkz Today
bonnebrochette@gmail.com Today
kjganesh Yesterday
kaushaam Yesterday
vijayvk Yesterday