What is the table that stores the AP Invoice notes?
AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOICE' and SOURCE_OBJECT_UID being the invoice_id of the payables invoice.
Query :
select
zn.note_txt
from
ap_invoices_all aia,
zmm_notes zn
where
invoice_num=:P_Invoice_Num
and zn.SOURCE_OBJECT_UID =aia.invoice_id
and zn.SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOICE'
--and zn.ATTRIBUTE_CATEGORY='GENERAL'
If you are facing issue for Page Break syntax <?split-by-page-break:?> is not working in RTF template for BIP report.
Please try below given solution and check it will work.
This issue for page break problem occurs on the last record of the report. It makes no different what that record is, it's always the last record.
Solution :
The solution is to change the page break tag.
Within the rtf template in Word, right click the first page break tag (below the first table) and select BI Publisher > Properties
A new box entitled BI Publisher Properties should appear on the screen. Within the Code box you should see this code
<?split-by-page-break:?>
Replace that code with this code
<xsl:attribute name="break-before">page</xsl:attribute>
Run the report again.
How to resolve issue for BIP RTF template XML tags showing value as <?ref: 0000xx?>
Sometime these xml data tags automatically changes to <?ref:xdoXXXX> format when opened in RTF. This is because of fields compatibility (BI Desktop version) with MS Word.
To resolve this issue we need open new Word file and modify Add-on setting for publisher as given below.
1. Navigate to Add-on Publisher -> Options -> Options
2. Change Field Labels from Business View to XML Tag Name.
Submit ESS Job request using SOAP UI using SOAP web service ERP Integration Service
Step2: Select ERP Integration Service
Step3: Copy Service WSDL URL
Step4 : Replace servername with Fusion ERP URL from Service
WSDL URL: https://servername/fscmService/ErpIntegrationService?WSDL
e.g. if your fusion ERP URL is https://fa-makd-saasfademo1.ds-fa.oraclepdemos.com/fscmUI
Then replace server name with fusion URL as given below.
e.g. WSDL URL: https://fa-makd-saasfademo1.ds-fa.oraclepdemos.com/fscmService/ErpIntegrationService?WSDL
Step5: Open SoapUI tool and enter project name and WSDL
Step6: Click on OK button , it will fetch service details
Step7: Expand ERPINtegrationServiceSoapHttp service and
select SubmitESSJobRequest
Step8 : Login to Fusion application and got to Manage Job and schedule from Setup and Maintenance
Step9: Enter details for Job package name and Job Definition
Name
Step10 : submit SOAP request
Check output
Step1) Download FBDI file for GL daily rates
Download DailyRatesImportTemplate.xlsm file
Step2) Open FBDI file and EDIT as per your requirements.
Step3. Click on Generate Daily Rates button generate zip
file
Step4) Login to cloud application and check existing rates
for given date.
Step5) Run Load Interface File for Import job in application
Pass parameter for daily rates
Browse zip file from computer and submit Job
It will run below given 4 program one by one automatically.
Once last program import and calculate Rates get successful check latest updated daily rates for given date. FBDI program loaded data successfully in cloud.
1) App Driven Orchestration:
Create an integration that uses an event or a business object to trigger the integration. For example, you create an integration with an Oracle RightNow Adapter as a trigger and an Oracle CX Sales and B2B Service Adapter as an invoke. The Oracle RightNow Adapter subscribes to an event from the Oracle RightNow application to trigger the integration. Orchestration integrations include features such as the following:
Switch activities to create multiple routing expressions.
For-each activities for looping over repeating elements.
Assign activities for assigning values to scalar variables.
Ad-hoc mappings on switch branches.
Callback activities (to end a process and respond back to the sender) and end activities (to end a process without responding back to the sender) in asynchronous integrations.
2) Scheduled Orchestration:
Create an integration that uses a schedule to trigger the integration instead of an adapter. For example, you add an initial invoke adapter to read a trigger file and a second FTP adapter to download the file for further processing. After designing this integration, you schedule when to run it.
3) File Transfer:
Create an integration to move files across a network.
4)Basic Routing:
Create an integration with a blank trigger and invoke in which to add your own adapters. You can also create a single routing expression and request and response enrichments, as needed. You cannot create multiple routing expressions. If your integration requires this feature, create an orchestrated integration.
5) Publish to OIC:
Create an integration in which you add a trigger adapter to publish messages to Oracle Integration through a predefined Oracle Integration Messaging invoke. No configuration of the invoke subscriber is required.
The publisher and subscribers participating in this integration style can be activated and deactivated independently of each other.
6) Subscribe to OIC:
Create an integration in which you add an invoke adapter to subscribe to messages from Oracle Integration through an Oracle Integration Messaging trigger. You are prompted to select the publisher to which to subscribe. You must have already created a publisher to which to subscribe. The publisher does not need to be active, but must already be completely configured.
Any business identifiers defined on fields in the published integration are copied to the subscriber. Any changes made to the published integration’s business identifiers after copying are not reflected in the subscriber. The publisher and subscribers participating in this integration style can be activated and deactivated independently of each other.
1) Payables
Payables Invoices- Installments Real time
Payables Invoices- Prepayment Application Real Time
Payables Invoices- Transactions Real time
Payables Invoices- Trial Balance Real time
Payables Invoices- With Holding Real time
Payables Payment- Disbursement Real Time
Payables Payment- Payments History Real Time
2) Receivables
Receivables- Adjustments Real time
Receivables- Bills Receivables Real Time
Receivables- Credit memo Application Real Time
Receivables- Credit Memo Request Real Time
Receivables- Customer Real Time
Receivables- Miscellenious Receipt Real Time
Receivables- Payments Schedule Real Time
Receivables- Transactions Real Time
Receivables- Receipts Details Real Time
